错误代码:11300001 数据集配置错误
Query:
Unknown system variable 'query_cache_size'java.lang.RuntimeException: 错误代码:11300001 数据集配置错误

Query:

Unknown system variable 'query_cache_size'

at com.fr.report.core.A.J.dealWithBEDSColumn(Unknown Source)

at com.fr.report.core.A.m.cc_ce_array(Unknown Source)

at com.fr.report.core.A.J.A(Unknown Source)

at com.fr.report.core.A.J.A(Unknown Source)

at com.fr.report.core.A.J.A(Unknown Source)

at com.fr.report.core.A.J.A(Unknown Source)

at com.fr.report.core.A.J.A(Unknown Source)

at com.fr.report.core.A.J.A(Unknown Source)

at com.fr.report.core.A.J.C(Unknown Source)

at com.fr.report.core.A.J.execute4Expand(Unknown Source)

at com.fr.report.core.A.J.execute(Unknown Source)

at com.fr.report.worksheet.WorkSheet.execute(Unknown Source)

at com.fr.report.core.sheet.AbstractWorkBookExecutor._execute(Unknown Source)

at com.fr.report.core.sheet.AbstractWorkBookExecutor.execute(Unknown Source)

at com.fr.main.impl.WorkBook.execute(Unknown Source)

at com.fr.main.impl.WorkBook.execute(Unknown Source)

at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source)

at com.fr.stable.PageActor.getResultBookFromCacheIfNeed(Unknown Source)

at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.execute(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.computeFitBook2Show$original$lbBurO35(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.computeFitBook2Show$original$lbBurO35$accessor$HHI1EKuI(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor$auxiliary$AxodFPrm.call(Unknown Source)

at com.fr.intelli.metrics.MonitorInterceptor.intercept(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.computeFitBook2Show(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.initFitBook2Show(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.getResultWorkBook(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.createPageSetChain(Unknown Source)

at com.fr.web.core.ReportSessionIDInfor.getReportPage(Unknown Source)

at com.fr.web.core.B.qA.A(Unknown Source)

at com.fr.web.core.B.qA.A(Unknown Source)

at com.fr.web.core.B.kA.A(Unknown Source)

at com.fr.web.core.B.KA.actionCMD(Unknown Source)

at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)

at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source)

at com.fr.web.core.B.hA.process(Unknown Source)

at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)

at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)

at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)

at com.fr.web.controller.BaseRequestService.preview(Unknown Source)

at com.fr.web.controller.ReportRequestService.preview(Unknown Source)

at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)

at com.fr.third.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)

at com.fr.third.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:747)

at com.fr.third.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:676)

at com.fr.third.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at com.fr.third.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)

at com.fr.third.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)

at com.fr.third.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)

at com.fr.third.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

at com.fr.third.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

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:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.fr.third.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at com.fr.third.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.fr.decision.base.DecisionServletInitializer$4.doFilter(Unknown Source)

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:200)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Unknown Source)

Caused by: com.fr.general.data.TableDataException: 错误代码:11300001 数据集配置错误

Query:

Unknown system variable 'query_cache_size'

at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source)

at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source)

at com.fr.data.index.AbstractIndexDataModel.getColumnCount(Unknown Source)

... 86 more

Caused by: java.sql.SQLException: Unknown system variable 'query_cache_size'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)

at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3833)

at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3283)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2297)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)

at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:806)

at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)

at sun.reflect.GeneratedConstructorAccessor102.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)

at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1461)

at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1525)

at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2153)

这是啥原因，本地navicat 访问没问题