[ 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)