Almost all access to database hangs (fwd)
От | Oliver Elphick |
---|---|
Тема | Almost all access to database hangs (fwd) |
Дата | |
Msg-id | 200104050859.f358x8a17233@linda.lfix.co.uk обсуждение исходный текст |
Ответы |
Re: Almost all access to database hangs (fwd)
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-general |
This is postgresql 7.0.3. Can someone help with clearing the problem and saving his data? ------- Forwarded Messages - amalgamated From: Sven Fischer <sepreh@gmx.de> To: 92641@bugs.debian.org Subject: Bug#92641: Similar problem since yesterday my postgres won't take a generated database any more - it just hangs with full utilisation of CPU power. The do.maintenance hangs, also a pg_dump I tried hangs. ... Simple select * queries on the database still work, but nothing else ................................. > > Vacuum each table of the affected database separately and see if you can > isolate the problem. The tables generated by me ones were unproblematic to vacuum. > Quite likely you have a corrupted index - in which case drop and > recreate the index. How can I find out which indices I have? I am not a postgres professional, and the \dt command in psql doesn't work anymore (it hangs also). ................................. > However, if \dt hangs, the problem is probably in a system index; > pg_class has two indexes: pg_class_oid_index and pg_class_relname_index. I can do a select * on pg_class, but that's it. Anything else I tried hangs. > See if you can do a pg_dump of this database. If you can, backup the > database itself, pg_dump it, delete it and recreate it from the dump. I tried to dump it ( pg_dump -t pg_class etcs ), but it hangs immediately. > If you can't do that, we'll have to try something else... Seems like that. But I wonder, why. I update my system regularly (unstable, that's fun ;-). Can a library conflict be the reason for it? Because I worked with the db one day, and the other day it gave me this hangs. The problem is, without dumping I would lose some data, and I wouldn't like that... :-P Greetings, Sven -- Sven Fischer -- Mülheimer Str. 133, 51469 Bergisch Gladbach, Germany Tel.: +49-(0)2202-458799 Fax.: +49-(0)89-244310437 sepreh@gmx.de ------- End of Forwarded Messages -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "My dear brothers, take note of this: Everyone should be quick to listen, slow to speak and slow to become angry, for man's anger does not bring about the righteous life that God desires." James 1:19,20
В списке pgsql-general по дате отправления: