Hi
I have a problem with CMS 6.5.3 used with a SqlServer database (on separate
server). Not a big one, just annoying.
The CMS is running fine, except that once in a while, after a long while of no
use, it appears to hang.
In log4j.log I find SQLexceptions with "Already closed" messages. See excerpt
below.
Seems a problem interacting with SQLserver or maybe a network thing?
Before I dig into this: anyone seen this before, solutions, suggestions?
Thanks, Reinier
Log4j.log:
2009-04-21 05:17:15,621 ERROR org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: Error managing cluster: Couldn't
close jdbc connection. Already closed.
org.quartz.JobPersistenceException: Couldn't close jdbc connection. Already closed. [See nested exception:
java.sql.SQLException: Already closed.]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2299)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1413)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2378)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2409)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Already closed.
at
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2297)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1413)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2378)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2409)
2009-04-21 05:17:29,681 ERROR org.quartz.core.ErrorLogger An error occured while scanning for the next
trigger to fire.
org.quartz.JobPersistenceException: Couldn't close jdbc connection. Already closed. [See nested exception:
java.sql.SQLException: Already closed.]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2299)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1228)
at
org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Already closed.
at
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
...
....
2009-04-21 05:17:56,195 ERROR org.quartz.impl.jdbcjobstore.JobStoreTX ClusterManager: Error managing cluster: Couldn't
close jdbc connection. Already closed.
org.quartz.JobPersistenceException: Couldn't close jdbc connection. Already closed. [See nested exception:
java.sql.SQLException: Already closed.]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.closeConnection(JobStoreSupport.java:2299)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.doCheckin(JobStoreTX.java:1413)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:2378)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:2409)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Already closed.
at
org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:77)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:180)
...
....
etc
--
Reinier van den Born
HintTech B.V.
T: +31(0)15 268 2573
F: +31(0)15 268 2567
M: +31(0)6 494 171 36
ATTENTION: WE HAVE MOVED!!
Delftechpark 37i | 2628 XH Delft | www.hinttech.com
HintTech is a specialist in eBusiness Technology ( .Net, Java platform, Tridion
) and IT-Projects.
Chamber of Commerce The Hague nr. 27242282 | Sales Tax nr. NL8062.16.396.B01
begin:vcard
fn:Reinier van den Born
n:van den Born;Reinier
org:HintTech B.V.
adr:;;Delfttechpark 37i ;Delft;;2628 XJ;Netherlands
email;internet:[email protected]
tel;work:+31-88-268 25 00
tel;fax:+31-88-268 25 01
tel;cell:+31-6 494 171 36
note;quoted-printable:KvK Den Haag nr. 27242282 | BTW nr. NL8062.16.396.B01=0D=0A=
=0D=0A=
HintTech levert specialisten op het gebied van softwareontwikkeling (.NET=
en Java), projectmanagement, informatiebeveiliging en business consulting=
.=0D=0A=
=0D=0A=
url:www.hinttech.com
version:2.1
end:vcard
********************************************
Hippocms-dev: Hippo CMS development public mailinglist
Searchable archives can be found at:
MarkMail: http://hippocms-dev.markmail.org
Nabble: http://www.nabble.com/Hippo-CMS-f26633.html
