# Checking port 64087 # Found port 64087 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=64087 host=/tmp/9tXSeERp_y Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log [10:08:28.202](0.060s) # 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 64088 # Found port 64088 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=64088 host=/tmp/9tXSeERp_y Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_newpub.log [10:08:28.357](0.155s) # 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 7545 ### 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/9tXSeERp_y -p 64087 -P 64088 --link [10:08:30.212](1.855s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [10:08:30.212](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)/ [10:08:30.212](0.000s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/ [10:08:30.212](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 8055 #### 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/9tXSeERp_y -p 64087 -P 64088 --link [10:08:31.149](0.937s) ok 5 - run of pg_upgrade of old cluster with slots having unconsumed WAL records status (got 1 vs expected 1) [10:08:31.150](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.)/ [10:08:31.151](0.001s) ok 7 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stderr /(?^:)/ [10:08:31.159](0.008s) ok 8 - the previous test failed due to unconsumed WALs [10:08:31.159](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 8348 #### 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 64089 # Found port 64089 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=64089 host=/tmp/9tXSeERp_y Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_sub.log [10:08:31.321](0.162s) # 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 8419 #### 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/152A960 on oldpub [10:12:05.475](214.154s) # poll_query_until timed out executing this query: # SELECT '0/152A960' <= 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 8348 ### 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 8419 ### 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" [10:12:05.695](0.220s) # Tests were run but no plan was declared and done_testing() was not seen. [10:12:05.695](0.000s) # Looks like your test exited with 29 just after 9.