maria-discuss team mailing list archive

[bbnlaccts acnts <bbnlaccts@xxxxxxxxx>]

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