Caused by: java.sql.SQLException: ORA-03135: connection lostcontact - Websphere

This is a discussion on Caused by: java.sql.SQLException: ORA-03135: connection lostcontact - Websphere ; We are receving the following error in the wps.out.log We have Oracle RDBMS 10.2.0.3 at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2 EEContext.java(Compiled Code)) at java.security.AccessController.doPrivileged1(Nativ e Method) at java.security.AccessController.doPrivileged(Access Controller.java(Compiled Code)) at javax.security.auth.Subject.doAs(Subject.java(Comp iled Code)) at com.ibm.websphere.security.auth.WSSubject.doAs(WSS ubject.java(Compiled Code)) at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J 2EEContext.java(Compiled Code)) at java.security.AccessController.doPrivileged1(Nativ ...

+ Reply to Thread
Results 1 to 9 of 9

Thread: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

  1. Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    We are receving the following error in the wps.out.log

    We have Oracle RDBMS 10.2.0.3


    at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2 EEContext.java(Compiled Code))
    at java.security.AccessController.doPrivileged1(Nativ e Method)
    at java.security.AccessController.doPrivileged(Access Controller.java(Compiled Code))
    at javax.security.auth.Subject.doAs(Subject.java(Comp iled Code))
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSS ubject.java(Compiled Code))
    at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J 2EEContext.java(Compiled Code))
    at java.security.AccessController.doPrivileged1(Nativ e Method)
    at java.security.AccessController.doPrivileged(Access Controller.java(Compiled Code))
    at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext .java(Compiled Code))
    at com.ibm.ws.asynchbeans.AlarmImpl.runListenerAsCJWo rk(AlarmImpl.java(Compiled Code))
    at com.ibm.ws.asynchbeans.am._Alarm.fireAlarm(_Alarm. java(Compiled Code))
    at com.ibm.ws.asynchbeans.am._Alarm.run(_Alarm.java(C ompiled Code))
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava(Compiled Code))
    Caused by: java.sql.SQLException: ORA-03135: connection lost contact

    at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
    at oracle.jdbc.driver.T2CConnection.checkError(T2CCon nection.java(Compiled Code))
    at oracle.jdbc.driver.T2CConnection.checkError(T2CCon nection.java(Compiled Code))
    at oracle.jdbc.driver.T2CPreparedStatement.executeFor Describe(T2CPreparedStatement.java:571)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java(Compiled Code))
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java(Compiled Code))
    at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java(Compiled Code))
    at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java(Compiled Code))
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. pmiExecuteQuery(WSJdbcPreparedStatement.java(Compi led Code))
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. executeQuery(WSJdbcPreparedStatement.java(Compiled Code))
    at com.ibm.wps.datastore.impl.DataStoreContext.execut eQuery(DataStoreContext.java:532)
    ... 26 more

    [26/11/09 20:10:06:192 GMT] 00000035 ThreadMonitor W WSVR0606W: Thread "wpsDefaultWorkManager.Alarm Pool : 1" (00000035) was previously reported to be hung but has completed. It was active for approximately 932080 milliseconds. There is/are 0 thread(s) in total in the server that still may be hung.
    [26/11/09 20:14:40:227 GMT] 0000006e Servlet W com.ibm.wps.engine.Servlet doGet() Invalid URL 'http://10.217.3.100/1/2/hbcl-21011'
    [26/11/09 20:14:40:228 GMT] 0000006e Servlet W com.ibm.wps.engine.Servlet doGet() EJPEI0156E: The requested URL http://10.217.3.100/1/2/hbcl-21011 cannot be decoded. Reason: com.ibm.wps.state.nls.exceptions.NlsCannotInterpre tCodecException: EJPEI0073E: The input mediator class com.ibm.wps.state.inputmediators.WPInputMediator@1 314310837 could not interpret codec hbcl-21011 for request com.ibm.wps.engine.PortalRequestWrapper@7d644aaa wrapping com.ibm.ws.webcontainer.srt.SRTServletRequest@5882 8b...
    [26/11/09 20:15:29:293 GMT] 00000064 TaskRunner E com.ibm.wps.cai.scheduler.TaskRunner run(TaskStatus ts) executing task of type class=com.ibm.wps.cai.scheduler.tasks.PurgeDeleted ApplicationsTask failed with exception=EJPFB0002E: Exception occurred.
    [26/11/09 20:15:29:379 GMT] 00000064 AlarmListener E SCHD0063E: A task with ID 5802 failed to run on Scheduler WPSTaskScheduler (wps/Scheduler) because of an exception: javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0x0 No; nested exception is:
    org.omg.CORBA.TRANSACTION_ROLLEDBACK: javax.transaction.TransactionRolledbackException: ; nested exception is:
    com.ibm.websphere.csi.CSITransactionRolledbackExce ption: Transaction marked rollbackonly vmcid: 0x0 minor code: 0 completed: No.

  2. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    VersiĆ³n WPS: 6.0.1.4

  3. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    Are you sure that your database is up and running without problems?

    Can you ensure that you have your connection pools set correctly based on the ratios defined in this URL:

    http://www-01.ibm.com/support/docvie...id=swg21319394

    Are you able to take a javacore or two when you receive this message in the systemOut, and match this thread with the thread in the javacore to determine what it is doing?

    "wpsDefaultWorkManager.Alarm Pool : 1"

    Matt Munse

    The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.

  4. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    Are you sure the thread pools are set correctly to the above URL? Also, were you able to get a javacore to match up with the systemOut message of a hung thread, you'll need to take this when you see the problem in the systemOut.

    *Matt Munse*

    The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.

  5. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    I am sure that the database is running an up, i made some test connections from connections pulls and no problem.

  6. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    2LKMONINUSE sys_mon_t:0xA97A1D60 infl_mon_t: 0xA979FC10:
    3LKMONOBJECT com.ibm.ws.util.BoundedBuffer@35DA8328/35DA8330:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "wpsDefaultWorkManager.Alarm Pool : 0" (9D97EB0)
    3LKWAITNOTIFY "wpsDefaultWorkManager.Alarm Pool : 1" (9DFC850)
    2LKMONINUSE sys_mon_t:0xA97A2720 infl_mon_t: 0xA97A0088:
    3LKMONOBJECT java.lang.Object@49B6CA30/49B6CA38:
    3LKNOTIFYQ Waiting to be notified:
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9FDA2B0)
    3LKWAITNOTIFY "java.lang.ThreadGroup[name=icmciWorkManager: icmjcrear,maxpri=10]" (9FFA160)
    3LKWAITNOT

  7. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    Can you please attach your javacore to the forum, and can you also paste into the forum from the systemOut the lines with the time/date stamp that is showing the hung thread.

    *Matt Munse*

    The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.

  8. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    I don't see a javacore that i matchs error's date.

  9. Re: Caused by: java.sql.SQLException: ORA-03135: connection lostcontact

    Can you manually reproduce the problem? The javacore will not be generated automatically and will need to be manually produced when the issue is occurring.

    *Matt Munse*

    The postings on this site are my own and do not necessarily represent the positions, strategies, or opinions of IBM.

+ Reply to Thread