alibaba / alibaba/DataX

oceanbasev10writer导入blob类型报错{"exception":"ORA-01465: invalid hex number","record":

Open
#999 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

2021-04-25 01:27:39.533 [0-insertTask-26] WARN InsertTask - Insert fatal error SqlState =HY000, errorCode = 1465, java.sql.BatchUpdateException: ORA-01465: invalid hex number
2021-04-25 01:27:39.580 [0-insertTask-24] ERROR StdoutPluginCollector -
java.sql.SQLException: ORA-01465: invalid hex number
at com.alipay.oceanbase.jdbc.SQLError.createSQLException(SQLError.java:1207) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4874) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4799) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.MysqlIO.sendCommand(MysqlIO.java:2993) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:3159) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2981) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1939) ~[oceanbase-client-1.1.4.jar:na]
at com.alipay.oceanbase.jdbc.PreparedStatement.execute(PreparedStatement.java:1230) ~[oceanbase-client-1.1.4.jar:na]
at com.alibaba.datax.plugin.rdbms.writer.CommonRdbmsWriter$Task.doOneInsert(CommonRdbmsWriter.java:435) ~[plugin-rdbms-util-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.InsertTask.doMultiInsert(InsertTask.java:200) [oceanbasev10writer-0.0.1-SNAPSHOT.jar:na]
at com.alibaba.datax.plugin.writer.oceanbasev10writer.task.InsertTask.run(InsertTask.java:98) [oceanbasev10writer-0.0.1-SNAPSHOT.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_262]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_262]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_262]

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by tracing the insert path through plugin-writer-oceanbasev10writer/.../InsertTask.java and plugin-rdbms-util/.../CommonRdbmsWriter.java, then reproduce the reported BLOB import failure against OceanBase. Done means the BLOB record imports without the ORA-01465 invalid-hex-number error.

Written by the indexing model from the issue text.

Assessment

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