Re: Troubleshooting a segfault and instance crash

2018-03-27 Thread Blair Boadway
ubject: Re: Troubleshooting a segfault and instance crash 2018-03-25 0:41 GMT+01:00 Blair Boadway mailto:bboad...@abebooks.com>>: Thanks for the tip. We are using RHEL 6.9 and definitely up to date on glibc (2.12-1.209.el6_9.2). We also have the same versions on a very similar system

Re: Troubleshooting a segfault and instance crash

2018-03-24 Thread Pavel Stehule
vel > > > -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

RE: Troubleshooting a segfault and instance crash

2018-03-24 Thread Jan Bilek
2018 at 2:56 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 de

Re: Troubleshooting a segfault and instance crash

2018-03-24 Thread Blair Boadway
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

Re: Troubleshooting a segfault and instance crash

2018-03-24 Thread Peter Geoghegan
On Thu, Mar 8, 2018 at 9:40 AM, Blair Boadway wrote: > 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 process (

Re: Troubleshooting a segfault and instance crash

2018-03-24 Thread Blair Boadway
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

RE: Troubleshooting a segfault and instance crash

2018-03-08 Thread Jan Bilek
sql.org<mailto:pgsql-gene...@postgresql.org>" mailto:pgsql-gene...@postgresql.org>> Subject: Re: Troubleshooting a segfault and instance crash Hi 2018-03-08 18:40 GMT+01:00 Blair Boadway mailto:bboad...@abebooks.com>>: Hello, We’re seeing an occasional segfault on a

Re: Troubleshooting a segfault and instance crash

2018-03-08 Thread Pavel Stehule
> > > > *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 and instance crash > > > > Hi > > > > 2018-03-08 18:40 GMT+

Re: Troubleshooting a segfault and instance crash

2018-03-08 Thread Blair Boadway
.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

Re: Troubleshooting a segfault and instance crash

2018-03-08 Thread Pavel Stehule
Hi 2018-03-08 18:40 GMT+01:00 Blair Boadway : > 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:4

Troubleshooting a segfault and instance crash

2018-03-08 Thread Blair Boadway
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