RE: Urgent: Segmentation Fault in PostgreSQL postmaster Process

Dear Team,

I am experiencing a segmentation fault issue with the postmaster process of our PostgreSQL database, and I am seeking your assistance. Below are the details of the error and our system configuration.

Issue Description

We encountered a segmentation fault in the postmaster process of our PostgreSQL instance. The relevant system log entry is as follows:

DB Logs:

LOG:  restartpoint starting: time

LOG:  startup process (PID 21704) was terminated by signal 11: Segmentation fault

LOG:  terminating any other active server processes

LOG:  database system is shut down

LOG:  starting PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

LOG:  listening on IPv4 address "0.0.0.0", port 5432

LOG:  listening on IPv6 address "::", port 5432

LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"

LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"

LOG:  database system was interrupted while in recovery at log time 2024-06-16 19:37:48 +08

HINT:  If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target.

OS logs:

kernel: postmaster[7844]: segfault at 2dd736b ip 00000000004ddc75 sp 00007ffe0e9c3490 error 6 in postgres[400000+73e000]

PostgreSQL Version and Environment:

PostgreSQL Version: 13.2

Operating System: rhel 7.9

Kernel Version: 3.10.0-1160.118.1.el7.x86_64

System Specifications: [32 vCPU, 250GB]