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 по дате отправления: