[
https://issues.apache.org/jira/browse/NIFI-12564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Matt Burgess updated NIFI-12564:
--------------------------------
Summary: Processor 'ExecuteSQL' error, when uses unsigned mediumint in
mysql (was: Processor 'ExecuteSQL' error, when uses unsigned mdeiumint in
mysql)
> Processor 'ExecuteSQL' error, when uses unsigned mediumint in mysql
> -------------------------------------------------------------------
>
> Key: NIFI-12564
> URL: https://issues.apache.org/jira/browse/NIFI-12564
> Project: Apache NiFi
> Issue Type: Bug
> Reporter: duhee
> Priority: Major
>
> * Nifi Version : NiFi 1.13.2
> * Processor : ExecuteSQL
> * Table schema
> {code:java}
> CREATE TABLE `nifi_test` (
> `clm1` varchar(15) NOT NULL DEFAULT '',
> `clm2` varchar(10) NOT NULL DEFAULT '',
> `clm3` varchar(12) NOT NULL DEFAULT '',
> `clm4` varchar(20) NOT NULL DEFAULT '',
> `clm5` mediumint(20) unsigned DEFAULT '1',
> PRIMARY KEY (`clm1`,`clm2`,`clm3`,`clm4`)
> );
> insert into nifi_test values ('1','2','3','4',1), ('11','12','13','14',100),
> ('21','22','23','24',0); {code}
> * Error Message
> {code:java}
> at
> org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:95)
> 2024-01-04 10:55:09,064 ERROR [Timer-Driven Process Thread-91]
> o.a.nifi.processors.standard.ExecuteSQL
> ExecuteSQL[id=ce977968-018c-1000-e472-2fba6455ce07] Unable to execute SQL
> select query [SELECT * FROM nifi_test WHERE 1=1 LIMIT 100000] for
> StandardFlowFileRecord[uuid=050b1e1c-85a4-440c-9dc4-27404cf1445d,claim=StandardContentClaim
> [resourceClaim=StandardResourceClaim[id=1704333306508-74869,
> container=default, section=117], offset=0,
> length=46],offset=0,name=72fd1391-d014-4329-927b-fd037587ddbc,size=46]
> routing to failure
> org.apache.nifi.processor.exception.ProcessException:
> java.lang.RuntimeException: Unable to resolve union for value 1 with type
> java.lang.Integer while appending record {"clm1": "1", "clm2": "2", "clm3":
> "3", "clm4": "4","clm5": 1}
> at
> org.apache.nifi.processors.standard.AbstractExecuteSQL.lambda$onTrigger$4(AbstractExecuteSQL.java:336)
> at
> org.apache.nifi.controller.repository.StandardProcessSession.write(StandardProcessSession.java:3129)
> at
> org.apache.nifi.processors.standard.AbstractExecuteSQL.onTrigger(AbstractExecuteSQL.java:332)
> at
> org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:27)
> at
> org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1361)
> at
> org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:247)
> at
> org.apache.nifi.controller.scheduling.AbstractTimeBasedSchedulingAgent.lambda$doScheduleOnce$0(AbstractTimeBasedSchedulingAgent.java:59)
> at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
> 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:750)
> Caused by: java.lang.RuntimeException: Unable to resolve union for value 1
> with type java.lang.Integer while appending record {"clm1": "1", "clm2": "2",
> "clm3": "3", "clm4": "4", "clm5": 1}
> at
> org.apache.nifi.util.db.JdbcCommon.convertToAvroStream(JdbcCommon.java:456)
> at
> org.apache.nifi.processors.standard.sql.DefaultAvroSqlWriter.writeResultSet(DefaultAvroSqlWriter.java:49)
> at
> org.apache.nifi.processors.standard.AbstractExecuteSQL.lambda$onTrigger$4(AbstractExecuteSQL.java:334)
> ... 14 common frames omitted
> Caused by: org.apache.avro.file.DataFileWriter$AppendWriteException:
> org.apache.avro.UnresolvedUnionException:Not in union ["null","long"]: 1
> (field=clm5)
> at org.apache.avro.file.DataFileWriter.append(DataFileWriter.java:317)
> at
> org.apache.nifi.util.db.JdbcCommon.convertToAvroStream(JdbcCommon.java:448)
> ... 16 common frames omitted
> Caused by: org.apache.avro.UnresolvedUnionException: Not in union
> ["null","long"]: 1 (field=clm5)
> at
> org.apache.avro.generic.GenericDatumWriter.writeField(GenericDatumWriter.java:247)
> at
> org.apache.avro.generic.GenericDatumWriter.writeRecord(GenericDatumWriter.java:234)
> at
> org.apache.avro.generic.GenericDatumWriter.writeWithoutConversion(GenericDatumWriter.java:145)
> at
> org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:95)
> at
> org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:82)
> at org.apache.avro.file.DataFileWriter.append(DataFileWriter.java:314)
> ... 17 common frames omitted
> Suppressed: org.apache.avro.UnresolvedUnionException: Not in union
> ["null","long"]: 1
> at
> org.apache.avro.generic.GenericData.resolveUnion(GenericData.java:908)
> at
> org.apache.avro.generic.GenericDatumWriter.resolveUnion(GenericDatumWriter.java:307)
> at
> org.apache.avro.generic.GenericDatumWriter.writeWithoutConversion(GenericDatumWriter.java:157)
> at
> org.apache.avro.generic.GenericDatumWriter.write(GenericDatumWriter.java:95)
> at
> org.apache.avro.generic.GenericDatumWriter.writeField(GenericDatumWriter.java:245)
> ... 22 common frames omitted {code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
