locked
SQLServerException: The connection is closed. RRS feed

  • Question

  • Hi,

    We are using  CA IDM 12.6sp5 deployed on Jboss EAP 6.3.3 which uses Microsoft SQl Server 2008 R2 SP2 as a store to save all the transactional information.

    Recently, we see a lot of errors related to the SQL Server Exception.

    com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

    We have also receive the following error on the DB Side.

    Source          spid74

    Message

    A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.

    We saw some cluster related errors. So we have restarted all the Servers in the cluster and also cleared the Journal files used in the Jboss Hornetq

    15:04:22,335 ERROR [org.quartz.impl.jdbcjobstore.JobStoreCMT] (QuartzScheduler_iam_imDefaultQuartzScheduler-NON_CLUSTERED_MisfireHandler) MisfireHandler: Error handling misfires: null: java.lang.reflect.UndeclaredThrowableException
    at com.sun.proxy.$Proxy69.rollback(Unknown Source)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.rollbackConnection(JobStoreSupport.java:3583) [quartz-all-1.7.3.jar:]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3133) [quartz-all-1.7.3.jar:]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3869) [quartz-all-1.7.3.jar:]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3889) [quartz-all-1.7.3.jar:]
    Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_71]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_71]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]
    at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_71]
    at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:71) [quartz-all-1.7.3.jar:]
    ... 5 more
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollback(SQLServerConnection.java:1954) [sqljdbc.jar:]
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:1117)
    at org.jboss.jca.adapters.jdbc.WrappedConnection.rollback(WrappedConnection.java:779)
    ... 10 more

    15:04:23,228 ERROR [ims.tmt.persistence] (Thread-2563 (HornetQ-client-global-threads-31915866)) PersistenceProvider: JMS:ID:dfabb8bb-9de6-11e5-b51b-b37c547b2cff: getLockedEvent: Exception loading event with id=8331d59b-53e4eac8-013747f2-197df0c4: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388) [sqljdbc.jar:]


     15:04:23,280 ERROR [ims.tmt.IMSMessageListener] (Thread-2563 (HornetQ-client-global-threads-31915866)) Locked Item Exception: Message with id ID:dfabb8bb-9de6-11e5-b51b-b37c547b2cff cannot get a lock on event 8331d59b-53e4eac8-013747f2-197df0c4. The connection is closed.: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:2166) [sqljdbc.jar:]15:04:23,358 WARN  [ims.tmt.IMSMessageListener] (Thread-2563 (HornetQ-client-global-threads-31915866)) Unable to end traction in null: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388) [sqljdbc.jar:]

    15:04:25,943 ERROR [ims.tmt.persistence] (Thread-2563 (HornetQ-client-global-threads-31915866)) PersistenceProvider: JMS:ID:dfabb8bb-9de6-11e5-b51b-b37c547b2cff: saveRuntimeStatusDetail: exception in saving the runtimestatusdetail: The connection is closed.: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) [sqljdbc.jar:]

    15:04:25,995 ERROR [ims.RuntimeStatusDetail] (Thread-2563 (HornetQ-client-global-threads-31915866)) Exception while writing to the DB: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388) [sqljdbc.jar:]
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareCall(SQLServerConnection.java:2176) [sqljdbc.jar:]
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareCall(BaseWrapperManagedConnection.java:811)
    at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareCall(BaseWrapperManagedConnection.java:797)
    at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareCall(WrappedConnection.java:598)
    at com.netegrity.ims.persistence.PersistenceProvider.saveRuntimeStatusDetail(PersistenceProvider.java:1484) [ims.jar:]
    at com.netegrity.ims.statusDetail.RuntimeStatusDetailService.writeToPersistence(RuntimeStatusDetailService.java:458) [ims.jar:]
    at com.netegrity.ims.statusDetail.RuntimeStatusDetailService.writeRuntimeStatusDetail(RuntimeStatusDetailService.java:443) [ims.jar:]
    at com.netegrity.ims.statusDetail.RuntimeStatusDetailMessageBean.onMessage(RuntimeStatusDetailMessageBean.java:78) [ims.jar:]
    at sun.reflect.GeneratedMethodAccessor85.invoke(Unknown Source) [:1.7.0_71]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_71]

    Tuesday, December 8, 2015 9:27 PM

Answers

All replies