Hello,
We’re seeing an occasional segfault on a particular database
Mar 7 14:46:35 pgprod2 kernel:postgres[29351]: segfault at 0 ip
00302f32868a sp 7ffcf1547498 error 4 in libc-2.12.so[302f20+18a000]
Mar 7 14:46:35 pgprod2 POSTGRES[21262]: [5] user=,db=,app=client= LOG: server
pr
.log_level = log
select * from information_schema.role_table_grants where grantee = 'auditor';
(0 rows)
thanks, Blair
From: Pavel Stehule
Date: Thursday, March 8, 2018 at 9:49 AM
To: Blair Boadway
Cc: "pgsql-gene...@postgresql.org"
Subject: Re: Troubleshooting a segfault a
PM
To: "pavel.steh...@gmail.com" , Blair Boadway
Cc: "pgsql-gene...@postgresql.org"
Subject: RE: Troubleshooting a segfault and instance crash
Hi Blair, Pavel,
we are using procedure described in https://access.redhat.com/solutions/4896
to automate crash detail collection f
ideas, we will pull the pg_hint_plan extension and see if that
removes the problem.
-Blair
From: Peter Geoghegan
Date: Saturday, March 24, 2018 at 4:18 PM
To: Blair Boadway
Cc: "pgsql-gene...@postgresql.org"
Subject: Re: Troubleshooting a segfault and instance crash
On Thu, Ma
conditions. This
strongly suggests pg_hint_plan was the root cause of our issue but we can’t yet
be 100% certain as the issue was always transient.
-Blair
From: Pavel Stehule
Date: Saturday, March 24, 2018 at 9:18 PM
To: Blair Boadway
Cc: Peter Geoghegan , "pgsql-gene...@postgresql.org"
S
