[pgpool-committers: 5323] 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
------
V3_6_STABLE

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

Modified Files
--------------
src/query_cache/pool_memqcache.c | 31 ++++++++++++++++++-------------
1 file changed, 18 insertions(+), 13 deletions(-)



More information about the pgpool-committers mailing list