By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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.

Topics
Database
Tags
MySQL
Language
English
Filipe Santos
asked 3 months ago155 views
2 Answers
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
EXPERT
Didier_Durand
answered 3 months ago
  • Filipe Santos
    3 months ago

    I made the changes but exactly 5m45s the process restarts

0

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

Filipe Santos
answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content