RE: strange behaviour (bug) - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: strange behaviour (bug)
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018CC3@SECTORBASE1
Whole thread Raw
In response to strange behaviour (bug)  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
Responses RE: strange behaviour (bug)
List pgsql-hackers
> > I'm going to handle btree split but currently there is no way
> > to rollback it - we unlock splitted pages after parent
> > is locked and concurrent backend may update one/both of
> > siblings before we get our locks back.
> > We have to continue with split or could leave parent unchanged
> > and handle "my bits moved..." (ie continue split in another
> > xaction if we found no parent for a page) ... or we could hold
> > locks on all splitted pages till some parent updated without
> > split, but I wouldn't do this.
> >
> 
> It seems to me that btree split operations must always be
> rolled forward even in case of abort/crash. DO you have
> other ideas ?

Yes, it should, but hard to implement, especially for abort case.
So, for the moment, I would proceed with handling "my bits moved...":
no reason to elog(FATAL) here - we can try to insert missed pointers
into parent page(s). WAL will guarantee that btitems moved to right
sibling will not be lost (level consistency), and missing some pointers
in parent level is acceptable - scans will work.

Vadim


pgsql-hackers by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Status of new relation file naming
Next
From: Peter Mount
Date:
Subject: Re: RE: [COMMITTERS] pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)