Database just stopped working. HELP

From: Steve Heaven <steve(at)thornet(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Database just stopped working. HELP
Date: 2000-12-14 08:56:59
Message-ID: 3.0.1.32.20001214085659.007478a4@mail.thornet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

One of the databases on our server has simply stopped. All the other dBs on
that server are unaffected.

No psql commands work, not even simple things like \d.
A vaccumdb --verbose produces the output below and then just locks up.
It doesnt seem to be in a loop as its not soaking up CPU power.
This Db has been working fine until now.

Any help would be _gratefully_ appreciated

Steve

NOTICE: --Relation pg_type--
NOTICE: Pages 3: Changed 0, Reapped 1, Empty 0, New 0; Tup 148: Vac 0,
Keep/VTL
0/0, Crash 0, UnUsed 66, MinLen 105, MaxLen 109; Re-using: Free/Avail.
Space 74
56/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
NOTICE: Index pg_type_typname_index: Pages 8; Tuples 148: Deleted 0.
Elapsed 0/
0 sec.
NOTICE: Index pg_type_oid_index: Pages 5; Tuples 148: Deleted 0. Elapsed
0/0 se
c.
NOTICE: --Relation pg_attribute--
NOTICE: Pages 10: Changed 0, Reapped 1, Empty 0, New 0; Tup 755: Vac 0,
Keep/VT
L 0/0, Crash 0, UnUsed 25, MinLen 97, MaxLen 100; Re-using: Free/Avail.
Space 25
72/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
NOTICE: Index pg_attribute_attrelid_index: Pages 27; Tuples 755: Deleted
0. Ela
psed 0/0 sec.
NOTICE: Index pg_attribute_relid_attnum_index: Pages 33; Tuples 755:
Deleted 0.
Elapsed 0/0 sec.
NOTICE: Index pg_attribute_relid_attnam_index: Pages 76; Tuples 755:
Deleted 0.
Elapsed 0/0 sec.
NOTICE: --Relation pg_proc--
NOTICE: Pages 21: Changed 0, Reapped 0, Empty 0, New 0; Tup 1021: Vac 0,
Keep/V
TL 0/0, Crash 0, UnUsed 0, MinLen 145, MaxLen 197; Re-using: Free/Avail.
Space 0
/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
NOTICE: Index pg_proc_prosrc_index: Pages 7; Tuples 1021. Elapsed 0/0 sec.
NOTICE: Index pg_proc_proname_narg_type_index: Pages 17; Tuples 1021.
Elapsed 0
/0 sec.
NOTICE: Index pg_proc_oid_index: Pages 5; Tuples 1021. Elapsed 0/0 sec.
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Ian Capon Fiel 2000-12-14 09:59:48 Re: PostgreSQL v.7.0.2 for Windows 98,2000,NT
Previous Message Esa Pikkarainen 2000-12-14 08:06:44 space problem