Replication from 5.5.36 to 10.1.10
I am trying to enable replication from an older version of MariaDB on the master (5.5.36) to a newer version on the slave (10.1.10). Since the master doesn't support GTID I'm trying to turn it off....
After successfully preparing the backup (using Percona xtrabackup) I attempt to start replication:
CHANGE MASTER TO
MASTER_
MASTER_
MASTER_
MASTER_PORT=3306,
MASTER_
MASTER_
MASTER_
MASTER_USE_GTID=no;
This is what I'm seeing in the mysql error log:
[ERROR] Slave I/O: Unable to load replication GTID slave state from mysql.gtid_
[Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.005214' at position 890018419, relay log './mysql-
[ERROR] Slave SQL: Unable to load replication GTID slave state from mysql.gtid_
[Note] Slave I/O thread: connected to master 'replicate@
[ERROR] Slave SQL: Error 'Duplicate entry '46082' for key 'PRIMARY'' on query. Default database: 'etl_execution'. Query: 'INSERT INTO `batches` (`batch_file`, `completed_at`, `created_at`, `status`) VALUES ('/home/x/x.ebf', NULL, '2016-01-20 09:14:03', 'executing')', Internal MariaDB error code: 1062
[Warning] Slave: Duplicate entry '46082' for key 'PRIMARY' Error_code: 1062
[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.005214' position 890018495
I feel like I'm close to getting the replication up and running but not sure what to do now- any help would be much appreciated- thanks guys.
Question information
- Language:
- English Edit question
- Status:
- Answered
- For:
- MariaDB Edit question
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask alyssenko for more information if necessary.