Re: 7.4.3 server panic

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris" <chris(at)paymentonline(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.4.3 server panic
Date: 2004-08-11 18:26:14
Message-ID: 15303.1092248774@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Chris" <chris(at)paymentonline(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2004-08-11 18:37:06 Re: replication
Previous Message Matt Van Mater 2004-08-11 18:24:59 disabling autocommit