View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000079 | Pgpool-II | Bug | public | 2013-10-29 07:27 | 2015-09-17 15:30 |
| Reporter | jamessewell | Assigned To | t-ishii | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | x86_64 | OS | Ubuntu | OS Version | 12.04.3 |
| Summary | 0000079: Pgpool 3.2 memory cache log: pool_delete_item_shmem_cache | ||||
| Description | We are running pgpool-II version 3.3.1 (tokakiboshi) from the PGDG repos. The machine has been up for 4 hours and we are seeing the following lines in our log file (caching is happening successfully): Oct 29 06:30:29 pgpool: 2013-10-29 06:30:29 ERROR: pid 4543: pool_delete_item_shmem_cache: item 308 was deleted Oct 29 06:30:29 pgpoolpgpool: 2013-10-29 06:30:29 ERROR: pid 4543: pool_delete_item_shmem_cache: item 1 was deleted Oct 29 06:30:29 pgpoolpgpool: 2013-10-29 06:30:29 ERROR: pid 4543: pool_delete_item_shmem_cache: item 234 was deleted Oct 29 06:30:29 pgpoolpgpool: 2013-10-29 06:30:29 ERROR: pid 4543: pool_delete_item_shmem_cache: item 310 was deleted This seems to be a repeat of this bug: http://www.pgpool.net/mantisbt/view.php?id=27 - except we have memqcache_expire set to 0. We have the following settings: memory_cache_enabled = on memqcache_method = 'shmem' memqcache_auto_cache_invalidation = on memqcache_expire = 0 memqcache_total_size = 1073741824 memqcache_max_num_cache = 1000000 memqcache_maxcache = 1048576 memqcache_cache_block_size = 1048576 memqcache_oiddir = '/var/log/pgpool/oiddir' | ||||
| Steps To Reproduce | Configure as above | ||||
| Tags | No tags attached. | ||||
|
|
Did you see "pool_add_item_shmem_cache: pool_hash_insert failed" as well? If so, memqcache_max_num_cache = 1000000 is too small. Try to increase it. |
|
|
No I did not. When I look at the cached statements through SHOW pool_cache the cache is not full. Cheers, James |
|
|
We’re seeing the same thing, memqcache_expire is 0, no other errors in the log: Nov 4 15:03:08 pgpool00 pgpool: 2013-11-04 15:03:08 LOG: pid 10508: pool_shared_memory_cache_size: number of blocks: 64 Nov 4 15:03:08 pgpool00 pgpool: 2013-11-04 15:03:08 LOG: pid 10508: pool_discard_oid_maps: discarded memqcache oid maps Nov 4 15:03:08 pgpool00 pgpool: 2013-11-04 15:03:08 LOG: pid 10508: pgpool-II successfully started. version 3.3.1 (tokakiboshi) Nov 4 15:03:17 pgpool00 pgpool: 2013-11-04 15:03:17 LOG: pid 10583: pool_reuse_block: blockid: 0 Nov 4 15:04:34 pgpool00 pgpool: 2013-11-04 15:04:34 ERROR: pid 10548: pool_delete_item_shmem_cache: item 56 was deleted (TKL/Debian 7) |
|
|
At this point I have no idea why this happens. Also I couldn't reproduce the problem. Do you know how to reproduce the problem? A self contained test case is the best. |
|
|
No feedback over 1 year. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-10-29 07:27 | jamessewell | New Issue | |
| 2013-11-03 18:27 | t-ishii | Note Added: 0000352 | |
| 2013-11-03 18:28 | t-ishii | Assigned To | => t-ishii |
| 2013-11-03 18:28 | t-ishii | Status | new => assigned |
| 2013-11-03 18:28 | t-ishii | Status | assigned => feedback |
| 2013-11-04 08:01 | jamessewell | Note Added: 0000353 | |
| 2013-11-04 08:01 | jamessewell | Status | feedback => assigned |
| 2013-11-05 00:17 | moeffju | Note Added: 0000356 | |
| 2013-11-05 00:17 | moeffju | Note Edited: 0000356 | |
| 2013-11-09 08:16 | t-ishii | Note Added: 0000367 | |
| 2013-11-09 08:16 | t-ishii | Status | assigned => feedback |
| 2015-09-17 15:30 | t-ishii | Note Added: 0000564 | |
| 2015-09-17 15:30 | t-ishii | Status | feedback => closed |
