Loading...

Details

Type: Bug
Resolution: Duplicate
Priority: Major
Fix Version/s: None
Affects Version/s: 1.7.2.Final
Component/s: None
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False
Steps to Reproduce:
Hide

1. run a debezium task, this task monitors table.include.list: tablea,tableb,tablec. this task would be running fine.
2. when the above task is running well, add another table test_001 into it.
3. update the table test_001 , and the exception occurs.

create table test_001(id varchar2(32), status integer, state number); insert into test_001 values ('1234', 3330,3333); update test_001 set state = 6666 where id = '1234';
Show
1. run a debezium task, this task monitors table.include.list: tablea,tableb,tablec. this task would be running fine. 2. when the above task is running well, add another table test_001 into it. 3. update the table test_001 , and the exception occurs. create table test_001(id varchar2 (32), status integer , state number ); insert into test_001 values ( '1234' , 3330,3333); update test_001 set state = 6666 where id = '1234' ;

SFDC Cases Counter:
SFDC Cases Links:

Description

[2022-04-20 10:12:30,407] ERROR Failed to properly convert data value for 'ORCL.TESTTABLE.COL.XH' of type NUMBER for row [060220221002002013, 3269, null, null, null, null, null, null, null, 0, 436186, 0, null, null, TO_DATE('2022-04-20 10:07:10', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null, null, null, null, null, 09_ZX0019-1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, 0, null, null, null, null, null, null, null, null, null, null, 0, 09_05080-5, null, null, null, null, null, null, 0, null, 0, 0, null, null, null, null, null, null, null, null, null, null, null, 5cf7b9eddb454feabeebb4f48205a023, null, null, null, null, 2, 0, 0, 0, null, null, null, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: (io.debezium.relational.TableSchemaBuilder:269)
java.lang.NumberFormatException: Value out of range. Value:"3269" Radix:10
	at java.lang.Byte.parseByte(Byte.java:151)
	at java.lang.Byte.parseByte(Byte.java:175)
	at io.debezium.connector.oracle.OracleValueConverters.lambda$convertTinyInt$14(OracleValueConverters.java:529)
	at io.debezium.jdbc.JdbcValueConverters.convertValue(JdbcValueConverters.java:1297)
	at io.debezium.connector.oracle.OracleValueConverters.convertTinyInt(OracleValueConverters.java:517)
	at io.debezium.connector.oracle.OracleValueConverters.convertNumericAsTinyInt(OracleValueConverters.java:445)
	at io.debezium.connector.oracle.OracleValueConverters.lambda$getNumericConverter$8(OracleValueConverters.java:237)
	at io.debezium.relational.TableSchemaBuilder.lambda$createValueGenerator$5(TableSchemaBuilder.java:264)
	at io.debezium.relational.TableSchema.valueFromColumnData(TableSchema.java:141)
	at io.debezium.relational.RelationalChangeRecordEmitter.emitUpdateRecord(RelationalChangeRecordEmitter.java:101)
	at io.debezium.relational.RelationalChangeRecordEmitter.emitChangeRecords(RelationalChangeRecordEmitter.java:52)
	at io.debezium.pipeline.EventDispatcher.dispatchDataChangeEvent(EventDispatcher.java:218)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor$1.accept(MemoryLogMinerEventProcessor.java:278)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor$1.accept(MemoryLogMinerEventProcessor.java:258)
	at io.debezium.connector.oracle.logminer.processor.TransactionCommitConsumer.dispatchChangeEvent(TransactionCommitConsumer.java:144)
	at io.debezium.connector.oracle.logminer.processor.TransactionCommitConsumer.accept(TransactionCommitConsumer.java:133)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.handleCommit(MemoryLogMinerEventProcessor.java:299)
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processRow(AbstractLogMinerEventProcessor.java:200)
	at io.debezium.connector.oracle.logminer.processor.AbstractLogMinerEventProcessor.processResults(AbstractLogMinerEventProcessor.java:178)
	at io.debezium.connector.oracle.logminer.processor.memory.MemoryLogMinerEventProcessor.process(MemoryLogMinerEventProcessor.java:134)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:173)
	at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:58)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:166)
	at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:127)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)

For bug reports, provide this information, please:

What Debezium connector do you use and what version?

1.7.2.Final & oracle 11g

Attachments

Issue Links

duplicates

DBZ-4240 Oracle connector parses NUMBER(*,0) as NUMBER(0,0) in DDL

Closed

Failed to properly convert data value for type NUMBER

Details

Description

What Debezium connector do you use and what version?

Attachments

Issue Links

Activity

People

Dates