CER DB Replication Status/Repaire

[mightyking]

Hi Everyone,

admin:utils dbreplication status
 
 -------------------- utils dbreplication status --------------------
 

SERVER                 ID STATE    STATUS     QUEUE  CONNECTION CHANGED
-----------------------------------------------------------------------
CER1_cer8_7_1_10000_17    2 Active   Local           0               
CER2_cer8_7_1_10000_17    3 Active   Error           0 Mar  2 14:45:58

Here`s the output of the utile dbreplication repair all

utils dbreplication repair output

To determine if replication is suspect, look for the following:
        (1) Number of rows in a table do not match on all nodes.
        (2) Non-zero values occur in any of the other output columns for a table

SERVER                 ID STATE    STATUS     QUEUE  CONNECTION CHANGED
-----------------------------------------------------------------------
CER1_cer8_7_1_10000_17    2 Active   Local           0               
CER2_cer8_7_1_10000_17    3 Active   Error           0 Mar  2 14:40:58

Attention: No active connected replication servers are currently available
Please check your system. Selected node CER2_cer8_7_1_10000_17 is out of service; aborting repair operation for that node

Both CER1 and CER2 are up and running. The only issue is when we shutdown the CER1 server, the admin page of the CER2 displays a HTTP 500 error message.

Thanks,

MK
 

[Dennis Mink]

Has this ever worked?  has anything changed, that could offer a clue to why it is not working?

Your CER2 server has state 3, which means there is a logical connection, but replication is suspect from CER1's point of view.

If you are newly deploying this. take my advise, rebuilt that CER2, assuming its a sub. much quicker that going through TAC.

Otherwise Check my post on this subject:

http://ciscoshizzle.blogspot.com.au/2013/10/cucm-database-replication-how-it-works.html

[mightyking]

HI Dennis,

Sorry for late reply. I was away for a week.

I had gone through each and every step mentionned in the provided link but still having the same issue. None of the dbreplication commands is able to repair the replication btw CER1 and CER2. To be honest with you I don`t know if the replication ever worked. I don`t know what else I can do to restablish the DB replication.

Thanks,

MK