Parsed test spec with 2 sessions

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get1 s2_insert4 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get1:

SELECT * FROM o_btree_iterate

WHERE id = 1; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get1 s2_insert4 s2_insert2 s2_break_step_down s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get1:

SELECT * FROM o_btree_iterate

WHERE id = 1; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get1 s2_insert3 s2_insert2 s2_break_step_down s2_insert4 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get1:

SELECT * FROM o_btree_iterate

WHERE id = 1; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_break_step_down s1_get1 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get1:

SELECT * FROM o_btree_iterate

WHERE id = 1; <waiting ...>

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_insert2 s2_break_step_down s1_get1 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get1:

SELECT * FROM o_btree_iterate

WHERE id = 1; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_bget1 s2_insert4 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget1:

SELECT * FROM o_btree_iterate

WHERE id > 0 and id < 2 ORDER BY id DESC; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_bget1 s2_insert4 s2_insert2 s2_break_step_down s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget1:

SELECT * FROM o_btree_iterate

WHERE id > 0 and id < 2 ORDER BY id DESC; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_bget1 s2_insert3 s2_insert2 s2_break_step_down s2_insert4 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget1:

SELECT * FROM o_btree_iterate

WHERE id > 0 and id < 2 ORDER BY id DESC; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_break_step_down s1_bget1 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget1:

SELECT * FROM o_btree_iterate

WHERE id > 0 and id < 2 ORDER BY id DESC; <waiting ...>

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_insert2 s2_break_step_down s1_bget1 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget1:

SELECT * FROM o_btree_iterate

WHERE id > 0 and id < 2 ORDER BY id DESC; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget1: <... completed>

id|t

--+-----

1|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get2 s2_insert4 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get2:

SELECT * FROM o_btree_iterate

WHERE id = 301; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get2 s2_insert4 s2_insert2 s2_break_step_down s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get2:

SELECT * FROM o_btree_iterate

WHERE id = 301; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get2 s2_insert3 s2_insert2 s2_break_step_down s2_insert4 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get2:

SELECT * FROM o_btree_iterate

WHERE id = 301; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_break_step_down s1_get2 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get2:

SELECT * FROM o_btree_iterate

WHERE id = 301; <waiting ...>

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_insert2 s2_break_step_down s1_get2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_get2:

SELECT * FROM o_btree_iterate

WHERE id = 301; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_get2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_bget2 s2_insert4 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget2:

SELECT * FROM o_btree_iterate

WHERE id > 300 and id < 302 ORDER BY id DESC; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_bget2 s2_insert4 s2_insert2 s2_break_step_down s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget2:

SELECT * FROM o_btree_iterate

WHERE id > 300 and id < 302 ORDER BY id DESC; <waiting ...>

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_bget2 s2_insert3 s2_insert2 s2_break_step_down s2_insert4 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget2:

SELECT * FROM o_btree_iterate

WHERE id > 300 and id < 302 ORDER BY id DESC; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_break_step_down s1_bget2 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget2:

SELECT * FROM o_btree_iterate

WHERE id > 300 and id < 302 ORDER BY id DESC; <waiting ...>

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_insert4 s2_insert2 s2_break_step_down s1_bget2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1, 1500, 5) id;

step s2_insert4:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(2, 1500, 5) id;

step s2_insert2:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1499, 1, -5) id;

step s2_break_step_down: SELECT pg_stopevent_set('step_down', 'true');

pg_stopevent_set

----------------

(1 row)

step s1_bget2:

SELECT * FROM o_btree_iterate

WHERE id > 300 and id < 302 ORDER BY id DESC; <waiting ...>

step s2_insert3:

INSERT INTO o_btree_iterate

SELECT id, repeat('abcde', id % 10) FROM generate_series(1498, 1, -5) id;

step s2_continue:

SELECT

(pg_stopevent_reset('step_down')::int +

pg_stopevent_reset('step_left')::int +

pg_stopevent_reset('step_right')::int +

pg_stopevent_reset('scan_end')::int)::bool;

bool

----

t

(1 row)

step s1_bget2: <... completed>

id|t

---+-----

301|abcde

(1 row)

starting permutation: s1_setup s2_bp_scan_end s2_insert1 s2_break_step_down s1_get3 s2_insert4 s2_insert2 s2_insert3 s2_continue

step s1_setup: SET orioledb.enable_stopevents = true; SET enable_seqscan = off;

step s2_bp_scan_end: SELECT pg_stopevent_set('scan_end', 'true');

pg_stopevent_set

----------------

(1 row)

step s2_insert1:

INSERT INTO o_btree_iterate