# Checking port 22168 # Found port 22168 Name: publisher Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/archives Connection string: port=22168 host=/tmp/5q7_qdCgog Log file: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/log/026_stats_publisher.log [14:58:03.055](0.017s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata --auth trust -c io_method=io_uring 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: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.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/026_stats/data/t_026_stats_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 ... Etc/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/026_stats/data/t_026_stats_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/026_stats/data/t_026_stats_publisher_data/pgdata ### Starting node "publisher" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_publisher_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/log/026_stats_publisher.log --options --cluster-name=publisher start waiting for server to start.... done server started # Postmaster PID for node "publisher" is 76784 # Checking port 22169 # Found port 22169 Name: subscriber Version: 19devel Data directory: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata Backup directory: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/backup Archive directory: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/archives Connection string: port=22169 host=/tmp/5q7_qdCgog Log file: /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/log/026_stats_subscriber.log [14:58:04.970](1.915s) # initializing database system by running initdb # Running: initdb --no-sync --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata --auth trust -c io_method=io_uring 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: C.UTF-8 LC_CTYPE: C.UTF-8 LC_MESSAGES: C LC_MONETARY: C.UTF-8 LC_NUMERIC: C LC_TIME: C.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/026_stats/data/t_026_stats_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 ... Etc/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/026_stats/data/t_026_stats_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/026_stats/data/t_026_stats_subscriber_data/pgdata ### Starting node "subscriber" # Running: pg_ctl --wait --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_subscriber_data/pgdata --log /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/log/026_stats_subscriber.log --options --cluster-name=subscriber start waiting for server to start.... done server started # Postmaster PID for node "subscriber" is 77401 [14:58:06.902](1.932s) ok 1 - Check that there are no subscription errors before starting logical replication. #### Begin standard error psql::1: NOTICE: created replication slot "test_tab1_sub" on publisher #### End standard error Waiting for replication conn test_tab1_sub's replay_lsn to pass 0/017D9A88 on publisher done [14:58:09.423](2.521s) ok 2 - Check that table 'test_tab1' now has 1 row. [15:01:28.473](199.050s) # poll_query_until timed out executing this query: # # SELECT apply_error_count > 0 AND confl_insert_exists > 0 # FROM pg_stat_subscription_stats # WHERE subname = 'test_tab1_sub' # # expecting this output: # t # last actual query output: # # with stderr: # psql: error: connection to server on socket "/tmp/5q7_qdCgog/.s.PGSQL.22169" failed: No such file or directory # Is the server running locally and accepting connections on that socket? [15:01:28.473](0.001s) # die: Timed out while waiting for apply error and insert_exists conflict for subscription 'test_tab1_sub' at /tmp/cirrus-ci-build/src/test/subscription/t/026_stats.pl line 126. [15:01:28.474](0.000s) 1..2 Timed out while waiting for apply error and insert_exists conflict for subscription 'test_tab1_sub' at /tmp/cirrus-ci-build/src/test/subscription/t/026_stats.pl line 126. # Postmaster PID for node "publisher" is 76784 ### Stopping node "publisher" using mode immediate # Running: pg_ctl --pgdata /tmp/cirrus-ci-build/build/testrun/subscription/026_stats/data/t_026_stats_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" [15:01:28.579](0.106s) # Looks like your test exited with 29 just after 2.