Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup
Date
Msg-id CAM3SWZQ0BZXwWQJW5EQ6N=P8=M6kn1PTp9yi3WKhVxjpXP7KXg@mail.gmail.com
Whole thread Raw
In response to BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup  (charles.harwood@zuerchertech.com)
Responses Re: BUG #12718: Apparent LWlock Problem Perhaps With Page Cleanup  ("Charles R. Harwood" <charles.harwood@zuerchertech.com>)
List pgsql-bugs
On Fri, Jan 30, 2015 at 2:14 PM,  <charles.harwood@zuerchertech.com> wrote:
> Many postgres worker processes stopped responding.  They continued to be in
> state 'active' and not 'waiting' for hours.  Each query was on the table
> that an autovacuum process was also hung on processing and was the oldest
> active transaction on.


Was pg_upgrade run on this database at some point [1]?

I foresee more problems here...

[1] http://www.postgresql.org/message-id/20140825225029.2536.5315@wrigleys.postgresql.org
--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: satson.csc17@gmail.com
Date:
Subject: BUG #12717: Slow Query
Next
From: hans@matfyz.cz
Date:
Subject: BUG #12721: psql -a does not preserve empty lines between SELECTs