mysql_reader报错,超时timeout
- 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