Missing record in binary replica 9.3.0

From: Kaveh Mousavi Zamani <kavehmz(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Missing record in binary replica 9.3.0
Date: 2013-10-17 13:13:43
Message-ID: CAJcKpEp0SzTo_2PJ4T5s-yFw=ASzbQ+wXwjRN7h=vbc5u+TEyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

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.

Regards

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-10-17 13:13:54 Re: Index creation fails with automatic names
Previous Message Vick Khera 2013-10-17 13:09:59 Re: Index creation fails with automatic names