[Bucardo-general] Questions about replication status

[samir devaliya]

Hi,

i have configured master-master swap replication using bucardo

At source database  i had COPY 5100000 records in a table which is in the
herd

At the target database bucardo log i.e log.bucardo file particular log have
generated...

[Fri Jan 20 23:58:54 2012]  KID Target delta count for public.acctpin: 5101353
[Fri Jan 20 23:58:54 2012]  KID Source delta count for
public.partner_rate_upd: 0
[Fri Jan 20 23:58:56 2012]  KID Target delta count for
public.partner_rate_upd: 0
[Fri Jan 20 23:58:56 2012]  KID Source delta count for public.partner: 0
[Fri Jan 20 23:58:57 2012]  KID Target delta count for public.partner: 0
[Fri Jan 20 23:58:57 2012]  KID Source delta count for public.rate_mgr: 0
[Fri Jan 20 23:58:58 2012]  KID Target delta count for public.rate_mgr: 0
[Fri Jan 20 23:58:58 2012]  KID Source delta count for public.service: 0
[Fri Jan 20 23:58:59 2012]  KID Target delta count for public.service: 0
[Fri Jan 20 23:58:59 2012]  KID Total source delta count: 0
[Fri Jan 20 23:58:59 2012]  KID Total target delta count: 5101353
[Fri Jan 20 23:58:59 2012]  KID Total delta count: 5101353
[Sat Jan 21 00:01:35 2012]  KID No conflict, target only for
public.acctpin.ap_sno: 3937834
[Sat Jan 21 00:01:35 2012]  KID No conflict, target only for
public.acctpin.ap_sno: 28336
[Sat Jan 21 00:01:35 2012]  KID No conflict, target only for
public.acctpin.ap_sno: 2662385
[Sat Jan 21 00:01:35 2012]  KID No conflict, target only for
public.acctpin.ap_sno: 1860139
[Sat Jan 21 00:01:35 2012]  KID No conflict, target only for
public.acctpin.ap_sno: 4525620
                                     .
                                     .
                                     .
                                     .
                                     .
                                     .
                                     .
[Sat Jan 21 20:06:02 2012]  KID Action summary: 2:5101353
[Sat Jan 21 20:46:01 2012]  KID [1/5101353] public.acctpin INSERT
target to source pk 1
[Sat Jan 21 20:46:01 2012]  KID [2/5101353] public.acctpin INSERT
target to source pk 10
[Sat Jan 21 20:46:01 2012]  KID [3/5101353] public.acctpin INSERT
target to source pk 100
[Sat Jan 21 20:46:01 2012]  KID [4/5101353] public.acctpin INSERT
target to source pk 1000
[Sat Jan 21 20:46:01 2012]  KID [5/5101353] public.acctpin INSERT
target to source pk 10000
[Sat Jan 21 20:46:01 2012]  KID [6/5101353] public.acctpin INSERT
target to source pk 100000
                                    .
                                    .
                                    .
                                    .
 [Sun Jan 22 17:28:18 2012]  KID [5101346/5101353] public.acctpin
INSERT target to source pk 999992
[Sun Jan 22 17:28:18 2012]  KID [5101347/5101353] public.acctpin
INSERT target to source pk 999993
[Sun Jan 22 17:28:18 2012]  KID [5101348/5101353] public.acctpin
INSERT target to source pk 999994
[Sun Jan 22 17:28:18 2012]  KID [5101349/5101353] public.acctpin
INSERT target to source pk 999995
[Sun Jan 22 17:28:18 2012]  KID [5101350/5101353] public.acctpin
INSERT target to source pk 999996
[Sun Jan 22 17:28:18 2012]  KID [5101351/5101353] public.acctpin
INSERT target to source pk 999997
[Sun Jan 22 17:28:18 2012]  KID [5101352/5101353] public.acctpin
INSERT target to source pk 999998
[Sun Jan 22 17:28:18 2012]  KID [5101353/5101353] public.acctpin
INSERT target to source pk 999999
[Sun Jan 22 17:28:41 2012]  KID Updating bucardo_track for
public.acctpin on spicebillingdba0
[Sun Jan 22 17:28:55 2012]  CTL Warning! Kid 13017 seems to have died.
Sync "spicesyncb0"

Now when i run command bucardo_ctl status at source side o/p is

[root at apple ~]# bucardo_ctl status
Days back: 3  User: bucardo  Database: bucardo  PID of Bucardo MCP:29526
Name        Type  State                          PID   Last_good Time
I/U/D Last_bad  Time

===========+=====+==============================+=====+=========+=====+=====+=========+====

spicesynca0| S   |RUN:49h9m50s>spicebillingdbb0 |29531|50h11m20s|7s
|0/0/0|50h11m59s|16s

run command bucardo_ctl status at target side o/p is

[root at banana ~]# bucardo_ctl status
Days back: 3  User: bucardo  Database: bucardo  PID of Bucardo MCP:28093
Name        Type  State                          PID   Last_good Time
I/U/D Last_bad Time

===========+=====+==============================+=====+=========+=====+=====+========+====

spicesyncb0| S   |RUN:47h8m10s>spicebillingdba0 |28097|50h10m56s|8s
|7/0/0|47h8m32s|2h7s


And when i check the source database and query running ....

two query similiar below is running

SELECT    DISTINCT d.rowid AS "BUCARDO_ID", t.ap_sno
    ,ap_acct,ap_pin,ap_activedate,ap_expirydate,ap_currencycode,ap_initvalue,ap_value,ap_partnerid,ap_serviceid,ap_type,ap_status
,ap_userno,ap_concurrentlock,ap_assigndate,ap_rechargeable,ap_expiryperiod,ap_orderid,ap_postpaidlimit,ap_reserve

FROM      bucardo.bucardo_delta d
LEFT JOIN public.acctpin t ON (t.ap_sno::int4 = d.rowid::int4)
WHERE     d.tablename =82125::oid

   AND       NOT EXISTS (
 SELECT 1
      FROM   bucardo.bucardo_track
bt
    WHERE  d.txntime = bt.txntime
 AND    bt.targetdb = 'spicebillingdbb0'::text
 AND    bt.tablename = 82125::oid
 )


I dont know what happening is the replication got failed or its still going on

Regards
Samir Devaliya.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120122/84ffce8d/attachment.html