View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000098 | Pgpool-II | Bug | public | 2014-04-24 09:36 | 2014-04-25 11:05 |
| Reporter | aamir | Assigned To | nagata | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | confirmed | Resolution | open | ||
| Platform | Ubuntu 12.04.4 LTS 64 bit | OS | Linux | ||
| Summary | 0000098: memqcache_auto_cache_invalidation doesn't work properly | ||||
| Description | When 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 Reproduce | You 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 | ||||
| Tags | No tags attached. | ||||
|
|
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 |
|
|
Thanks for your help nagata. It would be good to know if this restriction will be removed or not in future pgpool-II releases. |
|
|
We recognize this problem as TODO, although it isn't determined when. http://www.pgpool.net/mediawiki/index.php/TODO#Recognize_multi_statemnet_queries |
| 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 |
