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

Search Discussions

  • Vadim Mikheev at Feb 6, 2001 at 6:54 am

    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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedFeb 1, '01 at 10:15a
activeFeb 6, '01 at 6:54a
posts2
users2
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase