Re: 7.4.3 server panic - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.4.3 server panic
Date
Msg-id 15303.1092248774@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.4.3 server panic  ("Chris" <chris@paymentonline.com>)
List pgsql-general
"Chris" <chris@paymentonline.com> writes:
>> Can you get a stack traceback from this crash?

> (gdb) bt
> #0  0x284f9dcf in kill () from /lib/libc.so.5
> #1  0x284ee878 in raise () from /lib/libc.so.5
> #2  0x28566f82 in abort () from /lib/libc.so.5
> #3  0x08226a6a in errfinish ()
> #4  0x08226953 in errfinish ()
> #5  0x0822f54d in GetUserNameFromId ()
> #6  0x081183a3 in show_session_authorization ()
> #7  0x08232fe7 in show_all_settings ()
> #8  0x0823196b in AtEOXact_GUC ()
> #9  0x0823164f in AtEOXact_GUC ()
> #10 0x08094cbd in XactPopRollback ()
> #11 0x081a2334 in PostgresMain ()

The trace is a bit bogus, but it did help me figure out what's going on:
I think that we're trying to report the current session authorization to
the client (which is something that happens automatically on any change)
and it's referencing a deleted user.  Is it possible that your setup is
deleting the user that the entire session is running as?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql: immediately exit after an error?
Next
From: Robert Treat
Date:
Subject: Re: PostgreSQL 8.0 Feature List?