[ https://issues.apache.org/jira/browse/NIFI-4174?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16083577#comment-16083577 ]
Jorge Machado commented on NIFI-4174: ------------------------------------- After some tests I found out that I don't have connection to the DB. This should throw an error like: Cannot connect to database instead of schedulers error. > 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)