Error in MySQL replication process

Error in MySQL replication process

Dear,

After following the HA instructions (6.9 version build 6902), we noticed a MySQL error on the secondary server (servername.err file). (please note server names have been modified in the logs).

Here is the content after a restart:

151229 14:09:40 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151229 14:09:40  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 7004050, file name mysql-bin.000007
InnoDB: Last MySQL binlog file position 0 12682399, file name .\mysql-bin.000026
151229 14:09:41  InnoDB: Started; log sequence number 0 3514278871
151229 14:09:41 [Note] Event Scheduler: Loaded 0 events
151229 14:09:41 [Note] C:\Program Files (x86)\PMP\scripts\\..\mysql\bin\mysqld: ready for connections.
Version: '5.1.50-enterprise-commercial-pro-log'  socket: ''  port: 2345  MySQL Enterprise Server - Pro Edition (Commercial)
151229 14:09:51 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=server2-relay-bin' to avoid this problem.
151229 14:09:51 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='', master_port='3306', master_log_file='', master_log_pos='4'. New state master_host='server1.domain.com', master_port='2345', master_log_file='', master_log_pos='4'.
151229 14:09:51 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\server2-relay-bin.000001' position: 4
151229 14:09:51 [Note] Slave I/O thread: connected to master 'repl@server1.domain.com:2345',replication started in log 'FIRST' at position 4
151229 14:09:51 [ERROR] Slave SQL: Could not execute Delete_rows event on table passtrix.discovereddomains; Can't find record in 'discovereddomains', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000001, end_log_pos 646, Error_code: 1032
151229 14:09:51 [Warning] Slave: Can't find record in 'discovereddomains' Error_code: 1032
151229 14:09:51 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000001' position 342


Though the replication status is ok on the admin console, It seems the replication process fails..

Can you please help ?

Regards,

                New to ADManager Plus?

                  New to ADSelfService Plus?