# Checking port 52159 # Found port 52159 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=52159 host=/tmp/j5fzjDHknd Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log [13:36:50.390](0.052s) # 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 52160 # Found port 52160 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=52160 host=/tmp/j5fzjDHknd Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_newpub.log [13:36:50.598](0.208s) # 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 7445 ### 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/j5fzjDHknd -p 52159 -P 52160 --link [13:36:52.733](2.135s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [13:36:52.734](0.001s) 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:52.735](0.000s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/ [13:36:52.735](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 8049 #### 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/j5fzjDHknd -p 52159 -P 52160 --link [13:36:53.691](0.956s) ok 5 - run of pg_upgrade of old cluster with slots having unconsumed WAL records status (got 1 vs expected 1) [13:36:53.692](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:53.693](0.001s) ok 7 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stderr /(?^:)/ [13:36:53.694](0.001s) ok 8 - the previous test failed due to unconsumed WALs [13:36:53.695](0.001s) 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 52161 # Found port 52161 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=52161 host=/tmp/j5fzjDHknd Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_sub.log [13:36:53.839](0.144s) # 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 8374 #### 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/15364D8 on oldpub [13:40:27.675](213.836s) # poll_query_until timed out executing this query: # SELECT '0/15364D8' <= 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 8374 ### 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:27.896](0.220s) # Tests were run but no plan was declared and done_testing() was not seen. [13:40:27.896](0.000s) # Looks like your test exited with 29 just after 9.