Bug report and fix about building historic snapshot
| От | cca5507 |
|---|---|
| Тема | Bug report and fix about building historic snapshot |
| Дата | |
| Msg-id | tencent_0C36ED9C43750AA16BD753F26492F0580F09@qq.com обсуждение исходный текст |
| Ответы |
Re:Bug report and fix about building historic snapshot
|
| Список | pgsql-hackers |
(pub)create table t1 (id int primary key);
(pub)insert into t1 values (1);
(pub)create publication pub for table t1;
(sub)create table t1 (id int primary key);
(pub)begin; insert into t1 values (2); (txn1 in session1)
(sub)create subscription sub connection 'hostaddr=127.0.0.1 port=5432 user=xxx dbname=postgres' publication pub; (pub will switch to BUILDING_SNAPSHOT state soon)
(pub)begin; insert into t1 values (3); (txn2 in session2)
(pub)create table t2 (id int primary key); (session3)
(pub)commit; (commit txn1, and pub will switch to FULL_SNAPSHOT state soon)
(pub)begin; insert into t2 values (1); (txn3 in session3)
(pub)commit; (commit txn2, and pub will switch to CONSISTENT state soon)
(pub)commit; (commit txn3, and replay txn3 will failed because its snapshot cannot see t2)
Вложения
В списке pgsql-hackers по дате отправления: