# Checking port 57773 # Found port 57773 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=57773 host=/tmp/HY9KfzvbPm Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log [13:36:43.626](0.023s) # 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 57774 # Found port 57774 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=57774 host=/tmp/HY9KfzvbPm Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_newpub.log [13:36:43.750](0.123s) # 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 7473 ### 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/HY9KfzvbPm -p 57773 -P 57774 --link [13:36:45.799](2.049s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [13:36:45.799](0.000s) 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)/ [13:36:45.800](0.000s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/ [13:36:45.800](0.000s) 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 8043 #### 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/HY9KfzvbPm -p 57773 -P 57774 --link [13:36:46.770](0.970s) ok 5 - run of pg_upgrade of old cluster with slots having unconsumed WAL records status (got 1 vs expected 1) [13:36:46.771](0.001s) 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.)/ [13:36:46.771](0.001s) ok 7 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stderr /(?^:)/ [13:36:46.772](0.001s) ok 8 - the previous test failed due to unconsumed WALs [13:36:46.773](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 8326 #### 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 57775 # Found port 57775 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=57775 host=/tmp/HY9KfzvbPm Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_sub.log [13:36:46.933](0.160s) # 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 8401 #### 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/152A7A8 on oldpub [13:40:20.566](213.633s) # poll_query_until timed out executing this query: # SELECT '0/152A7A8' <= 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 8326 ### 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 8401 ### 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" [13:40:20.787](0.221s) # Tests were run but no plan was declared and done_testing() was not seen. [13:40:20.787](0.000s) # Looks like your test exited with 29 just after 9.