https://community.cloudera.com/t5/Support-Questions/QueryRecord-returns-quot-Cannot-commit-session-while-reading/m-p/363403#M238971 <P>I am using QueryRecord to translate data from one format to another, but once in a while, I am getting this error here. Not sure what to do about and how to handle it. I am using Nifi 1.19.1<BR /><BR /><SPAN>[Timer-Driven Process Thread-15] o.a.n.c.r.StandardProcessSession Failed to asynchronously commit session StandardProcessSession[id=25336651] for QueryRecord[id=dba21f2d-ea2b-327b-3692-5eefbb53cd52] java.lang.IllegalStateException: Cannot commit session while reading from FlowFile at org.apache.nifi.controller.repository.StandardProcessSession.validateCommitState(StandardProcessSession.java:245) at org.apache.nifi.controller.repository.StandardProcessSession.checkpoint(StandardProcessSession.java:274) at org.apache.nifi.controller.repository.StandardProcessSession.commit(StandardProcessSession.java:556) at org.apache.nifi.controller.repository.StandardProcessSession.commitAsync(StandardProcessSession.java:510) at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:28) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1356) at org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:246) at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:102) at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source)</SPAN></P> Wed, 08 Feb 2023 13:57:10 GMT Poul 2023-02-08T13:57:10Z https://community.cloudera.com/t5/Support-Questions/QueryRecord-returns-quot-Cannot-commit-session-while-reading/m-p/363403#M238971 <P>I am using QueryRecord to translate data from one format to another, but once in a while, I am getting this error here. Not sure what to do about and how to handle it. I am using Nifi 1.19.1<BR /><BR /><SPAN>[Timer-Driven Process Thread-15] o.a.n.c.r.StandardProcessSession Failed to asynchronously commit session StandardProcessSession[id=25336651] for QueryRecord[id=dba21f2d-ea2b-327b-3692-5eefbb53cd52] java.lang.IllegalStateException: Cannot commit session while reading from FlowFile at org.apache.nifi.controller.repository.StandardProcessSession.validateCommitState(StandardProcessSession.java:245) at org.apache.nifi.controller.repository.StandardProcessSession.checkpoint(StandardProcessSession.java:274) at org.apache.nifi.controller.repository.StandardProcessSession.commit(StandardProcessSession.java:556) at org.apache.nifi.controller.repository.StandardProcessSession.commitAsync(StandardProcessSession.java:510) at org.apache.nifi.processor.AbstractProcessor.onTrigger(AbstractProcessor.java:28) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1356) at org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:246) at org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:102) at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source)</SPAN></P> Wed, 08 Feb 2023 13:57:10 GMT https://community.cloudera.com/t5/Support-Questions/QueryRecord-returns-quot-Cannot-commit-session-while-reading/m-p/363403#M238971 Poul 2023-02-08T13:57:10Z https://community.cloudera.com/t5/Support-Questions/QueryRecord-returns-quot-Cannot-commit-session-while-reading/m-p/368993#M240326 <P>This is most likely linked to issue nifi.11106</P> Thu, 20 Apr 2023 08:44:46 GMT https://community.cloudera.com/t5/Support-Questions/QueryRecord-returns-quot-Cannot-commit-session-while-reading/m-p/368993#M240326 Poul 2023-04-20T08:44:46Z