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
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 |