Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

datax执行中抛出com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException异常,异常消息是query timeout #2262

Open
cyf-oss opened this issue Jan 7, 2025 · 0 comments

Comments

@cyf-oss
Copy link

cyf-oss commented Jan 7, 2025

image 报错的堆栈信息如上 【使用场景】mysqlreader向doriswriter迁移数据,单个job的数据量比较大,按分区进行迁移的,(已经拆分了很多,库是pb级别的),测试的job总计在十亿级别的数据,拆分后的task单次迁移的数据设置阈值在8千万以内,报错堆栈如下: ![image](https://github.com/user-attachments/assets/75cc0044-84e2-41ca-80eb-05e2c8112158) 【初步分析】 ![image](https://github.com/user-attachments/assets/19a99560-0dc5-4756-97e8-349f82ba521e) 查看源码,这块的异常sql状态码是42开头的,对应sql的queryTimeout未修改,是datax源码里的172800s, socketTime设置的600s(也设置过更高的,仍然会报这个错误),检查了很多超时的设置,就不知道为啥会抛出这错误了,很奇怪;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant