Solved: Need clarification on db replication

ciscoroyzhang · ‎07-04-2013

Hi there, a quick question: from the following screenshot based on cucm unified CM DB Status, can any one confirm to me that there is database replication issue here.

Screenshot A indectate that both database are 2 which is good. but screenshot B shows there are is problem. which one is correctly reflecting the database replication status?

Screenshot A

All servers have a replication count of 541.

All servers have a good replication status.

Server	Number of Replicates Created	Replicate_State
10.103.35.6	541	2 - good
10.103.35.7	541	2 - good

Screenshot B

Replication Server List (cdr list serv) from every server for debugging purposes only.

Server

cdr list serv

10.103.35.6

SERVER ID STATE STATUS QUEUE CONNECTION CHANGED

-----------------------------------------------------------------------

g_ausyd1as_41_ccm8_6_2_21900_5 2 Active Local 0

g_ausyd1as_42_ccm8_6_2_21900_5 3 Active Connected 0 May 17 20:28:31

10.103.35.7

SERVER ID STATE STATUS QUEUE CONNECTION CHANGED

-----------------------------------------------------------------------

g_ausyd1as_41_ccm8_6_2_21900_5 2 Active Connected 0 May 17 20:28:31

g_ausyd1as_42_ccm8_6_2_21900_5 3 Active Local 0

Aman Soi · ‎07-04-2013

Hi Roy,

Both the screenshots are correct.

First screenshot shows DBreplication which is fine.

Second Screenshot also shows replication and is OK.HAd DBReplication been problem , it would have shown DROPPED instead of Active.Values 2 and 3 correspond to ID State[which could be identity] of Pub abd SUB. Had there been third server in cluster, it would have ID state as 4.

regds,

aman

View solution in original post

Aman Soi · ‎07-04-2013

Hi Roy,

Can u share the output of utils dbreplication runtimestate from Publisher using CLI?

regds,

aman

Aman Soi · ‎07-04-2013

Hi Roy,

Both the screenshots are correct.

First screenshot shows DBreplication which is fine.

Second Screenshot also shows replication and is OK.HAd DBReplication been problem , it would have shown DROPPED instead of Active.Values 2 and 3 correspond to ID State[which could be identity] of Pub abd SUB. Had there been third server in cluster, it would have ID state as 4.

regds,

aman

ciscoroyzhang · ‎07-04-2013

Hi aman, thanks for the reply. the result from "untils dbreplcation status" is same as the scrrenshot B, I was bit confuresed with 2 and 3 in the screenshot B. thanks for clarifying this.... cheers Roy

Aman Soi · ‎07-04-2013

Hi Roy,

Thanks for rating.

regds,

aman

madhusudhanam · ‎07-04-2013

Hello Roy / Aman,

The below Information may help i believe.

Replicate_State counter

Use the Syslog viewer in the Cisco Unified Communications Manager Real-Time Monitoring Tool (RTMT) in order to check the Replicate_State counter for the Number of Replicates Created and State of Replication object on all nodes. The value on each node must equal 2. This counter represents the state of replication, which includes these possible values:

0 (Not Started)—No subscribers exist or the Database Layer Monitor service is not running and has not been running since the subscriber was installed.
1 (Started)—Replication is currently being setup.
2 (Finished)—Replication setup is completed and working.
3 (Broken)—Replication failed during setup and is not working.
4—Replication is not setup correctly.

Note: This information is the same for Cisco CallManager version 5.1(3) and all 6.1 versions.

Regards,

M.Madhusudhana Rao