# Checking port 51690 # Found port 51690 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=51690 host=/tmp/MG7IuO1qEk Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_oldpub.log [10:39:08.993](0.034s) # 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 51691 # Found port 51691 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=51691 host=/tmp/MG7IuO1qEk Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_newpub.log [10:39:09.150](0.157s) # 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 21762 ### 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/MG7IuO1qEk -p 51690 -P 51691 --copy [10:39:12.086](2.935s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [10:39:12.086](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:39:12.086](0.000s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/ [10:39:12.086](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 22645 ### 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/MG7IuO1qEk -p 51690 -P 51691 --copy [10:39:13.265](1.178s) ok 5 - run of pg_upgrade of old cluster with slots having unconsumed WAL records status (got 1 vs expected 1) [10:39:13.265](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.)/ [10:39:13.265](0.000s) ok 7 - run of pg_upgrade of old cluster with slots having unconsumed WAL records stderr /(?^:)/ [10:39:13.266](0.001s) ok 8 - the previous test failed due to unconsumed WALs [10:39:13.266](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 23041 # Checking port 51692 # Found port 51692 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=51692 host=/tmp/MG7IuO1qEk Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_sub.log [10:39:13.427](0.161s) # 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 23248 #### 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/153A428 on oldpub done done ### 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/MG7IuO1qEk -p 51690 -P 51691 --copy Performing Consistency Checks ----------------------------- Checking cluster versions ok Checking database user is the install user ok Checking database connection settings ok Checking for prepared transactions ok Checking for contrib/isn with bigint-passing mismatch ok Checking for valid logical replication slots ok Checking for subscription state ok Checking for data type usage ok Creating dump of global objects ok Creating dump of database schemas *failure* Consult the last few lines of "/tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata/pg_upgrade_output.d/20240424T103914.545/log/pg_upgrade_dump_5.log" for the probable cause of the failure. Failure, exiting [10:39:16.278](2.851s) not ok 10 - run of pg_upgrade of old cluster [10:39:16.278](0.000s) # Failed test 'run of pg_upgrade of old cluster' # at /tmp/cirrus-ci-build/src/bin/pg_upgrade/t/003_logical_slots.pl line 190. ### Starting node "newpub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/log/003_logical_slots_newpub.log -o --cluster-name=newpub start waiting for server to start.... done server started # Postmaster PID for node "newpub" is 23850 [10:39:16.490](0.211s) not ok 11 - check the slot exists on new cluster [10:39:16.490](0.000s) # Failed test 'check the slot exists on new cluster' # at /tmp/cirrus-ci-build/src/bin/pg_upgrade/t/003_logical_slots.pl line 196. [10:39:16.490](0.000s) # got: '' # expected: 'regress_sub|t|t' error running SQL: 'psql::1: ERROR: relation "tbl" does not exist LINE 1: INSERT INTO tbl VALUES (generate_series(11, 20)) ^' while running 'psql -XAtq -d port=51691 host=/tmp/MG7IuO1qEk dbname='postgres' -f - -v ON_ERROR_STOP=1' with sql 'INSERT INTO tbl VALUES (generate_series(11, 20))' at /tmp/cirrus-ci-build/src/test/perl/PostgreSQL/Test/Cluster.pm line 2124. # No postmaster PID for node "oldpub" # Postmaster PID for node "newpub" is 23850 ### Stopping node "newpub" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/003_logical_slots/data/t_003_logical_slots_newpub_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "newpub" # Postmaster PID for node "sub" is 23248 ### 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:39:16.676](0.185s) # Tests were run but no plan was declared and done_testing() was not seen. [10:39:16.676](0.000s) # Looks like your test exited with 29 just after 11.