Re: Index corruption
От | Hannu Krosing |
---|---|
Тема | Re: Index corruption |
Дата | |
Msg-id | 1151616225.2845.1.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Index corruption (Chris Browne <cbbrowne@acm.org>) |
Список | pgsql-hackers |
Ühel kenal päeval, N, 2006-06-29 kell 16:42, kirjutas Chris Browne: > marc@bloodnok.com (Marc Munro) writes: > > As you see, slony is attempting to enter one tuple > > ('374520943','22007','0') two times. > > > > Each previous time we have had this problem, rebuilding the indexes on > > slony log table (sl_log_1) has fixed the problem. I have not reindexed > > the table this time as I do not want to destroy any usable evidence. > > We have seen this phenomenon on 7.4.8 several times; pulled dumps of > sl_log_1 and index files that Jan Wieck looked at, which alas hasn't > led to a fix. > > He did, mind you, find some concurrency pattern that led, if memory > serves, to 7.4.12's release. We had experienced cases where there was > some worse corruption that required that we rebuild replicas from > scratch :-(. How well did you check the C-language triggers and special slony functions for possibly corrupting some backend/shared-mem structures ? -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com
В списке pgsql-hackers по дате отправления: