alibaba / alibaba/DataX

datax同步出现No operations allowed after connection closed

Open
#414 0 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

datax配置的是每天一个时间点同步,每次同步一个小时左右即可完成任务,下一次同步就报这个错误了,No operations allowed after connection closed,
mysql数据库服务设置的超时空闲连接为8小时,有办法可以不改动mysql空闲超时配置,改datax的哪里配置做到超时存活检测,自动重新连接来避免这个问题吗

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the scheduled DataX synchronization against MySQL with the server's eight-hour idle-connection timeout and capture when the connection closes. Inspect DataX's MySQL connection configuration and determine whether an idle-connection check or reconnect option exists; done means the next scheduled run succeeds without changing MySQL's timeout.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
backend, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.