| From: | "Vadim Mikheev" <vmikheev(at)sectorbase(dot)com> |
|---|---|
| To: | "Giuseppe Tanzilli - CSF" <g(dot)tanzilli(at)gruppocsf(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: WAL Crash during index vacuuming 7.1beta4 |
| Date: | 2001-02-06 06:52:38 |
| Message-ID: | 004601c09009$6512a500$4e79583f@sectorbase.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sourabh dixit | 2001-02-06 08:26:36 | Postgre SQL for Windows |
| Previous Message | Dan Wilson | 2001-02-06 05:57:55 | Re: Re: [HACKERS] Re: Re: grant privileges to a database [URGENT] |