# Checking port 62012
# Found port 62012
Name: publisher
Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_publisher_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_publisher_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_publisher_data/archives
Connection string: port=62012 host=/tmp/exLnRfLJmW
Log file: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/log/015_stream_publisher.log
[23:04:53.859](0.014s) # 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/subscription/015_stream/data/t_015_stream_publisher_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_publisher_data/pgdata
### Starting node "publisher"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_publisher_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/log/015_stream_publisher.log -o --cluster-name=publisher start
waiting for server to start.... done
server started
# Postmaster PID for node "publisher" is 31141
# Checking port 62013
# Found port 62013
Name: subscriber
Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/pgdata
Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/backup
Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/archives
Connection string: port=62013 host=/tmp/exLnRfLJmW
Log file: /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/log/015_stream_subscriber.log
[23:04:54.011](0.152s) # 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/subscription/015_stream/data/t_015_stream_subscriber_data/pgdata
# Running: /tmp/cirrus-ci-build/build/src/test/regress/pg_regress --config-auth /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/pgdata
### Starting node "subscriber"
# Running: pg_ctl -w -D /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/pgdata -l /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/log/015_stream_subscriber.log -o --cluster-name=subscriber start
waiting for server to start.... done
server started
# Postmaster PID for node "subscriber" is 31167
#### Begin standard error
psql:<stdin>:1: WARNING:  subscriptions created by regression test cases should have names starting with "regress_"
psql:<stdin>: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/154ADC8 on publisher
done
done
[23:04:54.419](0.408s) ok 1 - check initial data was copied to subscriber
[23:04:54.426](0.007s) # 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:54.487](0.061s) # issuing query via background psql: COMMIT
Waiting for replication conn tap_sub's replay_lsn to pass 0/17D9EE8 on publisher
done
[23:04:56.124](1.637s) ok 2 - check extra columns contain local defaults
Waiting for replication conn tap_sub's replay_lsn to pass 0/199FD70 on publisher
done
[23:04:57.152](1.028s) ok 3 - check extra columns contain local defaults
Waiting for replication conn tap_sub's replay_lsn to pass 0/1A85040 on publisher
done
[23:04:57.937](0.785s) ok 4 - check extra columns contain locally changed data
Waiting for replication conn tap_sub's replay_lsn to pass 0/1AEF9E8 on publisher
done
### Reloading node "subscriber"
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/pgdata reload
server signaled
[23:04:58.846](0.909s) # 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:58.920](0.074s) # issuing query via background psql: COMMIT
Waiting for replication conn tap_sub's replay_lsn to pass 0/1D75F20 on publisher
done
[23:04:59.896](0.976s) ok 5 - check extra columns contain local defaults
Waiting for replication conn tap_sub's replay_lsn to pass 0/1F2F878 on publisher
done
[23:05:00.877](0.981s) ok 6 - check extra columns contain local defaults
Waiting for replication conn tap_sub's replay_lsn to pass 0/20159D8 on publisher
done
[23:05:01.542](0.665s) ok 7 - check extra columns contain locally changed data
Waiting for replication conn tap_sub's replay_lsn to pass 0/20804E0 on publisher
done
### Reloading node "subscriber"
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/t_015_stream_subscriber_data/pgdata reload
server signaled
[23:05:02.240](0.698s) # issuing query via background psql: 
# BEGIN;
# INSERT INTO test_tab_2 SELECT i FROM generate_series(1, 5000) s(i);
[23:05:02.477](0.237s) # issuing query via background psql: COMMIT
Waiting for replication conn tap_sub's replay_lsn to pass 0/20CEB28 on publisher
done
[23:05:02.985](0.508s) ok 8 - data replicated to subscriber after dropping index
Waiting for replication conn tap_sub's replay_lsn to pass 0/20CEE48 on publisher
done
[23:05:03.031](0.047s) # issuing query via background psql: 
# BEGIN;
# INSERT INTO test_tab_2 SELECT i FROM generate_series(1, 5000) s(i);
[23:05:03.260](0.228s) # issuing query via background psql: COMMIT
Waiting for replication conn tap_sub's replay_lsn to pass 0/216B9F8 on publisher
[23:08:35.247](211.987s) # poll_query_until timed out executing this query:
# SELECT '0/216B9F8' <= 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 /tmp/cirrus-ci-build/src/test/subscription/t/015_stream.pl line 289.
# Postmaster PID for node "publisher" is 31141
### Stopping node "publisher" using mode immediate
# Running: pg_ctl -D /tmp/cirrus-ci-build/build/testrun/subscription/015_stream/data/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:35.358](0.111s) # Tests were run but no plan was declared and done_testing() was not seen.
[23:08:35.358](0.000s) # Looks like your test exited with 29 just after 8.