WAL Crash during index vacuuming 7.1beta4

Started by Giuseppe Tanzilli - CSFalmost 25 years ago2 messages
#1Giuseppe Tanzilli - CSF
g.tanzilli@gruppocsf.com
1 attachment(s)

Hi,
during the nightly vacuum pgsql closed and do not start any more.
Attached the log.

Seems the problem was rebuilding an Index,
There is a way to force wal to ignore indexes ?
Can I delete it ?

thanks in advance

-------------------------------------------------------
Giuseppe Tanzilli g.tanzilli@gruppocsf.com
CSF Sistemi srl phone ++39 0775 7771
Via del Ciavattino
Anagni FR
Italy

Attachments:

pgsql_logtext/plain; name=pgsql_logDownload
#2Vadim Mikheev
vmikheev@sectorbase.com
In reply to: Giuseppe Tanzilli - CSF (#1)
Re: WAL Crash during index vacuuming 7.1beta4

during the nightly vacuum pgsql closed and do not start any more.
Attached the log.

Seems the problem was rebuilding an Index,
There is a way to force wal to ignore indexes ?

The problem was in redoing tuple movement in *table*.

Can I delete it ?

...

DEBUG: redo starts at (6, 4144414796)
NOTICE: PageAddItem: tried overwrite of used ItemId

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

FATAL 2: heap_update_redo: failed to add tuple

I think that I've just fixed this problem (must not check itemid'
flag in PageAddItem in overwrite mode when offset number
== maxoff + 1). I hope that Giuseppe will check new code soon.

Thanks to Giuseppe for help!

Vadim