DataX同步到Hologres执行postSql时报连接数据库失败
- Dominant language
- Java
- Stars
- 17.4k
- Forks
- 5.7k
- PR merge metrics
- No merged PRs in 30d
Description
各位大佬好:
我在用DataX同步数据(SqlServer)到Hologres时, 数据同步完成后, DataX执行postSql时报连接数据库失败.
可以确定3点:
1.源库读正常
2.目标库写正常
3.目标库写入数据已完成(同步脚本preSql有truncate目标表, 并验证数据同步完成)
工作中用DataX同步数据比较多, 在MySQL和SqlServer互同步时执行postSql正常的, 所以猜测可能是Hologres数据库的连接关闭后, 再次获取和其他数据库有点不一样.
附件有DataX同步的完整日志, 盼大佬回复! 感谢!
[datax-sync.log](https://github.com/alibaba/DataX/files/10223620/datax-sync.log)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the attached datax-sync.log and trace the postSql execution path for the Hologres target after data writing completes. Compare its connection lifecycle with the reported successful MySQL and SQL Server cases, then confirm the failure can be reproduced and that postSql completes without regressing source reads or target writes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100