java.sql.SQLException: ORA-00028: your session has been killed

末蓝、 2023-10-11 12:41 123阅读 0赞

[https://blog.csdn.net/wzg725/article/details/82220290][https_blog.csdn.net_wzg725_article_details_82220290]

2019-09-21 18:47:14.144 [pool-1-thread-1] INFO  com.scai.dispatcher.job.CreditQueryJob - queryCreditApplyJobData -> queueSize=[0],maxQueueSize=[100]
    2019-09-21 18:47:14.145 [pool-1-thread-1] DEBUG c.s.d.m.J.queryCreditJobRuleDecisionReq - ==>  Preparing: select * from ( select tmp_page.*, rownum row_id from ( select * from SCAI_ZBANK_RULEDECISION_REQ where VERSION = 0 and (APPLY_STAUTS = '1' or APPLY_STAUTS = '1.5')
     ) tmp_page where rownum <= ? + ? ) where row_id > ? 
    2019-09-21 18:47:14.145 [pool-1-thread-1] DEBUG c.s.d.m.J.queryCreditJobRuleDecisionReq - ==> Parameters: 100(Integer), 0(Integer), 0(Integer)
    2019-09-21 18:47:14.159 [pool-1-thread-1] ERROR com.alibaba.druid.pool.DruidDataSource - discard connection
    java.sql.SQLException: ORA-00028: your session has been killed
    
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
            at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
            at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
            at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
            at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
            at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
            at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
            at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)
            at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
            at com.sun.proxy.$Proxy114.execute(Unknown Source)
            at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
            at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
            at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
            at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
            at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
            at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
            at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
            at sun.reflect.GeneratedMethodAccessor128.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
            at com.sun.proxy.$Proxy74.selectList(Unknown Source)
            at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
            at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
            at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
            at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
            at com.sun.proxy.$Proxy79.queryCreditJobRuleDecisionReq(Unknown Source)
            at com.scai.dispatcher.job.CreditQueryJob.queryCreditApplyJobData(CreditQueryJob.java:108)
            at com.scai.dispatcher.job.CreditQueryJob.execute(CreditQueryJob.java:56)
            at com.scai.dispatcher.job.CreditQueryJob.lambda$run$0(CreditQueryJob.java:168)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
            at java.lang.Thread.run(Thread.java:748)
    Exception in thread "pool-1-thread-1" org.springframework.dao.ConcurrencyFailureException: 
    ### Error querying database.  Cause: java.sql.SQLException: ORA-00028: your session has been killed

项目的测试环境出现了这个情况，生产环境比较稳定。为两台机器，配置也高。按照上个网址的也换下版本试试。由

<groupId>com.oracle</groupId>
    <artifactId>ojdbc6</artifactId>
    <version>11.2.0.3</version>

换成11.2.0.4

[https_blog.csdn.net_wzg725_article_details_82220290]: https://blog.csdn.net/wzg725/article/details/82220290