1. Grails Quartz plugin removing triggers on startup with persistence turned on stackoverflow.comI'm encountering the following problem: I've got a grails app, with the quartz plugin, and a persistent storage (Oracle). My job class has an empty triggers block like so: |
2. recommended properties for MySQL, SQL Server 2005/2008, Oracle 9i/10g forums.terracotta.org |
3. Quartz runing against clustered Oracle forums.terracotta.orgWill look for more information about the Oracle environment but we're running into issues running Quartz 1.6.0 against a clustered Oracle instance in our application: Code: 2009-12-03 16:50:11,488 WARN [AttributeRestoringConnectionInvocationHandler] : Failed restore connection's original auto commit setting. java.sql.SQLException: Closed Connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286) at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:1241) at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:268) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:293) at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.restoreOriginalAtributes(AttributeRestoringConnectionInvocationHandler.java:134) at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanupConnection(JobStoreSupport.java:3453) at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3090) at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713) ... |
4. Deadlock problem on Oracle when using many clustered servers forums.terracotta.orgHello, we are using Quartz 1.6.5 to schedule batch jobs (printing of reports, end-of-day jobs). The web server were using is WebLogic 10.0.3 and the database is Oracle 10.2.0. We have a clustered configuration with two physical servers each one having three logical servers (this means 6 quartz instances running); in this configuration we experience regularly a deadlock where all quartz ... |
5. how to instantiate quartz scheduler in oracle 10g server forums.terracotta.org |
6. quartz1.6.5 met oracle dead lock (RAM lock, no cluster) forums.terracotta.orgHi I'm using quartz1.6.5, met oracle dead lock. (very rare, only meet twice in 1 month stress run) dead lock is happen at this line org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2790) it looks like relative with the change for org.quartz.jobStore.acquireTriggersWithinLock property. (this property default changed to false after 1.6.3) after some search on oracle lock, it looks like relative with trigger table have foreign key reference ... |
7. Oracle Job Store Performance Problems forums.terracotta.orgHi We are having serious performance issues when using Quartz with the JDBCJobStore. The application exposes a web service and when receiving a web service request schedules a Quartz job to process the request asynchronously. The application runs in JBoss 4.0.3. There are two JBoss instances behind a load balancer configured to use an Oracle 10.2.0.4 database as the JobStore. Performance ... |
8. Source of quartz 1.6.1 tables for oracle forums.terracotta.org |
9. Quartz .net Oracle forums.terracotta.orgHi, I am trying to configure quartz.net to connect oracle. I had created the tables in a oracle schema named OPERA. I am using following config. quartz.jobStore.type = Quartz.Impl.AdoJobStore.JobStoreTX, Quartz quartz.jobStore.dataSource = default quartz.jobStore.tablePrefix = QRTZ_ quartz.jobStore.clustered = true quartz.jobStore.lockHandler.type = Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore, Quartz quartz.jobStore.driverDelegateType = Quartz.Impl.AdoJobStore.OracleDelegate, Quartz quartz.dataSource.default.connectionString = Data Source=XXX;User ID=XXX;Password=XXX quartz.dataSource.default.provider = OracleClient-20 quartz.jobStore.useProperties = true But it seems ... |
10. Quartz 1.8.3 support for Oracle 11 forums.terracotta.orgHi, I use quartz 1.8.3, for my project, with oracle 11g (CMT jobstore + OracleDelegate) and jboss 4.2.3.GA. The Oracle Drivers are to version 11.1.0.7.0. I replaced quartz 1.5.2 jboss embedded library with 1.8.3 version. With Oracle 10g all works fine since I followed this post https://jira.terracotta.org/jira/browse/QTZ-46?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel. Before I used the property "org.quartz.jobStore.dontSetAutoCommitFalse" setted to true and the triggers often remained ... |
11. Oracle orphaned session - Scheduler stuck at startup forums.terracotta.orgWe have seen several times the scheduler getting stuck at startup waiting for a DB connection. In those cases we found there was already an Oracle blocking session so Quartz would sit there waiting and waiting. After DBA killed the blocking session the app and quartz scheduler started just fine. We are running quartz-1.8.4 against Oracle 10g. Has anyone experienced a ... |
12. Deadlock on Oracle on query: SELECT * FROM QRTZ_LOCKS WHERE LOCK_NAME = :1 FOR UPDATE forums.terracotta.orgHello, We are using Quartz for several years with good results. Recently we configured it in cluster mode, with 2 application servers, and we get this database lock, that blocked the application. I've seen that the issue has already been reported, is there a solution? The version of Quartz is 1.5.1 Thank you Antonio Vivalda |
13. Quartz 2.0.2 with Oracle JDBCDataSource forums.terracotta.orgHello Guys, I am seeing some really strange behavior with my quartz installation. I have written my own scheduler application which uses Quartz in the background. So now this application runs fine (and the triggers get fired perfectly) when I run the application for the first time but it seems to be getting stuck in subsequent runs. I am using quartz ... |
14. DB Account lock issue with Oracle JDBC JobStoreCMT forums.terracotta.orgWe got Quartz 1.6.5 integrated with Spring 2.5 and Oracle JDBC jobstore. For most part its working fine, but once in a week we noticed that our Oracle user DB account is getting locked up. We are thinking this may be caused by Quartz jobs. I see following comment in Oracle db table script file. I did verify that we have ... |
15. Quartz 1.8.5, Oracle 11g, Oracle Spatial and JBOSS 5.1 forums.terracotta.orgGetting this error: --- Check the statement (update failed). --- Cause: java.sql.SQLException: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine ORA-29400: data cartridge error ORA-14450: attempt to access a transactional temp table already in use ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 720 ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 225 Basically, w/o Quartz, I don't get the error. With Quartz started, i get the error. ... |