[pgpool-general: 6412] Unable to parse the query

[milist ujang]

HI all,

Recently I'm using version 3.7.5 (amefuriboshi). there are 4 backends
streaming replication (synchronous), and 1 primary.

Intermittently user got SQLState: 02000 (No results were returned by the
query), take a look at pgpool log file, got this error on the same time:

Unable to parse the query: "select * from (select branch_type as A from
branch where parent_id in (1701) order by branch_id) limit 1 " from client
...

using the same query at the later time is OK, the table is static one.

anyway, we use query cache (shmem) and there are a lot of
LOG:  error while deleting item from shmem cache, item: NNN was already
deleted

is this 2 log may be correlated? is it due to high pressure on cache?
(recently no filter at all in cache)


-- 
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20190214/8fa53cbb/attachment.htm>