WAL Crash during index vacuuming 7.1beta4
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:
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