DMS restarting a full load table

Question

Hi,
My plan is moving some schemas for individual RDS using Mysql8.0.35 to Mysql8.0.35
I have a specific table with large rows without lobs about 966765 rows.

2024-01-22T22:52:01 [SOURCE_UNLOAD   ]E:  RetCode: SQL_ERROR  SqlState: 08S01 NativeError: 2013 Message: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.35]Lost connection to MySQL server during query [1022502]  (ar_odbc_stmt.c:3498)

I have updated connect_timeout net_read_timeout net_write_timeout params.

Near to finish, full load process restarts generating a loop.

Answer

Hi, thank you for the respones, i will try it.

Answer

Hi,

Having increased the various timeout values is a good thing!

But, did you also set also database variable `max_allowed_packet` to a large enough value to hold your biggest lines?

Best

DIdier

DMS restarting a full load table

Relevanter Inhalt