Re: 7.0.3 database corruption - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 7.0.3 database corruption
Date
Msg-id 17676.992529477@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.0.3 database corruption  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
Hannu Krosing <hannu@tm.ee> writes:
> I could send you tails of postgres logfiles that are rotated on
> detecting 
> the INSERT/UPDATE wait condition that does not go away in 10 sec. 
> How long logfiles (time) would be enough ?

Do the logs show the queries being executed?  The queries forming
the current transaction of the stuck backend, and all the transactions
that have occurred since that transaction started, would be useful
to look at.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: 7.0.3 database corruption
Next
From: Alex Pilosov
Date:
Subject: Re: Re: SELECT Field1 || Field2 FROM Table