[pgpool-general: 5450] error while deleting item from shmem cache, item: N was already deleted

PVY balroga3 at yandex.ru
Thu May 11 19:27:01 JST 2017


Hello.

Are  these  messages in  pgpool  log something to worry about or is it
normal? There are a lot of them with different item numbers:

May 11 12:44:11 ip-172-31-20-153 pgpool[30592]: [15-1] LOG:  error while deleting item from shmem cache, item: 70 was already deleted
May 11 12:44:11 ip-172-31-20-153 pgpool[30592]: [15-2] LOCATION:  pool_memqcache.c:2484
May 11 12:44:11 ip-172-31-20-153 pgpool[30592]: [16-1] LOG:  error while deleting item from shmem cache, item: 71 was already deleted
May 11 12:44:11 ip-172-31-20-153 pgpool[30592]: [16-2] LOCATION:  pool_memqcache.c:2484
May 11 12:44:11 ip-172-31-20-153 pgpool[30592]: [17-1] LOG:  error while deleting item from shmem cache, item: 83 was already deleted
May 11 12:44:11 ip-172-31-20-153 pgpool[30592]: [17-2] LOCATION:  pool_memqcache.c:2484

Also, pool_cache shows number of cache hits far greater than number
of selects, is it ok?

show pool_cache;
-[ RECORD 1 ]---------------+------
num_cache_hits              | 32671
num_selects                 | 3866
cache_hit_ratio             | 0.89
num_hash_entries            | 0
used_hash_entries           | 0
num_cache_entries           | 0
used_cache_entries_size     | 0
free_cache_entries_size     | 0
fragment_cache_entries_size | 0

Thank you.

-- 
 Pavel



More information about the pgpool-general mailing list