blob: 4dca2b86bc888af8260ef2fb1e49bb609b86f90a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
Parsed test spec with 4 sessions
starting permutation: cachefill1 at2 waitprunable4 vac4 grant1 wakeinval4 wakegrant4
step cachefill1: SELECT FROM vactest.reloid_catcache_set('vactest.orig50');
step at2:
CREATE TRIGGER to_set_relhastriggers BEFORE UPDATE ON vactest.orig50
FOR EACH ROW EXECUTE PROCEDURE suppress_redundant_updates_trigger();
<waiting ...>
step waitprunable4: CALL vactest.wait_prunable();
step vac4: VACUUM (FREEZE, DISABLE_PAGE_SKIPPING) pg_class;
step grant1: GRANT SELECT ON vactest.orig50 TO PUBLIC; <waiting ...>
step wakeinval4:
SELECT FROM injection_points_detach('transaction-end-process-inval');
SELECT FROM injection_points_wakeup('transaction-end-process-inval');
<waiting ...>
step at2: <... completed>
step wakeinval4: <... completed>
step wakegrant4:
SELECT FROM injection_points_detach('heap_update-before-pin');
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
step wakegrant4: <... completed>
starting permutation: cachefill1 at2 waitprunable4 vac4 grant1 wakeinval4 mkrels4 wakegrant4
step cachefill1: SELECT FROM vactest.reloid_catcache_set('vactest.orig50');
step at2:
CREATE TRIGGER to_set_relhastriggers BEFORE UPDATE ON vactest.orig50
FOR EACH ROW EXECUTE PROCEDURE suppress_redundant_updates_trigger();
<waiting ...>
step waitprunable4: CALL vactest.wait_prunable();
step vac4: VACUUM (FREEZE, DISABLE_PAGE_SKIPPING) pg_class;
step grant1: GRANT SELECT ON vactest.orig50 TO PUBLIC; <waiting ...>
step wakeinval4:
SELECT FROM injection_points_detach('transaction-end-process-inval');
SELECT FROM injection_points_wakeup('transaction-end-process-inval');
<waiting ...>
step at2: <... completed>
step wakeinval4: <... completed>
step mkrels4:
SELECT FROM vactest.mkrels('intruder', 1, 100); -- repopulate LP_UNUSED
step wakegrant4:
SELECT FROM injection_points_detach('heap_update-before-pin');
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
step wakegrant4: <... completed>
starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4
step snap3: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT;
step cachefill1: SELECT FROM vactest.reloid_catcache_set('vactest.orig50');
step at2:
CREATE TRIGGER to_set_relhastriggers BEFORE UPDATE ON vactest.orig50
FOR EACH ROW EXECUTE PROCEDURE suppress_redundant_updates_trigger();
<waiting ...>
step mkrels4:
SELECT FROM vactest.mkrels('intruder', 1, 100); -- repopulate LP_UNUSED
step r3: ROLLBACK;
step waitprunable4: CALL vactest.wait_prunable();
step vac4: VACUUM (FREEZE, DISABLE_PAGE_SKIPPING) pg_class;
step grant1: GRANT SELECT ON vactest.orig50 TO PUBLIC; <waiting ...>
step wakeinval4:
SELECT FROM injection_points_detach('transaction-end-process-inval');
SELECT FROM injection_points_wakeup('transaction-end-process-inval');
<waiting ...>
step at2: <... completed>
step wakeinval4: <... completed>
step at4: ALTER TABLE vactest.child50 INHERIT vactest.orig50;
step wakegrant4:
SELECT FROM injection_points_detach('heap_update-before-pin');
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
ERROR: tuple concurrently updated
step wakegrant4: <... completed>
step inspect4:
SELECT relhastriggers, relhassubclass FROM pg_class
WHERE oid = 'vactest.orig50'::regclass;
relhastriggers|relhassubclass
--------------+--------------
t |t
(1 row)
|
