[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