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
Thu, 01 Feb 2001 11:13:49 +0100
Giuseppe Tanzilli - CSF <g.tanzilli@gruppocsf.com>
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



Mon, 5 Feb 2001 22:52:38 -0800
"Vadim Mikheev" <vmikheev@sectorbase.com>
Re: WAL Crash during index vacuuming 7.1beta4