🌐 AI搜索 & 代理 主页
Skip to content

Commit be25c77

Browse files
alvherrealvherre
committed
Put back alternative-output expected files
These were removed in 5dee7a6, but that was too optimistic, per buildfarm member prion as reported by Tom Lane. Mea (Álvaro's) culpa. Author: Mihail Nikalayeu <mihailnikalayeu@gmail.com> Discussion: https://postgr.es/m/570630.1764737028@sss.pgh.pa.us
1 parent 64527a1 commit be25c77

File tree

2 files changed

+248
-0
lines changed

2 files changed

+248
-0
lines changed

‎src/test/modules/injection_points/expected/index-concurrently-upsert-predicate_1.out‎

Lines changed: 124 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,124 @@
1+
Parsed test spec with 5 sessions
2+
3+
starting permutation: s1_attach_invalidate_catalog_snapshot s4_wakeup_s1_setup s3_start_create_index s1_start_upsert s4_wakeup_define_index_before_set_valid s2_start_upsert s5_wakeup_s1_from_invalidate_catalog_snapshot s4_wakeup_s2 s4_wakeup_s1
4+
injection_points_attach
5+
-----------------------
6+
7+
(1 row)
8+
9+
injection_points_attach
10+
-----------------------
11+
12+
(1 row)
13+
14+
injection_points_attach
15+
-----------------------
16+
17+
(1 row)
18+
19+
step s1_attach_invalidate_catalog_snapshot:
20+
SELECT injection_points_attach('invalidate-catalog-snapshot-end', 'wait');
21+
<waiting ...>
22+
step s4_wakeup_s1_setup:
23+
SELECT CASE WHEN
24+
(SELECT pid FROM pg_stat_activity
25+
WHERE wait_event_type = 'InjectionPoint' AND
26+
wait_event = 'invalidate-catalog-snapshot-end') IS NOT NULL
27+
THEN injection_points_wakeup('invalidate-catalog-snapshot-end')
28+
END;
29+
30+
case
31+
----
32+
33+
(1 row)
34+
35+
step s1_attach_invalidate_catalog_snapshot: <... completed>
36+
injection_points_attach
37+
-----------------------
38+
39+
(1 row)
40+
41+
step s3_start_create_index:
42+
CREATE UNIQUE INDEX CONCURRENTLY tbl_pkey_special_duplicate ON test.tbl(abs(i)) WHERE i < 10000;
43+
<waiting ...>
44+
step s1_start_upsert:
45+
INSERT INTO test.tbl VALUES(13,now()) ON CONFLICT (abs(i)) WHERE i < 100 DO UPDATE SET updated_at = now();
46+
<waiting ...>
47+
step s4_wakeup_define_index_before_set_valid:
48+
SELECT injection_points_detach('define-index-before-set-valid');
49+
SELECT injection_points_wakeup('define-index-before-set-valid');
50+
51+
injection_points_detach
52+
-----------------------
53+
54+
(1 row)
55+
56+
injection_points_wakeup
57+
-----------------------
58+
59+
(1 row)
60+
61+
step s2_start_upsert:
62+
INSERT INTO test.tbl VALUES(13,now()) ON CONFLICT (abs(i)) WHERE i < 100 DO UPDATE SET updated_at = now();
63+
<waiting ...>
64+
step s5_wakeup_s1_from_invalidate_catalog_snapshot:
65+
DO $$
66+
DECLARE
67+
v_waiting_pid INTEGER;
68+
BEGIN
69+
LOOP
70+
SELECT pid INTO v_waiting_pid
71+
FROM pg_stat_activity
72+
WHERE wait_event_type = 'InjectionPoint'
73+
AND wait_event = 'invalidate-catalog-snapshot-end'
74+
LIMIT 1;
75+
EXIT WHEN v_waiting_pid IS NOT NULL;
76+
PERFORM pg_sleep(100);
77+
END LOOP;
78+
END
79+
$$;
80+
81+
SELECT injection_points_detach('invalidate-catalog-snapshot-end');
82+
SELECT injection_points_wakeup('invalidate-catalog-snapshot-end');
83+
84+
injection_points_detach
85+
-----------------------
86+
87+
(1 row)
88+
89+
injection_points_wakeup
90+
-----------------------
91+
92+
(1 row)
93+
94+
step s4_wakeup_s2:
95+
SELECT injection_points_detach('exec-insert-before-insert-speculative');
96+
SELECT injection_points_wakeup('exec-insert-before-insert-speculative');
97+
98+
injection_points_detach
99+
-----------------------
100+
101+
(1 row)
102+
103+
injection_points_wakeup
104+
-----------------------
105+
106+
(1 row)
107+
108+
step s4_wakeup_s1:
109+
SELECT injection_points_detach('check-exclusion-or-unique-constraint-no-conflict');
110+
SELECT injection_points_wakeup('check-exclusion-or-unique-constraint-no-conflict');
111+
112+
injection_points_detach
113+
-----------------------
114+
115+
(1 row)
116+
117+
injection_points_wakeup
118+
-----------------------
119+
120+
(1 row)
121+
122+
step s1_start_upsert: <... completed>
123+
step s2_start_upsert: <... completed>
124+
step s3_start_create_index: <... completed>

‎src/test/modules/injection_points/expected/index-concurrently-upsert_1.out‎

Lines changed: 124 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,124 @@
1+
Parsed test spec with 5 sessions
2+
3+
starting permutation: s1_attach_invalidate_catalog_snapshot s4_wakeup_s1_setup s3_start_create_index s1_start_upsert s4_wakeup_define_index_before_set_valid s2_start_upsert s5_wakeup_s1_from_invalidate_catalog_snapshot s4_wakeup_s2 s4_wakeup_s1
4+
injection_points_attach
5+
-----------------------
6+
7+
(1 row)
8+
9+
injection_points_attach
10+
-----------------------
11+
12+
(1 row)
13+
14+
injection_points_attach
15+
-----------------------
16+
17+
(1 row)
18+
19+
step s1_attach_invalidate_catalog_snapshot:
20+
SELECT injection_points_attach('invalidate-catalog-snapshot-end', 'wait');
21+
<waiting ...>
22+
step s4_wakeup_s1_setup:
23+
SELECT CASE WHEN
24+
(SELECT pid FROM pg_stat_activity
25+
WHERE wait_event_type = 'InjectionPoint' AND
26+
wait_event = 'invalidate-catalog-snapshot-end') IS NOT NULL
27+
THEN injection_points_wakeup('invalidate-catalog-snapshot-end')
28+
END;
29+
30+
case
31+
----
32+
33+
(1 row)
34+
35+
step s1_attach_invalidate_catalog_snapshot: <... completed>
36+
injection_points_attach
37+
-----------------------
38+
39+
(1 row)
40+
41+
step s3_start_create_index:
42+
CREATE UNIQUE INDEX CONCURRENTLY tbl_pkey_duplicate ON test.tbl(i);
43+
<waiting ...>
44+
step s1_start_upsert:
45+
INSERT INTO test.tbl VALUES (13,now()) ON CONFLICT (i) DO UPDATE SET updated_at = now();
46+
<waiting ...>
47+
step s4_wakeup_define_index_before_set_valid:
48+
SELECT injection_points_detach('define-index-before-set-valid');
49+
SELECT injection_points_wakeup('define-index-before-set-valid');
50+
51+
injection_points_detach
52+
-----------------------
53+
54+
(1 row)
55+
56+
injection_points_wakeup
57+
-----------------------
58+
59+
(1 row)
60+
61+
step s2_start_upsert:
62+
INSERT INTO test.tbl VALUES (13,now()) ON CONFLICT (i) DO UPDATE SET updated_at = now();
63+
<waiting ...>
64+
step s5_wakeup_s1_from_invalidate_catalog_snapshot:
65+
DO $$
66+
DECLARE
67+
v_waiting_pid INTEGER;
68+
BEGIN
69+
LOOP
70+
SELECT pid INTO v_waiting_pid
71+
FROM pg_stat_activity
72+
WHERE wait_event_type = 'InjectionPoint'
73+
AND wait_event = 'invalidate-catalog-snapshot-end'
74+
LIMIT 1;
75+
EXIT WHEN v_waiting_pid IS NOT NULL;
76+
PERFORM pg_sleep(100);
77+
END LOOP;
78+
END
79+
$$;
80+
81+
SELECT injection_points_detach('invalidate-catalog-snapshot-end');
82+
SELECT injection_points_wakeup('invalidate-catalog-snapshot-end');
83+
84+
injection_points_detach
85+
-----------------------
86+
87+
(1 row)
88+
89+
injection_points_wakeup
90+
-----------------------
91+
92+
(1 row)
93+
94+
step s4_wakeup_s2:
95+
SELECT injection_points_detach('exec-insert-before-insert-speculative');
96+
SELECT injection_points_wakeup('exec-insert-before-insert-speculative');
97+
98+
injection_points_detach
99+
-----------------------
100+
101+
(1 row)
102+
103+
injection_points_wakeup
104+
-----------------------
105+
106+
(1 row)
107+
108+
step s4_wakeup_s1:
109+
SELECT injection_points_detach('check-exclusion-or-unique-constraint-no-conflict');
110+
SELECT injection_points_wakeup('check-exclusion-or-unique-constraint-no-conflict');
111+
112+
injection_points_detach
113+
-----------------------
114+
115+
(1 row)
116+
117+
injection_points_wakeup
118+
-----------------------
119+
120+
(1 row)
121+
122+
step s1_start_upsert: <... completed>
123+
step s2_start_upsert: <... completed>
124+
step s3_start_create_index: <... completed>

0 commit comments

Comments
 (0)