Re: Urgent: Segmentation Fault in PostgreSQL postmaster Process

Veerendra Pulapa <veerendra.pulapa@xxxxxxxxxx> · Mon, 17 Jun 2024 18:30:44 +0530

The signal 11 error reported only on the standby node. We have two nodes, one master and one standby. And Virtual machines are hosted in azure. 

We have upgraded the OS from 7.x to 8.x after the upgrade we have observed some discrepancy then we rollback the OS. Even after rollback we are also facing the same problem.

Br,
Veerendra Pulapa | Technical ConsultantM: +91-9949349894 | www.ashnik.com

On Mon, Jun 17, 2024 at 10:44 AM Achilleas Mantzios <a.mantzios@xxxxxxxxxxxxxxxxxxxx> wrote:

    Στις 17/6/24 02:49, ο/η Veerendra
      Pulapa έγραψε:

            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.

    This runs as a primary right?
        The logs indicate that the postmaster had already crashed and
        was trying to recover while it threw another segfault.

    Give us some historical
        background of any events that happened in the course of your
        installation that might be of any interest. Such as, how often
        do you get the problem, how long are you having this problem,
        what did change before the problem started to appear
        (software/hardware).

    IME, such errors could be due to
        either faulty CPU or memory. I'd run a memtest and run
        diagnostics (BIOS), check temperatures, etc

            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]

                Br,
                Veerendra
                  Pulapa | Technical Consultant
                M:
                    +91-9949349894 | www.ashnik.com

          ______________________________________________________________________________________
          This email may contain
                confidential, privileged or copyright material and is
                solely for the use of the intended recipient(s). If you
                are not the rightful recipient of this email, please
                delete this email immediately and inform the recipient. 

    -- 
Achilleas Mantzios
 IT DEV - HEAD
 IT DEPT
 Dynacom Tankers Mgmt (as agents only)

______________________________________________________________________________________
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s). If you are not the rightful recipient of this email, please delete this email immediately and inform the recipient. 