Hi all,
we have a setup where we use PGPOOL instances between our application
and the main DB server. Lately there is an intermittent but annoying
error that sometimes pops up:
ERROR: unable to parse the query
DETAIL: invalid read kind
SSL SYSCALL error: EOF detected
Version numbers:
pgpool 3.7.20
postgresql 9.5.25
Relevant part of pgpool's log:
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992409-1] 2022-03-10 09:44:50: pid 8731: LOG: statement: SELECT 'OK'
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992410-1] 2022-03-10 09:44:50: pid 8731: LOG: DB node id: 0 backend
pid: 29433 statement: SELECT 'OK'
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992411-1] 2022-03-10 09:44:50: pid 8731: ERROR: unable to parse the
query
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992411-2] 2022-03-10 09:44:50: pid 8731: DETAIL: invalid read kind
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992412-1] 2022-03-10 09:44:50: pid 8731: LOG: statement: DISCARD
ALL
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992413-1] 2022-03-10 09:44:50: pid 8731: LOG: DB node id: 0 backend
pid: 29433 statement: DISCARD ALL
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992414-1] 2022-03-10 09:44:50: pid 8731: FATAL: failed to read kind
from backend 0
2022-03-10T09:44:50.000000+00:00 sanitized_hostname pgpool[8731]:
[2992414-2] 2022-03-10 09:44:50: pid 8731: DETAIL: kind == 0
The query does not appear to be relevant, it's well-formed and not the
same every time.
Now, what does this mean, and how to deal with it?
Best regards,
Peter Juhasz
Comnica Kft.