<div dir="ltr">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.<br><div><br>0x00007ffff6be85c3 in __select_nocancel () at ../sysdeps/unix/syscall-template.S:82<br>
82 T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)<br><br>Thread 2 (Thread 0x7ffff7fe57c0 (LWP 6849)):<br>Continuing.<br>2014-01-20 13:43:55 DEBUG: pid 6849: ProcessFrontendResponse: kind from frontend Q(51)<br>
2014-01-20 13:43:55 DEBUG: pid 6849: pool_unset_doing_extended_query_message: done<br>2014-01-20 13:43:55 DEBUG: pid 6849: statement2: SELECT<br>has_function_privilege('kristjan', 'pgpool_regclass(cstring)', 'execute')<br>
WHERE EXISTS(select * from account);<br>2014-01-20 13:43:55 DEBUG: pid 6849: pool_set_query_in_progress: done<br>2014-01-20 13:43:55 DEBUG: pid 6849: initSelectStmt: ANALYZE now(0)<br>2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info num= 1 current_select=0<br>
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info const or func 0<br>2014-01-20 13:43:55 DEBUG: pid 6849: initSelectStmt: ANALYZE now(1)<br>2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info num= 1 current_select=1<br>
2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info const or func 1<br>2014-01-20 13:43:55 DEBUG: pid 6849: inside build_virtual_info no dist state=E account<br><br>Program received signal SIGSEGV, Segmentation fault.<br>
0x000000000043df31 in DetectValidColumn (message=0x75c3e0, table_name=0x0, column_name=0x4c763f "*", no=0, call=2) at pool_rewrite_outfuncs.c:4747<br>4747 v_num = virtual->col_num;<br><br>Thread 1 (Thread 0x7ffff7fe57c0 (LWP 6847)):<br>
Continuing.<br><br>Program terminated with signal SIGSEGV, Segmentation fault.<br>The program no longer exists.<br><div><div class="gmail_extra"><br><br><div class="gmail_quote">On 20 January 2014 04:05, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Could you please provide pgpool-II version, pgpool.conf, PostgreSQL<br>
version and backtrace of pgpool when the sefault occured?<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br></div></div></div></div>