New and interesting replication issues with 9.2.8 sync rep

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема New and interesting replication issues with 9.2.8 sync rep
Дата
Msg-id 53644CF4.90508@agliodbs.com
обсуждение исходный текст
Ответы Re: New and interesting replication issues with 9.2.8 sync rep
Список pgsql-hackers
Just got a report of a replication issue with 9.2.8 from a community member:

Here's the sequence:

1) A --> B (sync rep)

2) Shut down B

3) Shut down A

4) Start up B as a master

5) Start up A as sync replica of B

6) A successfully joins B as a sync replica, even though its transaction
log is 1016 bytes *ahead* of B.

7) Transactions written to B all hang

8) Xlog on A is now corrupt, although the database itself is OK

Now, the above sequence happened because of the user misunderstanding
what sync rep really means.  However, A should not have been able to
connect with B in replication mode, especially in sync rep mode; that
should have failed.  Any thoughts on why it didn't?

I'm trying to produce a test case ...

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: regexp_replace( , , , NULL ) returns null?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: regexp_replace( , , , NULL ) returns null?