Postgres Pro
Downloads
Home   >   mailing lists

vacuumdb locked. - Mailing list pgsql-general

From Vilson farias
Subject vacuumdb locked.
Date
Msg-id 002201c0b0ad$ecad8740$98a0a8c0@dti.digitro.com.br
Whole thread Raw
List pgsql-general
Tree view 
Hi again.

  I'm having problems with vacuumdb. I have a table corrupted (oper_juntor).
I did a vacuum and it  freezed up. I checked out log file and found these
lines:

 MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages
0/0. CPU 0.00s/0.00u sec.
010319.16:16:20.898 [24167] NOTICE:  Index xak2estado: Pages 2; Tuples 0.
CPU 0.00s/0.00u sec.
010319.16:16:21.016 [24167] NOTICE:  Index xak1estado: Pages 2; Tuples 0.
CPU 0.00s/0.00u sec.
010319.16:16:21.121 [24167] NOTICE:  Index xpkestado: Pages 2; Tuples 0. CPU
0.00s/0.00u sec.
010319.16:16:21.328 [24167] NOTICE:  --Relation oper_juntor--
010319.16:16:21.369 [24167] NOTICE:  Rel oper_juntor: Uninitialized page 0 -
fixing
010319.16:16:21.639 [24167] NOTICE:  Rel oper_juntor: Uninitialized page 1 -
fixing
010319.16:16:21.643 [24167] NOTICE:  Rel oper_juntor: Uninitialized page 2 -
fixing
010319.16:16:21.816 [24167] NOTICE:  Rel oper_juntor: Uninitialized page 3 -
fixing
....
010319.16:16:22.443 [24167] NOTICE:  Rel oper_juntor: Uninitialized page
130 - fixing
....
010319.16:34:01.822 [24859] NOTICE:  Pages 3: Changed 0, reaped 0, Empty 0,
New 0; Tup 130: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed
0, MinLen 164, MaxLen 164; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail.
Pages 0/0. CPU 0.00s/0.00u sec.
010319.16:34:01.827 [24859] NOTICE:  Index pg_index_indexrelid_index: Pages
2; Tuples 130. CPU 0.00s/0.00u sec.

The point where vacuum freezed is here : pg_index_indexrelid_index.


I tryied again. At this time vacuum was taking so long time to finish I was
forced to kill it again. I've tryied another time and again it freezed at
same point :
NOTICE:  Index pg_index_indexrelid_index: Pages 2; Tuples 130. CPU
0.00s/0.00u sec.


This message appeared when I pressed Ctrl + c in vacuumdb process:
[postgres@dgtao postgres]$ fg
/usr/bin/vacuumdb --analyze --verbose -d bxs

Cancel request sent
ERROR:  Query cancel requested while waiting lock
vacuumdb: vacuum failed


Can you tell me what's happening?

Redhat 6.2, pentium 75, 32Mb, Postgres 7.0.3.


Regards,

  José Vilson de Mello de Farias
  Dígitro Tecnologia Ltda.

pgsql-general by date:

Previous
From: Daniel Wickstrom
Date:
Subject: select fails inside function, but works otherwise
Next
From: Lamar Owen
Date:
Subject: Re: Cant connect if -B 1024 was set to postmaster