# Checking port 55952 # Found port 55952 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=55952 host=/tmp/9mIuEXkkul Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_publisher.log [00:06:44.146](0.020s) # 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 7435 # Checking port 55953 # Found port 55953 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=55953 host=/tmp/9mIuEXkkul Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_old_sub.log [00:06:44.371](0.225s) # 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 7522 # Checking port 55954 # Found port 55954 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=55954 host=/tmp/9mIuEXkkul Log file: /tmp/cirrus-ci-build/build/testrun/pg_upgrade/004_subscription/log/004_subscription_new_sub.log [00:06:44.566](0.195s) # 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/9mIuEXkkul -p 55953 -P 55954 --link --check [00:06:45.977](1.411s) ok 1 - run of pg_upgrade where the new cluster has insufficient max_replication_slots status (got 1 vs expected 1) [00:06:45.977](0.000s) 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)/ [00:06:45.977](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 8023 #### 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/9mIuEXkkul -p 55953 -P 55954 --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 system-defined composite types in user tables WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ok Checking for reg* data types in user tables WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree 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/20240319T000646.451/subs_invalid.txt Failure, exiting [00:06:47.636](1.659s) ok 4 - run of pg_upgrade --check for old instance with relation in 'd' datasync(invalid) state and missing replication origin [00:06:47.655](0.019s) ok 5 - the previous test failed due to subscription table in invalid state [00:06:47.663](0.008s) 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 8552 #### Begin standard error psql::2: NOTICE: dropped replication slot "pg_16393_sync_16386_7347859267786235084" 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/154CAA8 on publisher [00:10:20.318](212.655s) # poll_query_until timed out executing this query: # SELECT '0/154CAA8' <= 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 7435 ### 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 8552 ### 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" [00:10:20.528](0.210s) # Tests were run but no plan was declared and done_testing() was not seen. [00:10:20.528](0.000s) # Looks like your test exited with 29 just after 6.