RE: [HACKERS] How to reset WAL enveironment

[Mikheev, Vadim]

> > > FATAL 2: btree_insert_redo: uninitialized page > > > > > > Is it a bug ? > > > > Seems so. btree_insert_redo shouldn't see uninitialized pages > > (only newroot and split ops add pages to index and they should > > be redone before insert op). > > Can you post/ftp me tgz of data dir? > > Or start up postmaster with --wal_debug=1 and send me > > output. > > > > Probably this is caused by my trial (local) change > and generated an illegal log output. > However it seems to mean that WAL isn't always > redo-able. Illegal log output is like disk crash - only BAR can help. I agree that elog(STOP) caused by problems with single data file is quite annoying, it would be great if we could mark table/index as corrupted after recovery, but there are no means for this now. For the moment we can only notify DBA about problems with file node and ignore further recovery of corresponding table/index - I'll do this for beta2/3 if no one else. > In my case the index is probably a > system index unfortunately. Is there a way to Your REINDEX works very well. > avoid invoking recovery process at startup ? You would get totally corrupted database. Remember - WAL avoids not only fsync() but write() too. Vadim