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: 4F9EC0A5.2060009@pgexperts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2012-04-30 17:38:06 Re: log_collector doesn't respond to reloads
Previous Message mng5888 2012-04-30 13:48:44 BUG #6622: ld.so.1: initdb: fatal: libxsit.so.1: open failed: No such file or directory