[pgpool] invalid read kind

From: Peter Juhasz <peter(dot)juhasz(at)comnica(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [pgpool] invalid read kind
Date: 2022-03-10 16:18:06
Message-ID: fb545ae1b0b784bf82dbac091208688086e72659.camel@comnica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message George Woodring 2022-03-10 17:32:21 Re: foreign key on delete cascade order?
Previous Message Tom Lane 2022-03-10 15:56:43 Re: foreign key on delete cascade order?