[pgpool-committers: 5321] 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_7_STABLE

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

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



More information about the pgpool-committers mailing list