src/test/regress/standby_schedule
От
Thomas Munro
Тема
src/test/regress/standby_schedule
Дата
Msg-id
CA+hUKG+XgpBpU9BMeRNOZxetjeAo0trB3qV5AjC9DGDuO6nZEw@mail.gmail.com
Список
Дерево обсуждения
src/test/regress/standby_schedule Thomas Munro <thomas.munro@gmail.com>
Re: src/test/regress/standby_schedule Tom Lane <tgl@sss.pgh.pa.us>
Hello, I guess no human or machine ever runs $SUBJECT, because when I tried it while hunting down users of txid_XXX functions, it failed (see end). To run it, you need a primary/standby pair, here 5441/5442, and then: PGPORT=5441 psql postgres -f sql/hs_primary_setup.sql PGPORT=5442 ./pg_regress --use-existing --dbname=postgres --schedule standby_schedule Perhaps the output changed in January with commit 2eb34ac3. Easy to fix, but I wonder if anyone has a good idea for how to get check-world to run it (probably via the "recovery" stuff). diff -U3 /home/tmunro/projects/postgresql/src/test/regress/expected/hs_standby_disallowed.out /home/tmunro/projects/postgresql/src/test/regress/results/hs_standby_disallowed.out --- /home/tmunro/projects/postgresql/src/test/regress/expected/hs_standby_disallowed.out 2020-03-24 09:02:24.835023971 +1300 +++ /home/tmunro/projects/postgresql/src/test/regress/results/hs_standby_disallowed.out 2020-04-03 13:09:24.339672898 +1300 @@ -64,7 +64,7 @@ (1 row) COMMIT PREPARED 'foobar'; -ERROR: COMMIT PREPARED cannot run inside a transaction block +ERROR: cannot execute COMMIT PREPARED during recovery ROLLBACK; BEGIN; SELECT count(*) FROM hs1; @@ -86,7 +86,7 @@ (1 row) ROLLBACK PREPARED 'foobar'; -ERROR: ROLLBACK PREPARED cannot run inside a transaction block +ERROR: cannot execute ROLLBACK PREPARED during recovery ROLLBACK; -- Locks BEGIN;
В списке pgsql-hackers по дате отправления