Jorge Machado created NIFI-4174:
-----------------------------------
Summary: GenerateTableFetch does not work with oracle on Nifi 1.2
Key: NIFI-4174
URL: https://issues.apache.org/jira/browse/NIFI-4174
Project: Apache NiFi
Issue Type: Bug
Affects Versions: 1.2.0
Reporter: Jorge Machado
Priority: Minor
I'm trying to extract some data from a oracle DB.
I'm getting :
{code:java}
2017-07-11 16:19:29,612 WARN [StandardProcessScheduler Thread-7]
o.a.n.controller.StandardProcessorNode Timed out while waiting for OnScheduled
of 'GenerateTableFetch' processor to finish. An attempt is made to cancel the
task via Thread.interrupt(). However it does not guarantee that the task will
be canceled since the code inside current OnScheduled operation may have been
written to ignore interrupts which may result in a runaway thread. This could
lead to more issues, eventually requiring NiFi to be restarted. This is usually
a bug in the target Processor
'GenerateTableFetch[id=f08a3acd-ac7e-17d7-598b-8f9720fd92d4]' that needs to be
documented, reported and eventually fixed.
2017-07-11 16:19:29,612 ERROR [StandardProcessScheduler Thread-7]
o.a.n.p.standard.GenerateTableFetch
GenerateTableFetch[id=f08a3acd-ac7e-17d7-598b-8f9720fd92d4]
GenerateTableFetch[id=f08a3acd-ac7e-17d7-598b-8f9720fd92d4] failed to invoke
@OnScheduled method due to java.lang.RuntimeException: Timed out while
executing one of processor's OnScheduled task.; processor will not be scheduled
to run for 30 seconds: java.lang.RuntimeException: Timed out while executing
one of processor's OnScheduled task.
java.lang.RuntimeException: Timed out while executing one of processor's
OnScheduled task.
at
org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1480)
at
org.apache.nifi.controller.StandardProcessorNode.access$000(StandardProcessorNode.java:102)
at
org.apache.nifi.controller.StandardProcessorNode$1.run(StandardProcessorNode.java:1303)
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:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.util.concurrent.TimeoutException: null
at java.util.concurrent.FutureTask.get(FutureTask.java:205)
at
org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1465)
... 9 common frames omitted
2017-07-11 16:19:29,613 ERROR [StandardProcessScheduler Thread-7]
o.a.n.controller.StandardProcessorNode Failed to invoke @OnScheduled method due
to java.lang.RuntimeException: Timed out while executing one of processor's
OnScheduled task.
java.lang.RuntimeException: Timed out while executing one of processor's
OnScheduled task.
at
org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1480)
at
org.apache.nifi.controller.StandardProcessorNode.access$000(StandardProcessorNode.java:102)
at
org.apache.nifi.controller.StandardProcessorNode$1.run(StandardProcessorNode.java:1303)
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:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.util.concurrent.TimeoutException: null
at java.util.concurrent.FutureTask.get(FutureTask.java:205)
at
org.apache.nifi.controller.StandardProcessorNode.invokeTaskAsCancelableFuture(StandardProcessorNode.java:1465)
... 9 common frames omitted
{code}
Database Connection Pooling Service:
jdbc:oracle:thin:@somehost:6779:someSID
oracle.jdbc.OracleDriver
/pathTo/ojdbc7.jar
max wait time 500mil
On the processor I have:
Max Wait Time 10 seconds
Partition Size 100
i tryed schedule 0s and 10 000s result is the same
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
