Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJ2dV-0020pn-Uj for pgsql-admin@arkaria.postgresql.org; Mon, 17 Jun 2024 03:02:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sJ2dS-00CP0E-Au for pgsql-admin@arkaria.postgresql.org; Mon, 17 Jun 2024 03:02:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJ2dR-00CP05-Sz for pgsql-admin@lists.postgresql.org; Mon, 17 Jun 2024 03:02:22 +0000 Received: from chi208.greengeeks.net ([65.60.38.74]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sJ2dN-0023YB-PB for pgsql-admin@postgresql.org; Mon, 17 Jun 2024 03:02:22 +0000 Received: from [217.180.196.83] (port=60858 helo=Incisivetech) by chi208.greengeeks.net with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.97.1) (envelope-from ) id 1sJ2dW-0000000BOUT-11Bd; Mon, 17 Jun 2024 03:02:14 +0000 From: To: "'Veerendra Pulapa'" , "'pgsql-admin'" , References: In-Reply-To: Subject: RE: Urgent: Segmentation Fault in PostgreSQL postmaster Process Date: Sun, 16 Jun 2024 23:02:11 -0400 Message-ID: <033501dac062$c1286930$43793b90$@incisivetechgroup.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0336_01DAC041.3A173E60" X-Mailer: Microsoft Outlook 16.0 Thread-Index: AQFiW/tAl62jNL8BZEqJ8CMugqg/OLK8DSEA Content-Language: en-us X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - chi208.greengeeks.net X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - incisivetechgroup.com X-Get-Message-Sender-Via: chi208.greengeeks.net: authenticated_id: lennam@incisivetechgroup.com X-Authenticated-Sender: chi208.greengeeks.net: lennam@incisivetechgroup.com X-Source: X-Source-Args: X-Source-Dir: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multipart message in MIME format. ------=_NextPart_000_0336_01DAC041.3A173E60 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Check if any disk issues=20 Storage is local or SAN , if SAN see if any hiccups to communicate SAN=20 Check disk space usage=20 =20 =20 =20 From: Veerendra Pulapa =20 Sent: Sunday, June 16, 2024 7:49 PM To: pgsql-admin ; = pgsql-admin@lists.postgresql.org Subject: Urgent: Segmentation Fault in PostgreSQL postmaster Process =20 Dear Team, =20 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. =20 Issue Description We encountered a segmentation fault in the postmaster process of our = PostgreSQL instance. The relevant system log entry is as follows: =20 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. =20 OS logs: kernel: postmaster[7844]: segfault at 2dd736b ip 00000000004ddc75 sp = 00007ffe0e9c3490 error 6 in postgres[400000+73e000] =20 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] =20 Br, Veerendra Pulapa | Technical Consultant M: +91-9949349894 | www.ashnik.com =20 = =20 = = = = =20 =20 _________________________________________________________________________= _____________ 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.=20 =20 ------=_NextPart_000_0336_01DAC041.3A173E60 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Check if any disk issues =

Storage is local or SAN , =C2=A0if = SAN see if any hiccups to communicate SAN

Check disk space usage

 

 

 

From: Veerendra Pulapa = <veerendra.pulapa@ashnik.com>
Sent: Sunday, June 16, = 2024 7:49 PM
To: pgsql-admin = <pgsql-admin@postgresql.org>; = pgsql-admin@lists.postgresql.org
Subject: 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]

 

Br,

V= eerendra Pulapa | Technical Consultant

M= : +91-9949349894 | www.ashnik.com

  &nbs= p;  &nbs= p;  =    &nbs= p;

 

____= _________________________________________________________________________= _________

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. 

 

------=_NextPart_000_0336_01DAC041.3A173E60--