Re: diagnosing a db crash - server exit code 2

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(at)joeconway(dot)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