[Bucardo-general] Bucardo will only replicate a single table - what I am doing wrong?

[Richard Martin]

Hi

I've got Bucardo running OK (I think).  I can get it to replicate data  
in a multimaster setup using swap as the type of replication.  I have  
two database on a single machine (while testing the setup) and I can  
get Bucardo to replicate on only one table!  I've obviously messed it  
up somewhere but I can't see it - anybody got any ideas?

Here is my setup:

> INSERT INTO db(name, dbname, dbhost, dbuser)
> VALUES ('banbridge','banbridge-leisure','192.168.0.27','banbridge- 
> leisure');
> INSERT INTO db(name, dbname, dbhost, dbuser)
> VALUES ('dromore','banbridge-leisure- 
> backup','192.168.0.27','banbridge-leisure-backup');
>
> INSERT INTO dbgroup(name) VALUES ('remote_dbs');
> INSERT INTO dbmap(db,dbgroup) VALUES ('dromore','remote_dbs');
>
> INSERT INTO goat(db, tablename, pkey, pkeytype, standard_conflict)
> VALUES('banbridge', 'calendars', 'id', 'int', 'latest');
> INSERT INTO goat(db, tablename, pkey, pkeytype, standard_conflict)
> VALUES('banbridge', 'users', 'id', 'int', 'latest');
> INSERT INTO goat(db, tablename, pkey, pkeytype, standard_conflict)
> VALUES('banbridge', 'titles', 'id', 'int', 'latest');
>
>
>
> INSERT INTO herd(name) VALUES ('leisure');
> INSERT INTO herdmap(herd,goat) SELECT 'leisure', id
> FROM goat WHERE db='banbridge' AND tablename IN  
> ('calendars','users','titles');
>
> INSERT INTO  
> sync 
> (name 
> ,source,targetdb,synctype,checktime,disable_triggers,disable_rules)
> VALUES ('leisure_sync','leisure','dromore','swap','10  
> minutes','pg_class','pg_class');



I want 3 tables replicated, calendars, titles and users.  All have a  
primary id called ID which is an INT.

Here's some output from the log:

> Sep 23 14:29:40 leisure-backup Bucardo[17490]: MCP Sent a kick  
> request to controller 17495 for sync "leisure_sync"
> Sep 23 14:29:41 leisure-backup Bucardo[17495]: CTL Got notice  
> "bucardo_ctl_kick_leisure_sync" from 17491
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Got a notice for  
> leisure_sync: banbridge -> dromore
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Source delta  
> count for public.calendars: 0
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Target delta  
> count for public.calendars: 0
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Source delta  
> count for public.users: 0
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Target delta  
> count for public.users: 61
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Source delta  
> count for public.titles: 0
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Target delta  
> count for public.titles: 0
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Total source  
> delta count: 0
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Total target  
> delta count: 61
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Total delta  
> count: 61
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Disabling  
> triggers and rules on dromore
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID Disabling  
> triggers and rules on banbridge
> Sep 23 14:29:41 leisure-backup Bucardo[17497]: KID No conflict,  
> target only for public.users.id: ?

Then it happily replicated the changes to the users data.

If I run a similar UPDATE on titles - no output at all - no errors  
even....

Anybody have any ideas?

Many thanks
Richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20080923/bf700fe7/attachment.html