[pgpool-committers: 5324] pgpool: Fix query cache invalidation bug.

Tatsuo Ishii ishii at sraoss.co.jp
Mon Nov 5 21:46:12 JST 2018


Fix query cache invalidation bug.

When a DML is executed in an explicit transaction, the table oid
buffer is wiped out by pool_reset_memqcache_buffer() and query cache
is not invalidated at the commit time because there's no DML oid
exists to invalidate query cache any more. To fix this, add new bool
parameter to pool_reset_memqcache_buffer() to specify whether to reset
table oid buffer or not. When a DML is executed in an explicit
transaction, call pool_reset_memqcache_buffer(false) to preserve the
table oid buffer.

Issue reported at https://github.com/pgpool/pgpool2/issues/19.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=7398ae009177cdc67c29f055a4eedec4adce8a79

Modified Files
--------------
src/query_cache/pool_memqcache.c | 28 ++++++++++++++++------------
1 file changed, 16 insertions(+), 12 deletions(-)



More information about the pgpool-committers mailing list