# Checking port 12493 # Found port 12493 Name: publisher Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/archives Connection string: port=12493 host=/tmp/sCltz6kpbF Log file: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher.log [10:37:21.994](0.048s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_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/100_bugs/data/t_100_bugs_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/100_bugs/data/t_100_bugs_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/100_bugs/data/t_100_bugs_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 67353 # Checking port 12494 # Found port 12494 Name: subscriber Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/archives Connection string: port=12494 host=/tmp/sCltz6kpbF Log file: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_subscriber.log [10:37:23.626](1.632s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_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/100_bugs/data/t_100_bugs_subscriber_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/100_bugs/data/t_100_bugs_subscriber_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/100_bugs/data/t_100_bugs_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_subscriber.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 67939 #### 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 Waiting for replication conn sub1's replay_lsn to pass 0/017C9BD8 on publisher done Waiting for replication conn sub1's replay_lsn to pass 0/017C9D20 on publisher done [10:37:25.374](1.749s) ok 1 - index predicates do not cause crash #### Begin standard error psql::1: NOTICE: dropped replication slot "sub1" on publisher #### End standard error ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Stopping node "subscriber" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_1.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 68291 [10:37:25.872](0.497s) ok 2 - update to temporary table without replica identity with FOR ALL TABLES publication [10:37:25.895](0.023s) ok 3 - update to unlogged table without replica identity with FOR ALL TABLES publication ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" # Checking port 12495 # Found port 12495 Name: twoways Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_twoways_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_twoways_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_twoways_data/archives Connection string: port=12495 host=/tmp/sCltz6kpbF Log file: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_twoways.log [10:37:26.019](0.124s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_twoways_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/100_bugs/data/t_100_bugs_twoways_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/100_bugs/data/t_100_bugs_twoways_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/100_bugs/data/t_100_bugs_twoways_data/pgdata ### Starting node "twoways" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_twoways_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_twoways.log --options --cluster-name=twoways start waiting for server to start.... done server started # Postmaster PID for node "twoways" is 68820 #### Begin standard error psql::1: WARNING: databases created by regression test cases should have names including "regression" #### End standard error #### Begin standard error psql::1: WARNING: databases created by regression test cases should have names including "regression" #### End standard error #### Begin standard error psql::1: WARNING: subscriptions created by regression test cases should have names starting with "regress_" #### End standard error Waiting for all subscriptions in "twoways" to synchronize data Waiting for replication conn testsub's replay_lsn to pass 0/02199148 on twoways done done [10:37:28.353](2.333s) ok 4 - 2x3000 rows in t [10:37:28.372](0.019s) ok 5 - 2x3000 rows in t2 # Checking port 12496 # Found port 12496 Name: testpublisher1 Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher1_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher1_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher1_data/archives Connection string: port=12496 host=/tmp/sCltz6kpbF Log file: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_testpublisher1.log [10:37:28.375](0.003s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher1_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/100_bugs/data/t_100_bugs_testpublisher1_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/100_bugs/data/t_100_bugs_testpublisher1_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/100_bugs/data/t_100_bugs_testpublisher1_data/pgdata ### Starting node "testpublisher1" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher1_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_testpublisher1.log --options --cluster-name=testpublisher1 start waiting for server to start.... done server started # Postmaster PID for node "testpublisher1" is 69510 # Checking port 12497 # Found port 12497 Name: testpublisher_subscriber Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher_subscriber_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher_subscriber_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher_subscriber_data/archives Connection string: port=12497 host=/tmp/sCltz6kpbF Log file: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_testpublisher_subscriber.log [10:37:29.929](1.554s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher_subscriber_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/100_bugs/data/t_100_bugs_testpublisher_subscriber_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/100_bugs/data/t_100_bugs_testpublisher_subscriber_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/100_bugs/data/t_100_bugs_testpublisher_subscriber_data/pgdata ### Starting node "testpublisher_subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_testpublisher_subscriber.log --options --cluster-name=testpublisher_subscriber start waiting for server to start.... done server started # Postmaster PID for node "testpublisher_subscriber" is 69710 # Checking port 12498 # Found port 12498 Name: testsubscriber1 Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testsubscriber1_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testsubscriber1_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testsubscriber1_data/archives Connection string: port=12498 host=/tmp/sCltz6kpbF Log file: /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_testsubscriber1.log [10:37:31.537](1.608s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testsubscriber1_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/100_bugs/data/t_100_bugs_testsubscriber1_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/100_bugs/data/t_100_bugs_testsubscriber1_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/100_bugs/data/t_100_bugs_testsubscriber1_data/pgdata ### Starting node "testsubscriber1" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testsubscriber1_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_testsubscriber1.log --options --cluster-name=testsubscriber1 start waiting for server to start.... done server started # Postmaster PID for node "testsubscriber1" is 69963 #### Begin standard error psql::1: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::1: NOTICE: created replication slot "testsub2" 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 "testsub1" on publisher #### End standard error Waiting for replication conn testsub1's replay_lsn to pass 0/017BC970 on testpublisher1 done Waiting for replication conn testsub2's replay_lsn to pass 0/017BD680 on testpublisher_subscriber done #### Begin standard error psql::1: NOTICE: dropped replication slot "testsub1" on publisher #### End standard error #### Begin standard error psql::1: NOTICE: dropped replication slot "testsub2" on publisher #### End standard error ### Stopping node "testpublisher1" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher1_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "testpublisher1" ### Stopping node "testpublisher_subscriber" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testpublisher_subscriber_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "testpublisher_subscriber" ### Stopping node "testsubscriber1" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_testsubscriber1_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "testsubscriber1" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_2.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 70346 ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_subscriber_2.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 70389 #### Begin standard error psql::1: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::1: NOTICE: created replication slot "tap_sub" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub's replay_lsn to pass 0/01814910 on publisher done done [10:37:35.175](3.639s) ok 6 - check initial data on subscriber Waiting for replication conn tap_sub's replay_lsn to pass 0/0181AF78 on publisher done [10:37:35.322](0.147s) ok 7 - update works with REPLICA IDENTITY #### Begin standard error psql::1: NOTICE: dropped replication slot "tap_sub" 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 "tap_sub_sch" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub_sch's replay_lsn to pass 0/018242B0 on publisher done done Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub_sch's replay_lsn to pass 0/01825BE0 on publisher done done [10:37:36.234](0.911s) ok 8 - check data in subscriber sch1.t1 after schema rename [10:37:36.257](0.023s) ok 9 - no data yet in subscriber sch2.t1 after schema rename Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn tap_sub_sch's replay_lsn to pass 0/01825C18 on publisher done done [10:37:36.540](0.283s) ok 10 - check data in subscriber sch2.t1 after schema rename #### Begin standard error psql::1: NOTICE: dropped replication slot "tap_sub_sch" on publisher #### End standard error ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Stopping node "subscriber" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_3.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 71045 ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_subscriber_3.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 71082 #### Begin standard error psql::1: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::1: NOTICE: created replication slot "sub_dropped_cols" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data done Waiting for replication conn sub_dropped_cols's replay_lsn to pass 0/0183E448 on publisher done [10:37:37.619](1.079s) ok 11 - replication with RI FULL and dropped columns ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Stopping node "subscriber" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_4.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 71240 ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_subscriber_4.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 71260 #### Begin standard error psql::3: WARNING: subscriptions created by regression test cases should have names starting with "regress_" psql::3: NOTICE: created replication slot "sub1" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn sub1's replay_lsn to pass 0/0185E838 on publisher done done [10:37:38.736](1.117s) ok 12 - check snapshot on subscriber Waiting for replication conn sub1's replay_lsn to pass 0/0185E918 on publisher done [10:37:38.812](0.077s) ok 13 - check replicated update on subscriber test_slot|0/0185E950|0000001B-00000002-1|pgoutput [10:37:38.823](0.011s) ok 14 - create and immediate drop of replication slot ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Stopping node "subscriber" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_5.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 71659 ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_subscriber_5.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 71712 #### Begin standard error psql::3: NOTICE: created replication slot "regress_sub" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data Waiting for replication conn regress_sub's replay_lsn to pass 0/018792C8 on publisher done done Waiting for replication conn regress_sub's replay_lsn to pass 0/01879338 on publisher done [10:37:40.002](1.179s) ok 15 - remote_lsn has advanced for apply worker raising an exception ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Stopping node "subscriber" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_subscriber_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_5.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 71988 #### Begin standard error psql::2: WARNING: databases created by regression test cases should have names including "regression" psql::3: WARNING: subscription was created, but is not connected HINT: To initiate replication, you must manually create the replication slot, enable the subscription, and alter the subscription to refresh publications. #### End standard error [10:37:40.574](0.572s) ok 16 - replication slot does not exist: exit code not 0 [10:37:40.574](0.000s) ok 17 - could not drop replication slot: error message ### Stopping node "publisher" using mode fast # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --mode fast stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/log/100_bugs_publisher_5.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 72049 #### Begin standard error psql::1: WARNING: databases created by regression test cases should have names including "regression" #### End standard error [10:37:41.000](0.425s) # connect output: # { # 'stderr' => 'background_psql: ready # ', # 'stdout' => 'background_psql: ready # ' # } [10:41:14.340](213.340s) # poll_query_until timed out executing this query: # # SELECT count(*) > 0 FROM pg_stat_activity # WHERE backend_type = 'client backend' AND wait_event = 'pg-get-publication-tables-after-list-built' # # expecting this output: # t # last actual query output: # f # with stderr: [10:41:14.340](0.001s) # die: timed out when waiting for client backend to reach wait event 'pg-get-publication-tables-after-list-built' at /tmp/cirrus-ci-build/src/test/subscription/t/100_bugs.pl line 648. [10:41:14.341](0.000s) 1..17 timed out when waiting for client backend to reach wait event 'pg-get-publication-tables-after-list-built' at /tmp/cirrus-ci-build/src/test/subscription/t/100_bugs.pl line 648. # Postmaster PID for node "publisher" is 72049 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_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 "subscriber" # Postmaster PID for node "twoways" is 68820 ### Stopping node "twoways" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/100_bugs/data/t_100_bugs_twoways_data/pgdata --mode immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "twoways" # No postmaster PID for node "testpublisher1" # No postmaster PID for node "testpublisher_subscriber" # No postmaster PID for node "testsubscriber1" [10:41:14.560](0.220s) # Looks like your test exited with 4 just after 17.