I'm about to begin researching this, but I thought I'd throw this out there
and see if there are any quick responses.
Last night, I got this:
Jan 13 03:31:28 db01 postgres[23537]: [140-2] DETAIL: Process 23537 waits
for AccessShareLock on relation 1260 of database 0; blocked by process
8.
Scott Whitney swhit...@journyx.com writes:
Last night, I got this:
Jan 13 03:31:28 db01 postgres[23537]: [140-2] DETAIL: Process 23537 waits
for AccessShareLock on relation 1260 of database 0; blocked by process
8.
Jan 13 03:31:28 db01 postgres[23537]: [140-3] Process 8 waits for
Tom Lane wrote:
Scott Whitney swhit...@journyx.com writes:
It ended up locking up about 250 customer databases until I restarted the
postmaster. This is version 8.1.4. Upgrading right now (even to a minor rev)
is not really an option.
Not related to the immediate problem, but: you
On Tue, Jan 13, 2009 at 10:37 AM, Scott Whitney swhit...@journyx.com wrote:
It ended up locking up about 250 customer databases until I restarted the
postmaster. This is version 8.1.4. Upgrading right now (even to a minor rev)
is not really an option. This box has been up and running for 306
deadlock error last night
On Tue, Jan 13, 2009 at 10:37 AM, Scott Whitney swhit...@journyx.com
wrote:
It ended up locking up about 250 customer databases until I restarted the
postmaster. This is version 8.1.4. Upgrading right now (even to a minor
rev)
is not really an option. This box has been