My Oracle Support Banner

Node 3 Migration Fails on SetupMySQL When Importing the MySQL Slave Database into the New MySQL Master (Doc ID 2536067.1)

Last updated on APRIL 17, 2023

Applies to:

Big Data Appliance Integrated Software - Version 4.11.0 and later
Linux x86-64

Symptoms


Note: In the example here <HOSTNAME5> is the host that Node 3 is being migrated to and <HOSTNAME2> is the host with MySQL Slave role.

Node 3 migration fails on SetupMySQL as below when importing the MySQL Slave database into the new MySQL Master:

INFO: Step 2 SetupMySQL
...

************************************
Error [23486]: (//<HOSTNAME5>.<DOMAIN>//Stage[post]/Mysql::Importmysql/Mysqlimportdb[<HOSTNAME5>.<DOMAIN>]/Exec[dump_db]/returns) change from notrun to 0 failed: /usr/bin/mysqldump -uroot -p'<MYSQL_ROOT_PASSWORD>' -h <HOSTNAME2>.<DOMAIN> --all-databases --insert-ignore > /opt/oracle/BDAMammoth/bdaconfig/tmp/dbdump_<HOSTNAME2>.<DOMAIN> returned 2 instead of one of [0]
************************************

1. Manually running the mysqldump on the node that Node 3 is being migrated to, Node 5 in the example here, to dump the MySQL Slave database also fails:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.