bdr appears to be trying to replicate to itself - Mailing list pgsql-general
| From | Cj B |
|---|---|
| Subject | bdr appears to be trying to replicate to itself |
| Date | |
| Msg-id | FCF0C1BA-8FE9-4D5D-9426-7C2C26B54710@gmail.com Whole thread Raw |
| Responses |
Re: bdr appears to be trying to replicate to itself
|
| List | pgsql-general |
I noticed a very strange issue starting about 20 days ago and my pg_xlog has just been filling up since then.
```
HOST A:
postgres=# select * from pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin |
restart_lsn
-----------------------------------------+--------+-----------+--------+-----------+--------+------+--------------+-------------
bdr_16385_6188730679935789649_1_16385__ | bdr | logical | 16385 | database_name | f | | 28174997 |
25/7677F300
bdr_16385_6188733518371128845_2_16385__ | bdr | logical | 16385 | database_name | t | | 38613316 |
41/7B7EDF80
select bdr.bdr_get_local_nodeid();
bdr_get_local_nodeid
-------------------------------
(6188730679935789649,1,16385)
SELECT slot_name, database, active, pg_xlog_location_diff(pg_current_xlog_insert_location(), restart_lsn) AS
retained_bytes FROM pg_replication_slots WHERE plugin = 'bdr';
slot_name | database | active | retained_bytes
-----------------------------------------+-----------+--------+----------------
bdr_16385_6188730679935789649_1_16385__ | database_name | f | 120353015152
bdr_16385_6188733518371128845_2_16385__ | database_name | t | 2288
(2 rows)
```
HOST B:
```
select * from pg_replication_slots;
slot_name | plugin | slot_type | datoid | database | active | xmin | catalog_xmin |
restart_lsn
-----------------------------------------+--------+-----------+--------+-----------+--------+------+--------------+-------------
bdr_16385_6188730679935789649_1_16385__ | bdr | logical | 16385 | database_name | t | | 3499719 |
3/B53F00A8
select bdr.bdr_get_local_nodeid();
bdr_get_local_nodeid
-------------------------------
(6188733518371128845,2,16385)
SELECT slot_name, database, active, pg_xlog_location_diff(pg_current_xlog_insert_location(), restart_lsn) AS
retained_bytes FROM pg_replication_slots WHERE plugin = 'bdr';
slot_name | database | active | retained_bytes
-----------------------------------------+-----------+--------+----------------
bdr_16385_6188730679935789649_1_16385__ | database_name | t | 68736
```
So it almost looks like HOST A is trying to replicate to itself since the replication_slots has the same node_id of
itselfand it's just filling up the pg_xlog.
This server has been setup since mid-may and I haven't added any new nodes but I did upgrade just this past weekend
beforeI noticed there was a problem:
dpkg -l | grep '^ii' | grep postgre
ii pgdg-keyring 2014.1 all keyring for apt.postgresql.org
ii postgresql-bdr-9.4 9.4.5-1trusty amd64 object-relational SQL
database,version 9.4 server
ii postgresql-bdr-9.4-bdr-plugin 0.9.3-1trusty amd64 BDR Plugin for PostgreSQL-BDR
9.4
ii postgresql-bdr-client-9.4 9.4.5-1trusty amd64 front-end programs for
PostgreSQL-BDR9.4
ii postgresql-bdr-contrib-9.4 9.4.5-1trusty amd64 additional facilities for
PostgreSQL
ii postgresql-client-common 170.pgdg14.04+1 all manager for multiple
PostgreSQLclient versions
ii postgresql-common 170.pgdg14.04+1 all PostgreSQL database-cluster
manager
ii postgresql-contrib 9.4+170.pgdg14.04+1 all additional facilities for
PostgreSQL(supported version)
Before I was on postgresql-bdr-client-9.4 9.4.4-1trusty
Can anyone help me fix this? I'm running out of HD space.
Thanks!
pgsql-general by date: