Hi, I am trying to set up a master slave replication between 2 servers running mariadb 10 on centos 6.7 In the initial setup itself i keep getting HA_ERR_KEY_NOT_FOUND. I have tried all methodology based on my novice knowledge ro rectify but in vain. i am new to this env. Any help will be greatly appreciated. - Server version 10.0.23-MariaDB-log - Protocol version 10 - UNIX socket /var/lib/mysql/mysql.sock. The scenario I have followed is this: 1. Shut the prod (mc1), took a cold backup and restored on slave (mc2). 2. On master ran show master status; prodarchivedlogs-bin.000001 and the pos as 582240 3. Set these info in slave. 4. Started the slave, it started throwing up error: 160812 3:31:50 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table radius1.radacct; Can't find record in 'radacct', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log prodarchivedlogs-bin.000001, end_log_pos 587695, Gtid 0-1-79, Internal MariaDB error code: 1032 160812 3:17:18 [Warning] Slave: Can't find record in 'radacct' Error_code: 1032 160812 3:17:18 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'prodarchivedlogs-bin.000001' position 587072 I have tried all methods based on my knowledge, but it is just not functioning. I tried using mysqlbinlog tool to extract to a file and then tried inserting, even then it is failing. Any help will be greatly appreciated. The prod my.cnf is as follows symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=1 The slave my.cnf is as follows skip-name-resolve skip-slave-start datadir=/var/lib/mysql/data1 socket=/var/lib/mysql/mysql.sockuser=mysql symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=2