alibaba / alibaba/DataX

DataX同步到Hologres执行postSql时报连接数据库失败

Open
#1,638 2 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同步数据(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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.