From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 8.4.4 locked after power failure |
Date: | 2011-09-12 14:19:16 |
Message-ID: | CAHyXU0zZohf-SLyj=usa5Yuw-CHq0+DyNVjdQNGPd8fKuTQw4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2011/9/12 Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>:
> So here's the thing. I got a message from one of the developers, that
> running 'create temporary sequence xyz;' hangs on the database.
> That seemed suspicious. I tried running any ddl command, and that hang.
> No other connections to the database.
>
> It turned out that it had a power failure earlier in the morning. That
> seems ok, but in the past postgresql will always recover fine (at
> least 8.3.x).
> This time I had to reindex, and vacuum all user and system catalogues
> to get system back in order.
>
> Any ideas ? Is that something new, is it fixed in any newer releases ?
>
>
> Unfortunately it had to be done rather quick - so I couldn't salvage any data.
It seems odd that you could not create a temp sequence but you were
able to reindex the entire database. did you confirm you were
blocking on a non-granted lock?
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-09-12 14:41:34 | Re: Index Corruption |
Previous Message | Devrim GÜNDÜZ | 2011-09-12 14:17:10 | Re: Has Pg 9.1.0 been released today? |