Postgres 13 signal 11: Segmentation fault tested on 2 independent machines - Mailing list pgsql-bugs

From pinker
Subject Postgres 13 signal 11: Segmentation fault tested on 2 independent machines
Date
Msg-id 1603050466566-0.post@n3.nabble.com
Whole thread Raw
Responses Re: Postgres 13 signal 11: Segmentation fault tested on 2 independent machines
List pgsql-bugs
Hi,
first time segmentation fault happened on my laptop:

cat /etc/redhat-release 
Fedora release 32 (Thirty Two)

SELECT version();
                                                 version                                                  
----------------------------------------------------------------------------------------------------------
 PostgreSQL 13.0 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 10.2.1
20200723 (Red Hat 10.2.1-1), 64-bit


while executing SQL function:
SELECT * FROM vacuum_dead_size(now());
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.


Please don't look at the timestamps as i was executing the function many
times. Although if you want the exact times i can also provide it.

Postgres logs:

2020-10-18 21:26:08.871 CEST [1423] LOG:  server process (PID 435031) was
terminated by signal 11: Segmentation fault
2020-10-18 21:26:08.871 CEST [1423] DETAIL:  Failed process was running:
SELECT * FROM vacuum_dead_size(now());
2020-10-18 21:26:08.871 CEST [1423] LOG:  terminating any other active
server processes
2020-10-18 21:26:08.871 CEST [429052] WARNING:  terminating connection
because of crash of another server process
2020-10-18 21:26:08.871 CEST [429052] 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.
2020-10-18 21:26:08.871 CEST [429052] HINT:  In a moment you should be able
to reconnect to the database and repeat your command.
2020-10-18 21:26:08.872 CEST [428785] WARNING:  terminating connection
because of crash of another server process
2020-10-18 21:26:08.872 CEST [428785] 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.
2020-10-18 21:26:08.872 CEST [428785] HINT:  In a moment you should be able
to reconnect to the database and repeat your command.
2020-10-18 21:26:08.878 CEST [435117] FATAL:  the database system is in
recovery mode
2020-10-18 21:26:08.879 CEST [1423] LOG:  all server processes terminated;
reinitializing
2020-10-18 21:26:08.911 CEST [435119] LOG:  database system was interrupted;
last known up at 2020-10-18 21:23:52 CEST
2020-10-18 21:26:08.977 CEST [435119] LOG:  database system was not properly
shut down; automatic recovery in progress
2020-10-18 21:26:08.980 CEST [435119] LOG:  redo starts at 0/E5080E8
2020-10-18 21:26:08.981 CEST [435119] LOG:  invalid record length at
0/E540EA8: wanted 24, got 0
2020-10-18 21:26:08.981 CEST [435119] LOG:  redo done at 0/E540E80
2020-10-18 21:26:09.000 CEST [1423] LOG:  database system is ready to accept
connections


journalctl:

Oct 18 20:48:48 localhost.localdomain systemd-coredump[428779]: Process
428774 (postmaster) of user 26 dumped core.
                                                                
                                                                Stack trace
of thread 428774:
                                                                #0 
0x00007fcbbbdd06e8 __memmove_avx_unaligned_erms (libc.so.6 + 0x1656e8)
                                                                #1 
0x00000000004f8362 fill_val (postgres + 0xf8362)
                                                                #2 
0x00000000004f908d heap_fill_tuple (postgres + 0xf908d)
                                                                #3 
0x00000000004fa27b heap_form_minimal_tuple (postgres + 0xfa27b)
                                                                #4 
0x000000000067c509 tts_minimal_materialize (postgres + 0x27c509)
                                                                #5 
0x000000000067c558 tts_minimal_copy_minimal_tuple (postgres + 0x27c558)
                                                                #6 
0x0000000000918ba7 tuplestore_puttupleslot (postgres + 0x518ba7)
                                                                #7 
0x000000000067f5c3 sqlfunction_receive (postgres + 0x27f5c3)
                                                                #8 
0x0000000000671f4f standard_ExecutorRun (postgres + 0x271f4f)
                                                                #9 
0x00000000006805b4 fmgr_sql (postgres + 0x2805b4)
                                                                #10
0x000000000067a4bf ExecMakeTableFunctionResult (postgres + 0x27a4bf)
                                                                #11
0x000000000068a2b1 FunctionNext (postgres + 0x28a2b1)
                                                                #12
0x0000000000671f22 standard_ExecutorRun (postgres + 0x271f22)
                                                                #13
0x00000000007d439c PortalRunSelect (postgres + 0x3d439c)
                                                                #14
0x00000000007d56ee PortalRun (postgres + 0x3d56ee)
                                                                #15
0x00000000007d127c exec_simple_query (postgres + 0x3d127c)
                                                                #16
0x00000000007d32e9 PostgresMain (postgres + 0x3d32e9)
                                                                #17
0x000000000075d569 ServerLoop (postgres + 0x35d569)
                                                                #18
0x000000000075e4b3 PostmasterMain (postgres + 0x35e4b3)
                                                                #19
0x00000000004f03f3 main (postgres + 0xf03f3)
                                                                #20
0x00007fcbbbc92042 __libc_start_main (libc.so.6 + 0x27042)
                                                                #21
0x00000000004f049e _start (postgres + 0xf049e)








--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html



pgsql-bugs by date:

Previous
From: Alexander Zubkov
Date:
Subject: Re: BUG #16659: postgresql leaks memory or do not limit its usage
Next
From: pinker
Date:
Subject: Re: Postgres 13 signal 11: Segmentation fault tested on 2 independent machines