Skip site navigation (1) Skip section navigation (2)

Re: diagnosing a db crash - server exit code 2

From: "Burgholzer, Robert (DEQ)" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Joe Conway" <mail(at)joeconway(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: diagnosing a db crash - server exit code 2
Date: 2011-09-23 20:54:37
Message-ID: B6C40D17104BEF47B1CB85623CDFAC6357BE2D@COVMSGCES-EMB13.cov.virginia.gov (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks Scott - I'm on the MFer.  That is, I WILL be on it next Monday when I have time to sit down, gin up a test case and break this sucker. :)

Stay tuned, and thanks bunches,

r.b.


-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Fri 9/23/2011 4:51 PM
To: Burgholzer, Robert (DEQ)
Cc: Joe Conway; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] diagnosing a db crash - server exit code 2
 
On Fri, Sep 23, 2011 at 2:45 PM, Burgholzer, Robert (DEQ)
<Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov> wrote:
> Scott - thanks, in pouring over the logs, I have not found anything certain,
> but have turned up a ton of mesages about my sysadmins se-linux security and
> php/pg (don't know if they're my app or script kiddies...).  I will keep
> looking for things pertianing to these crashes.  The message relative to php
> and pgsql:
> Sep 20 11:37:32 deq1 setroubleshoot: SELinux is preventing php
> (httpd_sys_script_t) "setopt" to <Unknown> (httpd_sys_script_t). For
> complete SELinux messages. run sealert -l
> 199268c4-b84d-4a33-a073-29bd4461f875

Take a peek here:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

If you can get a trace I'm sure Joe can figure out what's making it
croak.  Not that I speak for Joe, I just have faith in him. :)

In response to

pgsql-admin by date

Next:From: Christoph BergDate: 2011-09-23 21:00:09
Subject: Re: [pgsql-pkg-debian] Fwd: Invalid version while creating PostgreSQL 9.1 cluster
Previous:From: Scott MarloweDate: 2011-09-23 20:51:35
Subject: Re: diagnosing a db crash - server exit code 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group