alibaba / alibaba/DataX

mysql_reader报错,超时timeout

Open
#992 6 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

具体错误信息为:java.sql.SQLException: [32005, 2021040919565301001603002603151283989] : Query exceeded maximum time limit of 7200000.00ms
at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:26)
at com.alibaba.datax.plugin.rdbms.util.RdbmsException.asQueryException(RdbmsException.java:81)
at com.alibaba.datax.plugin.rdbms.reader.CommonRdbmsReader$Task.startRead(CommonRdbmsReader.java:220)
at com.alibaba.datax.plugin.reader.mysqlreader.MysqlReader$Task.startRead(MysqlReader.java:81)
at com.alibaba.datax.core.taskgroup.runner.ReaderRunner.run(ReaderRunner.java:57)
at java.lang.Thread.run(Thread.java:748)

应该设置哪里?或者配置mysq哪个参数?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the stack-trace entry points in plugin/reader/mysqlreader/MysqlReader.java, plugin/rdbms/reader/CommonRdbmsReader.java, and plugin/rdbms/util/RdbmsException.java. Trace how the MySQL reader constructs and executes the query, then identify whether the 7200000 ms limit comes from DataX or MySQL. Done means documenting the responsible setting and a confirmed configuration or workaround.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
data-engineering, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.