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
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 |