Re: BUG #16704: Segmentation Problem - SSL SYSCALL error: EOF detected

2020-11-05 13:03:24.906 CET [28788] LOG:  background worker "parallel worker" (PID 30704) was terminated by signal 11: Segmentation fault
2020-11-05 13:03:24.906 CET [28788] DETAIL:  Failed process was running: ...
2020-11-05 13:03:24.906 CET [28788] LOG:  terminating any other active server processes
2020-11-05 13:03:24.906 CET [30688] crons_user@db01 WARNING:  terminating connection because of crash of another server process
2020-11-05 13:03:24.906 CET [30688] crons_user@db01 DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

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