麦粉社区
>
帖子详情

升级后,高速缓存库的表数据预览失败

数据连接 发表于 2021-9-10 10:18
发表于 2021-9-10 10:18:44
smartbi更新升级后,恢复知识库,但是高速缓存库的表信息预览失败了,这个数据是存放在哪的,要如何恢复呢?(升级是按照指导文档做的https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=56694066,新版本装在了另一台机器上)

56379613abeb002a2a.png
堆栈信息
version:        2021-08-13 20:23:26
packageinfo:        Branch_SmartbiV95_20200429


SQL错误:Table 'unionbase.i402885ec017a513751371cef017a7a63da4a0815' doesn't exist
        at smartbi.freequery.basicdata.MetaDataServiceImpl.getTableDataByPage(MetaDataServiceImpl.java:3125)
        at ...(...)
        at smartbi.log.PreparedStatementWarp.executeQuery(PreparedStatementWarp.java:181)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'unionbase.i402885ec017a513751371cef017a7a63da4a0815' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
        at com.mysql.jdbc.Util.getInstance(Util.java:408)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
        at smartbi.log.PreparedStatementWarp.executeQuery(PreparedStatementWarp.java:181)
        at smartbi.freequery.querydata.SQLExecutor.executeInner(SQLExecutor.java:336)
        at smartbi.freequery.querydata.SQLExecutor.execute(SQLExecutor.java:226)
        at smartbi.freequery.querydata.SQLExecutor.execute(SQLExecutor.java:128)
        at smartbi.freequery.basicdata.MetaDataServiceImpl.getDataByQuerySqlWithState(MetaDataServiceImpl.java:3422)
        at smartbi.freequery.basicdata.MetaDataServiceImpl.getTableDataByPage(MetaDataServiceImpl.java:3123)
        at smartbi.freequery.basicdata.MetaDataServiceImpl.getSampleTableData(MetaDataServiceImpl.java:3540)
        at smartbi.freequery.client.datasource.DataSourceService.getSampleTableDataOnBrowser(DataSourceService.java:1321)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:498)
        at smartbi.framework.rmi.ClientService.execute(Smartbi:119)
        at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:230)
        at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:168)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
        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$2.doFilter(ExtensionFilter.java:167)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:156)
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:70)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:156)
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:179)
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:68)
        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:50)
        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:211)
        at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
        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:209)
        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:61)
        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(Smartbi:125)
        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:199)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626)
        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)



发表于 2021-9-10 12:53:38
检查一下升级后,高速缓存库能否链接上,如果不能,再来反馈
回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

1回帖数 0关注人数 1608浏览人数
最后回复于:2021-9-10 12:53
快速回复 返回顶部 返回列表