View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000372 | pgpool-HA | Bug | public | 2017-12-19 12:42 | 2017-12-27 13:14 |
| Reporter | Tohru Kobayashi | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | AWS | OS | Ubuntu | OS Version | 16.04 |
| Summary | 0000372: can not purge cached query with multiple | ||||
| Description | version 3.6.7 I found pgpool-II can not purge cached query with multiple and on memory query cache(memcached). If you use multiple pgpool-II over different server, there AREN'T share oids. Because, pgpool-II has oids in local directory. So, must purge queries WILLNOT purge. I think oids should be stored in memcache/postgresql or oids directory is in NFS if use multiple pgpool-II and on memory query cache. | ||||
| Steps To Reproduce | 1. set up pgpool1, pgpool2 with on memory query cache using memcached. oiddir is not share. 2. 'select * from hoges where id = 1' on pgpool1 3. "update hoges set name = 'fuga'" on pgpool2 4. 'select * from hoges where id = 1' on pgpool1. this is old cached result. | ||||
| Tags | memcached | ||||
|
|
Yes, that's a known issue and it's on our TODO list: https://pgpool.net/mediawiki/index.php/TODO#Allow_to_use_multiple_pgpool-II_instances_with_in-memory_query_cache_enabled |
|
|
BTW project name 'pgpool-HA' is not correct. You should use 'pgpool-II' instead. |
|
|
I'm going to close this issue. If you feel to retain this issue, please open new one in the "pgpool-II" category. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-12-19 12:42 | Tohru Kobayashi | New Issue | |
| 2017-12-19 12:42 | Tohru Kobayashi | Tag Attached: memcached | |
| 2017-12-19 15:06 | t-ishii | Note Added: 0001873 | |
| 2017-12-19 15:15 | t-ishii | Note Added: 0001874 | |
| 2017-12-27 13:13 | t-ishii | Note Added: 0001882 | |
| 2017-12-27 13:14 | t-ishii | Status | new => closed |
