1Parsed test spec with 2 sessions 2 3starting permutation: lock_share vac_specified commit 4step lock_share: 5 BEGIN; 6 LOCK part1 IN SHARE MODE; 7 8s2: WARNING: skipping vacuum of "part1" --- lock not available 9step vac_specified: VACUUM (SKIP_LOCKED) part1, part2; 10step commit: 11 COMMIT; 12 13 14starting permutation: lock_share vac_all_parts commit 15step lock_share: 16 BEGIN; 17 LOCK part1 IN SHARE MODE; 18 19step vac_all_parts: VACUUM (SKIP_LOCKED) parted; 20step commit: 21 COMMIT; 22 23 24starting permutation: lock_share analyze_specified commit 25step lock_share: 26 BEGIN; 27 LOCK part1 IN SHARE MODE; 28 29s2: WARNING: skipping analyze of "part1" --- lock not available 30step analyze_specified: ANALYZE (SKIP_LOCKED) part1, part2; 31step commit: 32 COMMIT; 33 34 35starting permutation: lock_share analyze_all_parts commit 36step lock_share: 37 BEGIN; 38 LOCK part1 IN SHARE MODE; 39 40step analyze_all_parts: ANALYZE (SKIP_LOCKED) parted; 41step commit: 42 COMMIT; 43 44 45starting permutation: lock_share vac_analyze_specified commit 46step lock_share: 47 BEGIN; 48 LOCK part1 IN SHARE MODE; 49 50s2: WARNING: skipping vacuum of "part1" --- lock not available 51step vac_analyze_specified: VACUUM (ANALYZE, SKIP_LOCKED) part1, part2; 52step commit: 53 COMMIT; 54 55 56starting permutation: lock_share vac_analyze_all_parts commit 57step lock_share: 58 BEGIN; 59 LOCK part1 IN SHARE MODE; 60 61step vac_analyze_all_parts: VACUUM (ANALYZE, SKIP_LOCKED) parted; 62step commit: 63 COMMIT; 64 65 66starting permutation: lock_share vac_full_specified commit 67step lock_share: 68 BEGIN; 69 LOCK part1 IN SHARE MODE; 70 71s2: WARNING: skipping vacuum of "part1" --- lock not available 72step vac_full_specified: VACUUM (SKIP_LOCKED, FULL) part1, part2; 73step commit: 74 COMMIT; 75 76 77starting permutation: lock_share vac_full_all_parts commit 78step lock_share: 79 BEGIN; 80 LOCK part1 IN SHARE MODE; 81 82step vac_full_all_parts: VACUUM (SKIP_LOCKED, FULL) parted; 83step commit: 84 COMMIT; 85 86 87starting permutation: lock_access_exclusive vac_specified commit 88step lock_access_exclusive: 89 BEGIN; 90 LOCK part1 IN ACCESS EXCLUSIVE MODE; 91 92s2: WARNING: skipping vacuum of "part1" --- lock not available 93step vac_specified: VACUUM (SKIP_LOCKED) part1, part2; 94step commit: 95 COMMIT; 96 97 98starting permutation: lock_access_exclusive vac_all_parts commit 99step lock_access_exclusive: 100 BEGIN; 101 LOCK part1 IN ACCESS EXCLUSIVE MODE; 102 103step vac_all_parts: VACUUM (SKIP_LOCKED) parted; 104step commit: 105 COMMIT; 106 107 108starting permutation: lock_access_exclusive analyze_specified commit 109step lock_access_exclusive: 110 BEGIN; 111 LOCK part1 IN ACCESS EXCLUSIVE MODE; 112 113s2: WARNING: skipping analyze of "part1" --- lock not available 114step analyze_specified: ANALYZE (SKIP_LOCKED) part1, part2; 115step commit: 116 COMMIT; 117 118 119starting permutation: lock_access_exclusive analyze_all_parts commit 120step lock_access_exclusive: 121 BEGIN; 122 LOCK part1 IN ACCESS EXCLUSIVE MODE; 123 124step analyze_all_parts: ANALYZE (SKIP_LOCKED) parted; <waiting ...> 125step commit: 126 COMMIT; 127 128step analyze_all_parts: <... completed> 129 130starting permutation: lock_access_exclusive vac_analyze_specified commit 131step lock_access_exclusive: 132 BEGIN; 133 LOCK part1 IN ACCESS EXCLUSIVE MODE; 134 135s2: WARNING: skipping vacuum of "part1" --- lock not available 136step vac_analyze_specified: VACUUM (ANALYZE, SKIP_LOCKED) part1, part2; 137step commit: 138 COMMIT; 139 140 141starting permutation: lock_access_exclusive vac_analyze_all_parts commit 142step lock_access_exclusive: 143 BEGIN; 144 LOCK part1 IN ACCESS EXCLUSIVE MODE; 145 146step vac_analyze_all_parts: VACUUM (ANALYZE, SKIP_LOCKED) parted; <waiting ...> 147step commit: 148 COMMIT; 149 150step vac_analyze_all_parts: <... completed> 151 152starting permutation: lock_access_exclusive vac_full_specified commit 153step lock_access_exclusive: 154 BEGIN; 155 LOCK part1 IN ACCESS EXCLUSIVE MODE; 156 157s2: WARNING: skipping vacuum of "part1" --- lock not available 158step vac_full_specified: VACUUM (SKIP_LOCKED, FULL) part1, part2; 159step commit: 160 COMMIT; 161 162 163starting permutation: lock_access_exclusive vac_full_all_parts commit 164step lock_access_exclusive: 165 BEGIN; 166 LOCK part1 IN ACCESS EXCLUSIVE MODE; 167 168step vac_full_all_parts: VACUUM (SKIP_LOCKED, FULL) parted; 169step commit: 170 COMMIT; 171 172