[pgpool-general: 7458] Pgpool child process with pid: XXXXX was terminated by segmentation fault

[Madathala, Giridhar R]

<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>