Oracle Communications EAGLE (Software)
 

PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec EMS
 

In this Document

Symptoms

Changes

Cause

Solution

References

Created from <SR 3-17313415301>

Applies to:

Symptoms

Failover has been set up on new E5MS 46.5 servers but failover has failed

Changes

Cause

Issue is due to difference in Databases between both primary and secondary servers
 
mysql> show slave status \G;
*************************** 1. row ***************************
  Slave_IO_State: Waiting for master to send event
  Master_Host: e5ms02
  Master_User: replication
  Master_Port: 3306
  Connect_Retry: 60
  Master_Log_File: log-bin.000014
  Read_Master_Log_Pos: 2566626
  Relay_Log_File: relay-bin.000002
  Relay_Log_Pos: 404527
  Relay_Master_Log_File: log-bin.000014
  Slave_IO_Running: Yes
  Slave_SQL_Running: No
  Replicate_Do_DB:
  Replicate_Ignore_DB:
  Replicate_Do_Table:
  Replicate_Ignore_Table:
  Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
  Last_Errno: 1452
  Last_Error: Could not execute Write_rows event on table WebNmsDB.TopoObject; Cannot add or update a child row: a foreign key constraint fails (`WebNmsDB`.`TopoObject`, CONSTRAINT `FK608221B9A4FF80BC` FOREIGN KEY (`MOID`) REFERENCES `ManagedObject` (`MOID`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log log-bin.000014, end_log_pos 858642
  Skip_Counter: 0
  Exec_Master_Log_Pos: 858079
  Relay_Log_Space: 1659043
  Until_Condition: None
  Until_Log_File:
  Until_Log_Pos: 0
  Master_SSL_Allowed: No
  Master_SSL_CA_File:
  Master_SSL_CA_Path:
  Master_SSL_Cert:
  Master_SSL_Cipher:
  Master_SSL_Key:
  Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
  Last_IO_Errno: 0
  Last_IO_Error:
  Last_SQL_Errno: 1452
  Last_SQL_Error: Could not execute Write_rows event on table WebNmsDB.TopoObject; Cannot add or update a child row: a foreign key constraint fails (`WebNmsDB`.`TopoObject`, CONSTRAINT `FK608221B9A4FF80BC` FOREIGN KEY (`MOID`) REFERENCES `ManagedObject` (`MOID`) ON DELETE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log log-bin.000014, end_log_pos 858642
  Replicate_Ignore_Server_Ids:
  Master_Server_Id: 2
  Master_UUID: 1eb2ef08-426e-11e8-8eb4-005056802533
  Master_Info_File: /Tekelec/WebNMS/mysql/data/master.info
  SQL_Delay: 0
  SQL_Remaining_Delay: NULL
  Slave_SQL_Running_State:
  Master_Retry_Count: 86400
  Master_Bind:
  Last_IO_Error_Timestamp:
  Last_SQL_Error_Timestamp: 180418 14:27:26
  Master_SSL_Crl:
  Master_SSL_Crlpath:
  Retrieved_Gtid_Set:
  Executed_Gtid_Set:
  Auto_Position: 0
 

Solution

Perform following steps:
1. Take backup from primary server
2. SCP to secondary server
3. restore the secondary from the backup of primary
4. perform the replication again
5. restart the application on primary
6. restart the application on secondary

Please follow customer documentation, Install/Upgrade Guide:

https://docs.oracle.com/cd/E93344_01/doc.466/E93348_rev_1.pdf

References

This solution has no attachment