Greetings,
I can't explain what happened but I'm getting some unusual messages that
I've never seen before and some operations in a specific table are not
working anymore (lock table and vacuum). I suppose that some kind of
curruption occurred in my database, but I'm not sure how can I deal with
this situation. Does someone know how can it be fixed? Is it possible to
'reset' TransactionProgress state or something like this? I even restarted
database and it's still the same situation? The problem has ocurred in a old
PostgreSQL 7.1.2 / RedHat 6.2 machine. I've been searching through mailing
lists but I couldn't find too much info about this.
Here are some of my psql logs :
bxs=# begin;
BEGIN
bxs=# lock table cham_atendimento;
NOTICE: current transaction is aborted, queries ignored until end of
transaction block
*ABORT STATE*
bxs=#
bxs=# rollback;
ROLLBACK
bxs=# VACUUM VERBOSE ANALYZE cham_atendimento;
NOTICE: --Relation cham_atendimento--
NOTICE: Rel cham_atendimento: TID 304/76: DeleteTransactionInProgress 0 -
can't shrink relation
NOTICE: Rel cham_atendimento: TID 305/2: DeleteTransactionInProgress 0 -
can't shrink relation
NOTICE: Rel cham_atendimento: TID 305/4: DeleteTransactionInProgress 0 -
can't shrink relation
.....<it repeats last pattern a lot of times>
NOTICE: Pages 316: Changed 0, reaped 316, Empty 0, New 0; Tup 25525: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 1788, MinLen 84,
MaxLen 93; Re-using: Free/Avail. Space 22880/0; EndEmpty/Avail. Pages 0/0.
CPU 0.08s/0.04u sec.
NOTICE: Index xpkcham_atendiment: Pages 213; Tuples 25525: Deleted 0. CPU
0.04s/0.20u sec.
NOTICE: Index xie1cham_atendimen: Pages 428; Tuples 25525: Deleted 0. CPU
0.09s/0.18u sec.
NOTICE: Index xie2cham_atendimen: Pages 318; Tuples 25525: Deleted 0. CPU
0.13s/0.21u sec.
NOTICE: Analyzing...
VACUUM
bxs=#
bxs=# SELECT count(*) FROM cham_atendimento;
count
-------
25525
(1 row)
Best regards,
----------------------------------------------------------------------------
----
José Vilson de Mello de Farias
Software Engineer
Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179
