Re: too many LWLocks taken - Mailing list pgsql-general

From Alex Vinogradovs
Subject Re: too many LWLocks taken
Date
Msg-id 1207585149.81391.26.camel@localhost
Whole thread Raw
In response to Re: too many LWLocks taken  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
It appears the errors were caused by table corruption. I've
truncated and reloaded some large table (300m entries),
and the problem disappeared. Table corruption was probably
caused by hardware failure, not by PostgreSQL :)


On Fri, 2008-04-04 at 20:15 -0400, Tom Lane wrote:
> Alex Vinogradovs <AVinogradovs@Clearpathnet.com> writes:
> > Version is 8.2.5 running on FreeBSD 6.2. I can try upgrading
> > to 8.2.7, if you think that would help.
>
> Well, an upgrade would be a good idea on general principles, but
> I doubt it will fix a previously unknown bug.
>
> Does the postmaster log show any other odd behavior around these
> errors?  Which process is throwing the error anyway?  If it's
> a regular backend, what query is it executing?
>
>             regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: edb-debugger, debugging pl/pgsql
Next
From: "Joshua D. Drake"
Date:
Subject: Re: edb-debugger, debugging pl/pgsql