[pgpool-general: 7458] Pgpool child process with pid: XXXXX was terminated by segmentation fault
Madathala, Giridhar R
giridhar at siu.edu
Fri Mar 26 12:51:52 JST 2021
<mailto:pgpool-general at pgpool.net>Hi,
I have been running into segmentation fault errors with pgpool only when using in-memory caching (memory_cache_enabled = on). When memory_cache_enabled is off, not really seeing any such issues. Any clue on what might be happening or if i missing something?
Pgpool errors:
2021-03-26 03:41:23: pid 17816: WARNING: child process with pid: 18034 was terminated by segmentation fault
2021-03-26 03:41:23: pid 17816: LOG: fork a new child process with pid: 19635
2021-03-26 03:43:19: pid 17816: WARNING: child process with pid: 18720 was terminated by segmentation fault
2021-03-26 03:43:19: pid 17816: LOG: fork a new child process with pid: 19683
Client App Errors (Java):
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:336) ~[postgresql-42.2.6.jar:42.2.6]
..
..
Caused by: java.io.EOFException
at org.postgresql.core.PGStream.receiveChar(PGStream.java:323) ~[postgresql-42.2.6.jar:42.2.6]
pgpool.conf configuration ( 1 backend node)
backend_clustering_mode = 'raw'
listen_addresses = '127.0.0.1'
port = 5432
backend_flag0 = 'ALWAYS_PRIMARY'
enable_pool_hba = on
pool_passwd = ''
authentication_timeout = 1min
allow_clear_text_frontend_auth = on
ssl = on
num_init_children = 48
max_pool = 6
listen_backlog_multiplier = 4
serialize_accept = on
memory_cache_enabled = on
memqcache_method = 'memcached'
memqcache_memcached_host = '127.0.0.1'
memqcache_memcached_port = 11211
memqcache_total_size = 128MB
memqcache_expire = 3600
memqcache_auto_cache_invalidation = on
memqcache_maxcache = 512kB
memqcache_cache_block_size = 1MB
Thanks,
Giri
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210326/01ba1ffb/attachment.htm>
More information about the pgpool-general
mailing list