/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/delay_execution/expected/partition-removal-1.out
233 строки
5 KB
Tom Lane
Improve display of query results in isolation tests.
23 июн 2021, 18:13
23 июн 2021, 18:13
4a05406
Код
Авторство
О чём код?
Parsed test spec with 3 sessions starting permutation: s3lock s1b s1exec s2remp s3check s3unlock s3check s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s1b: BEGIN; step s1exec: SELECT * FROM partrem WHERE a <> 1 AND a <> (SELECT 3); <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3check: SELECT * FROM partrem; a|b -+--- 1|ABC 3|DEF (2 rows) step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1exec: <... completed> a|b -+--- 2|JKL (1 row) step s3check: SELECT * FROM partrem; a|b -+--- 1|ABC 3|DEF (2 rows) step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1brr s1exec s2remp s3check s3unlock s3check s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1exec: SELECT * FROM partrem WHERE a <> 1 AND a <> (SELECT 3); <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3check: SELECT * FROM partrem; a|b -+--- 1|ABC 3|DEF (2 rows) step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1exec: <... completed> a|b -+--- 2|JKL (1 row) step s3check: SELECT * FROM partrem; a|b -+--- 1|ABC 3|DEF (2 rows) step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1b s1exec2 s2remp s3unlock s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s1b: BEGIN; step s1exec2: SELECT * FROM partrem WHERE a <> (SELECT 2) AND a <> 1; <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1exec2: <... completed> a|b -+--- 3|DEF (1 row) step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1brr s1exec2 s2remp s3unlock s1c step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1exec2: SELECT * FROM partrem WHERE a <> (SELECT 2) AND a <> 1; <waiting ...> step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1exec2: <... completed> a|b -+--- 3|DEF (1 row) step s1c: COMMIT; step s2remp: <... completed> starting permutation: s3lock s1brr s1prepare s2remp s1execprep s3unlock s1check s1c s1check s1dealloc step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1prepare: PREPARE ins AS INSERT INTO partrem VALUES ($1, 'GHI'); step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s1execprep: EXECUTE ins(2); <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1execprep: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+--- 2|GHI (1 row) step s1c: COMMIT; step s2remp: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+- (0 rows) step s1dealloc: DEALLOCATE ins; starting permutation: s1brr s1prepare s2remp s3lock s1execprep s3unlock s1check s1c s1check s1dealloc step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1prepare: PREPARE ins AS INSERT INTO partrem VALUES ($1, 'GHI'); step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s1execprep: EXECUTE ins(2); <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1execprep: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+--- 2|GHI (1 row) step s1c: COMMIT; step s2remp: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+- (0 rows) step s1dealloc: DEALLOCATE ins; starting permutation: s1brr s1check s3lock s2remp s1prepare s1execprep s3unlock s1check s1c s1check s1dealloc step s1brr: BEGIN ISOLATION LEVEL REPEATABLE READ; step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+- (0 rows) step s3lock: SELECT pg_advisory_lock(12543); pg_advisory_lock ---------------- (1 row) step s2remp: ALTER TABLE partrem DETACH PARTITION partrem2 CONCURRENTLY; <waiting ...> step s1prepare: PREPARE ins AS INSERT INTO partrem VALUES ($1, 'GHI'); step s1execprep: EXECUTE ins(2); <waiting ...> step s3unlock: SELECT pg_advisory_unlock(12543); pg_advisory_unlock ------------------ t (1 row) step s1execprep: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+--- 2|GHI (1 row) step s1c: COMMIT; step s2remp: <... completed> step s1check: SELECT * FROM partrem WHERE b = 'GHI'; a|b -+- (0 rows) step s1dealloc: DEALLOCATE ins;