<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
Try 'utils dbreplication repair'. That should always be the first step in trying to fix dbreplication.<div><br></div><div>However if only the dynamic tables are showing out of sync that may not really be a problem. <br><div><br><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: 12.0px Helvetica">-Ryan</font></div> </div><br><div><div>On Dec 10, 2008, at 10:25 AM, Djokic Sinisa wrote:</div><br class="Apple-interchange-newline"><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City" downloadurl="http://www.5iamas-microsoft-com:office:smarttags"> <o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place" downloadurl="http://www.5iantlavalamp.com/"> <o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region" downloadurl="http://www.5iantlavalamp.com/"> <!--[if !mso]> <style> st1\:*{behavior:url(#default#ieooui) } </style> <![endif]--> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> <div class="Section1"><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy">ryan..i see you online - </span></font><font size="2" color="navy" face="Wingdings"><span style="font-size:10.0pt;font-family: Wingdings;color:navy">J</span></font><font size="2" color="navy" face="Arial"><span style="font-size:10.0pt;font-family:Arial;color:navy">..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy">maybe you or wes have an advice?..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy">thanx..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy">regards..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p> <div><p class="MsoNormal"><strong><b><font size="2" color="navy" face="Verdana"><span style="font-size:10.0pt;font-family:Verdana;color:navy">Sinisa Djokic</span></font></b></strong><font size="2" color="navy" face="Verdana"><span style="font-size:10.0pt;font-family:Verdana; color:navy"> </span></font><font color="navy"><span style="color:navy"><o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" color="navy" face="Verdana"><span style="font-size: 10.0pt;font-family:Verdana;color:navy">System Engineer</span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="2" color="navy" face="Verdana"><span style="font-size:10.0pt; font-family:Verdana;color:navy">CCNP,CCDA,CQS-CWLDS,CS-CIPTDS,CS-CIPCCES Cisco Certified</span></font><font color="navy"><span style="color:navy"><o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" color="navy" face="Times New Roman"><span style="font-size:12.0pt;color:navy"> <o:p></o:p></span></font></p> </div> <table class="MsoNormalTable" border="0" cellpadding="0"> <tbody><tr> <td style="padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><font size="3" color="navy" face="Times New Roman"><span style="font-size:12.0pt;color:navy"><span><image002.gif></span><o:p></o:p></span></font></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><font size="3" color="navy" face="Times New Roman"><span style="font-size:12.0pt;color:navy"> <o:p></o:p></span></font></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><font size="1" color="navy" face="Verdana"><span style="font-size:7.5pt;font-family:Verdana;color:navy">MDS Informaticki inzenjering</span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="1" color="navy" face="Verdana"><span style="font-size: 7.5pt;font-family:Verdana;color:navy">Bul. Arsenija Carnojevica 170</span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="1" color="navy" face="Verdana"><span style="font-size: 7.5pt;font-family:Verdana;color:navy">11070 Novi <st1:place w:st="on"><st1:city w:st="on">Beograd</st1:city>, <st1:country-region w:st="on">Serbia</st1:country-region></st1:place></span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="1" color="navy" face="Verdana"><span style="font-size: 7.5pt;font-family:Verdana;color:navy">Tel: +381 11 2015 200, 2015 273</span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="1" color="navy" face="Verdana"><span style="font-size: 7.5pt;font-family:Verdana;color:navy">Fax: +381 11 3194 954</span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="1" color="navy" face="Arial"><span style="font-size:7.5pt; font-family:Arial;color:navy"><a href="http://www.mds.rs">www.mds.rs</a></span></font><font color="navy"><span style="color:navy"><br> </span></font><font size="1" color="navy" face="Arial"><span style="font-size:7.5pt; font-family:Arial;color:navy"><a href="mailto:sdjokic@mds.rs">sdjokic@mds.rs</a></span></font><font color="navy"><span style="color:navy"><o:p></o:p></span></font></p> </td> </tr> </tbody></table><p class="MsoNormal"><font size="2" color="navy" face="Arial"><span style="font-size: 10.0pt;font-family:Arial;color:navy"><o:p> </o:p></span></font></p> <div> <div class="MsoNormal" align="center" style="text-align:center"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <hr size="2" width="100%" align="center" tabindex="-1"> </span></font></div><p class="MsoNormal"><b><font size="2" face="Tahoma"><span style="font-size:10.0pt; font-family:Tahoma;font-weight:bold">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size:10.0pt;font-family:Tahoma"> Djokic Sinisa [<a href="mailto:sdjokic@mds.rs">mailto:sdjokic@mds.rs</a>] <br> <b><span style="font-weight:bold">Sent:</span></b> Wednesday, December 10, 2008 2:52 PM<br> <b><span style="font-weight:bold">To:</span></b> '<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>'<br> <b><span style="font-weight:bold">Subject:</span></b> DB replication not-synch !!!</span></font><o:p></o:p></p> </div><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">hi group..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">we have a CUCM 6.1.2 cluster with 3 x 7835 and over 1000 phones..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">all the phones are registered to subscriber number 1, first backup is subsciber number 2, and second backup is publisher..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">everything is working fine, but we had some issues with call pickup ( which we solved by restarting CCM-PUB CCM Sevrvice ) and after that we started to monitor system..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">during troubleshooting we got to DBREPLICATION..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">replication status is 2 and replication count is 393 which seems good..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">but when issuing " <b><span style="font-weight:bold">utils dbreplication status</span></b> " command among most of the log which shows no mismatch or any errors we found these few lines which indicate a possible problem in replication ( it's regarding mismatch between voip-pub and voip-sub2, there isn't any other errors ) :<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">"<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">Processing ccmdbtemplate_voip_pub_ccm6_1_2_1000_13_1_343_dnddynamic with 1125 rows group 7<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">------ Statistics for ccmdbtemplate_voip_pub_ccm6_1_2_1000_13_1_343_dnddynamic ------<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">data mismatch between <g_voip_pub_ccm6_1_2_1000_13> and <g_voip_sub2_ccm6_1_2_1000_13><o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">pkid:"245f843a-8821-4cee-aa36-5b9f72e25bdc "<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">--------------------------------------------------<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">data mismatch between <g_voip_pub_ccm6_1_2_1000_13> and <g_voip_sub2_ccm6_1_2_1000_13><o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">pkid:"301a7b5e-4a77-4660-8d0b-f8e5c840dddd "<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">--------------------------------------------------<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">data mismatch between <g_voip_pub_ccm6_1_2_1000_13> and <g_voip_sub2_ccm6_1_2_1000_13><o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">pkid:"6e39e9c0-d93b-4c8d-8ae0-451b69958dff "<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">--------------------------------------------------<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">data mismatch between <g_voip_pub_ccm6_1_2_1000_13> and <g_voip_sub2_ccm6_1_2_1000_13><o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">pkid:"81d3974d-b64f-4019-8203-437690ec8b09 "<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">--------------------------------------------------<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">data mismatch between <g_voip_pub_ccm6_1_2_1000_13> and <g_voip_sub2_ccm6_1_2_1000_13><o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">pkid:"97182d31-df7d-4708-be6a-1a0e93c07c24 "<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">--------------------------------------------------<o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">data mismatch between <g_voip_pub_ccm6_1_2_1000_13> and <g_voip_sub2_ccm6_1_2_1000_13><o:p></o:p></span></font></b></p><p class="MsoNormal"><b><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial;font-weight:bold">pkid:"b7ab2a2a-d746-4f30-b945-e46af4193eab "<o:p></o:p></span></font></b></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">"<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">so, does anybody have any opinion, is this out-of-synch between publisher and second subscriber something we should be worried about or not..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial">if it needs a fix, what procedure should be the most suitable ( resetting replication on critical subscriber or on all nodes ):<o:p></o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt">1. <o:p></o:p></span></font></p><p class="MsoNormal" style="margin-bottom:12.0pt"><b><font size="3" face="Times New Roman"><span style="font-size:12.0pt;font-weight:bold">utils dbreplication stop</span></font></b> on critical subscriber ( second subscriber )<br> <b><span style="font-weight:bold">utils dbreplication stop</span></b> on publisher<br> <b><span style="font-weight:bold">utils dbreplication reset <second subsciber></span></b> on publisher<o:p></o:p></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt">restart subscriber afterwards<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt">2. <o:p></o:p></span></font></p><p class="MsoNormal"><b><font size="3" face="Times New Roman"><span style="font-size:12.0pt;font-weight:bold">utils dbreplication stop </span></font></b>on all subscribers<br> <b><span style="font-weight:bold">utils dbreplication stop</span></b> on publisher<br> <b><span style="font-weight:bold">utils dbreplication reset all</span></b> on publisher<br> <br> restart subscribers afterwards<o:p></o:p></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt">3. if this this fails run clusterreset command according to procedure 1. or 2.<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt">thanx..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt">regards..<o:p></o:p></span></font></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p><p class="MsoNormal"><font size="2" face="Arial"><span style="font-size:10.0pt; font-family:Arial"><o:p> </o:p></span></font></p><p class="MsoNormal"><strong><b><font size="2" face="Verdana"><span style="font-size: 10.0pt;font-family:Verdana">Sinisa Djokic</span></font></b></strong><font size="2" face="Verdana"><span style="font-size:10.0pt;font-family:Verdana"> </span></font><o:p></o:p></p><p class="MsoNormal"><font size="2" face="Verdana"><span style="font-size:10.0pt; font-family:Verdana">System Engineer</span></font><br> <font size="2" face="Verdana"><span style="font-size:10.0pt;font-family:Verdana">CCNP,CCDA,CQS-CWLDS,CS-CIPTDS,CS-CIPCCES Cisco Certified</span></font><o:p></o:p></p><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"> <o:p></o:p></span></font></p> <table class="MsoNormalTable" border="0" cellpadding="0"> <tbody><tr> <td style="padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"><span><image003.gif></span><o:p></o:p></span></font></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size:12.0pt"> <o:p></o:p></span></font></p> </td> <td style="padding:.75pt .75pt .75pt .75pt"><p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size:7.5pt; font-family:Verdana">MDS Informaticki inzenjering</span></font><br> <font size="1" face="Verdana"><span style="font-size:7.5pt;font-family:Verdana">Bul. Arsenija Carnojevica 170</span></font><br> <font size="1" face="Verdana"><span style="font-size:7.5pt;font-family:Verdana">11070 Novi <st1:place w:st="on"><st1:city w:st="on">Beograd</st1:city>, <st1:country-region w:st="on">Serbia</st1:country-region></st1:place></span></font><br> <font size="1" face="Verdana"><span style="font-size:7.5pt;font-family:Verdana">Tel: +381 11 2015 200, 2015 273</span></font><br> <font size="1" face="Verdana"><span style="font-size:7.5pt;font-family:Verdana">Fax: +381 11 3194 954</span></font><br> <font size="1" face="Arial"><span style="font-size:7.5pt;font-family:Arial"><a href="http://www.mds.rs">www.mds.rs</a></span></font><br> <font size="1" face="Arial"><span style="font-size:7.5pt;font-family:Arial"><a href="mailto:sdjokic@mds.rs">sdjokic@mds.rs</a></span></font><o:p></o:p></p> </td> </tr> </tbody></table><p class="MsoNormal"><font size="3" face="Times New Roman"><span style="font-size: 12.0pt"><o:p> </o:p></span></font></p> </div> </o:smarttagtype></o:smarttagtype></o:smarttagtype><span><image002.gif></span><span><image003.gif></span><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">cisco-voip mailing list</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><a href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div> </div><br></div></div></body></html>