RE: strange behaviour (bug)

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: strange behaviour (bug)
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A23018CC3@SECTORBASE1
обсуждение исходный текст
Ответ на strange behaviour (bug)  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
Ответы RE: strange behaviour (bug)
Список 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 по дате отправления:

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: Status of new relation file naming
Следующее
От: Peter Mount
Дата:
Сообщение: Re: RE: [COMMITTERS] pgsql/src/interfaces/jdbc/org/postgresql/jdbc1 (DatabaseMetaData.java)