[pgpool-general: 6486] Re: Unable to parse the query
ujang.milist at gmail.com
Tue Apr 2 10:18:07 JST 2019
updated info, after disable cache shmem, error 0200 gone..
How to debug this cache behavior?
On Mon, Mar 18, 2019 at 7:09 PM milist ujang <ujang.milist at gmail.com> wrote:
> It seems "unable to parse" log messages just a warning, even though the
> query still processed normally.
> Since 0200 error intermittently being occurred, we turn
> on log_per_node_statement, and grep the log, and luckily users report 0200
> when the query was served by cache (query result fetched from cache.
> statement: select....).
> I got confused with the white_memqcache_table_list parameter, in current
> online document said that the parameter apply only for views and unlogged
> tables, but from slide at
> it said table can also be specified in this parameter.
> The table which got 0200 error is not listed in white_memqcache_table_list
> parameter, also not listed in black_memqcache_table_list parameter; but
> from the pgpool log, the query to that table served by cache.
> On Fri, Feb 15, 2019 at 8:28 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> > Tested in pgpool dev, 2 version of queries:
>> > A. select * from (select branch_type as A from branch where parent_id in
>> > (1813) order by branch_id) limit 1;
>> > B. select * from (select branch_type as A from branch where parent_id in
>> > (1813) order by branch_id) AS TMP limit 1;
>> > in pgpool log:
>> > A. there is log error unable to parse query.
>> > B. no error
>> Pgpool-II has an SQL parser which is ported from open source
>> PostgreSQL, not edb. The query A can only be parsed by edb, not by
>> either Pgpool-II or PostgreSQL. I bet PostgreSQL will give an error
>> with A too.
>> Best regards,
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
> ujang jaenudin | DBA Consultant (Freelancer)
ujang jaenudin | DBA Consultant (Freelancer)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general