麦粉社区
>
帖子详情

服务无法启动了!!!!提示无法连接数据库

数据连接 发表于 2021-6-14 16:58
发表于 2021-6-14 16:58:33
郁闷啊!今天突然就这样子了。。。。
【JVM启动时间】
JVM StartTime:2021-06-14 16:46:45
06-14 16:48:04  INFO activate(smartbi.framework.Framework:70) - -------打印版本信息结束------
06-14 16:48:04 DEBUG getLicenseContent(smartbi.framework.FrameworkConfiguration:520) - License file path: H:\Smartbi\Tomcat\bin\Smartbi-License.xml
06-14 16:48:04 DEBUG getLicenseVersion(smartbi.framework.FrameworkConfiguration:441) - License  Version: V9
06-14 16:48:04 DEBUG activate(smartbi.repository.DAOModule:137) - InputArguments:"-Djava.util.logging.config.file=H:\Smartbi\Tomcat\conf\logging.properties" "-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager" "-Xms128m" "-Xmx2048m" "-Dfile.encoding=GBK" "-Duser.region=CN" "-Duser.language=zh" "-Djava.awt.headless=true" "-XX:MaxMetaspaceSize=512m" "-XX:-OmitStackTraceInFastThrow" "-Xloggc:H:\Smartbi\Tomcat\bin\gc.log" "-Dmail.mime.splitlongparameters=false" "-XX:+HeapDumpOnOutOfMemoryError" "-Dlog4j.configuration=log4j.properties" "-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager" "-Djava.endorsed.dirs=H:\Smartbi\Tomcat\endorsed" "-Dcatalina.base=H:\Smartbi\Tomcat" "-Dcatalina.home=H:\Smartbi\Tomcat" "-Djava.io.tmpdir=H:\Smartbi\Tomcat\temp"
06-14 16:48:04 DEBUG activate(smartbi.repository.DAOModule:154) - Repository Info: [user]=admin;[password]=********;[driver]=com.mysql.jdbc.Driver;[URL]=jdbc:mysql://localhost:6688/smartbidemo?useUnicode=true&useOldAliasMetadataBehavior=true&zeroDateTimeBehavior=convertToNull&characterEncoding=GBK&autoReconnect=true&useServerPrepStmts=true
06-14 16:48:08 DEBUG initFontDir(smartbi.util.OfficeUtil:120) - Fonts dir: H:\Smartbi\Tomcat\bin\Font-smartbi
06-14 16:48:31 ERROR activate(smartbi.framework.Framework:153) - 创建知识库连接失败,请联系管理员
创建知识库连接失败,请联系管理员
        at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:151)
        at ...(...)
        at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:149)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
        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:919)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
        at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2095)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2020)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
        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.ConnectionImpl.getInstance(ConnectionImpl.java:385)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
        at smartbi.repository.RepositoryUpgradeHelper.upgradeRepository(RepositoryUpgradeHelper.java:149)
        at smartbi.repository.DAOModule.postActivate(DAOModule.java:198)
        at smartbi.framework.Framework.activate(Smartbi:135)
        at smartbi.extension.spring.SmartbiContextLoaderListener.contextInitialized(SmartbiContextLoaderListener.java:154)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4689)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5155)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:743)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:719)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:705)
        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1125)
        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1858)
        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)
        at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        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.SQLError.createCommunicationsException(SQLError.java:990)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2187)
        at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2036)
        ... 27 more
Caused by: java.net.ConnectException: Connection refused: connect
        at java.net.DualStackPlainSocketImpl.connect0(Native Method)
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:299)
        ... 29 more
