Re: diagnosing a db crash - server exit code 2 - Mailing list pgsql-admin

From Robert Burgholzer
Subject Re: diagnosing a db crash - server exit code 2
Date
Msg-id CACT-NGLpWxh1h7nvHSwptxZ19KBn0UfqLbX7JnjAbj7yhtTZMA@mail.gmail.com
Whole thread Raw
In response to Re: diagnosing a db crash - server exit code 2  (Joe Conway <mail@joeconway.com>)
List pgsql-admin
Thanks Joe - yeah, I am now tracing the postmaster -- will post up shortly.

r.b.

On Mon, Oct 3, 2011 at 1:28 PM, Joe Conway <mail@joeconway.com> wrote:
On 10/03/2011 10:10 AM, Robert Burgholzer wrote:
> FWIW - I am currently trying this while tracing the process that I
> assume is the postmaster (/usr/bin/postgres -D /home/postgres/data),
> since this process number indicates that it was recently restarted -
> although the other PG processes, writer, wal writer, autovacuum, stats
> collector all have their older pids indicating that they still survive.

Sounds like you are attaching to the wrong process. Try something like
the below...

Joe



Session #1: (connect to db and load PL/R)
-----------------
#psql contrib_regression
psql (9.2devel)
Type "help" for help.

contrib_regression=# load '$libdir/plr';
LOAD

Session #2: (use ps to find backend and attach)
-----------------
# ps -ef |grep postgres
postgres 17001     1  0 Sep24 ?        00:00:16
/usr/local/pgsql-head/bin/postgres -D /usr/local/pgsql-head/data -p 55437 -i
postgres 17006 17001 0 Sep24 ?        00:02:18 postgres: writer process

postgres 17007 17001 0 Sep24 ?        00:01:50 postgres: wal writer
process
postgres 17008 17001 0 Sep24 ?        00:00:37 postgres: autovacuum
launcher process
postgres 17009 17001 0 Sep24 ?        00:00:47 postgres: stats
collector process
postgres 26631 17001  0 10:22 ?        00:00:00 postgres: postgres
contrib_regression [local] idle

#gdb /usr/local/pgsql-head/bin/postgres 26631
(gdb) continue
Continuing.


Session #1: (run crashing function)
-----------------
run your PL/R function that causes the crash


--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support



--
--
Robert W. Burgholzer
http://www.findingfreestyle.com/
On Facebook - http://www.facebook.com/pages/Finding-Freestyle/151918511505970
Twitter - http://www.twitter.com/findfreestyle
What's a tweeted swim set? A Sweet? No, a #swaiku!  Get them by following http://twitter.com/findfreestyle

pgsql-admin by date:

Previous
From: Joe Conway
Date:
Subject: Re: diagnosing a db crash - server exit code 2
Next
From: Julien Rouhaud
Date:
Subject: Re: commiting transaction from outside