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-30 16:41:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On 04/28/12 17:17, Jeff Frost wrote:
> 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.

After slony replicating over to the freshly initdb'd original server, the
problem has not recurred.  Maybe the problem was catalog corruption?

In response to

pgsql-bugs by date

Next:From: Josh BerkusDate: 2012-04-30 17:38:06
Subject: Re: log_collector doesn't respond to reloads
Previous:From: mng5888Date: 2012-04-30 13:48:44
Subject: BUG #6622: initdb: fatal: open failed: No suchfile or directory

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