Re: Is Pg 7.0.x's Locking Mechanism BROKEN?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: frank <f.callaghan@ieee.org>
Cc: Fabrice Scemama <fabrices@ximmo.ftd.fr>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2000-07-27T20:23:14Z
Lists: pgsql-hackers
Frank and Fabrice,

If you aren't having any luck generating a reproducible example of this
problem, you might try recompiling the backend with LOCK_DEBUG defined
in src/include/config.h --- or just do
	gmake clean
	gmake PROFILE=-DLOCK_DEBUG all
This should produce pretty voluminous quantities of info in the
postmaster's stdout/stderr log.  Run the postmaster with -d2 so we
can see the related queries too, and then maybe the log will have enough
info to tell something useful the next time you see it happen.

			regards, tom lane