View Issue Details

IDProjectCategoryView StatusLast Update
0000098Pgpool-IIBugpublic2014-04-25 11:05
ReporteraamirAssigned Tonagata 
PrioritynormalSeveritymajorReproducibilityalways
Status confirmedResolutionopen 
PlatformUbuntu 12.04.4 LTS 64 bitOSLinuxOS Version
Product Version 
Target VersionFixed in Version 
Summary0000098: memqcache_auto_cache_invalidation doesn't work properly
DescriptionWhen I run multiple queries in one batch, query cache doesn’t get invalidated for an updated table. (memqcache_auto_cache_invalidation doesn’t work). This bug is stopping me to implement the query caching in production as users can update/delete the data but still see cached results on webpage.
i'm using pgpool-II version 3.3.2 (tokakiboshi). I have already run pgpool_regclass.sql on each database.
Steps To ReproduceYou will need 2 sessions to reproduce this bug.
Query caching should be enabled in pgpool.(memory_cache_enabled = on)

Session 1: Connect pgpool via terminal.

create table jill.test(a int,b text);


\d jill.test;
      
 Column | Type | Modifiers
--------+---------+-----------
 a | integer |
 b | text |

insert into jill.test values (1,'one');
insert into jill.test values (2,'two');

select * from jill.test;
 a | b
---+-----
 1 | one
 2 | two


Now Open 2nd session in pgAdminIII to execute multiple statements in one batch and execute following commands.Please run the following queries together, don’t run one query at a time.

select * from jill.test;
update jill.test set b='three' where a=2;

Execute the following statement in Session 1 again:

select * from jill.test;
 a | b
---+-----
 1 | one
 2 | two
TagsNo tags attached.

Activities

nagata

2014-04-24 13:09

developer   ~0000405

This is a restriction. pgpool-II can't process multiple statement properly.

http://www.pgpool.net/docs/pgpool-II-3.3.3/doc/pgpool-en.html#ng_multi_statement

aamir

2014-04-24 14:59

reporter   ~0000406

Thanks for your help nagata. It would be good to know if this restriction will be removed or not in future pgpool-II releases.

nagata

2014-04-25 11:05

developer   ~0000407

We recognize this problem as TODO, although it isn't determined when.
http://www.pgpool.net/mediawiki/index.php/TODO#Recognize_multi_statemnet_queries

Issue History

Date Modified Username Field Change
2014-04-24 09:36 aamir New Issue
2014-04-24 12:04 nagata Assigned To => nagata
2014-04-24 12:04 nagata Status new => assigned
2014-04-24 13:09 nagata Note Added: 0000405
2014-04-24 13:09 nagata Status assigned => confirmed
2014-04-24 14:59 aamir Note Added: 0000406
2014-04-25 11:05 nagata Note Added: 0000407