Missing record in binary replica 9.3

Поиск
Список
Период
Сортировка
От Kaveh Mousavi Zamani
Тема Missing record in binary replica 9.3
Дата
Msg-id CAJcKpEoTLY1Kaw4-8w=iEWuefj3M_LKyhAATcoGFyB=sQLTJ6Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: m@pplcast.com
Дата:
Сообщение: BUG #8533: JSON error caused by optimisation
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #8531: systemtap probe mark(checkpoint__done) error when i read the parameters