Almost all access to database hangs (fwd) - Mailing list pgsql-general

From Oliver Elphick
Subject Almost all access to database hangs (fwd)
Date
Msg-id 200104050859.f358x8a17233@linda.lfix.co.uk
Whole thread Raw
Responses Re: Almost all access to database hangs (fwd)
List 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 by date:

Previous
From: Peter T Mount
Date:
Subject: RE: JBuilder4 JDBC Explorer
Next
From: Matt Allen
Date:
Subject: Re: Relation XX does not exist