version: 2023-01-13 22:30:50
packageinfo: Hotfix_SmartbiV10_5_8_20230111
SQL错误:select *
from "SmartbiCache"."smartbimpp"."rcb_xdtztb" t1
left join "dashujufengkong"."DEFAULT"."rcb_la_report" t2
on t1."dbil_no" = t2."借据号";Query failed (#20230815_084139_00360_vxihe): Current transaction is aborted, commands ignored until end of transaction block
at smartbi.freequery.querydata.store.DBSQLResultStore.getResultSetCount(DBSQLResultStore.java:3669)
at ...(...)
at smartbi.log.PreparedStatementWarp.executeQuery(PreparedStatementWarp.java:323)
Caused by: java.sql.SQLException: Query failed (#20230815_084139_00360_vxihe): Current transaction is aborted, commands ignored until end of transaction block
at com.facebook.presto.jdbc.PrestoResultSet.resultsException(PrestoResultSet.java:1841)
at com.facebook.presto.jdbc.PrestoResultSet.getColumns(PrestoResultSet.java:1751)
at com.facebook.presto.jdbc.PrestoResultSet.(PrestoResultSet.java:121)
at com.facebook.presto.jdbc.PrestoStatement.internalExecute(PrestoStatement.java:272)
at com.facebook.presto.jdbc.PrestoStatement.execute(PrestoStatement.java:230)
at com.facebook.presto.jdbc.PrestoStatement.executeQuery(PrestoStatement.java:79)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at smartbi.log.PreparedStatementWarp.executeQuery(PreparedStatementWarp.java:323)
at smartbi.freequery.querydata.store.DBSQLResultStore.getResultSetCount(DBSQLResultStore.java:3646)
at smartbi.freequery.querydata.store.DBSQLResultStore.getDataRows(DBSQLResultStore.java:422)
at smartbi.freequery.report.SimpleReportBO.getTotalRowsInternal(SimpleReportBO.java:1630)
at smartbi.freequery.report.SimpleReportBO.getTotalRows(SimpleReportBO.java:1592)
at smartbi.freequery.client.simplereport.ClientReportService.getTotalRowsCount(ClientReportService.java:3760)
at smartbi.freequery.client.simplereport.ClientReportService.getTotalRowsCountWithFuture(ClientReportService.java:3732)
at sun.reflect.GeneratedMethodAccessor1650.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138)
at smartbi.framework.rmi.ClientService.execute(ClientService.java:120)
at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:209)
at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:132)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
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 smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:249)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:273)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:276)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:238)
at smartbi.freequery.filter.Filter.doFilter(Filter.java:33)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:240)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:64)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122)
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:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:366)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:881)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1647)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.facebook.presto.spi.PrestoException: Current transaction is aborted, commands ignored until end of transaction block
at com.facebook.presto.transaction.InMemoryTransactionManager$TransactionMetadata.checkOpenTransaction(InMemoryTransactionManager.java:367)
at com.facebook.presto.transaction.InMemoryTransactionManager.checkAndSetActive(InMemoryTransactionManager.java:239)
at com.facebook.presto.transaction.TransactionManager.activateTransaction(TransactionManager.java:84)
at com.facebook.presto.execution.SqlQueryManager.createQueryInternal(SqlQueryManager.java:354)
at com.facebook.presto.execution.SqlQueryManager.lambda$createQuery$4(SqlQueryManager.java:303)
at com.facebook.presto.$gen.Presto_0_218_6_gd2c62c6_dirty____20230814_084700_1.run(Unknown Source)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
... 1 more
