# Checking port 58467 # Found port 58467 Name: publisher Data directory: C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_publisher_data/pgdata Backup directory: C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_publisher_data/backup Archive directory: C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_publisher_data/archives Connection string: port=58467 host=C:/Windows/TEMP/_buSd4jyb_ Log file: C:\cirrus\build/testrun/subscription/010_truncate\log/010_truncate_publisher.log [13:41:15.143](0.106s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_publisher_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl -w -D C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_publisher_data/pgdata -l C:\cirrus\build/testrun/subscription/010_truncate\log/010_truncate_publisher.log -o --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 7092 # Checking port 58468 # Found port 58468 Name: subscriber Data directory: C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/pgdata Backup directory: C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/backup Archive directory: C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/archives Connection string: port=58468 host=C:/Windows/TEMP/_buSd4jyb_ Log file: C:\cirrus\build/testrun/subscription/010_truncate\log/010_truncate_subscriber.log [13:41:16.743](1.599s) # initializing database system by copying initdb template # Running: robocopy /E /NJS /NJH /NFL /NDL /NP C:/cirrus/build/tmp_install/initdb-template C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/pgdata # Running: C:\cirrus\build\src/test\regress\pg_regress.exe --config-auth C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl -w -D C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/pgdata -l C:\cirrus\build/testrun/subscription/010_truncate\log/010_truncate_subscriber.log -o --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 6276 #### Begin standard error psql::1: NOTICE: created replication slot "sub1" on publisher #### End standard error #### Begin standard error psql::1: NOTICE: created replication slot "sub2" on publisher #### End standard error #### Begin standard error psql::1: NOTICE: created replication slot "sub3" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data done Waiting for replication conn sub1's replay_lsn to pass 0/1532528 on publisher done Waiting for replication conn sub1's replay_lsn to pass 0/1532BC8 on publisher done [13:41:25.763](9.020s) ok 1 - truncate replicated [13:41:25.979](0.217s) ok 2 - sequence not restarted Waiting for replication conn sub1's replay_lsn to pass 0/1533258 on publisher done [13:41:26.950](0.971s) ok 3 - truncate restarted identities Waiting for replication conn sub2's replay_lsn to pass 0/15338F8 on publisher done [13:41:28.530](1.580s) ok 4 - truncate not replicated Waiting for replication conn sub2's replay_lsn to pass 0/1534140 on publisher done [13:41:30.047](1.517s) ok 5 - truncate replicated after publication change Waiting for replication conn sub3's replay_lsn to pass 0/1534E20 on publisher done [13:41:31.438](1.392s) ok 6 - truncate of multiple tables replicated [13:41:31.579](0.140s) ok 7 - truncate of multiple tables replicated #### Begin standard error psql::1: NOTICE: dropped replication slot "sub2" on publisher #### End standard error Waiting for replication conn sub1's replay_lsn to pass 0/1535E30 on publisher done [13:41:33.128](1.550s) ok 8 - truncate of multiple tables some not published [13:41:33.386](0.257s) ok 9 - truncate of multiple tables some not published Waiting for replication conn sub1's replay_lsn to pass 0/1536058 on publisher done [13:41:35.602](2.216s) ok 10 - check synchronous logical replication Waiting for replication conn sub1's replay_lsn to pass 0/15366E8 on publisher done [13:41:36.868](1.266s) ok 11 - truncate replicated in synchronous logical replication #### Begin standard error psql::1: NOTICE: created replication slot "sub5_1" on publisher #### End standard error #### Begin standard error psql::1: NOTICE: created replication slot "sub5_2" on publisher #### End standard error Waiting for all subscriptions in "subscriber" to synchronize data done Waiting for replication conn sub5_1's replay_lsn to pass 0/1538428 on publisher done Waiting for replication conn sub5_2's replay_lsn to pass 0/1538428 on publisher [13:47:02.847](325.979s) # poll_query_until timed out executing this query: # SELECT '0/1538428' <= replay_lsn AND state = 'streaming' # FROM pg_catalog.pg_stat_replication # WHERE application_name IN ('sub5_2', 'walreceiver') # expecting this output: # t # last actual query output: # # with stderr: # psql: error: connection to server on socket "C:/Windows/TEMP/_buSd4jyb_/.s.PGSQL.58467" failed: Connection refused (0x0000274D/10061) # Is the server running locally and accepting connections on that socket? timed out waiting for catchup at C:/cirrus/src/test/subscription/t/010_truncate.pl line 219. # No postmaster PID for node "publisher" # Postmaster PID for node "subscriber" is 6276 ### Stopping node "subscriber" using mode immediate # Running: pg_ctl -D C:\cirrus\build/testrun/subscription/010_truncate\data/t_010_truncate_subscriber_data/pgdata -m immediate stop waiting for server to shut down.... done server stopped # No postmaster PID for node "subscriber" [13:47:02.976](0.130s) # Tests were run but no plan was declared and done_testing() was not seen. [13:47:02.977](0.000s) # Looks like your test exited with 2 just after 11.