直接上报错
测试省本级---------------------false
2022-09-20 00:40:10.204 [http-nio-8002-exec-9] DEBUG com.epf.landweb.dao.StateOwnedBuildLandDao.getUserIds - ==> Preparing: select su.id from JX_ADMIN.SYS_USER su where instr( su.REGIONAL,?,1,1) =1
2022-09-20 00:40:10.205 [http-nio-8002-exec-9] DEBUG com.epf.landweb.dao.StateOwnedBuildLandDao.getUserIds - ==> Parameters: 36(String)
2022-09-20 00:40:10.207 [http-nio-8002-exec-9] DEBUG com.epf.landweb.dao.StateOwnedBuildLandDao.getUserIds - <== Total: 38
2022-09-20 00:40:10.210 [http-nio-8002-exec-9] DEBUG com.epf.landweb.dao.StateOwnedBuildLandDao.getStateOwnedBuildLandList_COUNT - ==> Preparing: SELECT count(*) FROM (SELECT tt.TARGET_NO, concat(concat((SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.FIRST_CLASS_USE), '-'), (SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.SECOND_CLASS_USE)) AS firstHSecondUse, concat((SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.FIRST_CLASS_USE), (SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.SECOND_CLASS_USE)) AS firstSecondUse, tt.BEGIN_PRICE, tt.STATUS, tt.BEGIN_NOTICE_TIME, tt.END_NOTICE_TIME, tt.BEGIN_FOCUS_TIME, tt.END_FOCUS_TIME, tt.BEGIN_APPLY_TIME, tt.END_APPLY_TIME, tt.END_EARNEST_TIME, tt.BEGIN_LIMIT_TIME, ttt.TRANS_TYPE, tt.UNIT, tt.IS_AFTER_CHECK, tt.LAND_APPRAISALREPORT_NO, ttem.CURRENCY, ttem.AMOUNT, tg.GOODS_NO, tg.CANTON_PROVINCE, tg.CANTON_CITY, tg.CANTON_AREA, tg.FIRST_CLASS_USE, tg.SECOND_CLASS_USE, tg.AREA, tg.COORDINATE, tg.img, tg.AGGREGATE_INVESTMENT, tg.CRITERION, tg.PANORAMA, tg.GOODS_NAME, tt.CURRENT_PRICE, tt.WINNER_ID, tg.LOCATION, tt.QUOTA_TYPE, tt.IS_RESERVE, tt.ID AS targetId, ttg.GOODS_ID, row_number() OVER (PARTITION BY tt.target_no ORDER BY tt.INSERT_TIME DESC) rn, tg.AREA_UNIT FROM (SELECT tt1.* FROM TRANS_TARGET tt1, (SELECT tt1.target_no, MAX(tt1.INSERT_TIME) INSERT_TIME FROM TRANS_TARGET tt1 GROUP BY tt1.TARGET_NO) tto WHERE tt1.target_no = tto.target_no AND tt1.INSERT_TIME = tto.INSERT_TIME) tt LEFT JOIN (SELECT ttg1.* FROM TRANS_TARGET_GOODS ttg1, (SELECT ttg1.target_id, MAX(ttg1.INSERT_TIME) INSERT_TIME FROM TRANS_TARGET_GOODS ttg1 GROUP BY ttg1.target_id) ttgo WHERE ttg1.target_id = ttgo.target_id AND ttg1.INSERT_TIME = ttgo.INSERT_TIME) ttg ON tt.ID = ttg.TARGET_ID LEFT JOIN TRANS_TARGET_EARNEST_MONEY ttem ON tt.ID = ttem.TARGET_ID LEFT JOIN TRANS_GOODS tg ON tg.id = ttg.GOODS_ID LEFT JOIN TRANS_TRANSACTION_TYPE ttt ON tt.TRANS_TYPE = ttt.id WHERE 1 = 1 AND tg.FIRST_CLASS_USE = ? AND tt.INSERT_USER IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND tt.DELETE_FLAG = 0 AND tt.STATUS NOT IN ('trans_status-002', 'trans_status-001')) j WHERE rn = 1
2022-09-20 00:40:10.210 [http-nio-8002-exec-9] DEBUG com.epf.landweb.dao.StateOwnedBuildLandDao.getStateOwnedBuildLandList_COUNT - ==> Parameters: land_use-063(String), f91a28f0-548f-40c3-aaac-5a44bbb33d3d(String), 830a11ab-2d23-4aa0-8dd8-696238c4023d(String), 0e09874b-de9f-4b6b-a39f-23f6f7571710(String), 56bf388c-9ad6-48cc-b73c-cd73763604f8(String), 9ea5c37f-fed6-43a0-9497-8f47090499da(String), da8a7cc8-47cc-412c-8e25-a8dd10119adb(String), 976a5006-0722-428f-9422-e7bd17160f9b(String), e9e5b579-fd01-4d20-89c5-56e1afeaf734(String), 66403e7b-db30-4ccb-91ad-f861b8856148(String), 2bd90586-e998-45d6-9cfa-1917ae235587(String), 5d94edce-7d04-4e65-94bf-557b12ae7dab(String), b5a0bc1d-fa70-4be7-af58-48369fa07bf4(String), 6afbe7d1-70fa-445c-b78f-08c19cd1d07d(String), 45d774ae-75c3-408e-97b6-0a8dff69e8b0(String), b86d52cf-494a-42b7-a762-902b982c4086(String), ce8e6f4e-69ac-4162-8d41-5f426f10c595(String), d3b8bc1b-e760-4da8-9dd2-551b3f19f392(String), 1866cad2-817c-4922-af45-110c325f6a20(String), 1f388ffa-08cf-416e-a426-d4cf3c6befb5(String), 94bbfd0a-227d-4b23-848b-78a95ed9b816(String), 1bbc1bc2-0f0d-4ea6-838c-a7b7ed84c590(String), 6e19c053-0309-47a0-b2c5-c8d09892ec65(String), b986bd53-3199-4008-81d4-75b489cca9bb(String), 755dfc9e-a00d-48fb-b690-89c721e65b66(String), 56a77f72-d02f-4b21-abb5-df2d16102bdd(String), 48cb1425-99c9-43e7-aa13-69432d42cb78(String), b6cc8030-7528-4612-918b-244008ad8d4d(String), cb775105-042b-435c-b5c6-a55920abd037(String), 08d25f92-99b6-4a5d-89df-0d954d7847c9(String), 446941ff-a2ec-40cd-a48a-24ebe36afd23(String), 4cea21d7-f4bf-42c1-91ca-33bf19b866dc(String), 4aa353f3-e434-46a4-a703-42ad59966eef(String), fb2ca59b-4fdd-47eb-878d-a4c8488483cb(String), fc5903cf-7c88-407c-9ab8-b08e5cd8dc54(String), 37fa058d-4b2e-469d-85e0-ae9bb2da78b3(String), 50e56547-8aaa-4f52-b52a-1a2d21745a05(String), ea191874-82ab-477b-b636-8ac88a7f0fc4(String), 122cdb44-6d17-4b68-9079-18b58aed346f(String)
2022-09-20 00:40:10.341 [http-nio-8002-exec-9] ERROR com.alibaba.druid.pool.PreparedStatementPool - exitImplicitCacheToClose error
java.sql.SQLRecoverableException: Closed Statement
at oracle.jdbc.driver.OracleClosedStatement.exitImplicitCacheToClose(OracleClosedStatement.java:4687)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.exitImplicitCacheToClose(OraclePreparedStatementWrapper.java:1623)
at com.alibaba.druid.util.OracleUtils.exitImplicitCacheToClose(OracleUtils.java:73)
at com.alibaba.druid.pool.PreparedStatementPool.closeRemovedStatement(PreparedStatementPool.java:170)
at com.alibaba.druid.pool.PreparedStatementPool.clear(PreparedStatementPool.java:138)
at com.alibaba.druid.pool.DruidConnectionHolder.clearStatementCache(DruidConnectionHolder.java:225)
at com.alibaba.druid.pool.DruidPooledConnection.disable(DruidPooledConnection.java:218)
at com.alibaba.druid.pool.DruidDataSource.handleFatalError(DruidDataSource.java:1579)
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1540)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:133)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:77)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:502)
at sun.reflect.GeneratedMethodAccessor248.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.$Proxy421.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:324)
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 sun.reflect.GeneratedMethodAccessor246.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.github.pagehelper.SqlUtil.doProcessPage(SqlUtil.java:475)
at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:407)
at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
at com.github.pagehelper.PageHelper.intercept(PageHelper.java:250)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy418.query(Unknown Source)
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.GeneratedMethodAccessor245.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.$Proxy166.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy256.getStateOwnedBuildLandList(Unknown Source)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl.getStateOwnedBuildLandList(StateOwnedBuildLandServiceImpl.java:262)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl$$FastClassBySpringCGLIB$$34c94d40.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at com.epf.dict.aspect.TranslationDictAspect.Translation(TranslationDictAspect.java:50)
at sun.reflect.GeneratedMethodAccessor302.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl$$EnhancerBySpringCGLIB$$8a699da8.getStateOwnedBuildLandList(<generated>)
at com.epf.landweb.controller.StateOwnedBuildLandController.getStateOwnedBuildLandList(StateOwnedBuildLandController.java:163)
at sun.reflect.GeneratedMethodAccessor326.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.epf.common.security.XssAndSqlFilter.doFilter(XssAndSqlFilter.java:64)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:155)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:123)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
2022-09-20 00:40:10.342 [http-nio-8002-exec-9] ERROR com.alibaba.druid.pool.DruidDataSource - discard connection
java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)
at sun.reflect.GeneratedMethodAccessor248.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.$Proxy421.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:324)
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 sun.reflect.GeneratedMethodAccessor246.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.github.pagehelper.SqlUtil.doProcessPage(SqlUtil.java:475)
at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:407)
at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
at com.github.pagehelper.PageHelper.intercept(PageHelper.java:250)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy418.query(Unknown Source)
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.GeneratedMethodAccessor245.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.$Proxy166.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy256.getStateOwnedBuildLandList(Unknown Source)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl.getStateOwnedBuildLandList(StateOwnedBuildLandServiceImpl.java:262)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl$$FastClassBySpringCGLIB$$34c94d40.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at com.epf.dict.aspect.TranslationDictAspect.Translation(TranslationDictAspect.java:50)
at sun.reflect.GeneratedMethodAccessor302.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl$$EnhancerBySpringCGLIB$$8a699da8.getStateOwnedBuildLandList(<generated>)
at com.epf.landweb.controller.StateOwnedBuildLandController.getStateOwnedBuildLandList(StateOwnedBuildLandController.java:163)
at sun.reflect.GeneratedMethodAccessor326.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.epf.common.security.XssAndSqlFilter.doFilter(XssAndSqlFilter.java:64)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:155)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:123)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
2022-09-20 00:40:10.344 [http-nio-8002-exec-9] ERROR com.tiaim.framework.exception.TiExceptionHandler -
### Error querying database. Cause: java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
### The error may exist in URL [jar:file:/home/admin/47-48-91/epf-land2-landweb-8002-32.jar!/BOOT-INF/classes!/config/mapper/landweb/StateOwnedBuildLandDao.xml]
### The error may involve com.epf.landweb.dao.StateOwnedBuildLandDao.getStateOwnedBuildLandList-Inline
### The error occurred while setting parameters
### SQL: SELECT count(*) FROM (SELECT tt.TARGET_NO, concat(concat((SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.FIRST_CLASS_USE), '-'), (SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.SECOND_CLASS_USE)) AS firstHSecondUse, concat((SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.FIRST_CLASS_USE), (SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.SECOND_CLASS_USE)) AS firstSecondUse, tt.BEGIN_PRICE, tt.STATUS, tt.BEGIN_NOTICE_TIME, tt.END_NOTICE_TIME, tt.BEGIN_FOCUS_TIME, tt.END_FOCUS_TIME, tt.BEGIN_APPLY_TIME, tt.END_APPLY_TIME, tt.END_EARNEST_TIME, tt.BEGIN_LIMIT_TIME, ttt.TRANS_TYPE, tt.UNIT, tt.IS_AFTER_CHECK, tt.LAND_APPRAISALREPORT_NO, ttem.CURRENCY, ttem.AMOUNT, tg.GOODS_NO, tg.CANTON_PROVINCE, tg.CANTON_CITY, tg.CANTON_AREA, tg.FIRST_CLASS_USE, tg.SECOND_CLASS_USE, tg.AREA, tg.COORDINATE, tg.img, tg.AGGREGATE_INVESTMENT, tg.CRITERION, tg.PANORAMA, tg.GOODS_NAME, tt.CURRENT_PRICE, tt.WINNER_ID, tg.LOCATION, tt.QUOTA_TYPE, tt.IS_RESERVE, tt.ID AS targetId, ttg.GOODS_ID, row_number() OVER (PARTITION BY tt.target_no ORDER BY tt.INSERT_TIME DESC) rn, tg.AREA_UNIT FROM (SELECT tt1.* FROM TRANS_TARGET tt1, (SELECT tt1.target_no, MAX(tt1.INSERT_TIME) INSERT_TIME FROM TRANS_TARGET tt1 GROUP BY tt1.TARGET_NO) tto WHERE tt1.target_no = tto.target_no AND tt1.INSERT_TIME = tto.INSERT_TIME) tt LEFT JOIN (SELECT ttg1.* FROM TRANS_TARGET_GOODS ttg1, (SELECT ttg1.target_id, MAX(ttg1.INSERT_TIME) INSERT_TIME FROM TRANS_TARGET_GOODS ttg1 GROUP BY ttg1.target_id) ttgo WHERE ttg1.target_id = ttgo.target_id AND ttg1.INSERT_TIME = ttgo.INSERT_TIME) ttg ON tt.ID = ttg.TARGET_ID LEFT JOIN TRANS_TARGET_EARNEST_MONEY ttem ON tt.ID = ttem.TARGET_ID LEFT JOIN TRANS_GOODS tg ON tg.id = ttg.GOODS_ID LEFT JOIN TRANS_TRANSACTION_TYPE ttt ON tt.TRANS_TYPE = ttt.id WHERE 1 = 1 AND tg.FIRST_CLASS_USE = ? AND tt.INSERT_USER IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND tt.DELETE_FLAG = 0 AND tt.STATUS NOT IN ('trans_status-002', 'trans_status-001')) j WHERE rn = 1
### Cause: java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
; uncategorized SQLException; SQL state [60000]; error code [600]; ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
; nested exception is java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
org.springframework.jdbc.UncategorizedSQLException:
### Error querying database. Cause: java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
### The error may exist in URL [jar:file:/home/admin/47-48-91/epf-land2-landweb-8002-32.jar!/BOOT-INF/classes!/config/mapper/landweb/StateOwnedBuildLandDao.xml]
### The error may involve com.epf.landweb.dao.StateOwnedBuildLandDao.getStateOwnedBuildLandList-Inline
### The error occurred while setting parameters
### SQL: SELECT count(*) FROM (SELECT tt.TARGET_NO, concat(concat((SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.FIRST_CLASS_USE), '-'), (SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.SECOND_CLASS_USE)) AS firstHSecondUse, concat((SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.FIRST_CLASS_USE), (SELECT ZH_CN FROM JX_ADMIN.SYS_DICTIONARIES WHERE GROUP_ID = (SELECT id FROM JX_ADMIN.SYS_DICT_GROUP WHERE CODE = 'land_use') AND DICT_VALUE = tg.SECOND_CLASS_USE)) AS firstSecondUse, tt.BEGIN_PRICE, tt.STATUS, tt.BEGIN_NOTICE_TIME, tt.END_NOTICE_TIME, tt.BEGIN_FOCUS_TIME, tt.END_FOCUS_TIME, tt.BEGIN_APPLY_TIME, tt.END_APPLY_TIME, tt.END_EARNEST_TIME, tt.BEGIN_LIMIT_TIME, ttt.TRANS_TYPE, tt.UNIT, tt.IS_AFTER_CHECK, tt.LAND_APPRAISALREPORT_NO, ttem.CURRENCY, ttem.AMOUNT, tg.GOODS_NO, tg.CANTON_PROVINCE, tg.CANTON_CITY, tg.CANTON_AREA, tg.FIRST_CLASS_USE, tg.SECOND_CLASS_USE, tg.AREA, tg.COORDINATE, tg.img, tg.AGGREGATE_INVESTMENT, tg.CRITERION, tg.PANORAMA, tg.GOODS_NAME, tt.CURRENT_PRICE, tt.WINNER_ID, tg.LOCATION, tt.QUOTA_TYPE, tt.IS_RESERVE, tt.ID AS targetId, ttg.GOODS_ID, row_number() OVER (PARTITION BY tt.target_no ORDER BY tt.INSERT_TIME DESC) rn, tg.AREA_UNIT FROM (SELECT tt1.* FROM TRANS_TARGET tt1, (SELECT tt1.target_no, MAX(tt1.INSERT_TIME) INSERT_TIME FROM TRANS_TARGET tt1 GROUP BY tt1.TARGET_NO) tto WHERE tt1.target_no = tto.target_no AND tt1.INSERT_TIME = tto.INSERT_TIME) tt LEFT JOIN (SELECT ttg1.* FROM TRANS_TARGET_GOODS ttg1, (SELECT ttg1.target_id, MAX(ttg1.INSERT_TIME) INSERT_TIME FROM TRANS_TARGET_GOODS ttg1 GROUP BY ttg1.target_id) ttgo WHERE ttg1.target_id = ttgo.target_id AND ttg1.INSERT_TIME = ttgo.INSERT_TIME) ttg ON tt.ID = ttg.TARGET_ID LEFT JOIN TRANS_TARGET_EARNEST_MONEY ttem ON tt.ID = ttem.TARGET_ID LEFT JOIN TRANS_GOODS tg ON tg.id = ttg.GOODS_ID LEFT JOIN TRANS_TRANSACTION_TYPE ttt ON tt.TRANS_TYPE = ttt.id WHERE 1 = 1 AND tg.FIRST_CLASS_USE = ? AND tt.INSERT_USER IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND tt.DELETE_FLAG = 0 AND tt.STATUS NOT IN ('trans_status-002', 'trans_status-001')) j WHERE rn = 1
### Cause: java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
; uncategorized SQLException; SQL state [60000]; error code [600]; ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
; nested exception is java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy166.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy256.getStateOwnedBuildLandList(Unknown Source)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl.getStateOwnedBuildLandList(StateOwnedBuildLandServiceImpl.java:262)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl$$FastClassBySpringCGLIB$$34c94d40.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at com.epf.dict.aspect.TranslationDictAspect.Translation(TranslationDictAspect.java:50)
at sun.reflect.GeneratedMethodAccessor302.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at com.epf.landweb.service.impl.StateOwnedBuildLandServiceImpl$$EnhancerBySpringCGLIB$$8a699da8.getStateOwnedBuildLandList(<generated>)
at com.epf.landweb.controller.StateOwnedBuildLandController.getStateOwnedBuildLandList(StateOwnedBuildLandController.java:163)
at sun.reflect.GeneratedMethodAccessor326.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:90)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.epf.common.security.XssAndSqlFilter.doFilter(XssAndSqlFilter.java:64)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:155)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:123)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [kkdoilsn1], [], [], [], [], [], [], [], [], [], [], []
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3409)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3407)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:498)
at sun.reflect.GeneratedMethodAccessor248.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.$Proxy421.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:324)
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 sun.reflect.GeneratedMethodAccessor246.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.github.pagehelper.SqlUtil.doProcessPage(SqlUtil.java:475)
at com.github.pagehelper.SqlUtil._processPage(SqlUtil.java:407)
at com.github.pagehelper.SqlUtil.processPage(SqlUtil.java:374)
at com.github.pagehelper.PageHelper.intercept(PageHelper.java:250)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy418.query(Unknown Source)
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.GeneratedMethodAccessor245.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)
... 94 common frames omitted
这里因为修改了主读写库表数据结构,查询主读库报错,因为知道是修改了数据库结构,而且只有查询主读库会报错,查询读写库是正常的,所以怀疑是应该cache引起的
所以第一时间flush 了buffer_cache 和shared_pool
代码如下:
alter system flush buffer_cache
alter system flush shared_pool
之后再测试,发现还是抛这个错误,就在从库里边查询表,发现表打不开,所以因该是同步的时候有些东西没有同步过来,然后重新同步了一次后发现不报错了