[Bucardo-general] Remote DB track tables aren't cleaned up.
Andrey Solovjov
solovjov at mcn.ru
Tue Apr 7 14:48:20 UTC 2015
I've created simple test configurution (see in the end of this post).
Bucardo version 5.3.1
I have to DBs: remote and local with 2 tables tab1 and tab2 each. Remote
DB (Postgres) is on the other host.
tab1 is replicated from local to remote db. tab2 is replicated from
remote to local.
Replication works but bucardo.delta_public_tab2 and
bucardo.track_public_tab2 aren't cleaned up.
Bucardo log output is:
(771) [Tue Apr 7 17:40:24 2015] VAC Finish and fetch
bucardo_purge_delta on database "local"
(771) [Tue Apr 7 17:40:24 2015] VAC Purge on db "local" gave: Tables
processed: 1
(771) [Tue Apr 7 17:42:24 2015] VAC Running bucardo_purge_delta on
database "local"
(771) [Tue Apr 7 17:42:24 2015] VAC Finish and fetch
bucardo_purge_delta on database "local"
(771) [Tue Apr 7 17:42:24 2015] VAC Purge on db "local" gave: Tables
processed: 1
So "remote" is not purged.
I have production server with similar config and table is updated quite
frequently. As a result those tables become huge and sync becomes very
slow so I have to clean tables by my own script (quite simple).
Is it a bug or normal behavior?
bucardo list all
-- customcodes:
There are no entries in the 'customcode' table.
-- customnames:
No customnames have been added yet
-- customcols:
No customcols have been added yet
-- dbgroups:
dbgroup: local_to_remote Members: local:source remote:target
dbgroup: remote_to_local Members: local:target remote:source
-- databases:
Database: local Status: active Conn: psql -U bucardo -d test_local_db
Database: remote Status: active Conn: psql -U bucardo -d
test_remote_db -h 10.0.0.101
-- relgroup:
Relgroup: local_relgoup DB: local Members: public.tab1
Used in syncs: local_to_remote
Relgroup: remote_relgoup DB: remote Members: public.tab2
Used in syncs: remote_to_local
-- syncs:
Sync "local_to_remote" Relgroup "local_relgoup" [Active]
DB group "local_to_remote" local:source remote:target
Sync "remote_to_local" Relgroup "remote_relgoup" [Active]
DB group "remote_to_local" local:target remote:source
-- tables:
1. Table: public.tab1 DB: local PK: name (text)
2. Table: public.tab2 DB: remote PK: name (text)
Best regards, Andrew.
More information about the Bucardo-general
mailing list