[Pgpool-hackers] pgbench causes pgpool to emit segmentation fault

[Fujii Masao]

On Mon, Jan 31, 2011 at 6:40 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> Sound like a bug. I will try to reproduce the bug. If I cann't, I will
> request you the stack trace.
>
>> I installed pgpool-II from the CVS HEAD, and PostgreSQL from the current
>> git master.
>
> Just out of curiousity, have you tried with PostgreSQL 9.0.x? If so,
> is there any difference?

In 9.0, the segmentation fault didn't happen, but pgbench got stuck.

Here is the stack trace of the main process of pgpool.
(gdb) bt
#0  0x00000036654cce83 in __select_nocancel () from /lib64/libc.so.6
#1  0x000000000040342c in pool_pause (timeout=0x7fffb12d5510) at main.c:2103
#2  0x0000000000406857 in main (argc=<value optimized out>,
argv=<value optimized out>) at main.c:691

Here is the stack trace of the child process.
(gdb) bt
#0  0x00000036654cce83 in __select_nocancel () from /lib64/libc.so.6
#1  0x0000000000416811 in pool_process_query (frontend=0x12b73170,
backend=0x12b67670, reset_request=0) at pool_process_query.c:245
#2  0x0000000000409042 in do_child (unix_fd=4, inet_fd=5) at child.c:328
#3  0x0000000000403c35 in fork_a_child (unix_fd=4, inet_fd=5, id=0) at
main.c:1045
#4  0x000000000040641d in main (argc=<value optimized out>,
argv=<value optimized out>) at main.c:529

BTW, I use very simple pgpool.conf for the test. This might be
the cause of the problem.

-------------------
listen_addresses = '*'
port = 9999
num_init_children = 2
pid_file_name = '/tmp/pgpool.pid'
load_balance_mode = true
master_slave_mode = true
master_slave_sub_mode = 'stream'
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/home/postgres/9.0/pgsql-9.0.1/act'
backend_hostname1 = 'localhost'
backend_port1 = 5433
backend_weight1 = 1
backend_data_directory1 = '/home/postgres/9.0/pgsql-9.0.1/sby'
enable_pool_hba = true
-------------------

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center