使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

DMS restarting a full load table

0

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.

主题
数据库
标签
MySQL
语言
English
Filipe Santos
已提问 4 个月前167 查看次数
2 回答
0

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

profile pictureAWS
专家
Didier_Durand
已回答 4 个月前
  • Filipe Santos
    4 个月前

    I made the changes but exactly 5m45s the process restarts

0

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

Filipe Santos
已回答 4 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容