# Checking port 65247 # Found port 65247 Name: publisher Data directory: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/archives Connection string: port=65247 host=/tmp/MtGU70dNPI Log file: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/log/015_stream_publisher.log [23:04:54.506](0.014s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/tmp_install/initdb-template /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/pgdata # Running: /tmp/cirrus-ci-build/src/test/subscription/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/pgdata -l /tmp/cirrus-ci-build/src/test/subscription/tmp_check/log/015_stream_publisher.log -o --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 43270 # Checking port 65248 # Found port 65248 Name: subscriber Data directory: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/pgdata Backup directory: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/backup Archive directory: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/archives Connection string: port=65248 host=/tmp/MtGU70dNPI Log file: /tmp/cirrus-ci-build/src/test/subscription/tmp_check/log/015_stream_subscriber.log [23:04:54.695](0.189s) # initializing database system by copying initdb template # Running: cp -RPp /tmp/cirrus-ci-build/tmp_install/initdb-template /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/pgdata # Running: /tmp/cirrus-ci-build/src/test/subscription/../../../src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl -w -D /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/pgdata -l /tmp/cirrus-ci-build/src/test/subscription/tmp_check/log/015_stream_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 43297 #### Begin standard error 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/1558588 on publisher done done [23:04:55.286](0.592s) ok 1 - check initial data was copied to subscriber [23:04:55.298](0.012s) # issuing query via background psql: # BEGIN; # INSERT INTO test_tab SELECT i, sha256(i::text::bytea) FROM generate_series(3, 5000) s(i); # UPDATE test_tab SET b = sha256(b) WHERE mod(a,2) = 0; # DELETE FROM test_tab WHERE mod(a,3) = 0; # [23:04:55.430](0.132s) # issuing query via background psql: COMMIT Waiting for replication conn tap_sub's replay_lsn to pass 0/17E76A8 on publisher done [23:04:56.035](0.605s) ok 2 - check extra columns contain local defaults Waiting for replication conn tap_sub's replay_lsn to pass 0/19AD530 on publisher done [23:04:56.654](0.619s) ok 3 - check extra columns contain local defaults Waiting for replication conn tap_sub's replay_lsn to pass 0/1A92800 on publisher done [23:04:57.083](0.429s) ok 4 - check extra columns contain locally changed data Waiting for replication conn tap_sub's replay_lsn to pass 0/1AFD1A8 on publisher done ### Reloading node "subscriber" # Running: pg_ctl -D /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/pgdata reload server signaled [23:04:57.676](0.593s) # issuing query via background psql: # BEGIN; # INSERT INTO test_tab SELECT i, sha256(i::text::bytea) FROM generate_series(3, 5000) s(i); # UPDATE test_tab SET b = sha256(b) WHERE mod(a,2) = 0; # DELETE FROM test_tab WHERE mod(a,3) = 0; # [23:04:57.829](0.153s) # issuing query via background psql: COMMIT Waiting for replication conn tap_sub's replay_lsn to pass 0/1D836E0 on publisher done [23:04:58.243](0.413s) ok 5 - check extra columns contain local defaults Waiting for replication conn tap_sub's replay_lsn to pass 0/1F3D038 on publisher done [23:04:58.933](0.690s) ok 6 - check extra columns contain local defaults Waiting for replication conn tap_sub's replay_lsn to pass 0/2023198 on publisher done [23:04:59.287](0.354s) ok 7 - check extra columns contain locally changed data Waiting for replication conn tap_sub's replay_lsn to pass 0/208DC88 on publisher done ### Reloading node "subscriber" # Running: pg_ctl -D /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_subscriber_data/pgdata reload server signaled [23:04:59.613](0.325s) # issuing query via background psql: # BEGIN; # INSERT INTO test_tab_2 SELECT i FROM generate_series(1, 5000) s(i); [23:04:59.744](0.131s) # issuing query via background psql: COMMIT Waiting for replication conn tap_sub's replay_lsn to pass 0/20DC2E8 on publisher done [23:05:00.116](0.372s) ok 8 - data replicated to subscriber after dropping index Waiting for replication conn tap_sub's replay_lsn to pass 0/20DC608 on publisher done [23:05:00.221](0.105s) # issuing query via background psql: # BEGIN; # INSERT INTO test_tab_2 SELECT i FROM generate_series(1, 5000) s(i); [23:05:00.468](0.247s) # issuing query via background psql: COMMIT Waiting for replication conn tap_sub's replay_lsn to pass 0/21791B8 on publisher [23:08:39.738](219.271s) # poll_query_until timed out executing this query: # SELECT '0/21791B8' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('tap_sub', 'walreceiver') # expecting this output: # t # last actual query output: # # with stderr: timed out waiting for catchup at t/015_stream.pl line 289. # Postmaster PID for node "publisher" is 43270 ### Stopping node "publisher" using mode immediate # Running: pg_ctl -D /tmp/cirrus-ci-build/src/test/subscription/tmp_check/t_015_stream_publisher_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "publisher" # No postmaster PID for node "subscriber" [23:08:39.844](0.106s) # Tests were run but no plan was declared and done_testing() was not seen. [23:08:39.844](0.000s) # Looks like your test exited with 29 just after 8.