java - Database error recovering from misfires Qualtz -


i configured quartz use scheduled jobs database. when start scheduler with:

try {              // grab scheduler instance factory              scheduler scheduler = stdschedulerfactory.getdefaultscheduler();                // , start off              scheduler.start();               scheduler.shutdown();           } catch (exception se) {              log.log(loglevel.error, se.getmessage());          }

the config file of project looks like:

org.quartz.scheduler.instancename = databasescheduler org.quartz.scheduler.skipupdatecheck = true org.quartz.threadpool.threadcount = 3  org.quartz.jobstore.class = org.quartz.impl.jdbcjobstore.jobstoretx org.quartz.jobstore.driverdelegateclass = org.quartz.impl.jdbcjobstore.mssqldelegate org.quartz.datasource.mydb.driver = com.microsoft.sqlserver.jdbc.sqlserverdriver org.quartz.datasource.mydb.url = jdbc:sqlserver://server:1433;databasename=schedules org.quartz.datasource.mydb.user = sa      org.quartz.datasource.mydb.password = password org.quartz.datasource.mydb.maxconnections = 2  org.quartz.jobstore.tableprefix = qrtz_ org.quartz.jobstore.datasource = mydb org.quartz.scheduler.misfirepolicy =  donothing

the error got is:

org.quartz.jobpersistenceexception: database error recovering misfires. [see nested exception: java.sql.sqlexception: sqlexception provoked following failure: java.lang.interruptedexception]     @ org.quartz.impl.jdbcjobstore.jobstoresupport.dorecovermisfires(jobstoresupport.java:3213)     @ org.quartz.impl.jdbcjobstore.jobstoresupport$misfirehandler.manage(jobstoresupport.java:3951)     @ org.quartz.impl.jdbcjobstore.jobstoresupport$misfirehandler.run(jobstoresupport.java:3972) caused by: java.sql.sqlexception: sqlexception provoked following failure: java.lang.interruptedexception     @ com.mchange.v2.sql.sqlutils.tosqlexception(sqlutils.java:106)     @ com.mchange.v2.sql.sqlutils.tosqlexception(sqlutils.java:65)     @ com.mchange.v2.sql.sqlutils.tosqlexception(sqlutils.java:62)     @ com.mchange.v2.c3p0.stmt.googoostatementcache.acquirestatement(googoostatementcache.java:562)     @ com.mchange.v2.c3p0.stmt.googoostatementcache.checkoutstatement(googoostatementcache.java:168)     @ com.mchange.v2.c3p0.impl.newpooledconnection.checkoutstatement(newpooledconnection.java:234)     @ com.mchange.v2.c3p0.impl.newproxyconnection.preparestatement(newproxyconnection.java:199)     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:62)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:498)     @ org.quartz.impl.jdbcjobstore.attributerestoringconnectioninvocationhandler.invoke(attributerestoringconnectioninvocationhandler.java:73)     @ com.sun.proxy.$proxy3.preparestatement(unknown source)     @ org.quartz.impl.jdbcjobstore.stdjdbcdelegate.countmisfiredtriggersinstate(stdjdbcdelegate.java:390)     @ org.quartz.impl.jdbcjobstore.jobstoresupport.dorecovermisfires(jobstoresupport.java:3192)     ... 2 more

can me error? have looked @ stackoverflow post. without luck. i'm using quartz 2.2.3. when database tables empty got error.

found issue. in source code scheduler start , close scheduler. in time nothing can scheduled , start of scheduler not finished before close has been called. removing close call worked correctly.


-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more