vacuumdb locked.

From: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "SIMONE Carla MOSENA" <simone(dot)mosena(at)digitro(dot)com(dot)br>
Subject: vacuumdb locked.
Date: 2001-03-19 19:51:01
Message-ID: 002201c0b0ad$ecad8740$98a0a8c0@dti.digitro.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)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.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-19 19:52:24 Re: select fails inside function, but works otherwise
Previous Message Brent R. Matzelle 2001-03-19 19:08:08 Re: Win Nt setup help please