src/test/isolation/expected/vacuum-skip-locked.out - master - githubmirror/postgres

src/test/isolation/expected/vacuum-skip-locked.out
170 строк4 KB
Alvaro Herrera
Indicate session name in isolationtester notices
09 ноя 2018, 19:08
09 ноя 2018, 19:08a28e10e
Parsed test spec with 2 sessions

starting permutation: lock_share vac_specified commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

s2: WARNING:  skipping vacuum of "part1" --- lock not available
step vac_specified: VACUUM (SKIP_LOCKED) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_share vac_all_parts commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

step vac_all_parts: VACUUM (SKIP_LOCKED) parted;
step commit: 
	COMMIT;


starting permutation: lock_share analyze_specified commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

s2: WARNING:  skipping analyze of "part1" --- lock not available
step analyze_specified: ANALYZE (SKIP_LOCKED) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_share analyze_all_parts commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

step analyze_all_parts: ANALYZE (SKIP_LOCKED) parted;
step commit: 
	COMMIT;


starting permutation: lock_share vac_analyze_specified commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

s2: WARNING:  skipping vacuum of "part1" --- lock not available
step vac_analyze_specified: VACUUM (ANALYZE, SKIP_LOCKED) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_share vac_analyze_all_parts commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

step vac_analyze_all_parts: VACUUM (ANALYZE, SKIP_LOCKED) parted;
step commit: 
	COMMIT;


starting permutation: lock_share vac_full_specified commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

s2: WARNING:  skipping vacuum of "part1" --- lock not available
step vac_full_specified: VACUUM (SKIP_LOCKED, FULL) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_share vac_full_all_parts commit
step lock_share: 
	BEGIN;
	LOCK part1 IN SHARE MODE;

step vac_full_all_parts: VACUUM (SKIP_LOCKED, FULL) parted;
step commit: 
	COMMIT;


starting permutation: lock_access_exclusive vac_specified commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

s2: WARNING:  skipping vacuum of "part1" --- lock not available
step vac_specified: VACUUM (SKIP_LOCKED) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_access_exclusive vac_all_parts commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

step vac_all_parts: VACUUM (SKIP_LOCKED) parted;
step commit: 
	COMMIT;


starting permutation: lock_access_exclusive analyze_specified commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

s2: WARNING:  skipping analyze of "part1" --- lock not available
step analyze_specified: ANALYZE (SKIP_LOCKED) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_access_exclusive analyze_all_parts commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

step analyze_all_parts: ANALYZE (SKIP_LOCKED) parted; <waiting ...>
step commit: 
	COMMIT;

step analyze_all_parts: <... completed>

starting permutation: lock_access_exclusive vac_analyze_specified commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

s2: WARNING:  skipping vacuum of "part1" --- lock not available
step vac_analyze_specified: VACUUM (ANALYZE, SKIP_LOCKED) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_access_exclusive vac_analyze_all_parts commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

step vac_analyze_all_parts: VACUUM (ANALYZE, SKIP_LOCKED) parted; <waiting ...>
step commit: 
	COMMIT;

step vac_analyze_all_parts: <... completed>

starting permutation: lock_access_exclusive vac_full_specified commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

s2: WARNING:  skipping vacuum of "part1" --- lock not available
step vac_full_specified: VACUUM (SKIP_LOCKED, FULL) part1, part2;
step commit: 
	COMMIT;


starting permutation: lock_access_exclusive vac_full_all_parts commit
step lock_access_exclusive: 
	BEGIN;
	LOCK part1 IN ACCESS EXCLUSIVE MODE;

step vac_full_all_parts: VACUUM (SKIP_LOCKED, FULL) parted;
step commit: 
	COMMIT;