关于#Nacos#的问题，如何解决？

Question

Nacos运行一段时间start.out没报错nacos.log报错

2023-07-03 06:40:07,931 WARN HikariPool-1 - Connection com.mysql.cj.jdbc.ConnectionImpl@1a55a9a5 marked as broken because of SQLSTATE(null), ErrorCode(0)

com.mysql.cj.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113)
    at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1178)
    at com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:111)
    at com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
    at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:475)
    at com.alibaba.nacos.config.server.service.datasource.ExternalDataSourceServiceImpl$CheckDbHealthTask.run(ExternalDataSourceServiceImpl.java:279)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
    at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:833)
2023-07-03 06:40:07,930 WARN HikariPool-1 - Connection com.mysql.cj.jdbc.ConnectionImpl@58fae449 marked as broken because of SQLSTATE(null), ErrorCode(0)

com.mysql.cj.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:113)
    at com.mysql.cj.jdbc.StatementImpl.checkCancelTimeout(StatementImpl.java:2167)
    at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1069)
    at com.mysql.cj.NativeSession.execSQL(NativeSession.java:666)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:930)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1009)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
    at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:651)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)
    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:879)
    at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:901)
    at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
    at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:55)
    at com.alibaba.nacos.plugin.auth.impl.persistence.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:149)
    at com.alibaba.nacos.plugin.auth.impl.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:90)
    at com.alibaba.nacos.plugin.auth.impl.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:56)
    at jdk.internal.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:568)
    at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539)
    at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
    at java.base/java.lang.Thread.run(Thread.java:833)

nacos几分钟后掉线
怎么解决

Answer 1

• 以下回答由chatgpt基于相关博客总结生成:

  根据你提供的信息，问题可能出现在Nacos运行一段时间后的报错和自动掉线的情况。这可以有多种原因，可能是配置错误、数据库连接问题或者其他未知的问题。下面是一些可能的解决方案：

  1. 检查start.out文件和nacos.log文件：

  2. 首先打开start.out文件，查看是否有任何报错信息。如果没有报错信息，则可能是由于nacos.log文件中的报错导致的。接下来查看nacos.log文件中的报错信息，尝试理解报错的原因。

  3. 修改Nacos的运行模式为单机模式：

  4. 打开nacos的bin目录下的start.cmd文件，找到set MODE="cluster"这一行，将其修改为set MODE="standalone"，保存文件。然后重新启动Nacos，看是否问题得到解决。

  5. 检查数据库配置是否正确：

  6. 检查是否已经创建了Nacos所需要的数据库。在MySQL中创建一个名为nacos的数据库。进入nacos/conf目录，使用nacos-mysql.sql文件初始化数据库。同时，确保在application.properties配置文件中的数据库连接信息正确。

  7. 检查数据库连接是否正常：

  8. 在数据库连接信息中，确保使用正确的数据库地址、用户名和密码。可以尝试使用命令行或者可视化工具连接到MySQL数据库，验证连接是否正常。

  以上是可能的解决方案，希望能够帮助你解决问题。如果以上方案都不能解决该问题，可能需要更详细地检查日志以及代码来排查问题。