BUG #8534: Missing record in binary replica 9.3
От | kavehmz@gmail.com |
---|---|
Тема | BUG #8534: Missing record in binary replica 9.3 |
Дата | |
Msg-id | E1VWpo8-0008LK-Lx@wrigleys.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 8534 Logged by: Kaveh Mousavi Zamani Email address: kavehmz@gmail.com PostgreSQL version: 9.3.0 Operating system: Debian 6.0 Description: All, I found something in the following setup: I have 3 DBS db01 (9.3.0) master db02 (9.3.0) replica same network db03 (9.3.0) sync replica another network 80ms away. db01 have around 30 - 300 records per second update. At some point today I found there is a missing record in both replica. Data after that point has been replicated though db01 select * from transaction.account where client_detail_id ='163042'; id | client_detail_id | last_modified ---------+----------------+---------------+----------+ 1736861 | 163042 | 2013-10-17 10:39:18.312815 in both other dbs no record. Does anyone has any idea how could this happen? Is this a bug in 9.3 replication? then in db01 I did update last_modified field for that record and suddenly new record and new last_modified values appeared in both replicas. I double check the replica DB and I can confirm there are more missing lines in different tables. Regards
В списке pgsql-bugs по дате отправления: