/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/expected/fk-deadlock_1.out
131 строка
4 KB
Tom Lane
Use annotations to reduce instability of isolation-test results.
23 июн 2021, 04:43
23 июн 2021, 04:43
741d7f1
Код
Авторство
О чём код?
Parsed test spec with 2 sessions starting permutation: s1i s1u s1c s2i s2u s2c step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; step s1c: COMMIT; step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; step s2c: COMMIT; starting permutation: s1i s1u s2i s1c s2u s2c step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; step s2i: INSERT INTO child VALUES (2, 1); step s1c: COMMIT; step s2u: UPDATE parent SET aux = 'baz'; ERROR: could not serialize access due to concurrent update step s2c: COMMIT; starting permutation: s1i s1u s2i s2u s1c s2c step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; <waiting ...> step s1c: COMMIT; step s2u: <... completed> ERROR: could not serialize access due to concurrent update step s2c: COMMIT; starting permutation: s1i s2i s1u s1c s2u s2c step s1i: INSERT INTO child VALUES (1, 1); step s2i: INSERT INTO child VALUES (2, 1); step s1u: UPDATE parent SET aux = 'bar'; step s1c: COMMIT; step s2u: UPDATE parent SET aux = 'baz'; ERROR: could not serialize access due to concurrent update step s2c: COMMIT; starting permutation: s1i s2i s1u s2u s1c s2c step s1i: INSERT INTO child VALUES (1, 1); step s2i: INSERT INTO child VALUES (2, 1); step s1u: UPDATE parent SET aux = 'bar'; step s2u: UPDATE parent SET aux = 'baz'; <waiting ...> step s1c: COMMIT; step s2u: <... completed> ERROR: could not serialize access due to concurrent update step s2c: COMMIT; starting permutation: s1i s2i s2u s1u s2c s1c step s1i: INSERT INTO child VALUES (1, 1); step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; step s1u: UPDATE parent SET aux = 'bar'; <waiting ...> step s2c: COMMIT; step s1u: <... completed> ERROR: could not serialize access due to concurrent update step s1c: COMMIT; starting permutation: s1i s2i s2u s2c s1u s1c step s1i: INSERT INTO child VALUES (1, 1); step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; step s2c: COMMIT; step s1u: UPDATE parent SET aux = 'bar'; ERROR: could not serialize access due to concurrent update step s1c: COMMIT; starting permutation: s2i s1i s1u s1c s2u s2c step s2i: INSERT INTO child VALUES (2, 1); step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; step s1c: COMMIT; step s2u: UPDATE parent SET aux = 'baz'; ERROR: could not serialize access due to concurrent update step s2c: COMMIT; starting permutation: s2i s1i s1u s2u s1c s2c step s2i: INSERT INTO child VALUES (2, 1); step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; step s2u: UPDATE parent SET aux = 'baz'; <waiting ...> step s1c: COMMIT; step s2u: <... completed> ERROR: could not serialize access due to concurrent update step s2c: COMMIT; starting permutation: s2i s1i s2u s1u s2c s1c step s2i: INSERT INTO child VALUES (2, 1); step s1i: INSERT INTO child VALUES (1, 1); step s2u: UPDATE parent SET aux = 'baz'; step s1u: UPDATE parent SET aux = 'bar'; <waiting ...> step s2c: COMMIT; step s1u: <... completed> ERROR: could not serialize access due to concurrent update step s1c: COMMIT; starting permutation: s2i s1i s2u s2c s1u s1c step s2i: INSERT INTO child VALUES (2, 1); step s1i: INSERT INTO child VALUES (1, 1); step s2u: UPDATE parent SET aux = 'baz'; step s2c: COMMIT; step s1u: UPDATE parent SET aux = 'bar'; ERROR: could not serialize access due to concurrent update step s1c: COMMIT; starting permutation: s2i s2u s1i s1u s2c s1c step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; <waiting ...> step s2c: COMMIT; step s1u: <... completed> ERROR: could not serialize access due to concurrent update step s1c: COMMIT; starting permutation: s2i s2u s1i s2c s1u s1c step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; step s1i: INSERT INTO child VALUES (1, 1); step s2c: COMMIT; step s1u: UPDATE parent SET aux = 'bar'; ERROR: could not serialize access due to concurrent update step s1c: COMMIT; starting permutation: s2i s2u s2c s1i s1u s1c step s2i: INSERT INTO child VALUES (2, 1); step s2u: UPDATE parent SET aux = 'baz'; step s2c: COMMIT; step s1i: INSERT INTO child VALUES (1, 1); step s1u: UPDATE parent SET aux = 'bar'; step s1c: COMMIT;