strange vacuum problem fixed by itself after one day??? - Mailing list pgsql-admin

From Palle Girgensohn
Subject strange vacuum problem fixed by itself after one day???
Date
Msg-id 39C8A6CE.9B85B1F9@partitur.se
Whole thread Raw
List pgsql-admin
Hi!

Here's a strange thing:

Automatic vacuum failed this night, and so did the pg_dump.

Here's what happened when trying to vacuum today:

db=# vacuum verbose;
...
NOTICE:  --Relation personer--
NOTICE:  Pages 155: Changed 0, reaped 6, Empty 0, New 0; Tup
6004: Vac 1, Keep/VTL 0/0, Crash 0, UnUsed 10, MinLen 132,
MaxLen 332; Re-using: Free/Avail. Space 8980/516;
EndEmpty/Avail. Pages 1/3. CPU 0.01s/0.43u sec.
NOTICE:  Index personer_personid_fname_idx: Pages 44; Tuples
6004: Deleted 0. CPU 0.00s/0.01u sec.
NOTICE:  Index personer_personid_index: Pages 30; Tuples 6004:
Deleted 0. CPU 0.00s/0.00u sec.
NOTICE:  Index personer_fnamn_idx: Pages 34; Tuples 6004:
Deleted 0. CPU 0.00s/0.00u sec.
NOTICE:  Rel personer: Pages: 155 --> 154; Tuple(s) moved: 0.
CPU 0.00s/0.00u sec.
NOTICE:  FlushRelationBuffers(personer, 154): block 153 is
referenced (private 0, global 2)
FATAL 1:  VACUUM (vc_repair_frag): FlushRelationBuffers
returned -2
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset:
Succeeded.


I tried several times, to no avail. So, I sat down and began
writing this mail, and for reference, I did a vacuum analyze
again, and whaow, it just worked:

NOTICE:  --Relation personer--
NOTICE:  Pages 155: Changed 1, reaped 6, Empty 0, New 0; Tup
6005: Vac 1, Keep/VTL 0/0, Crash 0, UnUsed 10, MinLen 132,
MaxLen 332; Re-using: Free/Avail. Space 8788/700;
EndEmpty/Avail. Pages 0/4. CPU 0.02s/0.42u sec.
NOTICE:  Index personer_personid_fname_idx: Pages 44; Tuples
6005: Deleted 0. CPU 0.00s/0.01u sec.
NOTICE:  Index personer_personid_index: Pages 30; Tuples 6005:
Deleted 0. CPU 0.00s/0.01u sec.
NOTICE:  Index personer_fnamn_idx: Pages 34; Tuples 6005:
Deleted 0. CPU 0.00s/0.01u sec.
NOTICE:  Rel personer: Pages: 155 --> 155; Tuple(s) moved: 0.
CPU 0.00s/0.00u sec.


How come? It was broken for more than half a day, and I did try
multiple verbose [analyze].


FreeBSD 4.1-STABLE Tue Sep 12 20:48:53 CEST 2000
PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.0, compiled by cc

/Palle

--
         Partitur Informationsteknik AB
Wenner-Gren Center             +46 8 566 280 02
113 46 Stockholm           +46 70 785 86 02
Sweden                   girgen@partitur.se

pgsql-admin by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: NOTICE: CREATE TABLE/FOREIGN KEY clause ignored; not yet implemented
Next
From: Palle Girgensohn
Date:
Subject: vacuum problem: mdopen: couldn't open