core-auth.log 81 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977
  1. 2020-09-03 08:34:26,951 WARN [LOAD-USERS] load failed
  2. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3001ms.
  3. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  4. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  5. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  6. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  7. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  8. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  9. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  10. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  11. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  12. at com.alibaba.nacos.config.server.auth.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:135)
  13. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:88)
  14. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:54)
  15. at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
  16. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  17. at java.lang.reflect.Method.invoke(Method.java:498)
  18. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  19. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  20. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  21. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  22. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  23. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  24. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  25. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  26. at java.lang.Thread.run(Thread.java:748)
  27. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3001ms.
  28. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  29. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  30. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  31. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  32. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  33. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  34. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  35. ... 23 common frames omitted
  36. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  37. The last packet successfully received from the server was 2,154,364 milliseconds ago. The last packet sent successfully to the server was 2,154,449 milliseconds ago.
  38. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  39. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  40. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
  41. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
  42. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:165)
  43. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  44. ... 28 common frames omitted
  45. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  46. The last packet successfully received from the server was 2,154,364 milliseconds ago. The last packet sent successfully to the server was 2,154,449 milliseconds ago.
  47. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  48. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  49. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  50. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  51. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  52. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  53. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  54. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  55. at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:593)
  56. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:654)
  57. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986)
  58. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:921)
  59. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1165)
  60. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:742)
  61. ... 31 common frames omitted
  62. Caused by: java.net.SocketException: Connection reset by peer: socket write error
  63. at java.net.SocketOutputStream.socketWrite0(Native Method)
  64. at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
  65. at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
  66. at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
  67. at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
  68. at com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:55)
  69. at com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:50)
  70. at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:584)
  71. ... 36 common frames omitted
  72. 2020-09-03 08:34:29,953 WARN [LOAD-ROLES] load failed
  73. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  74. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  75. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  76. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  77. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  78. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  79. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  80. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  81. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  82. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  83. at com.alibaba.nacos.config.server.auth.ExternalRolePersistServiceImpl.getRolesByUserName(ExternalRolePersistServiceImpl.java:98)
  84. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:77)
  85. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  86. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  87. at java.lang.reflect.Method.invoke(Method.java:498)
  88. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  89. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  90. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  91. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  92. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  93. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  94. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  95. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  96. at java.lang.Thread.run(Thread.java:748)
  97. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  98. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  99. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  100. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  101. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  102. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  103. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  104. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  105. ... 22 common frames omitted
  106. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  107. The last packet successfully received from the server was 2,154,364 milliseconds ago. The last packet sent successfully to the server was 2,154,449 milliseconds ago.
  108. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  109. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  110. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
  111. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
  112. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:165)
  113. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  114. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  115. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  116. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  117. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  118. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  119. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  120. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  121. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  122. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  123. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  124. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  125. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  126. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  127. at com.alibaba.nacos.config.server.auth.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:135)
  128. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:88)
  129. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:54)
  130. at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
  131. ... 11 common frames omitted
  132. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  133. The last packet successfully received from the server was 2,154,364 milliseconds ago. The last packet sent successfully to the server was 2,154,449 milliseconds ago.
  134. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  135. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  136. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  137. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  138. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  139. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  140. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  141. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  142. at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:593)
  143. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:654)
  144. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986)
  145. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:921)
  146. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1165)
  147. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:742)
  148. ... 31 common frames omitted
  149. Caused by: java.net.SocketException: Connection reset by peer: socket write error
  150. at java.net.SocketOutputStream.socketWrite0(Native Method)
  151. at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
  152. at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
  153. at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
  154. at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
  155. at com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:55)
  156. at com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:50)
  157. at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:584)
  158. ... 36 common frames omitted
  159. 2020-09-03 08:34:44,954 WARN [LOAD-USERS] load failed
  160. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  161. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  162. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  163. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  164. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  165. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  166. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  167. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  168. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  169. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  170. at com.alibaba.nacos.config.server.auth.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:135)
  171. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:88)
  172. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:54)
  173. at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
  174. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  175. at java.lang.reflect.Method.invoke(Method.java:498)
  176. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  177. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  178. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  179. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  180. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  181. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  182. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  183. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  184. at java.lang.Thread.run(Thread.java:748)
  185. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  186. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  187. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  188. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  189. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  190. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  191. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  192. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  193. ... 23 common frames omitted
  194. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  195. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  196. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  197. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  198. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  199. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  200. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
  201. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
  202. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  203. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  204. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  205. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  206. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
  207. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
  208. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
  209. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  210. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:719)
  211. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:705)
  212. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  213. ... 3 common frames omitted
  214. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  215. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  216. at sun.reflect.GeneratedConstructorAccessor90.newInstance(Unknown Source)
  217. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  218. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  219. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  220. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  221. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  222. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  223. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
  224. at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
  225. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
  226. ... 15 common frames omitted
  227. Caused by: java.net.NoRouteToHostException: No route to host: connect
  228. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  229. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  230. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  231. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  232. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  233. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  234. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  235. at java.net.Socket.connect(Socket.java:606)
  236. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
  237. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
  238. ... 17 common frames omitted
  239. 2020-09-03 08:34:47,956 WARN [LOAD-ROLES] load failed
  240. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  241. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  242. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  243. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  244. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  245. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  246. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  247. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  248. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  249. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  250. at com.alibaba.nacos.config.server.auth.ExternalRolePersistServiceImpl.getRolesByUserName(ExternalRolePersistServiceImpl.java:98)
  251. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:77)
  252. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  253. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  254. at java.lang.reflect.Method.invoke(Method.java:498)
  255. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  256. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  257. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  258. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  259. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  260. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  261. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  262. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  263. at java.lang.Thread.run(Thread.java:748)
  264. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  265. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  266. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  267. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  268. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  269. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  270. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  271. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  272. ... 22 common frames omitted
  273. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  274. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  275. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  276. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  277. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  278. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  279. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
  280. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
  281. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  282. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  283. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  284. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  285. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
  286. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
  287. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
  288. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  289. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:719)
  290. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:705)
  291. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  292. ... 3 common frames omitted
  293. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  294. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  295. at sun.reflect.GeneratedConstructorAccessor90.newInstance(Unknown Source)
  296. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  297. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  298. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  299. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  300. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  301. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  302. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
  303. at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
  304. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
  305. ... 15 common frames omitted
  306. Caused by: java.net.NoRouteToHostException: No route to host: connect
  307. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  308. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  309. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  310. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  311. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  312. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  313. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  314. at java.net.Socket.connect(Socket.java:606)
  315. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
  316. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
  317. ... 17 common frames omitted
  318. 2020-09-03 08:35:02,957 WARN [LOAD-USERS] load failed
  319. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  320. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  321. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  322. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  323. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  324. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  325. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  326. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  327. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  328. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  329. at com.alibaba.nacos.config.server.auth.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:135)
  330. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:88)
  331. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:54)
  332. at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
  333. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  334. at java.lang.reflect.Method.invoke(Method.java:498)
  335. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  336. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  337. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  338. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  339. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  340. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  341. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  342. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  343. at java.lang.Thread.run(Thread.java:748)
  344. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  345. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  346. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  347. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  348. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  349. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  350. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  351. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  352. ... 23 common frames omitted
  353. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  354. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  355. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  356. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  357. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  358. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  359. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
  360. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
  361. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  362. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  363. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  364. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  365. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
  366. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
  367. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
  368. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  369. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:719)
  370. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:705)
  371. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  372. ... 3 common frames omitted
  373. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  374. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  375. at sun.reflect.GeneratedConstructorAccessor90.newInstance(Unknown Source)
  376. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  377. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  378. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  379. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  380. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  381. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  382. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
  383. at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
  384. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
  385. ... 15 common frames omitted
  386. Caused by: java.net.NoRouteToHostException: No route to host: connect
  387. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  388. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  389. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  390. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  391. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  392. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  393. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  394. at java.net.Socket.connect(Socket.java:606)
  395. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
  396. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
  397. ... 17 common frames omitted
  398. 2020-09-03 08:35:05,959 WARN [LOAD-ROLES] load failed
  399. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  400. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  401. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  402. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  403. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  404. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  405. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  406. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  407. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  408. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  409. at com.alibaba.nacos.config.server.auth.ExternalRolePersistServiceImpl.getRolesByUserName(ExternalRolePersistServiceImpl.java:98)
  410. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:77)
  411. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  412. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  413. at java.lang.reflect.Method.invoke(Method.java:498)
  414. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  415. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  416. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  417. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  418. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  419. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  420. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  421. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  422. at java.lang.Thread.run(Thread.java:748)
  423. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  424. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  425. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  426. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  427. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  428. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  429. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  430. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  431. ... 22 common frames omitted
  432. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  433. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  434. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  435. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  436. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  437. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  438. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
  439. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
  440. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  441. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  442. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  443. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  444. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
  445. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
  446. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
  447. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  448. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:719)
  449. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:705)
  450. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  451. ... 3 common frames omitted
  452. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  453. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  454. at sun.reflect.GeneratedConstructorAccessor90.newInstance(Unknown Source)
  455. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  456. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  457. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  458. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  459. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  460. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  461. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
  462. at com.mysql.cj.NativeSession.connect(NativeSession.java:152)
  463. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
  464. ... 15 common frames omitted
  465. Caused by: java.net.NoRouteToHostException: No route to host: connect
  466. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  467. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  468. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  469. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  470. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  471. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  472. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  473. at java.net.Socket.connect(Socket.java:606)
  474. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
  475. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
  476. ... 17 common frames omitted
  477. 2020-09-03 08:35:20,961 WARN [LOAD-USERS] load failed
  478. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  479. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  480. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  481. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  482. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  483. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  484. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  485. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  486. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  487. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  488. at com.alibaba.nacos.config.server.auth.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:135)
  489. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:88)
  490. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:54)
  491. at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
  492. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  493. at java.lang.reflect.Method.invoke(Method.java:498)
  494. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  495. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  496. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  497. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  498. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  499. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  500. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  501. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  502. at java.lang.Thread.run(Thread.java:748)
  503. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  504. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  505. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  506. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  507. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  508. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  509. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  510. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  511. ... 23 common frames omitted
  512. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  513. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  514. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  515. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  516. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  517. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  518. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
  519. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
  520. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  521. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  522. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  523. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  524. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
  525. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
  526. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
  527. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  528. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:719)
  529. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:705)
  530. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  531. ... 3 common frames omitted
  532. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  533. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  534. at sun.reflect.GeneratedConstructorAccessor90.newInstance(Unknown Source)
  535. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  536. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  537. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  538. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  539. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  540. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  541. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562)
  542. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732)
  543. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:709)
  544. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:132)
  545. at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:540)
  546. at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202)
  547. at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1452)
  548. at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
  549. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
  550. ... 15 common frames omitted
  551. Caused by: java.net.SocketException: Connection reset
  552. at java.net.SocketInputStream.read(SocketInputStream.java:210)
  553. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  554. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  555. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  556. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  557. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  558. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  559. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  560. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  561. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556)
  562. ... 23 common frames omitted
  563. 2020-09-03 08:35:23,963 WARN [LOAD-ROLES] load failed
  564. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  565. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  566. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  567. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  568. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  569. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  570. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  571. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  572. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  573. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  574. at com.alibaba.nacos.config.server.auth.ExternalRolePersistServiceImpl.getRolesByUserName(ExternalRolePersistServiceImpl.java:98)
  575. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:77)
  576. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  577. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  578. at java.lang.reflect.Method.invoke(Method.java:498)
  579. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  580. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  581. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  582. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  583. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  584. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  585. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  586. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  587. at java.lang.Thread.run(Thread.java:748)
  588. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3000ms.
  589. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  590. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  591. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  592. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  593. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  594. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  595. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  596. ... 22 common frames omitted
  597. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  598. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  599. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  600. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  601. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  602. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  603. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
  604. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
  605. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  606. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  607. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  608. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  609. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
  610. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
  611. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
  612. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  613. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:719)
  614. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:705)
  615. at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  616. ... 3 common frames omitted
  617. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  618. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  619. at sun.reflect.GeneratedConstructorAccessor90.newInstance(Unknown Source)
  620. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  621. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  622. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  623. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  624. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  625. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  626. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562)
  627. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732)
  628. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:709)
  629. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:132)
  630. at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:540)
  631. at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202)
  632. at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1452)
  633. at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
  634. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
  635. ... 15 common frames omitted
  636. Caused by: java.net.SocketException: Connection reset
  637. at java.net.SocketInputStream.read(SocketInputStream.java:210)
  638. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  639. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  640. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  641. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  642. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  643. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  644. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  645. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  646. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556)
  647. ... 23 common frames omitted
  648. 2020-09-03 10:54:43,075 WARN [LOAD-ROLES] load failed
  649. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 23809ms.
  650. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  651. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  652. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  653. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  654. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  655. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  656. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  657. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  658. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  659. at com.alibaba.nacos.config.server.auth.ExternalRolePersistServiceImpl.getRolesByUserName(ExternalRolePersistServiceImpl.java:98)
  660. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:77)
  661. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  662. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  663. at java.lang.reflect.Method.invoke(Method.java:498)
  664. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  665. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  666. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  667. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  668. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  669. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  670. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  671. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  672. at java.lang.Thread.run(Thread.java:748)
  673. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 23809ms.
  674. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  675. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  676. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  677. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  678. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  679. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  680. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  681. ... 22 common frames omitted
  682. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  683. The last packet successfully received from the server was 38,679 milliseconds ago. The last packet sent successfully to the server was 38,743 milliseconds ago.
  684. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  685. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  686. at com.mysql.cj.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:2448)
  687. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:738)
  688. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
  689. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:165)
  690. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  691. ... 27 common frames omitted
  692. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  693. The last packet successfully received from the server was 38,679 milliseconds ago. The last packet sent successfully to the server was 38,743 milliseconds ago.
  694. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  695. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  696. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  697. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  698. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  699. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  700. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  701. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  702. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562)
  703. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732)
  704. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671)
  705. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986)
  706. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:921)
  707. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1165)
  708. at com.mysql.cj.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:2444)
  709. ... 31 common frames omitted
  710. Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  711. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67)
  712. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  713. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  714. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  715. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  716. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  717. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  718. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556)
  719. ... 37 common frames omitted
  720. 2020-09-03 10:54:46,077 WARN [LOAD-USERS] load failed
  721. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3001ms.
  722. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
  723. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:612)
  724. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  725. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  726. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  727. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  728. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  729. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  730. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  731. at com.alibaba.nacos.config.server.auth.ExternalUserPersistServiceImpl.getUsers(ExternalUserPersistServiceImpl.java:135)
  732. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.getUsersFromDatabase(NacosUserDetailsServiceImpl.java:88)
  733. at com.alibaba.nacos.console.security.nacos.users.NacosUserDetailsServiceImpl.reload(NacosUserDetailsServiceImpl.java:54)
  734. at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
  735. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  736. at java.lang.reflect.Method.invoke(Method.java:498)
  737. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  738. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  739. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  740. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  741. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  742. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  743. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  744. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  745. at java.lang.Thread.run(Thread.java:748)
  746. Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 3001ms.
  747. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:689)
  748. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:196)
  749. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:161)
  750. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  751. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:151)
  752. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
  753. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
  754. ... 23 common frames omitted
  755. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  756. The last packet successfully received from the server was 1,189,947 milliseconds ago. The last packet sent successfully to the server was 1,190,013 milliseconds ago.
  757. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  758. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  759. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
  760. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
  761. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:165)
  762. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:185)
  763. ... 28 common frames omitted
  764. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  765. The last packet successfully received from the server was 1,189,947 milliseconds ago. The last packet sent successfully to the server was 1,190,013 milliseconds ago.
  766. at sun.reflect.GeneratedConstructorAccessor97.newInstance(Unknown Source)
  767. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  768. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  769. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  770. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  771. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  772. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  773. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562)
  774. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732)
  775. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671)
  776. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986)
  777. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:921)
  778. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1165)
  779. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:742)
  780. ... 31 common frames omitted
  781. Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
  782. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67)
  783. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  784. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  785. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  786. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  787. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  788. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  789. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556)
  790. ... 37 common frames omitted
  791. 2020-09-03 12:43:26,972 WARN [LOAD-ROLES] load failed
  792. org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select role,username from roles where 1=1 limit 0,2147483647]; Communications link failure
  793. The last packet successfully received from the server was 3,001 milliseconds ago. The last packet sent successfully to the server was 3,001 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  794. The last packet successfully received from the server was 3,001 milliseconds ago. The last packet sent successfully to the server was 3,001 milliseconds ago.
  795. at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100)
  796. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  797. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  798. at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
  799. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
  800. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  801. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  802. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  803. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:763)
  804. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:97)
  805. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  806. at com.alibaba.nacos.config.server.auth.ExternalRolePersistServiceImpl.getRolesByUserName(ExternalRolePersistServiceImpl.java:98)
  807. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:77)
  808. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  809. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  810. at java.lang.reflect.Method.invoke(Method.java:498)
  811. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  812. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  813. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  814. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  815. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  816. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  817. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  818. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  819. at java.lang.Thread.run(Thread.java:748)
  820. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  821. The last packet successfully received from the server was 3,001 milliseconds ago. The last packet sent successfully to the server was 3,001 milliseconds ago.
  822. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  823. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  824. at com.mysql.cj.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:2448)
  825. at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
  826. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  827. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  828. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:678)
  829. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
  830. ... 20 common frames omitted
  831. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  832. The last packet successfully received from the server was 3,001 milliseconds ago. The last packet sent successfully to the server was 3,001 milliseconds ago.
  833. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  834. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  835. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  836. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  837. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  838. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  839. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  840. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  841. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562)
  842. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732)
  843. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671)
  844. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986)
  845. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:921)
  846. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1165)
  847. at com.mysql.cj.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:2444)
  848. ... 25 common frames omitted
  849. Caused by: java.net.SocketTimeoutException: Read timed out
  850. at java.net.SocketInputStream.socketRead0(Native Method)
  851. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  852. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  853. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  854. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  855. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  856. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  857. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  858. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  859. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  860. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  861. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  862. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  863. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  864. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  865. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556)
  866. ... 31 common frames omitted
  867. 2020-09-03 12:44:31,121 WARN [LOAD-ROLES] load failed
  868. org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [select count(*) from permissions where role='ROLE_ADMIN' ]; Communications link failure
  869. The last packet successfully received from the server was 3,000 milliseconds ago. The last packet sent successfully to the server was 3,000 milliseconds ago.; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  870. The last packet successfully received from the server was 3,000 milliseconds ago. The last packet sent successfully to the server was 3,000 milliseconds ago.
  871. at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:100)
  872. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
  873. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  874. at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1444)
  875. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632)
  876. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
  877. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
  878. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  879. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:783)
  880. at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:804)
  881. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:66)
  882. at com.alibaba.nacos.config.server.service.repository.extrnal.ExternalStoragePaginationHelperImpl.fetchPage(ExternalStoragePaginationHelperImpl.java:56)
  883. at com.alibaba.nacos.config.server.auth.ExternalPermissionPersistServiceImpl.getPermissions(ExternalPermissionPersistServiceImpl.java:69)
  884. at com.alibaba.nacos.console.security.nacos.roles.NacosRoleServiceImpl.reload(NacosRoleServiceImpl.java:94)
  885. at sun.reflect.GeneratedMethodAccessor132.invoke(Unknown Source)
  886. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  887. at java.lang.reflect.Method.invoke(Method.java:498)
  888. at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
  889. at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
  890. at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  891. at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
  892. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
  893. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
  894. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  895. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  896. at java.lang.Thread.run(Thread.java:748)
  897. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  898. The last packet successfully received from the server was 3,000 milliseconds ago. The last packet sent successfully to the server was 3,000 milliseconds ago.
  899. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  900. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  901. at com.mysql.cj.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:2448)
  902. at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
  903. at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
  904. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
  905. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:678)
  906. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
  907. ... 21 common frames omitted
  908. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  909. The last packet successfully received from the server was 3,000 milliseconds ago. The last packet sent successfully to the server was 3,000 milliseconds ago.
  910. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  911. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  912. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  913. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  914. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  915. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  916. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  917. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  918. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:562)
  919. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:732)
  920. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:671)
  921. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:986)
  922. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:921)
  923. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1165)
  924. at com.mysql.cj.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:2444)
  925. ... 26 common frames omitted
  926. Caused by: java.net.SocketTimeoutException: Read timed out
  927. at java.net.SocketInputStream.socketRead0(Native Method)
  928. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  929. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  930. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  931. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  932. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  933. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  934. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  935. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  936. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  937. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  938. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  939. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  940. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  941. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  942. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:556)
  943. ... 32 common frames omitted