Troubleshooting MySQL online migration failure in DMS

added by DotNetKicks
10/17/2018 12:42:53 PM

1 Kicks, 909 Views

Overview While performing an online migration of a MySQL database using the Azure Database Migration Service (DMS), a few of our customers have encountered a similar error message: "'load data local infile "R:\\repldata\\tasks\\fd954e8d-5a57-48e0-93f8-af811246c0f8\\data_files\\1\\LOAD00000277.csv" into table ...;'","RetCode: SQL_ERROR SqlState: HY000 NativeError: 1213 Message: [MySQL][ODBC 5.3(w) Driver][mysqld-]Deadlock found when trying to get lock; try restarting transaction","Failed to...