Odd quartz error in log.

[Nathan Keiter]

This pops up once in a while in 2.2.1, looks like bad SQL in the source code? Is there a fix for this?

Cause:
java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

Full output:

[26/06/13 13:40:11:213 EDT] ERROR quartz.DotJobStore: ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'NonTxDataSource.DotMarketingQuartzScheduler': java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'NonTxDataSource.DotMarketingQuartzScheduler': java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
[See nested exception: java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction
]
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3070)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3713)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3749)
Caused by: java.sql.SQLException: ORA-01453: SET TRANSACTION must be first statement of transaction

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
at oracle.jdbc.driver.PhysicalConnection.setTransactionIsolation(PhysicalConnection.java:3971)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:340)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setTransactionIsolation(PoolingDataSource.java:332)
at com.dotmarketing.quartz.DotJobStore$2.getConnection(DotJobStore.java:77)
at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:164)
... 3 more


Nathan

Nathan I. Keiter
Lead Network Applications Programmer
DataSystems
Gettysburg College
Campus Box 2453
717-337-6993

Measure your success by the level of service you provide.
Si hoc legere scis nimium eruditionis habes.

[Jason Tesser]

the had to do with Quartz transaction management. It should be ok and just be noise but we did address in in 2.3. 

--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com.
To post to this group, send email to dot...@googlegroups.com.
Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/groups/opt_out.

[Nathan Keiter]

Ok, thanks. We won't worry about it then. =-)

Nathan

Nathan I. Keiter
Lead Network Applications Programmer
DataSystems
Gettysburg College
Campus Box 2453
717-337-6993

Measure your success by the level of service you provide.
Si hoc legere scis nimium eruditionis habes.

From: Jason Tesser <jason...@gmail.com<mailto:jason...@gmail.com>>
Reply-To: "dot...@googlegroups.com<mailto:dot...@googlegroups.com>" <dot...@googlegroups.com<mailto:dot...@googlegroups.com>>
Date: Wednesday, June 26, 2013 1:44 PM
To: "dot...@googlegroups.com<mailto:dot...@googlegroups.com>" <dot...@googlegroups.com<mailto:dot...@googlegroups.com>>
Subject: Re: [dotcms] Odd quartz error in log.

the had to do with Quartz transaction management. It should be ok and just be noise but we did address in in 2.3.

To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms%2Bunsu...@googlegroups.com>.
To post to this group, send email to dot...@googlegroups.com<mailto:dot...@googlegroups.com>.

Visit this group at http://groups.google.com/group/dotcms.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.

To unsubscribe from this group and stop receiving emails from it, send an email to dotcms+un...@googlegroups.com<mailto:dotcms+un...@googlegroups.com>.
To post to this group, send email to dot...@googlegroups.com<mailto:dot...@googlegroups.com>.