06-14 16:48:31 DEBUG processInitParams(smartbi.freequery.filter.Filter:156) - Suppression of stack traces enabled for smartbi.freequery.filter.GZIPFilter
06-14 16:48:31 DEBUG processInitParams(smartbi.freequery.filter.Filter:156) - Suppression of stack traces enabled for smartbi.freequery.filter.ETagFilter
06-14 16:48:31  INFO prepareRepository(org.apache.axis2.deployment.DeploymentEngine:934) - No modules directory was found under H:\Smartbi\Tomcat\webapps\smartbi\WEB-INF.
06-14 16:48:32  WARN processMethods(org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator:302) - We don't support method overloading. Ignoring [executeReport]
06-14 16:48:32  INFO deploy(org.apache.axis2.deployment.ServiceDeployer:91) - Deploying Web service: SmartbiService.aar - file:/H:/Smartbi/Tomcat/webapps/smartbi/WEB-INF/services/SmartbiService.aar
14-Jun-2021 16:48:32.972 信息 [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Web应用程序目录[H:\Smartbi\Tomcat\webapps\smartbi]的部署已在[98,869]毫秒内完成
14-Jun-2021 16:48:32.972 信息 [main] org.apache.coyote.AbstractProtocol.start 开始协议处理句柄["http-nio-18080"]
14-Jun-2021 16:48:32.987 信息 [main] org.apache.catalina.startup.Catalina.start Server startup in 106463 ms
06-14 16:52:34 ERROR exceptionToString(smartbi.framework.rmi.RMIServlet:344) - BIConfigService.testConnection error.
连接失败:SQL错误:Could not create connection to database server. Attempted reconnect 3 times. Giving up.
        at smartbi.config.BIConfigService.testConnection(BIConfigService.java:1796)
        at ...(...)
        at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:45)
Caused by: java.sql.SQLException: SQL错误:Could not create connection to database server. Attempted reconnect 3 times. Giving up.
        at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:45)
        at smartbi.connectionpool.ConnectionPool.doGetConnection(ConnectionPool.java:455)
        at smartbi.connectionpool.ConnectionPool.driverConnect(ConnectionPool.java:339)
        at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:535)
        at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:496)
        at smartbi.connectionpool.RepositoryConnectionProvider.getConnection(RepositoryConnectionProvider.java:48)
        at smartbi.config.BIConfigService.testConnection(BIConfigService.java:1792)
        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:118)
        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:163)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:152)
        at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:70)
        at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:152)
        at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:175)
        at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.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.rmi.TransactionFilter.doFilter(Smartbi:80)
        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:56)
        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)
Caused by: SQL错误:Could not create connection to database server. Attempted reconnect 3 times. Giving up.
        at smartbi.connectionpool.ConnectionPool$5.createConnectionInner(ConnectionPool.java:764)
        at smartbi.connectionpool.ConnectionPool$5.createConnection(ConnectionPool.java:797)
        at smartbi.connectionpool.SmartbiPoolableConnectionFactory.makeObjectInternal(SmartbiPoolableConnectionFactory.java:75)
        at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:35)
        ... 61 more



2710260c71a358f805.png
发表于 2021-6-14 16:59:16
{"retCode":"CLIENT_USER_NOT_LOGIN","result":"尚未登录或会话已超时","stackTrace":"尚未登录或会话已超时\r\n\tat smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:147)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:56)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat smartbi.framework.RedisSessionFilter.doFilter(Smartbi:125)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n\tat org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:543)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)\r\n\tat org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)\r\n\tat org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:615)\r\n\tat org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)\r\n\tat org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818)\r\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1626)\r\n\tat org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n\tat org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)\r\n\tat java.lang.Thread.run(Thread.java:748)\r\n"}
回复

使用道具 举报

发表于 2021-6-16 14:20:44
知识库无法连接,检查下Mysql的服务是否正常启动。可以在操作系统的“服务”里面查看。并且用jdbc工具如navicate连一下试试
回复

使用道具 举报

发表于 2021-6-18 15:37:28
我这边解决了,但是有问题,smart mysql 的服务要自己启动才行
回复

使用道具 举报

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

本版积分规则

快速回复 返回顶部 返回列表