oceanbasev10writer导入blob类型报错{"exception":"ORA-01465: invalid hex number","record":
- 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