Database Error Recovering From Misfires
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Quartz Error Misfire Handling and Failure on Job Recovery up vote 1 down vote favorite I'm new to JSP and Quartz Scheduling! In this project, I'm trying to make the quartz scheduler continue functioning in case the server is turned off then on ignoring the missed jobs. For this, I researched JobPersistence and I have modified the quartz.properties file as the following: org.quartz.threadPool.threadCount=5 org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX org.quartz.jobStore.tablePrefix = QRTZ_ org.quartz.jobStore.useProperties = true org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate org.quartz.jobStore.dataSource = myDB org.quartz.dataSource.myDB.driver = com.mysql.jdbc.Driver org.quartz.dataSource.myDB.URL = jdbc:mysql://localhost:3306/contacts org.quartz.dataSource.myDB.user = root org.quartz.dataSource.myDB.password = root the web.xml file contains the following: ...
Support Search GitHub This repository Watch 195 Star 1,473 Fork 503 quartznet/quartznet Code Issues 72 Pull requests 9 Projects 1 Pulse Graphs New issue Quartz job recovery periodically fails in clustered environment #67 Closed eugentorica opened this Issue Sep 21, 2012 · 39 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 8 participants eugentorica commented Sep 21, 2012 http://stackoverflow.com/questions/31423003/quartz-error-misfire-handling-and-failure-on-job-recovery Using Quartz 2.0.1 SqlSever with mirroring. quartz.jobStore.type = "Quartz.Impl.AdoJobStore.JobStoreTX, Quartz"; quartz.jobStore.clustered = "true"; quartz.jobStore.lockHandler.type = "Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz"; Sometimes one sql server instance fails and I find in log error of this kind: [ERROR] Quartz.Core.QuartzSchedulerThread - Runtime error occurred in main trigger firing loop. System.ArgumentNullException: Connnection-transaction pair cannot be null Parameter name: cth https://github.com/quartznet/quartznet/issues/67 at Quartz.Impl.AdoJobStore.JobStoreSupport.RollbackConnection(ConnectionAndTransactionHolder cth) in c:\Work\OpenSource\quartznet\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 3300 at Quartz.Impl.AdoJobStore.JobStoreSupport.ExecuteInNonManagedTXLock(String lockName, Func2 txCallback) in c:\Work\OpenSource\quartznet\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 3463
at Quartz.Impl.AdoJobStore.JobStoreSupport.TriggersFired(IList1 triggers) in c:\Work\OpenSource\quartznet\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 2550 at Quartz.Core.QuartzSchedulerThread.Run() in c:\Work\OpenSource\quartznet\src\Quartz\Core\QuartzSchedulerThread.cs:line 369 DateTime=2012-09-18T19:27:29.0470000Z After this message I assume job gets blocked and in logs with certain periodicity appears the following message: Quartz.Impl.AdoJobStore.JobStoreTX - Handling 1 trigger(s) that missed their scheduled fire-time. I suppose that this is an attempt to handle blocked job but for now I have to wait when job gets blocked and see the dump. Other jobs (about 25) works as expected. By blocked I mean that job is not fired. Blocked trigger has state ACQUIRED in table TRIGGERS . This trigger also appears in FIRED_TRIGGERS table with state ACQUIRED. Interestingly value of NEXT_FIRE_TIME field in TRIGGERS table for this trigger is constantly increasing although job is not called. Service is stopping normally so I assume no job thread gets blocked in this scenario however restarting ser
Search Forums Home » Liferay Portal » English » 1. Installation / Deployment / Setup Recent Posts Statistics https://web.liferay.com/community/forums/-/message_boards/message/23650439 RSS (Opens New Window) Answer (Unmark) Mark as an http://quartz.10975.n7.nabble.com/Configure-Quartz-to-recover-from-database-outages-td8261.html Answer Threads [ Previous | Next ] Errors occur while using MySQL as default database Sohil Ladhani April 12, 2013 11:40 PM RE: Errors occur while using MySQL as default database David H Nebinger April 13, 2013 database error 6:07 AM RE: Errors occur while using MySQL as default database Sohil Ladhani April 13, 2013 6:12 AM RE: Errors occur while using MySQL as default database Dayanand Chowdhary July 19, 2013 4:48 AM RE: Errors occur while using MySQL as default database David H Nebinger July database error recovering 22, 2013 5:05 AM Errors occur while using MySQL as default database April 12, 2013 11:40 PM Answer Sohil Ladhani Rank: New Member Posts: 6 Join Date: November 16, 2012 Recent Posts I'm using Liferay v6.1 CE. I switched from Liferay's HSQL to MySQL v5.1.23 by following the instructions on this page and other similar pages which have same instructions. But when I start the server, I get following errors in the browser, which I think are related to Tomcat. I have Apache Tomcat 7.0.23 btw.HTTP Status 500 -type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionorg.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 5754: }55: }56: else {57: redirect = PortalUtil.getHomeURL(request);58: }59: 60: if (!request.isRequestedSessionIdFromCookie()) {Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:568) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:72) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:121) com.liferay.portal.servlet.filters.sso.ntlm.NtlmPostFilter.processFilter(NtlmPostFilter.java:83) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:48) com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:203) com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(I
threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Configure Quartz to recover from database outages? Hi, Is it possible to configure Quartz to recover from db outrage? We are using MySQL, and when I purposely stop/start MySQL service, the other components of our application using C3P0 connection pool recover nicely, but Quartz refuses to come back... 18 Aug 2008 09:21:37,350 [QuartzScheduler_QuartzScheduler-NON_CLUSTERED_MisfireHandler] ERROR JobStoreSupport$MisfireHandler : MisfireHandler: Error handling misfires: Database error recovering from misfires. org.quartz.JobPersistenceException: Database error recovering from misfires. [See nested exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Our quartz configuration uses org.quartz.impl.jdbcjobstore.JobStoreTX and org.quartz.impl.jdbcjobstore.StdJDBCDelegate Thanks!! --------------------------------------------------------------------- Posted via Jive Forums http://forums.opensymphony.com/thread.jspa?threadID=427265&messageID=515226#515226--------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] popianovka Reply | Threaded Open this post in threaded view ♦ ♦ | Report Content as Inappropriate ♦ ♦ Re: Configure Quartz to recover from database outages? Give org.quartz.dataSource.NAME.validationQuery a shot. See: http://www.opensymphony.com/quartz/wikidocs/ConfigDataSources.html--------------------------------------------------------------------- Posted via Jive Forums http://forums.opensymphony.com/thread.jspa?threadID=427265&messageID=515305#515305--------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] « Return to Quartz Users | 1 view|%1 views Loading... Free forum by Nabble Edit this page