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