Re: BUG #3245: PANIC: failed to re-find shared loc k ob je ct

Dorochevsky,Michel wrote:

Michel; I've uploaded an 8.2.3 postgres.exe to
http://developer.pgadmin.org/~dpage/postgres-8.2.3-debug.zip. This is
the same as the release version, but configured with --enable-debug
--enable-cassert, and patched with Tom's patch.

Regards, Dave.

Dave,
Thanks a lot. You can download the results at
www.dorochevsky.de/infos/postgresql-2007-04-23_130939.zip
run with the debug version of postgres you provided.

Hope this helps to clarify what is going on.

Thanks!

It looks like it's a relation-lock that's being lost. That's all I can
say :(.

Dave, could you do another build with LOCK_DEBUG enabled? Michel, could
you please add trace_locks=on to postgresql.conf, and run the test one
more time with the LOCK_DEBUG-enabled build. That should give us a much
better picture of what's happening. (be warned, it can generate a lot of
log...)

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

Heikki Linnakangas wrote:

Dave, could you do another build with LOCK_DEBUG enabled? Michel, could
you please add trace_locks=on to postgresql.conf, and run the test one
more time with the LOCK_DEBUG-enabled build. That should give us a much
better picture of what's happening. (be warned, it can generate a lot of
log...)

Sure - Michel, please download from
http://developer.pgadmin.org/~dpage/postgres-8.2.3-debug2.zip.

This is the same as the release version, but with

--enable-debug
--enable-cassert
-DLOCK_DEBUG
Tom's patch
Heikki's LOCK_DEBUG patch.

Regards, Dave

"Dorochevsky,Michel" <michel.dorochevsky@softcon.de> writes:

Thanks a lot. You can download the results at
www.dorochevsky.de/infos/postgresql-2007-04-23_130939.zip
run with the debug version of postgres you provided.

So, which of your tables has OID 417227? Easiest way to check is
select 417227::regclass

regards, tom lane

Michel, could you show us all the non-default entries in your
postgresql.conf? Just wondering if there might be something relevant...

regards, tom lane