alibaba / alibaba/DataX

频繁报:关闭的连接错误

Open
#393 1 comment 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

at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLRecoverableException: 关闭的连接
at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:3921)
at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doBatchInsert(CommonRdbmsWriter.java:361)
at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.startWriteWithConnection(CommonRdbmsWriter.java:291)

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the stack trace in com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task, especially doBatchInsert and startWriteWithConnection. Reproduce or inspect the Oracle JDBC closed-connection failure around rollback, then determine the cause and verify that the writer no longer reports this error during batch insertion.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, sql
Domain
database
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.