Workbench throws error in Data migration with online transfer option

[kamesh bogg]

Dear Team,

I am facing following issue when database migration happening from SQL server to MySQL with large sets of data .

Error:


19:01:55 [INF][ copytable]: Re-enabling triggers for schema 'test'

19:01:55 [ERR][ copytable]: Exception: Querying Trigger Definitions: Lost connection to MySQL server during query
ERROOR: Copy helper exited with an error: Worker exited with status.



All the tables data copied successfully to Mysql. Not able to finish tool getting hanged and not able to get the report summary for the migration.

Kindly help on how to solve this issue.

I tried with 1.5 ,8 GB of database size ,In both the scenarios I am facing the same issue.

I tried following settings .

increase the threads in online transfer to 10 threads still same issue.

I tried to update the connection-live time still the same issue.

Please help on the same how to proceed.

Thanks.