[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