BUG #13541: There is a visibility issue when run some DDL and Query. The time window is very shot

Поиск
Список
Период
Сортировка
От beijing_pg@163.com
Тема BUG #13541: There is a visibility issue when run some DDL and Query. The time window is very shot
Дата
Msg-id 20150807121643.32633.60549@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13541: There is a visibility issue when run some DDL and Query. The time window is very shot
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13541
Logged by:          zhangjinyu
Email address:      beijing_pg@163.com
PostgreSQL version: 9.2.13
Operating system:   suse
Description:

There is a visibility issue when run some DDL and Query. The time window is
very shot. Postgres is to hold relation lock after getsnapshot. Before a
query holds relation lock, if another session run a DDL(alter table alter
column set datatype), Once this DDL committed, select query will return zero
row, because the DDL(alter table alter column set datatype) will rewrite all
tuples with new transaction id.

We can use the following test case to repro the issue.  we add sleep(40)
after GetTransactionSnapshot (in function exec_simple_query) to enlarge the
time window.
Step1: session1: select * from t; (return 3 row)
                 set enable_sleep30_after_getsnapshot=on;
select * from t;
Step2: session2: begin transaction;
alter table t alter c1 set type char(10);
commit;

we can see session1 "select * from t" return 0 row.
======================================
session1:
select * from t;  (it returns 3 rows)
set enable_sleep30_after_getsnapshot=on;
select * from t;  (it returns 0 row)

session2:
start transaction;
alter table t alter c1 set type char(10);
end;

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #13540: upsert is not good
Следующее
От: Mark Simonetti
Дата:
Сообщение: Hang on NOTIFY