subscriber.log

application/octet-stream

Download

2023-10-02 10:21:21.803 UTC [979] LOG:  starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-8.3.1, 64-bit
2023-10-02 10:21:21.804 UTC [979] LOG:  listening on IPv6 address "::1", port 5433
2023-10-02 10:21:21.804 UTC [979] LOG:  listening on IPv4 address "127.0.0.1", port 5433
2023-10-02 10:21:21.807 UTC [979] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5433"
2023-10-02 10:21:21.813 UTC [982] LOG:  database system was shut down at 2023-10-02 10:21:21 UTC
2023-10-02 10:21:21.823 UTC [979] LOG:  database system is ready to accept connections
2023-10-02 10:21:21.962 UTC [992] LOG:  logical replication apply worker for subscription "sub" has started
2023-10-02 10:21:21.975 UTC [994] LOG:  logical replication table synchronization worker for subscription "sub", table "tbl" has started
2023-10-02 10:21:36.257 UTC [979] LOG:  received fast shutdown request
2023-10-02 10:21:36.259 UTC [979] LOG:  aborting any active transactions
2023-10-02 10:21:36.259 UTC [994] FATAL:  terminating logical replication worker due to administrator command
2023-10-02 10:21:36.261 UTC [992] FATAL:  terminating logical replication worker due to administrator command
2023-10-02 10:21:36.262 UTC [979] LOG:  background worker "logical replication launcher" (PID 985) exited with exit code 1
2023-10-02 10:21:36.262 UTC [979] LOG:  background worker "logical replication tablesync worker" (PID 994) exited with exit code 1
2023-10-02 10:21:36.263 UTC [979] LOG:  background worker "logical replication apply worker" (PID 992) exited with exit code 1
2023-10-02 10:21:36.263 UTC [980] LOG:  shutting down
2023-10-02 10:21:36.265 UTC [980] LOG:  checkpoint starting: shutdown immediate
2023-10-02 10:21:36.283 UTC [980] LOG:  checkpoint complete: wrote 53 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.009 s, total=0.021 s; sync files=41, longest=0.002 s, average=0.001 s; distance=144 kB, estimate=144 kB; lsn=0/154B678, redo lsn=0/154B678
2023-10-02 10:21:36.289 UTC [979] LOG:  database system is shut down
2023-10-02 10:21:36.388 UTC [1020] LOG:  starting PostgreSQL 17devel on x86_64-linux, compiled by gcc-8.3.1, 64-bit
2023-10-02 10:21:36.389 UTC [1020] LOG:  listening on IPv6 address "::1", port 5433
2023-10-02 10:21:36.389 UTC [1020] LOG:  listening on IPv4 address "127.0.0.1", port 5433
2023-10-02 10:21:36.393 UTC [1020] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5433"
2023-10-02 10:21:36.399 UTC [1023] LOG:  database system was shut down at 2023-10-02 10:21:36 UTC
2023-10-02 10:21:36.399 UTC [1023] LOG:  recovered replication state of node 1 to 0/0
2023-10-02 10:21:36.399 UTC [1023] LOG:  recovered replication state of node 2 to 0/30000D0
2023-10-02 10:21:36.406 UTC [1020] LOG:  database system is ready to accept connections
2023-10-02 10:21:36.520 UTC [1033] LOG:  logical replication apply worker for subscription "sub" has started
2023-10-02 10:21:36.527 UTC [1033] ERROR:  could not start WAL streaming: ERROR:  replication slot "sub" does not exist
2023-10-02 10:21:36.528 UTC [1020] LOG:  background worker "logical replication apply worker" (PID 1033) exited with exit code 1
2023-10-02 10:21:41.523 UTC [1038] LOG:  logical replication apply worker for subscription "sub" has started
2023-10-02 10:21:41.530 UTC [1038] ERROR:  could not start WAL streaming: ERROR:  replication slot "sub" does not exist
2023-10-02 10:21:41.531 UTC [1020] LOG:  background worker "logical replication apply worker" (PID 1038) exited with exit code 1
2023-10-02 10:21:46.525 UTC [1045] LOG:  logical replication apply worker for subscription "sub" has started
2023-10-02 10:21:46.526 UTC [1045] ERROR:  could not connect to the publisher: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
		Is the server running locally and accepting connections on that socket?
2023-10-02 10:21:46.527 UTC [1020] LOG:  background worker "logical replication apply worker" (PID 1045) exited with exit code 1
2023-10-02 10:21:47.803 UTC [1020] LOG:  received fast shutdown request
2023-10-02 10:21:47.805 UTC [1020] LOG:  aborting any active transactions
2023-10-02 10:21:47.807 UTC [1020] LOG:  background worker "logical replication launcher" (PID 1026) exited with exit code 1
2023-10-02 10:21:47.809 UTC [1021] LOG:  shutting down
2023-10-02 10:21:47.811 UTC [1021] LOG:  checkpoint starting: shutdown immediate
2023-10-02 10:21:47.822 UTC [1021] LOG:  checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.004 s, total=0.013 s; sync files=6, longest=0.002 s, average=0.001 s; distance=1 kB, estimate=1 kB; lsn=0/154BCD0, redo lsn=0/154BCD0
2023-10-02 10:21:47.828 UTC [1020] LOG:  database system is shut down