[2022-08-09 17:04:17.959] |-[ERROR] |-[42587adab4364b69b0e71b278c1acd2e] |-[SYSTEM] |-[g5.qry.database.AsyncTableRowInserts.proc(AsyncTableRowInserts.java:90)] |-[OTHER: SQL error detected! msg:null,e:java.sql.BatchUpdateException: A truncation error was encountered trying to shrink VARCHAR 'SELECT `执行时间`, `结算时间`, `基地`, `账套名称`, `结算用户名称`
, `结算用户&' to length 500.]
[2022-08-09 17:04:26.412] |-[ERROR] |-[81a0e40117b340118e5a3faca250cce2] |-[admin] |-[g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:229)] |-[DASHBOARD: [报错bi20220809170250-754<test/报错bi.db>][图表1][ErrCode: 0] Interrupt task is already scheduled for the thread GThread@672818063[g5.qry.jdbc.JDBCExecutor$SQLRunnable@6f16083e [ts=1660035866401, report=null, wts=11, cost=0, qryCost=0, grpCost=0, group=报错bi20220809170250-754, query=2435982, ready=true]] and the type SO_TIMEOUT]
java.lang.IllegalStateException: Interrupt task is already scheduled for the thread GThread@672818063[g5.qry.jdbc.JDBCExecutor$SQLRunnable@6f16083e [ts=1660035866401, report=null, wts=11, cost=0, qryCost=0, grpCost=0, group=报错bi20220809170250-754, query=2435982, ready=true]] and the type SO_TIMEOUT
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:85) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:103) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.net.nt.TimeoutSocketChannel.scheduleInterrupt(TimeoutSocketChannel.java:235) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.net.nt.TimeoutSocketChannel.write(TimeoutSocketChannel.java:198) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:350) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.net.ns.NIONSDataChannel.writeDataToSocketChannel(NIONSDataChannel.java:199) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.net.ns.NIONSDataChannel.writeDataToSocketChannel(NIONSDataChannel.java:144) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CMAREngineNIO.flush(T4CMAREngineNIO.java:743) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:756) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:429) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:407) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) ~[ojdbc10.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) ~[ojdbc10.jar:19.3.0.0.0]
at g5.qry.jdbc.JDBCExecutor.getRS(JDBCExecutor.java:1361) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor.initQry(JDBCExecutor.java:1338) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:957) ~[product.jar:?]
at g5.qry.sql.SQLExecutor.init0(SQLExecutor.java:438) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:226) [product.jar:?]
at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:214) [product.jar:?]
at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:319) [product.jar:?]
[2022-08-09 17:04:26.412] |-[ERROR] |-[81a0e40117b340118e5a3faca250cce2] |-[admin] |-[g5.qry.QueryPool$QueryRunnable.run(QueryPool.java:219)] |-[DASHBOARD: [报错bi20220809170250-754<test/报错bi.db>][图表1][ErrCode: 0] Related Dashboard: '报错bi20220809170250-754' Related Query: '分公司-hlf' Related Element: '图表1' Run user: 'admin'
Caused by: java.sql.SQLException 执行SQL失败:“Interrupt task is already scheduled for the thread GThread@672818063[g5.qry.jdbc.JDBCExecutor$SQLRunnable@6f16083e [ts=1660035866401, report=null, wts=11, cost=0, qryCost=0, grpCost=0, group=报错bi20220809170250-754, query=2435982, ready=true]] and the type SO_TIMEOUT”]
java.sql.SQLException: 执行SQL失败:“Interrupt task is already scheduled for the thread GThread@672818063[g5.qry.jdbc.JDBCExecutor$SQLRunnable@6f16083e [ts=1660035866401, report=null, wts=11, cost=0, qryCost=0, grpCost=0, group=报错bi20220809170250-754, query=2435982, ready=true]] and the type SO_TIMEOUT”
at g5.qry.jdbc.JDBCExecutor.convertException(JDBCExecutor.java:1411) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:230) ~[product.jar:?]
at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:214) [product.jar:?]
at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:319) [product.jar:?]
Caused by: java.lang.IllegalStateException: Interrupt task is already scheduled for the thread GThread@672818063[g5.qry.jdbc.JDBCExecutor$SQLRunnable@6f16083e [ts=1660035866401, report=null, wts=11, cost=0, qryCost=0, grpCost=0, group=报错bi20220809170250-754, query=2435982, ready=true]] and the type SO_TIMEOUT
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:85) ~[?:?]
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:103) ~[?:?]
at oracle.net.nt.TimeoutSocketChannel.scheduleInterrupt(TimeoutSocketChannel.java:235) ~[?:?]
at oracle.net.nt.TimeoutSocketChannel.write(TimeoutSocketChannel.java:198) ~[?:?]
at oracle.net.ns.NIOPacket.writeToSocketChannel(NIOPacket.java:350) ~[?:?]
at oracle.net.ns.NIONSDataChannel.writeDataToSocketChannel(NIONSDataChannel.java:199) ~[?:?]
at oracle.net.ns.NIONSDataChannel.writeDataToSocketChannel(NIONSDataChannel.java:144) ~[?:?]
at oracle.jdbc.driver.T4CMAREngineNIO.flush(T4CMAREngineNIO.java:743) ~[?:?]
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:756) ~[?:?]
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:429) ~[?:?]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:407) ~[?:?]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[?:?]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) ~[?:?]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) ~[?:?]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) ~[?:?]
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) ~[?:?]
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) ~[?:?]
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) ~[?:?]
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) ~[?:?]
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) ~[?:?]
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) ~[?:?]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) ~[?:?]
at g5.qry.jdbc.JDBCExecutor.getRS(JDBCExecutor.java:1361) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor.initQry(JDBCExecutor.java:1338) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor.init0(JDBCExecutor.java:957) ~[product.jar:?]
at g5.qry.sql.SQLExecutor.init0(SQLExecutor.java:438) ~[product.jar:?]
at g5.qry.jdbc.JDBCExecutor$SQLRunnable.run(JDBCExecutor.java:226) ~[product.jar:?]
... 2 more
[2022-08-09 17:04:26.419] |-[ERROR] |-[81a0e40117b340118e5a3faca250cce2] |-[admin] |-[g5.sv.db.impl.DBServiceImpl.process(DBServiceImpl.java:1182)] |-[DASHBOARD: [报错bi20220809170250-754<test/报错bi.db>][图表1][ErrCode: 8192] ERROR]
g5.util.GRTException: 执行数据失败:执行SQL失败:“Interrupt task is already scheduled for the thread GThread@672818063[g5.qry.jdbc.JDBCExecutor$SQLRunnable@6f16083e [ts=1660035866401, report=null, wts=11, cost=0, qryCost=0, grpCost=0, group=报错bi20220809170250-754, query=2435982, ready=true]] and the type SO_TIMEOUT”
at g5.db.RTDashboard.execData(RTDashboard.java:1844) ~[product.jar:?]
at g5.db.RTDashboard.execData(RTDashboard.java:1716) ~[product.jar:?]
at g5.db.impl.DBTool.execData(DBTool.java:4453) ~[product.jar:?]
at g5.db.impl.DBTool.executeElem(DBTool.java:4484) ~[product.jar:?]
at g5.sv.db.req.UpdateElemReq.process1(UpdateElemReq.java:112) ~[product.jar:?]
at g5.sv.db.req.UpdateElemReq.process0(UpdateElemReq.java:73) ~[product.jar:?]
at g5.sv.Req.process(Req.java:41) ~[product.jar:?]
at g5.sv.db.impl.DBServiceImpl.process(DBServiceImpl.java:1102) [product.jar:?]
at g5.sv.db.DBProc.procReq(DBProc.java:996) [product.jar:?]
at g5.sv.db.DBProc.service(DBProc.java:139) [product.jar:?]
at g5.sv.ServletHelper.service(ServletHelper.java:101) [product.jar:?]
at g5.sv.PortalServlet.service(PortalServlet.java:486) [product.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) [servlet-api.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at g5.sv.standardsso.SSOLoginFilter.doFilter(SSOLoginFilter.java:117) [product.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-websocket.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [catalina.jar:9.0.43]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:9.0.43]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) [catalina.jar:9.0.43]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.43]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687) [catalina.jar:9.0.43]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:9.0.43]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:346) [catalina.jar:9.0.43]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) [tomcat-coyote.jar:9.0.43]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.43]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:887) [tomcat-coyote.jar:9.0.43]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1684) [tomcat-coyote.jar:9.0.43]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.43]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.43]
at java.lang.Thread.run(Thread.java:834) [?:?] |