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

Re: 9.1.3 backends getting stuck in 'startup'

From: Jeff Frost <jeff(at)pgexperts(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 9.1.3 backends getting stuck in 'startup'
Date: 2012-04-29 00:17:25
Message-ID: 343438C7-5C1A-47B9-BBE8-AE0E6DC57804@pgexperts.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Apr 27, 2012, at 6:15 PM, Tom Lane wrote:

> Jeff Frost <jeff(at)pgexperts(dot)com> writes:
>> Oh, good idea!  Looks like pg_buffercache is installed in this DB.  Customer
>> reports that it has been installed since the server has existed (and on the
>> previous server) but is not currently being used, though the issue with the
>> hanging startups did not start until this morning. Could it still cause
>> contention even if it's not being executed?
> 
> No, it shouldn't.  Perhaps we should start asking questions around the
> idea of "so what changed this morning?".  There has to have been some
> triggering cause, a configuration change or application change or
> something.


Since I had a theory that it's probably stalling on pg_catalog access, one of the guys wrote a test harness that makes several connections and creates and drops lots of temp tables. That does seem to allow us to reproduce the issue in the production DB, but not in a newly created DB.  So, we're about to initdb a new data directory and slony replicate the data over to it on the original server.

In response to

Responses

pgsql-bugs by date

Next:From: mng5888Date: 2012-04-30 13:48:44
Subject: BUG #6622: ld.so.1: initdb: fatal: libxsit.so.1: open failed: No suchfile or directory
Previous:From: Alex HunsakerDate: 2012-04-28 23:52:20
Subject: Re: hstore parser incorrectly handles malformed input

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