<div dir="ltr"><div>Odd. I am attaching my pgpool.conf in case I missed something. I was easily able to get the same issue on different machines where I set up PostgreSQL. I used the sample schemas and partition rules that come with PgPool II.<br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 22 January 2014 05:23, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I'm trying to reproduce the problem but cannot.<br>
<br>
set paramell_mode = on and issuing the following query is all to do?<br>
<br>
SELECT has_function_privilege('user', 'pgpool_regclass(cstring)', 'execute')<br>
<div class="im">WHERE EXISTS(select * from account)<br>
<br>
</div>Could you please tell me about DB schema and partition rule registed<br>
in pgpool_catalog.dist_def? If you use replication mode, please tell<br>
me about pgpool_catalog.replicate_def, too.<br>
<div class="HOEnZb"><div class="h5"><br>
On Mon, 20 Jan 2014 13:50:50 +0200<br>
Kristjan Siimson <<a href="mailto:kristjan.siimson@cashongo.co.uk">kristjan.siimson@cashongo.co.uk</a>> wrote:<br>
<br>
> I'm using pgpool II 3.3.2 and PostgreSQL 9.3.2. It's easy to replicate the<br>
> issue, all you need to do is set parallel_mode = on.<br>
><br>
> 0x00007ffff6be85c3 in __select_nocancel () at<br>
> ../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<br>
> frontend Q(51)<br>
> 2014-01-20 13:43:55 DEBUG: pid 6849:<br>
> 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<br>
> current_select=0<br>
> 2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info const or func<br>
> 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<br>
> current_select=1<br>
> 2014-01-20 13:43:55 DEBUG: pid 6849: inside build_range_info const or func<br>
> 1<br>
> 2014-01-20 13:43:55 DEBUG: pid 6849: inside build_virtual_info no dist<br>
> state=E account<br>
><br>
> Program received signal SIGSEGV, Segmentation fault.<br>
> 0x000000000043df31 in DetectValidColumn (message=0x75c3e0, table_name=0x0,<br>
> 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>
><br>
><br>
> On 20 January 2014 04:05, Tatsuo Ishii <<a href="mailto:ishii@postgresql.org">ishii@postgresql.org</a>> wrote:<br>
><br>
> > 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>
> ><br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
</font></span></blockquote></div><br></div>