PostgreSQL error (Segmentation Fault with message "SSL SYSCALL error: EOF detected")

From: angell2006(at)ukr(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: PostgreSQL error (Segmentation Fault with message "SSL SYSCALL error: EOF detected")
Date: 2018-11-09 09:27:54
Message-ID: 1541755652.808841957.eh53q4en@frv34.fwdcdn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello. I want to report error on PostgreSQL.

If I execute queries:

DROP TABLE IF EXISTS client_tt;
CREATE TABLE client_tt(id_client_tt integer NOT NULL, id_unique integer);
INSERT INTO client_tt(id_client_tt, id_unique) VALUES('1', '1');
ALTER TABLE ONLY client_tt ADD CONSTRAINT client_tt_pkey PRIMARY KEY (id_client_tt);
ALTER TABLE ONLY client_tt ADD CONSTRAINT client_tt_ibfk_7 FOREIGN KEY (id_unique) REFERENCES client_tt(id_client_tt) ON DELETE SET NULL DEFERRABLE;
ALTER TABLE client_tt ADD COLUMN tt_code_inn VARCHAR(12) NOT NULL DEFAULT '';
DELETE FROM client_tt;

Then system throws Segmentation Fault with message "SSL SYSCALL error: EOF detected".

Details:

PostgreSQL version:
postgres=# SELECT VERSION();
version
-----------------------------------------------------------------------------------------------------------
PostgreSQL 11.0 (Debian 11.0-1+b1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.2.0-9) 8.2.0, 64-bit
(1 row)

Linux version: Debian GNU/Linux testing (buster)
> cat /proc/version
Linux version 4.18.0-2-amd64 (debian-kernel(at)lists(dot)debian(dot)org) (gcc version 7.3.0 (Debian 7.3.0-30)) #1 SMP Debian 4.18.10-2 (2018-11-02)

psql version:
> PGPASSWORD=**** psql -h localhost -U postgres
psql (11.0 (Debian 11.0-1+b1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)

The error is repeated if I run queries:
1) On this system by php7.2-pgsql
2) On Ubuntu 16.04.5 LTS by psql (11.0 (Ubuntu 11.0-1.pgdg16.04+2)) and by php7.2-pgsql

In /var/log/postgresql/postgresql-11-main.log I see:

2018-11-07 18:59:29.670 EET [12806] LOG: server process (PID 14341) was terminated by signal 11: Segmentation fault
2018-11-07 18:59:29.670 EET [12806] DETAIL: Failed process was running: DELETE FROM client_tt;
2018-11-07 18:59:29.686 EET [12806] LOG: terminating any other active server processes
2018-11-07 18:59:29.692 EET [12811] WARNING: terminating connection because of crash of another server process
2018-11-07 18:59:29.692 EET [12811] 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.
2018-11-07 18:59:29.692 EET [12811] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2018-11-07 18:59:29.708 EET [16602] postgres(at)ddc_tests FATAL: the database system is in recovery mode

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ing. Gianluca Alberici 2018-11-09 09:33:14 Re: Ris: BUG #15482: Foreign keys to a partition (NOT A PARTITIONED) break the server
Previous Message Etsuro Fujita 2018-11-09 09:27:09 Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT