server process (PID 2964738) was terminated by signal 11: Segmentation fault - Mailing list pgsql-general

From Stefan Froehlich
Subject server process (PID 2964738) was terminated by signal 11: Segmentation fault
Date
Msg-id 20221106111820.GA26442@static.231.150.9.176.clients.your-server.de
Whole thread Raw
Responses Re: server process (PID 2964738) was terminated by signal 11: Segmentation fault  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
This was starting with an invalid memory alloc request size, like in
<https://www.postgresql.org/message-id/2080966.1592844878%40sss.pgh.pa.us>.

I followed the suggestion to trace down the faulty record, found and
fixed it. Now I can access that record again, but if I try to dump
the table I get:

| 2022-11-06 11:52:36.367 CET [2098-35] LOG:  server process (PID 2964738) was terminated by signal 11: Segmentation
fault
| [...]
| 2022-11-06 11:53:46.229 CET [2964744-2] LOG:  database system was not properly shut down; automatic recovery in
progress
| 2022-11-06 11:53:46.263 CET [2964744-3] LOG:  redo starts at 7D/E53B6440
| 2022-11-06 11:53:46.265 CET [2964744-4] LOG:  invalid record length at 7D/E5412958: wanted 24, got 0
| 2022-11-06 11:53:46.265 CET [2964744-5] LOG:  redo done at 7D/E5412920
| 2022-11-06 11:53:46.749 CET [2098-39] LOG:  database system is ready to accept connections

Whatever was "done" does not prevent the problem from being
reproducible. I tried to track down this faulty record as well, but
binary proves difficult with 25*10^6 rows if the server crashes and
rebuilds after each try.

Is there any reasonable way to proceed from here?

The system seems to be working fine (the currupted table contains
textual information only), but right now I cannot even make proper
backups which is not a good thing.

Regards,

Stefan



pgsql-general by date:

Previous
From: Larry Sevilla
Date:
Subject: Re: Is there a guide to use PostgresSQL as alternative to MariaDB/MySQL in OpenStack?
Next
From: Rafal Pietrak
Date:
Subject: Re: an difficult SQL