vacuumdb locked.
От | Vilson farias |
---|---|
Тема | vacuumdb locked. |
Дата | |
Msg-id | 002201c0b0ad$ecad8740$98a0a8c0@dti.digitro.com.br обсуждение исходный текст |
Список | 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@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 по дате отправления: