Hi All, I have just done master master setup using Bucardo. Records are inserting both Database but it seems some problem with sequence.
Here is the scenario. *DB server 1 :* opensips=# insert into dispatcher(setid,destination,flags,weight,attrs,description) values (1,'sip: 192.168.1.15:5060',0,1,'','FS1'); INSERT 0 1 *Db server 2:* opensips=# select * from dispatcher; id | setid | destination | flags | weight | attrs | description ----+-------+----------------------+-------+--------+-------+------------- 1 | 1 | sip:192.168.1.15:5060 | 0 | 1 | | FS1 (1 row) opensips=# insert into dispatcher(setid,destination,flags,weight,attrs,description) values (2,'sip: 192.168.1.15:5060',0,1,'','FS2'); ERROR: duplicate key value violates unique constraint "dispatcher_pkey" DETAIL: Key (id)=(1) already exists. opensips=# insert into dispatcher(setid,destination,flags,weight,attrs,description) values (2,'sip: 192.168.1.15:5060',0,1,'','FS2'); INSERT 0 1 *DB server 1:* opensips=# select * from dispatcher; id | setid | destination | flags | weight | attrs | description ----+-------+-----------------------+-------+--------+-------+------------- 1 | 1 | sip:41.218.72.6:5060 | 0 | 1 | | FS1 2 | 2 | sip:192.168.1.15:5060 | 0 | 1 | | FS2 (2 rows) opensips=# insert into dispatcher(setid,destination,flags,weight,attrs,description) values (3,'sip: 192.168.1.17:5060',0,1,'','FS3'); ERROR: duplicate key value violates unique constraint "dispatcher_pkey" DETAIL: Key (id)=(2) already exists. opensips=# insert into dispatcher(setid,destination,flags,weight,attrs,description) values (3,'sip: 192.168.1.17:5060',0,1,'','FS3'); INSERT 0 1 Is there anyway to avoid this situation? any parameter or configuration to avoid this. i am kindda of new to bucardo may be this is a silly question but really i am just confuse with this. Any suggestion and idea will be appreciable. *Regards* Juned Khan
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
