# Checking port 22096 # Found port 22096 Name: publisher Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/archives Connection string: port=22096 host=/tmp/MVLxYME8Ur Log file: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/log/013_partition_publisher.log [14:55:58.023](0.021s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata --auth trust -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/log/013_partition_publisher.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 50001 # Checking port 22097 # Found port 22097 Name: subscriber1 Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/archives Connection string: port=22097 host=/tmp/MVLxYME8Ur Log file: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/log/013_partition_subscriber1.log [14:55:59.495](1.471s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata --auth trust -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata ### Starting node "subscriber1" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber1_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/log/013_partition_subscriber1.log --options --cluster-name=subscriber1 start waiting for server to start.... done server started # Postmaster PID for node "subscriber1" is 50592 # Checking port 22098 # Found port 22098 Name: subscriber2 Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/archives Connection string: port=22098 host=/tmp/MVLxYME8Ur Log file: /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/log/013_partition_subscriber2.log [14:56:01.010](1.515s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata --auth trust -c debug_copy_parse_plan_trees=on -c debug_write_read_parse_plan_trees=on -c debug_raw_expression_coverage_test=on -c debug_parallel_query=regress The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with this locale configuration: locale provider: libc LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 LC_MESSAGES: C LC_MONETARY: en_US.UTF-8 LC_NUMERIC: C LC_TIME: en_US.UTF-8 The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are enabled. creating directory /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default "max_connections" ... 100 selecting default "shared_buffers" ... 128MB selecting default time zone ... UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata -l logfile start # Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata ### Starting node "subscriber2" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/log/013_partition_subscriber2.log --options --cluster-name=subscriber2 start waiting for server to start.... done server started # Postmaster PID for node "subscriber2" is 50987 #### Begin standard error psql::1: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::1: NOTICE: created replication slot "sub1" on publisher #### End standard error #### Begin standard error psql::1: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::1: NOTICE: created replication slot "sub2" on publisher #### End standard error Waiting for all subscriptions in "subscriber1" to synchronize data done Waiting for all subscriptions in "subscriber2" to synchronize data done Waiting for replication conn sub1's replay_lsn to pass 0/017EACC8 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017EACC8 on publisher done [14:56:04.298](3.288s) ok 1 - inserts into tab1 and its partitions replicated [14:56:04.333](0.035s) ok 2 - inserts into tab1_2 replicated into tab1_2_1 correctly [14:56:04.373](0.040s) ok 3 - inserts into tab1_2 replicated into tab1_2_2 correctly [14:56:04.398](0.025s) ok 4 - inserts into tab1_1 replicated [14:56:04.423](0.025s) ok 5 - inserts into tab1_2 replicated [14:56:04.465](0.042s) ok 6 - check replica insert after trigger applied on subscriber [14:56:04.509](0.044s) ok 7 - inserts into tab1_def replicated Waiting for replication conn sub1's replay_lsn to pass 0/017EAFC8 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017EAFC8 on publisher done [14:56:04.788](0.279s) ok 8 - update of tab1_1, tab1_2 replicated [14:56:04.825](0.037s) ok 9 - updates of tab1_2 replicated into tab1_2_1 correctly [14:56:04.843](0.018s) ok 10 - updates of tab1_2 replicated into tab1_2_2 correctly [14:56:04.861](0.018s) ok 11 - check replica update after trigger applied on subscriber [14:56:04.884](0.022s) ok 12 - update of tab1_1 replicated [14:56:04.905](0.022s) ok 13 - tab1_2 updated [14:56:04.931](0.026s) ok 14 - check replica update after trigger applied on subscriber [14:56:04.958](0.027s) ok 15 - tab1_def unchanged Waiting for replication conn sub1's replay_lsn to pass 0/017EB1A8 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017EB1A8 on publisher done [14:56:05.192](0.234s) ok 16 - update of tab1 (delete from tab1_def + insert into tab1_1) replicated [14:56:05.209](0.017s) ok 17 - updates of tab1 (delete + insert) replicated into tab1_2_2 correctly [14:56:05.270](0.061s) ok 18 - tab1_1 unchanged [14:56:05.381](0.111s) ok 19 - insert into tab1_2 replicated [14:56:05.438](0.057s) ok 20 - delete from tab1_def replicated Waiting for replication conn sub1's replay_lsn to pass 0/017EB308 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017EB308 on publisher done [14:56:05.811](0.373s) ok 21 - delete from tab1_1, tab1_2 replicated [14:56:05.836](0.025s) ok 22 - delete from tab1_1 replicated [14:56:05.864](0.028s) ok 23 - delete from tab1_2 replicated Waiting for replication conn sub1's replay_lsn to pass 0/017EC070 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017EC070 on publisher done [14:56:06.148](0.284s) ok 24 - truncate of tab1_2 replicated [14:56:06.167](0.019s) ok 25 - truncate of tab1_2 replicated Waiting for replication conn sub1's replay_lsn to pass 0/017F1B58 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017F1B58 on publisher done [14:56:06.372](0.205s) ok 26 - truncate of tab1_1 replicated [14:56:06.390](0.018s) ok 27 - truncate of tab1 replicated Waiting for replication conn sub1's replay_lsn to pass 0/017F1E28 on publisher done Waiting for replication conn sub2's replay_lsn to pass 0/017F1E28 on publisher done Waiting for replication conn sub1's replay_lsn to pass 0/017F1F98 on publisher [14:59:44.401](218.011s) # poll_query_until timed out executing this query: # SELECT '0/017F1F98' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('sub1', 'walreceiver') # expecting this output: # t # last actual query output: # # with stderr: [14:59:44.414](0.013s) # Last pg_stat_replication contents: # 51403|10|postgres|sub2|||-1|2026-05-06 14:56:03.398507+00||streaming|0/0184E808|0/0184E808|0/0184E808|0/0184E808||||0|async|2026-05-06 14:59:40.991225+00 [14:59:44.414](0.000s) # die: timed out waiting for catchup at /tmp/cirrus-ci-build/src/test/subscription/t/013_partition.pl line 366. [14:59:44.415](0.000s) 1..27 timed out waiting for catchup at /tmp/cirrus-ci-build/src/test/subscription/t/013_partition.pl line 366. # Postmaster PID for node "publisher" is 50001 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_publisher_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" # No postmaster PID for node "subscriber1" # Postmaster PID for node "subscriber2" is 50987 ### Stopping node "subscriber2" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/013_partition/data/t_013_partition_subscriber2_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber2" [14:59:44.625](0.210s) # Looks like your test exited with 29 just after 27.