On 2013-11-18 10:58:26 -0800, Christophe Pettus wrote:
> After promotion, it was discovered that there was significant data
> loss on S1. Rows that were present on P1 were missing on S1, and some
> rows were duplicated (including duplicates that violated primary key
> and other unique constraints). The indexes were corrupt, in that they
> seemed to think that the duplicates were not duplicated, and that the
> missing rows were still present.
Were there any kind of patterns in the lost data? What kind of workload
are they running? I have an idea what the issue might be...
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services
