Hi Prasad,
thanks for your fast response! I use a lot of JDBC-Queries, so your assumption is right. Here is the jstack output regarding the scheduler:
"DefaultQuartzScheduler_QuartzSchedulerThread" #32 prio=5 os_prio=31 tid=0x00007ffee8cd1000 nid=0x7403 in Object.wait() [0x0000700002502000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at org.quartz.simpl.SimpleThreadPool.blockForAvailableThreads(SimpleThreadPool.java:452)
- locked <0x0000000780420438> (a java.lang.Object)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)
"DefaultQuartzScheduler_Worker-10" #31 prio=5 os_prio=31 tid=0x00007ffee9dee800 nid=0x7203 waiting on condition [0x00007000023ff000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x0000000780234e60> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-9" #30 prio=5 os_prio=31 tid=0x00007ffee8cce000 nid=0x7003 waiting on condition [0x00007000022fc000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x000000078023cbc0> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-8" #29 prio=5 os_prio=31 tid=0x00007ffee91e5000 nid=0x6e03 waiting on condition [0x00007000021f9000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x00000007802441b8> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-7" #28 prio=5 os_prio=31 tid=0x00007ffee91e4000 nid=0x6c03 waiting on condition [0x00007000020f6000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x0000000780235000> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-6" #27 prio=5 os_prio=31 tid=0x00007ffee9dfc800 nid=0x6a03 waiting on condition [0x0000700001ff3000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x00000007802351a0> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-5" #26 prio=5 os_prio=31 tid=0x00007ffee92f4800 nid=0x6803 waiting on condition [0x0000700001ef0000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x0000000780244358> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-4" #25 prio=5 os_prio=31 tid=0x00007ffee92ef000 nid=0x6603 waiting on condition [0x0000700001ded000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x0000000780235340> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-3" #24 prio=5 os_prio=31 tid=0x00007ffee8ce7000 nid=0x6403 waiting on condition [0x0000700001cea000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x00000007802444f8> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-2" #23 prio=5 os_prio=31 tid=0x00007ffee8cee800 nid=0x6203 waiting on condition [0x0000700001be7000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x0000000780235548> (a java.lang.Object)
"DefaultQuartzScheduler_Worker-1" #22 prio=5 os_prio=31 tid=0x00007ffee8c69000 nid=0x6003 waiting on condition [0x0000700001ae4000]
java.lang.Thread.State: TIMED_WAITING (sleeping)
at java.lang.Thread.sleep(Native Method)
at org.apache.zeppelin.notebook.Notebook$CronJob.execute(Notebook.java:645)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
- locked <0x000000078023cd60> (a java.lang.Object)
Can I do anything in my code to close the jdbc connection? I use the normal spark module to query the jdbc data.
Best,
Florian
On 2016-11-09 21:12 (+0100), Prasad Wagle <p...@gmail.com> wrote:
> Hi Florian,>
>
> We have seen this behavior when the 10 quartz scheduler worker threads are>
> waiting for some note paragraph to complete at this statement>
> <https://github.com/apache/zeppelin/blob/v0.6.2/zeppelin-zengine/src/main/java/org/apache/zeppelin/notebook/Notebook.java#L645>.>
> You can see what the quartz scheduler worker threads are doing in the>
> jstack output of the ZeppelinServer process (look for>
> DefaultQuartzScheduler_Worker). Can you post that part of the jstack>
> output?>
>
> In some cases where the paragraphs generate JDBC queries, I have managed to>
> unblock threads by killing the queries in the database.>
>
> Regards,>
> Prasad>
>
>
>
> On Wed, Nov 9, 2016 at 1:41 AM, Florian Schulz <fl...@web.de> wrote:>
>
> > Hi,>
> >>
> > I have a problem with the scheduler. I have a notebook and I execute the>
> > spark code in it every minute (with the cron scheduler). The scheduler>
> > starts ten times and then it stops and do nothing anymore (in no notebook>
> > at all). I use version 0.6.2 of Apache Zeppelin. Do you have any idea, why>
> > this happens? I can reproduce this without a problem, but I can't find>
> > anything in the logs. Hope you can help me.>
> >>
> >>
> > Best regards>
> > Florian>
> >>
>