# Checking port 64908 # Found port 64908 Name: oldpub Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/archives Connection string: port=64908 host=/tmp/D2YxSqEMCG Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log [16:31:15.883](0.041s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata # Checking port 64909 # Found port 64909 Name: newpub Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/archives Connection string: port=64909 host=/tmp/D2YxSqEMCG Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_newpub.log [16:31:16.127](0.244s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata ### Starting node "oldpub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log -o --cluster-name=oldpub start waiting for server to start.... done server started # Postmaster PID for node "oldpub" is 7526 ### Stopping node "oldpub" using mode fast # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "oldpub" # Running: pg_upgrade --no-sync -d /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata -b /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin -B /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin -s /tmp/D2YxSqEMCG -p 64908 -P 64909 --link [16:31:18.622](2.495s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [16:31:18.625](0.003s) ok 2 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stdout /(?^:max_replication_slots \(1\) must be greater than or equal to the number of logical replication slots \(2\) on the old cluster)/ [16:31:18.627](0.002s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/ [16:31:18.629](0.001s) ok 4 - pg_upgrade_output.d/ not removed after pg_upgrade failure ### Starting node "oldpub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log -o --cluster-name=oldpub start waiting for server to start.... done server started # Postmaster PID for node "oldpub" is 8132 #### Begin standard error psql::4: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree #### End standard error ### Stopping node "oldpub" using mode fast # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "oldpub" # Running: pg_upgrade --no-sync -d /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata -b /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin -B /tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/bin -s /tmp/D2YxSqEMCG -p 64908 -P 64909 --link [16:31:19.399](0.770s) ok 5 - run of pg_upgrade of old cluster with slots having unconsumed WAL records status (got 1 vs expected 1) [16:31:19.399](0.000s) ok 6 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stdout /(?^:Your installation contains logical replication slots that can't be upgraded.)/ [16:31:19.402](0.003s) ok 7 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stderr /(?^:)/ [16:31:19.403](0.001s) ok 8 - the previous test failed due to unconsumed WALs [16:31:19.404](0.000s) ok 9 - the previous test failed due to unconsumed WALs ### Starting node "oldpub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log -o --cluster-name=oldpub start waiting for server to start.... done server started # Postmaster PID for node "oldpub" is 8350 #### Begin standard error psql::2: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree psql::3: WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree #### End standard error # Checking port 64910 # Found port 64910 Name: sub Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/archives Connection string: port=64910 host=/tmp/D2YxSqEMCG Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_sub.log [16:31:19.608](0.204s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/build/tmp_install/initdb-template /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/pgdata ### Starting node "sub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_sub.log -o --cluster-name=sub start waiting for server to start.... done server started # Postmaster PID for node "sub" is 8439 #### Begin standard error psql::3: NOTICE: created replication slot "regress_sub" on publisher #### End standard error Waiting for all subscriptions in "sub" to synchronize data Waiting for replication conn regress_sub's replay_lsn to pass 0/1535A10 on oldpub [16:34:58.758](219.150s) # poll_query_until timed out executing this query: # SELECT '0/1535A10' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('regress_sub', 'walreceiver') # expecting this output: # t # last actual query output: # t # with stderr: # WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree timed out waiting for catchup at /tmp/cirrus-ci-build/src/bin/pg_upgrade/t/003_logical_slots.pl line 177. # Postmaster PID for node "oldpub" is 8350 ### Stopping node "oldpub" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_oldpub_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "oldpub" # No postmaster PID for node "newpub" # Postmaster PID for node "sub" is 8439 ### Stopping node "sub" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_sub_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "sub" [16:34:58.981](0.223s) # Tests were run but no plan was declared and done_testing() was not seen. [16:34:58.982](0.000s) # Looks like your test exited with 29 just after 9.