Skip site navigation (1) Skip section navigation (2)

Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: "Dorochevsky, Michel" <michel(dot)dorochevsky(at)softcon(dot)de>, pgsql-bugs(at)postgresql(dot)org, Dave Page <dpage(at)postgresql(dot)org>
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect
Date: 2007-04-24 02:42:38
Message-ID: 19442.1177382558@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-patches
Well hot dang, I managed to reproduce this:

$ ./followlog "dbname = tschema" <log.sql
command failed at log line 30522:
COMMIT PREPARED '257_dm0td2luMjAwMHByby8yNTM2AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==_MQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=='
PANIC:  failed to re-find shared lock object
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
$ 

So at least now we know it's not a Windows-specific issue, which is
something I was getting more and more worried about after two days of
not being able to duplicate the crash.  I went so far as to make a
program that reads the log excerpt Michel sent, and execute the commands
in sequence on as many different connections as he had active ... and
darn if it doesn't fail.  It seems fully reproducible on both 8.2 and
HEAD.

Now to start debugging.  We can stop pestering Michel to run various
strange binaries, at least.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: ITAGAKI TakahiroDate: 2007-04-24 04:16:01
Subject: Any incompatibility in pg_enc between 8.2 and 8.3?
Previous:From: Robert TreatDate: 2007-04-24 01:15:38
Subject: Re: [HACKERS] Wild idea: 9.0?

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-04-24 04:37:20
Subject: Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect
Previous:From: Daniele VarrazzoDate: 2007-04-23 23:27:05
Subject: ILIKE fails with accented letters on utf8 locale

pgsql-patches by date

Next:From: Greg SmithDate: 2007-04-24 04:16:38
Subject: Re: Load distributed checkpoint V4
Previous:From: Koichi SuzukiDate: 2007-04-24 01:15:15
Subject: Re: [HACKERS] Full page writes improvement, code update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group