diff options
Diffstat (limited to 'src/test/isolation/expected/detach-partition-concurrently-4.out')
| -rw-r--r-- | src/test/isolation/expected/detach-partition-concurrently-4.out | 118 |
1 files changed, 55 insertions, 63 deletions
diff --git a/src/test/isolation/expected/detach-partition-concurrently-4.out b/src/test/isolation/expected/detach-partition-concurrently-4.out index e5dc40d0769..d49736a17d5 100644 --- a/src/test/isolation/expected/detach-partition-concurrently-4.out +++ b/src/test/isolation/expected/detach-partition-concurrently-4.out @@ -1,6 +1,6 @@ Parsed test spec with 3 sessions -starting permutation: s2snitch s1b s1s s2detach s1cancel s2noop s1insert s1c +starting permutation: s2snitch s1b s1s s2detach s1cancel s1insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -9,13 +9,12 @@ a 1 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; @@ -30,11 +29,11 @@ a 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> step s1insert: insert into d4_fk values (1); +ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s2detach: <... completed> -error in steps s1insert s2detach: ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; -starting permutation: s2snitch s1brr s1s s2detach s1cancel s2noop s1insert s1c +starting permutation: s2snitch s1brr s1s s2detach s1cancel s1insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1s: select * from d4_primary; @@ -43,13 +42,12 @@ a 1 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; @@ -64,22 +62,21 @@ a 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> step s1insert: insert into d4_fk values (1); +ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s2detach: <... completed> -error in steps s1insert s2detach: ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; -starting permutation: s2snitch s1b s1declare s2detach s1cancel s2noop s1fetchall s1insert s1c +starting permutation: s2snitch s1b s1declare s2detach s1cancel s1fetchall s1insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1declare: declare f cursor for select * from d4_primary; step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request step s1fetchall: fetch all from f; a @@ -100,22 +97,21 @@ a 1 2 step s1insert: insert into d4_fk values (1); +ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s2detach: <... completed> -error in steps s1insert s2detach: ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; -starting permutation: s2snitch s1b s1declare s2detach s1cancel s2noop s1svpt s1insert s1rollback s1fetchall s1c +starting permutation: s2snitch s1b s1declare s2detach s1cancel s1svpt s1insert s1rollback s1fetchall s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1declare: declare f cursor for select * from d4_primary; step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request step s1svpt: savepoint f; step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" @@ -144,16 +140,15 @@ a step s1c: commit; step s2detach: <... completed> -starting permutation: s2snitch s1b s2detach s1declare s1cancel s2noop s1fetchall s1insert s1c +starting permutation: s2snitch s1b s2detach s1declare s1cancel s1fetchall s1insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1declare: declare f cursor for select * from d4_primary; -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t -step s2noop: UNLISTEN noop; +t step s1fetchall: fetch all from f; a @@ -175,16 +170,15 @@ step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; -starting permutation: s2snitch s1b s2detach s1declare s1cancel s2noop s1svpt s1insert s1rollback s1fetchall s1c +starting permutation: s2snitch s1b s2detach s1declare s1cancel s1svpt s1insert s1rollback s1fetchall s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; step s1declare: declare f cursor for select * from d4_primary; -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t -step s2noop: UNLISTEN noop; +t step s1svpt: savepoint f; step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" @@ -210,7 +204,7 @@ a 2 step s1c: commit; -starting permutation: s2snitch s1brr s1declare2 s1fetchone s2detach s1cancel s2noop s1updcur s1c +starting permutation: s2snitch s1brr s1declare2 s1fetchone s2detach s1cancel s1updcur s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1declare2: declare f cursor for select * from d4_fk where a = 2; @@ -219,13 +213,12 @@ a 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request step s1updcur: update d4_fk set a = 1 where current of f; ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; @@ -240,8 +233,8 @@ a 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> step s1updcur: update d4_fk set a = 1 where current of f; +ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s2detach: <... completed> -error in steps s1updcur s2detach: ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; starting permutation: s2snitch s1brr s1declare2 s1fetchone s1updcur s2detach s1c @@ -256,7 +249,7 @@ step s1updcur: update d4_fk set a = 1 where current of f; step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> step s1c: commit; step s2detach: <... completed> -error in steps s1c s2detach: ERROR: removing partition "d4_primary1" violates foreign key constraint "d4_fk_a_fkey1" +ERROR: removing partition "d4_primary1" violates foreign key constraint "d4_fk_a_fkey1" starting permutation: s2snitch s1b s1s s2detach s3insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); @@ -272,7 +265,7 @@ ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk step s1c: commit; step s2detach: <... completed> -starting permutation: s2snitch s1b s1s s2detach s3brr s3insert s3commit s1cancel s2noop s1c +starting permutation: s2snitch s1b s1s s2detach s3brr s3insert s3commit s1cancel s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -285,13 +278,12 @@ step s3brr: begin isolation level repeatable read; step s3insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s3commit: commit; -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request step s1c: commit; starting permutation: s2snitch s1b s1s s2detach s3brr s3insert s3commit s1c @@ -310,7 +302,7 @@ step s3commit: commit; step s1c: commit; step s2detach: <... completed> -starting permutation: s2snitch s1brr s1s s2detach s1cancel s2noop s3vacfreeze s1s s1insert s1c +starting permutation: s2snitch s1brr s1s s2detach s1cancel s1noop s3vacfreeze s1s s1insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1brr: begin isolation level repeatable read; step s1s: select * from d4_primary; @@ -319,13 +311,13 @@ a 1 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request +step s1noop: step s3vacfreeze: vacuum freeze pg_catalog.pg_inherits; step s1s: select * from d4_primary; a @@ -336,7 +328,7 @@ step s1insert: insert into d4_fk values (1); ERROR: insert or update on table "d4_fk" violates foreign key constraint "d4_fk_a_fkey" step s1c: commit; -starting permutation: s2snitch s1b s1s s2detach s1cancel s2noop s3vacfreeze s1s s1insert s1c +starting permutation: s2snitch s1b s1s s2detach s1cancel s1noop s3vacfreeze s1s s1insert s1c step s2snitch: insert into d4_pid select pg_backend_pid(); step s1b: begin; step s1s: select * from d4_primary; @@ -345,13 +337,13 @@ a 1 2 step s2detach: alter table d4_primary detach partition d4_primary1 concurrently; <waiting ...> -step s1cancel: select pg_cancel_backend(pid), pg_sleep(0.1) from d4_pid; -pg_cancel_backendpg_sleep +step s1cancel: select pg_cancel_backend(pid) from d4_pid; +pg_cancel_backend -t +t step s2detach: <... completed> -error in steps s1cancel s2detach: ERROR: canceling statement due to user request -step s2noop: UNLISTEN noop; +ERROR: canceling statement due to user request +step s1noop: step s3vacfreeze: vacuum freeze pg_catalog.pg_inherits; step s1s: select * from d4_primary; a |