# Checking port 55853 # Found port 55853 Name: publisher Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_publisher_data/archives Connection string: port=55853 host=/tmp/1fC2i2SbPT Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_publisher.log [10:08:28.189](0.018s) # 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/004_subscription/data/t_004_subscription_publisher_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_publisher_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_publisher.log -o --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 7506 # Checking port 55854 # Found port 55854 Name: old_sub Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/archives Connection string: port=55854 host=/tmp/1fC2i2SbPT Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_old_sub.log [10:08:28.516](0.326s) # 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/004_subscription/data/t_004_subscription_old_sub_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata ### Starting node "old_sub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_old_sub.log -o --cluster-name=old_sub start waiting for server to start.... done server started # Postmaster PID for node "old_sub" is 7629 # Checking port 55855 # Found port 55855 Name: new_sub Data directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_data/archives Connection string: port=55855 host=/tmp/1fC2i2SbPT Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_new_sub.log [10:08:28.793](0.277s) # 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/004_subscription/data/t_004_subscription_new_sub_data/pgdata # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_data/pgdata #### Begin standard error psql::1: NOTICE: created replication slot "regress_sub1" on publisher #### End standard error ### Stopping node "old_sub" using mode fast # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "old_sub" # Running: pg_upgrade --no-sync -d /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_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/1fC2i2SbPT -p 55854 -P 55855 --link --check [10:08:30.168](1.375s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [10:08:30.170](0.001s) ok 2 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stdout /(?^:max_replication_slots \(0\) must be greater than or equal to the number of subscriptions \(1\) on the old cluster)/ [10:08:30.170](0.000s) ok 3 - run of pg_upgrade where the new cluster has insufficient max_replication_slots stderr /(?^:)/ ### Starting node "old_sub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_old_sub.log -o --cluster-name=old_sub start waiting for server to start.... done server started # Postmaster PID for node "old_sub" is 8038 #### Begin standard error psql::1: NOTICE: dropped replication slot "regress_sub1" on publisher #### End standard error #### Begin standard error psql::4: NOTICE: created replication slot "regress_sub2" on publisher #### End standard error #### Begin standard error psql::1: NOTICE: created replication slot "regress_sub3" on publisher #### End standard error ### Stopping node "old_sub" using mode fast # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -m fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "old_sub" # Running: pg_upgrade --no-sync -d /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_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/1fC2i2SbPT -p 55854 -P 55855 --link --check Performing Consistency Checks ----------------------------- Checking cluster versions ok WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree Checking database user is the install user WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Checking database connection settings ok Checking for prepared transactions WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Checking for contrib/isn with bigint-passing mismatch ok Checking for valid logical replication slots ok Checking for subscription state WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree fatal Your installation contains subscriptions without origin or having relations not in i (initialize) or r (ready) state. You can allow the initial sync to finish for all relations and then restart the upgrade. A list of the problematic subscriptions is in the file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_new_sub_data/pgdata/pg_upgrade_output.d/20240329T100830.765/subs_invalid.txt Failure, exiting [10:08:31.418](1.248s) ok 4 - run of pg_upgrade --check for old instance with relation in 'd' datasync(invalid) state and missing replication origin [10:08:31.419](0.001s) ok 5 - the previous test failed due to subscription table in invalid state [10:08:31.419](0.000s) ok 6 - the previous test failed due to missing replication origin ### Starting node "old_sub" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_old_sub.log -o --cluster-name=old_sub start waiting for server to start.... done server started # Postmaster PID for node "old_sub" is 8425 #### Begin standard error psql::2: NOTICE: dropped replication slot "pg_16393_sync_16386_7351725184715717872" on publisher psql::2: NOTICE: dropped replication slot "regress_sub2" on publisher psql::3: NOTICE: dropped replication slot "regress_sub3" on publisher #### End standard error #### Begin standard error psql::3: NOTICE: created replication slot "regress_sub4" on publisher #### End standard error Waiting for replication conn regress_sub4's replay_lsn to pass 0/1540F68 on publisher [10:12:06.054](214.635s) # poll_query_until timed out executing this query: # SELECT '0/1540F68' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('regress_sub4', '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/004_subscription.pl line 205. # Postmaster PID for node "publisher" is 7506 ### Stopping node "publisher" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_publisher_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" # Postmaster PID for node "old_sub" is 8425 ### Stopping node "old_sub" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/data/t_004_subscription_old_sub_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "old_sub" # No postmaster PID for node "new_sub" [10:12:06.264](0.210s) # Tests were run but no plan was declared and done_testing() was not seen. [10:12:06.264](0.000s) # Looks like your test exited with 29 just after 6.