麦粉社区
>
帖子详情

升级失败,恢复备份失败

安装指导 发表于 2022-8-17 12:13
发表于 2022-8-17 12:13:12

进去主页就强制升级,升级不成功,又回复不了备份

发表于 2022-8-17 15:04:16
后台报错信息可以发一下
可能config界面没配置好信息,升级先连一个空的知识库测试通过保存重启服务
  •   BI_WTH
    我不想升级,为什么没有取消升级的选项啊,
    
    升级报错
    08-17 15:44:52  INFO startUpgrade(:3007) - Start Upgrade
    08-17 15:44:52 DEBUG doUpgrade(smartbix.dao.upgrade.RepositoryUpgradeHandler:92) - [smartbix.dao, smartbix.datamining, smartbix.jobflow, smartbix.augmenteddataset.repository, smartbix.dataprocess, smartbix.dataset, smartbix.datasource, smartbix.fileresource, smartbix.material, smartbix.modelquery, smartbix.page, smartbix.smartbi.service, smartbix.smartbi]
    08-17 15:44:52 DEBUG upgradeRepository(smartbi.repository.RepositoryUpgradeHelper:298) - dryRun=false, taskSize=40
    08-17 15:44:52 ERROR doUpgrade(smartbi.usermanager.upgrade.UpgradeTask_0_0_41:87) - Upgrade module 'smartbi.usermanager.upgrade' to 0.0.42 fail.
    java.sql.SQLException: Incorrect string value: 'xAF u00...' for column 'c_long' at row 1
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1281) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:787) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2133) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2067) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5175) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2052) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at smartbi.usermanager.upgrade.UpgradeTask_0_0_41.doUpgrade(UpgradeTask_0_0_41.java:84) [smartbi-UserManager.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:413) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:306) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) [smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [smartbi-FrameworkRMI.jar:?]
    	at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:131) [smartbi-FrameworkRMI.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71) [smartbi-Framework.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [smartbi-FreeQuery.jar:?]
    	at smartbi.freequery.filter.Filter.doFilter(Filter.java:33) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    08-17 15:44:52 FATAL addOperationLog(smartbi.repository.RepositoryUpgradeHelper:468) - Upgraded module 'smartbi.usermanager' fail from UpgradeTask_0_0_41 to 0.0.42
    08-17 15:44:52 DEBUG startUpgrade(smartbi.config.BIConfigService:3036) - Upgrade failed
    08-17 15:44:52 ERROR (smartbi.config.BIConfigService - 升级知识库失败
    smartbi.SmartbiException: 升级知识库失败
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:307) ~[smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) ~[smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [smartbi-FrameworkRMI.jar:?]
    	at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:131) [smartbi-FrameworkRMI.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71) [smartbi-Framework.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [smartbi-FreeQuery.jar:?]
    	at smartbi.freequery.filter.Filter.doFilter(Filter.java:33) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    
    
    
    2022-8-17 15:50| 回复
  •   BI_WTH
    我不想升级,为什么没有取消升级的选项啊,
    
    升级报错
    08-17 15:44:52  INFO startUpgrade(:3007) - Start Upgrade
    08-17 15:44:52 DEBUG doUpgrade(smartbix.dao.upgrade.RepositoryUpgradeHandler:92) - [smartbix.dao, smartbix.datamining, smartbix.jobflow, smartbix.augmenteddataset.repository, smartbix.dataprocess, smartbix.dataset, smartbix.datasource, smartbix.fileresource, smartbix.material, smartbix.modelquery, smartbix.page, smartbix.smartbi.service, smartbix.smartbi]
    08-17 15:44:52 DEBUG upgradeRepository(smartbi.repository.RepositoryUpgradeHelper:298) - dryRun=false, taskSize=40
    08-17 15:44:52 ERROR doUpgrade(smartbi.usermanager.upgrade.UpgradeTask_0_0_41:87) - Upgrade module 'smartbi.usermanager.upgrade' to 0.0.42 fail.
    java.sql.SQLException: Incorrect string value: 'xAF u00...' for column 'c_long' at row 1
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1281) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:787) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2133) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2067) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5175) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2052) ~[_JDBC_mysql-connector-java-5.1.48.jar:5.1.48]
    	at smartbi.usermanager.upgrade.UpgradeTask_0_0_41.doUpgrade(UpgradeTask_0_0_41.java:84) [smartbi-UserManager.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:413) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:306) [smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) [smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [smartbi-FrameworkRMI.jar:?]
    	at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:131) [smartbi-FrameworkRMI.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71) [smartbi-Framework.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [smartbi-FreeQuery.jar:?]
    	at smartbi.freequery.filter.Filter.doFilter(Filter.java:33) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    08-17 15:44:52 FATAL addOperationLog(smartbi.repository.RepositoryUpgradeHelper:468) - Upgraded module 'smartbi.usermanager' fail from UpgradeTask_0_0_41 to 0.0.42
    08-17 15:44:52 DEBUG startUpgrade(smartbi.config.BIConfigService:3036) - Upgrade failed
    08-17 15:44:52 ERROR (smartbi.config.BIConfigService - 升级知识库失败
    smartbi.SmartbiException: 升级知识库失败
    	at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:307) ~[smartbi-DAO.jar:?]
    	at smartbi.repository.RepositoryUpgradeHelper.doUpgrade(RepositoryUpgradeHelper.java:451) ~[smartbi-DAO.jar:?]
    	at smartbi.config.BIConfigService.startUpgrade(BIConfigService.java:3012) [smartbi-BIConfig.jar:?]
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_202-ea]
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_202-ea]
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_202-ea]
    	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_202-ea]
    	at smartbi.framework.rmi.ClientService.executeInternal(ClientService.java:138) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.ClientService.execute(ClientService.java:120) [smartbi-IndexServer.jar:?]
    	at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:206) [smartbi-FrameworkRMI.jar:?]
    	at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:131) [smartbi-FrameworkRMI.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [servlet-api.jar:?]
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [servlet-api.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:285) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77) [classes/:?]
    	at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:266) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:298) [smartbi-ExtensionManager.jar:?]
    	at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:119) [smartbi-ExtensionManager.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71) [smartbi-Framework.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:237) [smartbi-FreeQuery.jar:?]
    	at smartbi.freequery.filter.Filter.doFilter(Filter.java:33) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:85) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:236) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:57) [smartbi-FreeQuery.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at smartbi.framework.RedisSessionFilter.doFilter(RedisSessionFilter.java:122) [smartbi-IndexServer.jar:?]
    	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [catalina.jar:8.5.81]
    	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:8.5.81]
    	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698) [catalina.jar:8.5.81]
    	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [catalina.jar:8.5.81]
    	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:367) [catalina.jar:8.5.81]
    	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:639) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:8.5.81]
    	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:882) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1691) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util.jar:8.5.81]
    	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.81]
    	at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202-ea]
    
    
    
    2022-8-17 15:50| 回复
  •   真的人
     回复 BI_WTH
    好像是乱码,看看这个文档https://wiki.smartbi.com.cn/pages/viewpage.action?pageId=76679856
    2022-8-17 16:03| 回复

回复

使用道具 举报

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

本版积分规则

4回帖数 0关注人数 1157浏览人数
最后回复于:2022-8-17 15:04
快速回复 返回顶部 返回列表