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)

Reply via email to