Hi CraigI have a similar issue with a rather small number of servers involved.*Node 1:*max_replication_slots = 4max_wal_senders = 6wal_level = 'logical'track_commit_timestamp = onshared_preload_libraries = 'bdr'max_worker_processes = 10log_error_verbosity = verboselog_min_messages = debug1log_line_prefix = 'd=%d p=%p a=%a%q 'bdr.default_apply_delay = 2000bdr.log_conflicts_to_table = onbdr.connections = 'bdrnode3,bdrnode3'bdr.bdrnode2_dsn = 'dbname=db user=postgres host=host2 port=5599'bdr.bdrnode3_dsn = 'dbname=db user=postgres host=host3 port=5599'*Node 2:*max_replication_slots = 4max_wal_senders = 6wal_level = 'logical'track_commit_timestamp = onshared_preload_libraries = 'bdr'max_worker_processes = 10log_error_verbosity = verboselog_min_messages = debug1log_line_prefix = 'd=%d p=%p a=%a%q 'bdr.default_apply_delay = 2000bdr.log_conflicts_to_table = onbdr.connections = 'bdrnode1,bdrnode3'bdr.bdrnode1_dsn = 'dbname=db user=postgres host=host1 port=5599'bdr.bdrnode3_dsn = 'dbname=db user=postgres host=host3 port=5599'bdr.bdrnode1_init_replica = onbdr.bdrnode1_replica_local_dsn = 'dbname=db user=postgres host=localhost port=5599'*Node 3:*max_replication_slots = 4max_wal_senders = 6wal_level = 'logical'track_commit_timestamp = onshared_preload_libraries = 'bdr'max_worker_processes = 10log_error_verbosity = verboselog_min_messages = debug1log_line_prefix = 'd=%d p=%p a=%a%q 'bdr.default_apply_delay = 2000bdr.log_conflicts_to_table = onbdr.connections = 'bdrnode1,bdrnode2'bdr.bdrnode1_dsn = 'dbname=db user=postgres host=host1 port=5599'bdr.bdrnode2_dsn = 'dbname=db user=postgres host=host2 port=5599'bdr.bdrnode1_init_replica = onbdr.bdrnode1_replica_local_dsn = 'dbname=db user=postgres host=localhost port=5599'The above setup is an attempt for a "3-remote site simple Multi-Master Plex" configuration.Node1 and Node2 are replicating, but Node3 does not work, and the following data is is from Node3 logs:d=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive CONTEXT: slot "bdr_16396_6106457559585933042_1_16398__", output plugin "bdr", in the startup callbackd=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive LOCATION: pg_decode_startup, bdr_output.c:450d=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive ERROR: 55000: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6107134089288229725, timelineid=1, dboid=16396): status='i', bdr still starting up: applying initial dump of remote noded=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive HINT: Monitor pg_stat_activity and the logs, wait until the node has caught upd=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive CONTEXT: slot "bdr_16396_6106457559585933042_1_16398__", output plugin "bdr", in the startup callbackd=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive LOCATION: bdr_ensure_node_ready, bdr_output.c:268d=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive LOG: 08006: could not receive data from client: Connection reset by peerd=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive LOCATION: pq_recvbuf, pqcomm.c:869d=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 08003: unexpected EOF on client connectiond=db_name p=3173 a=bdr (6106457559585933042,1,16398,): receive LOCATION: SocketBackend, postgres.c:353d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 00000: received replication command: IDENTIFY_SYSTEMd=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 00000: received replication command: START_REPLICATION SLOT "bdr_16396_6106458869483394081_1_16396__" LOGICAL 0/0 (pg_version '90400', pg_catversion '201408161', bdr_version '701', min_bdr_version '700', sizeof_int '4', sizeof_long '8', sizeof_datum '8', maxalign '8', float4_byval '1', float8_byval '1', integer_datetimes '1', bigendian '0', db_encoding 'UTF8')d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 00000: bdr.bdr_conflict_handlers OID set to 16991d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive CONTEXT: slot "bdr_16396_6106458869483394081_1_16396__", output plugin "bdr", in the startup callbackd=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOCATION: pg_decode_startup, bdr_output.c:450d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive ERROR: 55000: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6107134089288229725, timelineid=1, dboid=16396): status='i', bdr still starting up: applying initial dump of remote noded=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive HINT: Monitor pg_stat_activity and the logs, wait until the node has caught upd=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive CONTEXT: slot "bdr_16396_6106458869483394081_1_16396__", output plugin "bdr", in the startup callbackd=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOCATION: bdr_ensure_node_ready, bdr_output.c:268d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOG: 08006: could not receive data from client: Connection reset by peerd=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOCATION: pq_recvbuf, pqcomm.c:869d=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 08003: unexpected EOF on client connectiond=db_name p=3175 a=bdr (6106458869483394081,1,16396,): receive LOCATION: SocketBackend, postgres.c:353d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 00000: received replication command: IDENTIFY_SYSTEMd=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 00000: received replication command: START_REPLICATION SLOT "bdr_16396_6106457559585933042_1_16398__" LOGICAL 0/0 (pg_version '90400', pg_catversion '201408161', bdr_version '701', min_bdr_version '700', sizeof_int '4', sizeof_long '8', sizeof_datum '8', maxalign '8', float4_byval '1', float8_byval '1', integer_datetimes '1', bigendian '0', db_encoding 'UTF8')d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 00000: bdr.bdr_conflict_handlers OID set to 16991d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive CONTEXT: slot "bdr_16396_6106457559585933042_1_16398__", output plugin "bdr", in the startup callbackd=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOCATION: pg_decode_startup, bdr_output.c:450d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive ERROR: 55000: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6107134089288229725, timelineid=1, dboid=16396): status='i', bdr still starting up: applying initial dump of remote noded=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive HINT: Monitor pg_stat_activity and the logs, wait until the node has caught upd=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive CONTEXT: slot "bdr_16396_6106457559585933042_1_16398__", output plugin "bdr", in the startup callbackd=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOCATION: bdr_ensure_node_ready, bdr_output.c:268d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOG: 08006: could not receive data from client: Connection reset by peerd=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOCATION: pq_recvbuf, pqcomm.c:869d=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 08003: unexpected EOF on client connectiond=db_name p=3189 a=bdr (6106457559585933042,1,16398,): receive LOCATION: SocketBackend, postgres.c:353d= p=3190 a=DEBUG: 00000: autovacuum: processing database "db_name"d= p=3190 a=LOCATION: AutoVacWorkerMain, autovacuum.c:1670d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 00000: received replication command: IDENTIFY_SYSTEMd=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 00000: received replication command: START_REPLICATION SLOT "bdr_16396_6106458869483394081_1_16396__" LOGICAL 0/0 (pg_version '90400', pg_catversion '201408161', bdr_version '701', min_bdr_version '700', sizeof_int '4', sizeof_long '8', sizeof_datum '8', maxalign '8', float4_byval '1', float8_byval '1', integer_datetimes '1', bigendian '0', db_encoding 'UTF8')d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 00000: bdr.bdr_conflict_handlers OID set to 16991d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive CONTEXT: slot "bdr_16396_6106458869483394081_1_16396__", output plugin "bdr", in the startup callbackd=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOCATION: pg_decode_startup, bdr_output.c:450d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive ERROR: 55000: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6107134089288229725, timelineid=1, dboid=16396): status='i', bdr still starting up: applying initial dump of remote noded=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive HINT: Monitor pg_stat_activity and the logs, wait until the node has caught upd=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive CONTEXT: slot "bdr_16396_6106458869483394081_1_16396__", output plugin "bdr", in the startup callbackd=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOCATION: bdr_ensure_node_ready, bdr_output.c:268d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOG: 08006: could not receive data from client: Connection reset by peerd=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOCATION: pq_recvbuf, pqcomm.c:869d=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive DEBUG: 08003: unexpected EOF on client connectiond=db_name p=3191 a=bdr (6106458869483394081,1,16396,): receive LOCATION: SocketBackend, postgres.c:353d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 00000: received replication command: IDENTIFY_SYSTEMd=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 00000: received replication command: START_REPLICATION SLOT "bdr_16396_6106457559585933042_1_16398__" LOGICAL 0/0 (pg_version '90400', pg_catversion '201408161', bdr_version '701', min_bdr_version '700', sizeof_int '4', sizeof_long '8', sizeof_datum '8', maxalign '8', float4_byval '1', float8_byval '1', integer_datetimes '1', bigendian '0', db_encoding 'UTF8')d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOCATION: exec_replication_command, walsender.c:1292d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 00000: bdr.bdr_conflict_handlers OID set to 16991d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive CONTEXT: slot "bdr_16396_6106457559585933042_1_16398__", output plugin "bdr", in the startup callbackd=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOCATION: pg_decode_startup, bdr_output.c:450d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive ERROR: 55000: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6107134089288229725, timelineid=1, dboid=16396): status='i', bdr still starting up: applying initial dump of remote noded=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive HINT: Monitor pg_stat_activity and the logs, wait until the node has caught upd=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive CONTEXT: slot "bdr_16396_6106457559585933042_1_16398__", output plugin "bdr", in the startup callbackd=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOCATION: bdr_ensure_node_ready, bdr_output.c:268d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOG: 08006: could not receive data from client: Connection reset by peerd=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOCATION: pq_recvbuf, pqcomm.c:869d=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive DEBUG: 08003: unexpected EOF on client connectiond=db_name p=3199 a=bdr (6106457559585933042,1,16398,): receive LOCATION: SocketBackend, postgres.c:353*The persisting error is:* 55000: bdr output plugin: slot creation rejected, bdr.bdr_nodes entry for local node (sysid=6107134089288229725, timelineid=1, dboid=16396): status='i', bdr still starting up: applying initial dump of remote nodeI hope I have provided enough detail and that I am posting at the right forum.Regards
-- View this message in context: http://postgresql.nabble.com/BDR-Error-restarted-tp5833139p5835137.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
