[Bucardo-general] Why does it replicate only the primary key column ?

[Kiriakos Tsourapas]

Well, here is a copy of the logs :

Apr 28 17:47:41  Bucardo[2298]: KID Total target delta count: 0
Apr 28 17:47:41  Bucardo[2298]: KID Total delta count: 1
Apr 28 17:47:41  Bucardo[2298]: KID No conflict, source only for public."WHITELIST"."RECIPIENT": 12345
Apr 28 17:47:41  Bucardo[2298]: KID Action summary: 1:1
Apr 28 17:47:41  Bucardo[2298]: KID [1/1] public."WHITELIST" UPDATE source to target pk 12345
Apr 28 17:47:41  Bucardo[2298]: KID Updating bucardo_track for public."WHITELIST" on MyTest
Apr 28 17:47:41  Bucardo[2298]: KID Issuing final commit for source and target
Apr 28 17:47:41  Bucardo[2298]: KID Marking as done in the q table, notifying controller
Apr 28 17:47:41  Bucardo[2298]: KID Finished syncing. Time: 0. Updates: 0+1 Inserts: 0+0 Deletes: 0+0 Sync: MyTest. Keepalive: 1
Apr 28 17:47:41  Bucardo[1053]: CTL Got notice "bucardo_syncdone_MyTest_MyTest" from 2299 (kid on database MyTest)
Apr 28 17:47:41  Bucardo[1053]: CTL Sent notice "bucardo_syncdone_MyTest"

Do you see anything strange ?

The above update only updated the RECIPIENT column of the table :
CREATE TABLE "WHITELIST"
(
  "RECIPIENT" character varying(20) NOT NULL,
  "TEST" character varying(10) NOT NULL,
  CONSTRAINT "PK_WHITELIST" PRIMARY KEY ("RECIPIENT")
)

The TEST column was left untouched.


Any help will be appreciated.




On Apr 28, 2010, at 18:35, Greg Sabino Mullane wrote:

>> But I have a table with a primary key column and another column and :
>> 1. When I change the simple column, it detects that something changed, but it does not send the change.
>> 2. When I change the primary-key column, it only replicates this column and leaves the simple column untouched.
>> 
>> By the way, I am using 'swap' replication, i.e. master-to-master.
> 
> It certainly should not be acting like this. Have you checked the logs to see 
> if anything odd is going on?
> 
> -- 
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100428/a949734c/attachment.html