[pgpool-general: 2454] Re: Segfault in pgpool triggered by a background query

[Kristjan Siimson]

I'm using pgpool II 3.3.2 and PostgreSQL 9.3.2. It's easy to replicate the
issue, all you need to do is set parallel_mode = on.

0x00007ffff6be85c3 in __select_nocancel () at
../sysdeps/unix/syscall-template.S:82
82    T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)

Thread 2 (Thread 0x7ffff7fe57c0 (LWP 6849)):
Continuing.
2014-01-20 13:43:55 DEBUG: pid 6849: ProcessFrontendResponse: kind from
frontend Q(51)
2014-01-20 13:43:55 DEBUG: pid 6849:
pool_unset_doing_extended_query_message: done
2014-01-20 13:43:55 DEBUG: pid 6849: statement2: SELECT
has_function_privilege('kristjan', 'pgpool_regclass(cstring)', 'execute')
WHERE EXISTS(select * from account);
2014-01-20 13:43:55 DEBUG: pid 6849: pool_set_query_in_progress: done
2014-01-20 13:43:55 DEBUG: pid 6849: initSelectStmt: ANALYZE now(0)
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info num= 1
current_select=0
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info const or func
0
2014-01-20 13:43:55 DEBUG: pid 6849: initSelectStmt: ANALYZE now(1)
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info num= 1
current_select=1
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info const or func
1
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_virtual_info no dist
state=E account

Program received signal SIGSEGV, Segmentation fault.
0x000000000043df31 in DetectValidColumn (message=0x75c3e0, table_name=0x0,
column_name=0x4c763f "*", no=0, call=2) at pool_rewrite_outfuncs.c:4747
4747        v_num = virtual->col_num;

Thread 1 (Thread 0x7ffff7fe57c0 (LWP 6847)):
Continuing.

Program terminated with signal SIGSEGV, Segmentation fault.
The program no longer exists.


On 20 January 2014 04:05, Tatsuo Ishii <ishii at postgresql.org> wrote:

> Could you please provide pgpool-II version, pgpool.conf, PostgreSQL
> version and backtrace of pgpool when the sefault occured?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20140120/b3dafaaf/attachment.htm>