From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: hko@framelogic.pl
Subject: BUG #16704: Segmentation Problem - SSL SYSCALL error: EOF detected
Date: Thu, 05 Nov 2020 12:07:38 +0000
Message-ID: <16704-f63938f3224b1cd9@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16704
Logged by: Henryk Korulski
Email address: hko@framelogic.pl
PostgreSQL version: 13.0
Operating system: PostgreSQL 13.0 (Debian 13.0-1.pgdg90+1) on x86_64
Description:
We use PG12 Database. After upgrade it to version 13 we have problems with
random query - error SSL SYSCALL error: EOF detected.
It appears on many tables (when selecting data or when inserting). I watch
one select query causes this error. I copied sql query from script and
execute nativly in psql and the problem was the same result with error.
After VACUUM FULL ANALYZE my table, i executed once again my query and query
result was succes. It has been working about 25 minuts and then i got the
same error.
Problem is very similar like
https://www.postgresql.org/message-id/15219.1541773523%40sss.pgh.pa.us
Please HELP.
Best regards
Henryk
My query:
select distinct pam.dscr, p.pojazd_id, m.nazwa, model, nr_rejestracyjny,
(
select array_to_string( array(
select distinct f.firma1_id || '::' || f.nazwa
FROM grupa_pojazdow_pojazd gpp
join grupa_pojazdow gp on gp.grupa_pojazdow_id =
gpp.grupa_pojazdow_id
join firma1 f on gp.firma1_id = f.firma1_id
where gpp.pojazd_id = p.pojazd_id
order by f.firma1_id || '::' || f.nazwa
)
, '|' )
) as firms
from pojazd p
join marka m on m.marka_id = p.marka_id
join pojazd_admin_multi pam on (pam.pojazd_id = p.pojazd_id
and pam.datetime_to is null)
where dscr is not null
order by p.pojazd_id
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, hko@framelogic.pl
Subject: Re: BUG #16704: Segmentation Problem - SSL SYSCALL error: EOF detected
In-Reply-To: <16704-f63938f3224b1cd9@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox