Digital Office Automation System Backend
Ви не можете вибрати більше 25 тем Теми мають розпочинатися з літери або цифри, можуть містити дефіси (-) і не повинні перевищувати 35 символів.

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781
  1. 2024-08-13 08:31:49 [main] INFO c.x.job.admin.XxlJobAdminApplication - Starting XxlJobAdminApplication using Java 1.8.0_181 on zhushi-wangqiang with PID 7140 (D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes started by Adminis in D:\idea\sy\ruoyi-plus)
  2. 2024-08-13 08:31:49 [main] INFO c.x.job.admin.XxlJobAdminApplication - The following 1 profile is active: "dev"
  3. 2024-08-13 08:31:50 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat initialized with port(s): 9100 (http)
  4. 2024-08-13 08:31:50 [main] INFO o.a.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-9100"]
  5. 2024-08-13 08:31:50 [main] INFO o.a.catalina.core.StandardService - Starting service [Tomcat]
  6. 2024-08-13 08:31:50 [main] INFO o.a.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.71]
  7. 2024-08-13 08:31:50 [main] INFO o.a.c.c.C.[.[.[/xxl-job-admin] - Initializing Spring embedded WebApplicationContext
  8. 2024-08-13 08:31:50 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 1085 ms
  9. 2024-08-13 08:31:51 [main] INFO c.x.j.a.c.scheduler.XxlJobScheduler - >>>>>>>>> init xxl-job admin success.
  10. 2024-08-13 08:31:51 [xxl-job, admin JobFailMonitorHelper] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Starting...
  11. 2024-08-13 08:31:51 [main] INFO o.s.b.a.w.s.WelcomePageHandlerMapping - Adding welcome page template: index
  12. 2024-08-13 08:31:51 [xxl-job, admin JobFailMonitorHelper] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Start completed.
  13. 2024-08-13 08:31:51 [main] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 14 endpoint(s) beneath base path '/actuator'
  14. 2024-08-13 08:31:51 [main] INFO o.a.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-9100"]
  15. 2024-08-13 08:31:51 [main] INFO o.a.c.c.C.[.[.[/xxl-job-admin] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  16. 2024-08-13 08:31:51 [main] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
  17. 2024-08-13 08:31:51 [main] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 1 ms
  18. 2024-08-13 08:31:51 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat started on port(s): 9100 (http) with context path '/xxl-job-admin'
  19. 2024-08-13 08:31:51 [main] INFO c.x.job.admin.XxlJobAdminApplication - Started XxlJobAdminApplication in 2.676 seconds (JVM running for 3.26)
  20. 2024-08-13 08:31:51 [registrationTask1] INFO d.c.b.a.c.r.ApplicationRegistrator - Application registered itself as b155dc8c8b90
  21. 2024-08-13 08:31:56 [xxl-job, admin JobScheduleHelper#scheduleThread] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>> init xxl-job admin scheduler success.
  22. 2024-08-13 09:19:55 [http-nio-9100-exec-4] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@cdc1e53 (Communications link failure
  23. The last packet successfully received from the server was 2,904 milliseconds ago. The last packet sent successfully to the server was 2,904 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  24. 2024-08-13 09:22:09 [xxl-job, admin JobScheduleHelper#scheduleThread] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread stop
  25. 2024-08-13 09:22:10 [xxl-job, admin JobScheduleHelper#ringThread] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#ringThread stop
  26. 2024-08-13 09:22:10 [SpringApplicationShutdownHook] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper stop
  27. 2024-08-13 09:22:10 [xxl-job, admin JobLogReportHelper] INFO c.x.j.a.c.thread.JobLogReportHelper - >>>>>>>>>>> xxl-job, job log report thread stop
  28. 2024-08-13 09:22:10 [xxl-job, admin JobLosedMonitorHelper] INFO c.x.j.a.c.thread.JobCompleteHelper - >>>>>>>>>>> xxl-job, JobLosedMonitorHelper stop
  29. 2024-08-13 09:22:10 [xxl-job, admin JobFailMonitorHelper] INFO c.x.j.a.c.t.JobFailMonitorHelper - >>>>>>>>>>> xxl-job, job fail monitor thread stop
  30. 2024-08-13 09:22:10 [xxl-job, admin JobRegistryMonitorHelper-registryMonitorThread] INFO c.x.j.a.c.thread.JobRegistryHelper - >>>>>>>>>>> xxl-job, job registry monitor thread stop
  31. 2024-08-13 09:22:10 [SpringApplicationShutdownHook] INFO c.x.j.a.c.t.JobTriggerPoolHelper - >>>>>>>>> xxl-job trigger thread pool shutdown success.
  32. 2024-08-13 09:22:10 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Shutdown initiated...
  33. 2024-08-13 09:22:10 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Shutdown completed.
  34. 2024-08-13 09:22:45 [main] INFO c.x.job.admin.XxlJobAdminApplication - Starting XxlJobAdminApplication using Java 1.8.0_181 on zhushi-wangqiang with PID 17960 (D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes started by Adminis in D:\idea\sy\ruoyi-plus)
  35. 2024-08-13 09:22:45 [main] INFO c.x.job.admin.XxlJobAdminApplication - The following 1 profile is active: "dev"
  36. 2024-08-13 09:22:45 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat initialized with port(s): 9100 (http)
  37. 2024-08-13 09:22:45 [main] INFO o.a.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-9100"]
  38. 2024-08-13 09:22:45 [main] INFO o.a.catalina.core.StandardService - Starting service [Tomcat]
  39. 2024-08-13 09:22:45 [main] INFO o.a.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.71]
  40. 2024-08-13 09:22:46 [main] INFO o.a.c.c.C.[.[.[/xxl-job-admin] - Initializing Spring embedded WebApplicationContext
  41. 2024-08-13 09:22:46 [main] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 784 ms
  42. 2024-08-13 09:22:46 [main] INFO c.x.j.a.c.scheduler.XxlJobScheduler - >>>>>>>>> init xxl-job admin success.
  43. 2024-08-13 09:22:46 [xxl-job, admin JobRegistryMonitorHelper-registryMonitorThread] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Starting...
  44. 2024-08-13 09:22:46 [main] INFO o.s.b.a.w.s.WelcomePageHandlerMapping - Adding welcome page template: index
  45. 2024-08-13 09:22:46 [xxl-job, admin JobRegistryMonitorHelper-registryMonitorThread] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Start completed.
  46. 2024-08-13 09:22:46 [main] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 14 endpoint(s) beneath base path '/actuator'
  47. 2024-08-13 09:22:46 [main] INFO o.a.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-9100"]
  48. 2024-08-13 09:22:46 [main] INFO o.a.c.c.C.[.[.[/xxl-job-admin] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  49. 2024-08-13 09:22:46 [main] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
  50. 2024-08-13 09:22:46 [main] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 0 ms
  51. 2024-08-13 09:22:46 [main] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat started on port(s): 9100 (http) with context path '/xxl-job-admin'
  52. 2024-08-13 09:22:46 [main] INFO c.x.job.admin.XxlJobAdminApplication - Started XxlJobAdminApplication in 2.049 seconds (JVM running for 2.582)
  53. 2024-08-13 09:22:46 [registrationTask1] INFO d.c.b.a.c.r.ApplicationRegistrator - Application registered itself as b155dc8c8b90
  54. 2024-08-13 09:22:51 [xxl-job, admin JobScheduleHelper#scheduleThread] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>> init xxl-job admin scheduler success.
  55. 2024-08-13 10:00:01 [http-nio-9100-exec-1] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@47e6080e (Communications link failure
  56. The last packet successfully received from the server was 3,847 milliseconds ago. The last packet sent successfully to the server was 3,848 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  57. 2024-08-13 10:00:02 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@52d71a8c (Communications link failure
  58. The last packet successfully received from the server was 6,009 milliseconds ago. The last packet sent successfully to the server was 6,010 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  59. 2024-08-13 10:55:38 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@58c43df1 (Communications link failure
  60. The last packet successfully received from the server was 6,001 milliseconds ago. The last packet sent successfully to the server was 6,001 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  61. 2024-08-13 11:06:14 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@6b123951 (Communications link failure
  62. The last packet successfully received from the server was 3,134 milliseconds ago. The last packet sent successfully to the server was 3,134 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  63. 2024-08-13 13:11:44 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@1f9991d5 (Communications link failure
  64. The last packet successfully received from the server was 5,306 milliseconds ago. The last packet sent successfully to the server was 5,306 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  65. 2024-08-13 13:11:45 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@55c1a782 (Communications link failure
  66. The last packet successfully received from the server was 5,998 milliseconds ago. The last packet sent successfully to the server was 5,999 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  67. 2024-08-13 13:29:51 [http-nio-9100-exec-5] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@e847841 (Communications link failure
  68. The last packet successfully received from the server was 1,875 milliseconds ago. The last packet sent successfully to the server was 1,875 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  69. 2024-08-13 13:29:52 [xxl-job, admin JobLogReportHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@5e20b608 (Communications link failure
  70. The last packet successfully received from the server was 2,506 milliseconds ago. The last packet sent successfully to the server was 2,507 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  71. 2024-08-13 13:29:52 [xxl-job, admin JobRegistryMonitorHelper-registryMonitorThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@6201853b (Communications link failure
  72. The last packet successfully received from the server was 610,785 milliseconds ago. The last packet sent successfully to the server was 610,785 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  73. 2024-08-13 13:29:52 [http-nio-9100-exec-5] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@20188955 (Communications link failure
  74. The last packet successfully received from the server was 599,306 milliseconds ago. The last packet sent successfully to the server was 599,306 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  75. 2024-08-13 13:50:41 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@3a0f83d2 (Communications link failure
  76. The last packet successfully received from the server was 5,806 milliseconds ago. The last packet sent successfully to the server was 5,806 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  77. 2024-08-13 14:41:58 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@383487ff (Communications link failure
  78. The last packet successfully received from the server was 2,133 milliseconds ago. The last packet sent successfully to the server was 2,133 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  79. 2024-08-13 14:41:59 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@5fd9cfab (Communications link failure
  80. The last packet successfully received from the server was 3,135 milliseconds ago. The last packet sent successfully to the server was 3,136 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  81. 2024-08-13 14:42:00 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@59aee919 (Communications link failure
  82. The last packet successfully received from the server was 771,696 milliseconds ago. The last packet sent successfully to the server was 771,696 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  83. 2024-08-13 14:42:01 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@45b996ac (Communications link failure
  84. The last packet successfully received from the server was 769,942 milliseconds ago. The last packet sent successfully to the server was 769,942 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  85. 2024-08-13 14:42:01 [http-nio-9100-exec-10] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@790fd329 (Communications link failure
  86. The last packet successfully received from the server was 496,658 milliseconds ago. The last packet sent successfully to the server was 496,658 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  87. 2024-08-13 14:42:02 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@10d40d56 (Communications link failure
  88. The last packet successfully received from the server was 465,089 milliseconds ago. The last packet sent successfully to the server was 465,089 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  89. 2024-08-13 14:42:02 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@46ecbef5 (Communications link failure
  90. The last packet successfully received from the server was 451,350 milliseconds ago. The last packet sent successfully to the server was 451,351 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  91. 2024-08-13 14:42:02 [http-nio-9100-exec-10] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@3ba90c05 (Communications link failure
  92. The last packet successfully received from the server was 428,999 milliseconds ago. The last packet sent successfully to the server was 428,999 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  93. 2024-08-13 14:42:03 [xxl-job, admin JobScheduleHelper#scheduleThread] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@4a2e14f4 (Communications link failure
  94. The last packet successfully received from the server was 122,181 milliseconds ago. The last packet sent successfully to the server was 122,181 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  95. 2024-08-13 14:42:03 [xxl-job, admin JobFailMonitorHelper] WARN com.zaxxer.hikari.pool.PoolBase - HikariCP - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@57598514 (Communications link failure
  96. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.). Possibly consider using a shorter maxLifetime value.
  97. 2024-08-13 14:42:07 [xxl-job, admin JobFailMonitorHelper] ERROR c.x.j.a.c.t.JobFailMonitorHelper - >>>>>>>>>>> xxl-job, job fail monitor thread error:{}
  98. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
  99. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10012ms.
  100. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  101. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findFailJobLogIds
  102. ### The error occurred while executing a query
  103. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10012ms.
  104. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
  105. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  106. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  107. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  108. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  109. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  110. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  111. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  112. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  113. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  114. at java.lang.Thread.run(Thread.java:748)
  115. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  116. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10012ms.
  117. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  118. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findFailJobLogIds
  119. ### The error occurred while executing a query
  120. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10012ms.
  121. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  122. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  123. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  124. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  125. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  126. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  127. at java.lang.reflect.Method.invoke(Method.java:498)
  128. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  129. ... 9 common frames omitted
  130. Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10012ms.
  131. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  132. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  133. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  134. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  135. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  136. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  137. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  138. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  139. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  140. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  141. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  142. ... 15 common frames omitted
  143. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10012ms.
  144. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  145. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  146. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  147. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  148. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  149. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  150. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  151. ... 25 common frames omitted
  152. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  153. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  154. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  155. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  156. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  157. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  158. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  159. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  160. ... 30 common frames omitted
  161. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  162. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  163. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  164. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  165. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  166. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  167. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  168. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  169. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  170. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  171. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  172. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  173. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  174. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  175. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  176. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  177. ... 33 common frames omitted
  178. Caused by: java.net.SocketTimeoutException: Read timed out
  179. at java.net.SocketInputStream.socketRead0(Native Method)
  180. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  181. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  182. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  183. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  184. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  185. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  186. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  187. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  188. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  189. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  190. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  191. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  192. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  193. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  194. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  195. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  196. ... 39 common frames omitted
  197. 2024-08-13 14:42:10 [http-nio-9100-exec-10] WARN o.s.b.a.j.DataSourceHealthIndicator - DataSource health check failed
  198. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10003ms.
  199. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  200. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:330)
  201. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:122)
  202. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:105)
  203. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:100)
  204. at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82)
  205. at org.springframework.boot.actuate.health.HealthIndicator.getHealth(HealthIndicator.java:37)
  206. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:104)
  207. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:46)
  208. at org.springframework.boot.actuate.health.HealthEndpointSupport.getLoggedHealth(HealthEndpointSupport.java:172)
  209. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:145)
  210. at org.springframework.boot.actuate.health.HealthEndpointSupport.getAggregateContribution(HealthEndpointSupport.java:156)
  211. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:141)
  212. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:110)
  213. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:81)
  214. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:90)
  215. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:79)
  216. at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
  217. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  218. at java.lang.reflect.Method.invoke(Method.java:498)
  219. at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282)
  220. at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:74)
  221. at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:60)
  222. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$ServletWebOperationAdapter.handle(AbstractWebMvcEndpointHandlerMapping.java:357)
  223. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$OperationHandler.handle(AbstractWebMvcEndpointHandlerMapping.java:464)
  224. at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
  225. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  226. at java.lang.reflect.Method.invoke(Method.java:498)
  227. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  228. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  229. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  230. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  231. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  232. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  233. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  234. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  235. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  236. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  237. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  238. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  239. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  240. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  241. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  242. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  243. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  244. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  245. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  246. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  247. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  248. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  249. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  250. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  251. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  252. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  253. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
  254. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  255. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  256. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  257. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  258. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  259. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  260. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  261. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
  262. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  263. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  264. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  265. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  266. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  267. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  268. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  269. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  270. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
  271. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
  272. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  273. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  274. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  275. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  276. at java.lang.Thread.run(Thread.java:748)
  277. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10003ms.
  278. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  279. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  280. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  281. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  282. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  283. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  284. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  285. ... 77 common frames omitted
  286. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  287. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  288. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  289. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  290. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  291. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  292. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  293. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  294. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  295. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  296. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  297. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  298. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  299. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  300. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  301. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  302. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  303. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  304. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  305. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  306. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  307. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  308. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  309. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  310. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  311. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  312. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  313. at java.lang.reflect.Method.invoke(Method.java:498)
  314. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  315. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  316. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  317. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  318. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  319. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  320. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  321. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  322. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  323. ... 1 common frames omitted
  324. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  325. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  326. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  327. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  328. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  329. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  330. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  331. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  332. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  333. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  334. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  335. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  336. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  337. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  338. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  339. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  340. ... 33 common frames omitted
  341. Caused by: java.net.SocketTimeoutException: Read timed out
  342. at java.net.SocketInputStream.socketRead0(Native Method)
  343. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  344. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  345. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  346. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  347. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  348. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  349. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  350. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  351. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  352. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  353. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  354. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  355. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  356. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  357. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  358. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  359. ... 39 common frames omitted
  360. 2024-08-13 14:42:10 [http-nio-9100-exec-10] WARN o.s.b.a.health.HealthEndpointSupport - Health contributor org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator (db) took 10006ms to respond
  361. 2024-08-13 14:42:11 [xxl-job, admin JobScheduleHelper#scheduleThread] ERROR c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread error:{}
  362. java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  363. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  364. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  365. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  366. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  367. at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:70)
  368. at java.lang.Thread.run(Thread.java:748)
  369. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  370. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  371. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  372. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  373. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  374. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  375. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  376. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  377. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  378. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  379. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  380. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  381. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  382. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  383. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  384. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  385. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  386. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  387. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  388. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  389. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  390. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  391. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  392. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  393. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  394. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  395. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  396. at java.lang.reflect.Method.invoke(Method.java:498)
  397. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  398. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  399. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  400. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  401. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  402. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  403. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  404. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  405. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  406. ... 1 common frames omitted
  407. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  408. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  409. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  410. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  411. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  412. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  413. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  414. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  415. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  416. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  417. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  418. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  419. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  420. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  421. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  422. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  423. ... 33 common frames omitted
  424. Caused by: java.net.SocketTimeoutException: Read timed out
  425. at java.net.SocketInputStream.socketRead0(Native Method)
  426. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  427. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  428. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  429. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  430. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  431. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  432. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  433. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  434. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  435. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  436. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  437. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  438. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  439. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  440. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  441. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  442. ... 39 common frames omitted
  443. 2024-08-13 14:42:21 [xxl-job, admin JobScheduleHelper#scheduleThread] ERROR c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread error:{}
  444. java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  445. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  446. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  447. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  448. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  449. at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:70)
  450. at java.lang.Thread.run(Thread.java:748)
  451. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  452. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  453. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  454. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  455. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  456. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  457. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  458. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  459. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  460. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  461. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  462. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  463. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  464. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  465. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  466. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  467. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  468. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  469. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  470. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  471. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  472. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  473. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  474. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  475. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  476. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  477. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  478. at java.lang.reflect.Method.invoke(Method.java:498)
  479. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  480. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  481. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  482. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  483. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  484. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  485. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  486. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  487. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  488. ... 1 common frames omitted
  489. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  490. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  491. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  492. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  493. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  494. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  495. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  496. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  497. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  498. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  499. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  500. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  501. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  502. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  503. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  504. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  505. ... 33 common frames omitted
  506. Caused by: java.net.SocketTimeoutException: Read timed out
  507. at java.net.SocketInputStream.socketRead0(Native Method)
  508. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  509. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  510. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  511. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  512. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  513. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  514. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  515. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  516. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  517. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  518. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  519. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  520. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  521. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  522. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  523. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  524. ... 39 common frames omitted
  525. 2024-08-13 14:42:27 [xxl-job, admin JobFailMonitorHelper] ERROR c.x.j.a.c.t.JobFailMonitorHelper - >>>>>>>>>>> xxl-job, job fail monitor thread error:{}
  526. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
  527. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  528. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  529. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findFailJobLogIds
  530. ### The error occurred while executing a query
  531. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  532. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
  533. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  534. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  535. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  536. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  537. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  538. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  539. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  540. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  541. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  542. at java.lang.Thread.run(Thread.java:748)
  543. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  544. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  545. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  546. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findFailJobLogIds
  547. ### The error occurred while executing a query
  548. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  549. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  550. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  551. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  552. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  553. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  554. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  555. at java.lang.reflect.Method.invoke(Method.java:498)
  556. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  557. ... 9 common frames omitted
  558. Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  559. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  560. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  561. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  562. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  563. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  564. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  565. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  566. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  567. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  568. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  569. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  570. ... 15 common frames omitted
  571. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  572. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  573. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  574. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  575. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  576. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  577. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  578. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  579. ... 25 common frames omitted
  580. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  581. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  582. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  583. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  584. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  585. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  586. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  587. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  588. ... 30 common frames omitted
  589. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  590. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  591. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  592. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  593. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  594. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  595. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  596. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  597. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  598. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  599. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  600. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  601. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  602. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  603. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  604. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  605. ... 33 common frames omitted
  606. Caused by: java.net.SocketTimeoutException: Read timed out
  607. at java.net.SocketInputStream.socketRead0(Native Method)
  608. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  609. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  610. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  611. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  612. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  613. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  614. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  615. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  616. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  617. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  618. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  619. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  620. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  621. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  622. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  623. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  624. ... 39 common frames omitted
  625. 2024-08-13 14:42:30 [http-nio-9100-exec-4] WARN o.s.b.a.j.DataSourceHealthIndicator - DataSource health check failed
  626. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10003ms.
  627. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  628. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:330)
  629. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:122)
  630. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:105)
  631. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:100)
  632. at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82)
  633. at org.springframework.boot.actuate.health.HealthIndicator.getHealth(HealthIndicator.java:37)
  634. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:104)
  635. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:46)
  636. at org.springframework.boot.actuate.health.HealthEndpointSupport.getLoggedHealth(HealthEndpointSupport.java:172)
  637. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:145)
  638. at org.springframework.boot.actuate.health.HealthEndpointSupport.getAggregateContribution(HealthEndpointSupport.java:156)
  639. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:141)
  640. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:110)
  641. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:81)
  642. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:90)
  643. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:79)
  644. at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
  645. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  646. at java.lang.reflect.Method.invoke(Method.java:498)
  647. at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282)
  648. at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:74)
  649. at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:60)
  650. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$ServletWebOperationAdapter.handle(AbstractWebMvcEndpointHandlerMapping.java:357)
  651. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$OperationHandler.handle(AbstractWebMvcEndpointHandlerMapping.java:464)
  652. at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
  653. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  654. at java.lang.reflect.Method.invoke(Method.java:498)
  655. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  656. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  657. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  658. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  659. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  660. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  661. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  662. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  663. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  664. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  665. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  666. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  667. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  668. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  669. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  670. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  671. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  672. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  673. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  674. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  675. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  676. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  677. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  678. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  679. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  680. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  681. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
  682. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  683. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  684. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  685. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  686. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  687. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  688. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  689. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
  690. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  691. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  692. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  693. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  694. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  695. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  696. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  697. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  698. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
  699. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
  700. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  701. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  702. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  703. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  704. at java.lang.Thread.run(Thread.java:748)
  705. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10003ms.
  706. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  707. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  708. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  709. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  710. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  711. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  712. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  713. ... 77 common frames omitted
  714. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  715. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  716. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  717. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  718. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  719. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  720. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  721. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  722. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  723. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  724. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  725. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  726. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  727. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  728. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  729. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  730. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  731. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  732. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  733. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  734. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  735. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  736. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  737. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  738. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  739. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  740. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  741. at java.lang.reflect.Method.invoke(Method.java:498)
  742. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  743. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  744. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  745. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  746. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  747. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  748. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  749. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  750. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  751. ... 1 common frames omitted
  752. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  753. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  754. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  755. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  756. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  757. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  758. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  759. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  760. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  761. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  762. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  763. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  764. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  765. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  766. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  767. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  768. ... 33 common frames omitted
  769. Caused by: java.net.SocketTimeoutException: Read timed out
  770. at java.net.SocketInputStream.socketRead0(Native Method)
  771. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  772. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  773. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  774. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  775. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  776. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  777. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  778. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  779. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  780. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  781. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  782. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  783. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  784. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  785. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  786. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  787. ... 39 common frames omitted
  788. 2024-08-13 14:42:30 [http-nio-9100-exec-4] WARN o.s.b.a.health.HealthEndpointSupport - Health contributor org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator (db) took 10005ms to respond
  789. 2024-08-13 14:42:31 [xxl-job, admin JobScheduleHelper#scheduleThread] ERROR c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread error:{}
  790. java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10007ms.
  791. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  792. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  793. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  794. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  795. at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:70)
  796. at java.lang.Thread.run(Thread.java:748)
  797. Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  798. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  799. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  800. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  801. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763)
  802. at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
  803. at com.zaxxer.hikari.pool.PoolBase.isConnectionAlive(PoolBase.java:169)
  804. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
  805. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  806. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  807. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  808. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  809. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  810. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  811. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  812. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  813. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  814. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  815. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  816. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  817. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  818. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  819. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  820. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  821. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  822. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  823. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  824. at java.lang.reflect.Method.invoke(Method.java:498)
  825. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  826. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  827. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  828. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  829. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  830. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  831. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  832. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  833. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  834. ... 1 common frames omitted
  835. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  836. The last packet successfully received from the server was 67,370 milliseconds ago. The last packet sent successfully to the server was 67,370 milliseconds ago.
  837. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  838. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  839. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  840. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  841. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  842. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  843. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  844. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  845. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  846. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  847. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  848. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  849. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  850. at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:723)
  851. ... 33 common frames omitted
  852. Caused by: java.net.SocketTimeoutException: Read timed out
  853. at java.net.SocketInputStream.socketRead0(Native Method)
  854. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  855. at java.net.SocketInputStream.read(SocketInputStream.java:171)
  856. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  857. at com.mysql.cj.protocol.ReadAheadInputStream.fill(ReadAheadInputStream.java:107)
  858. at com.mysql.cj.protocol.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:150)
  859. at com.mysql.cj.protocol.ReadAheadInputStream.read(ReadAheadInputStream.java:180)
  860. at java.io.FilterInputStream.read(FilterInputStream.java:133)
  861. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  862. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  863. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  864. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  865. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  866. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  867. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  868. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  869. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  870. ... 39 common frames omitted
  871. 2024-08-13 14:42:34 [xxl-job, admin JobRegistryMonitorHelper-registryMonitorThread] ERROR c.x.j.a.c.thread.JobRegistryHelper - >>>>>>>>>>> xxl-job, job registry monitor thread error:{}
  872. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
  873. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  874. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobGroupMapper.xml]
  875. ### The error may involve com.xxl.job.admin.dao.XxlJobGroupDao.findByAddressType
  876. ### The error occurred while executing a query
  877. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  878. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
  879. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  880. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  881. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  882. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  883. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  884. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  885. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  886. at com.sun.proxy.$Proxy78.findByAddressType(Unknown Source)
  887. at com.xxl.job.admin.core.thread.JobRegistryHelper$3.run(JobRegistryHelper.java:64)
  888. at java.lang.Thread.run(Thread.java:748)
  889. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  890. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  891. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobGroupMapper.xml]
  892. ### The error may involve com.xxl.job.admin.dao.XxlJobGroupDao.findByAddressType
  893. ### The error occurred while executing a query
  894. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  895. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  896. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  897. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  898. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  899. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  900. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  901. at java.lang.reflect.Method.invoke(Method.java:498)
  902. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  903. ... 9 common frames omitted
  904. Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  905. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  906. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  907. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  908. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  909. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  910. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  911. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  912. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  913. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  914. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  915. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  916. ... 15 common frames omitted
  917. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  918. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  919. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  920. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  921. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  922. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  923. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  924. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  925. ... 25 common frames omitted
  926. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  927. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  928. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  929. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  930. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  931. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  932. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  933. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  934. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  935. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  936. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  937. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  938. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  939. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  940. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  941. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  942. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  943. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  944. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  945. at java.util.concurrent.FutureTask.run(FutureTask.java)
  946. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  947. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  948. ... 1 common frames omitted
  949. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  950. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  951. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  952. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  953. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  954. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  955. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  956. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  957. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  958. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  959. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  960. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  961. ... 16 common frames omitted
  962. Caused by: java.net.SocketTimeoutException: connect timed out
  963. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  964. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  965. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  966. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  967. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  968. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  969. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  970. at java.net.Socket.connect(Socket.java:589)
  971. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  972. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  973. ... 18 common frames omitted
  974. 2024-08-13 14:42:41 [xxl-job, admin JobScheduleHelper#scheduleThread] ERROR c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread error:{}
  975. java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10006ms.
  976. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  977. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  978. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  979. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  980. at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:70)
  981. at java.lang.Thread.run(Thread.java:748)
  982. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  983. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  984. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  985. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  986. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  987. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  988. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  989. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  990. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  991. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  992. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  993. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  994. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  995. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  996. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  997. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  998. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  999. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1000. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1001. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1002. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1003. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1004. ... 1 common frames omitted
  1005. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1006. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1007. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1008. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1009. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1010. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1011. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1012. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1013. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1014. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1015. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1016. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1017. ... 16 common frames omitted
  1018. Caused by: java.net.SocketTimeoutException: connect timed out
  1019. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1020. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1021. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1022. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1023. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1024. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1025. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1026. at java.net.Socket.connect(Socket.java:589)
  1027. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1028. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1029. ... 18 common frames omitted
  1030. 2024-08-13 14:42:47 [xxl-job, admin JobFailMonitorHelper] ERROR c.x.j.a.c.t.JobFailMonitorHelper - >>>>>>>>>>> xxl-job, job fail monitor thread error:{}
  1031. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
  1032. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  1033. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  1034. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findFailJobLogIds
  1035. ### The error occurred while executing a query
  1036. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  1037. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
  1038. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  1039. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  1040. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  1041. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  1042. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  1043. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  1044. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  1045. at com.sun.proxy.$Proxy80.findFailJobLogIds(Unknown Source)
  1046. at com.xxl.job.admin.core.thread.JobFailMonitorHelper$1.run(JobFailMonitorHelper.java:43)
  1047. at java.lang.Thread.run(Thread.java:748)
  1048. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  1049. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  1050. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  1051. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findFailJobLogIds
  1052. ### The error occurred while executing a query
  1053. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  1054. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  1055. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  1056. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  1057. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  1058. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  1059. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1060. at java.lang.reflect.Method.invoke(Method.java:498)
  1061. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  1062. ... 9 common frames omitted
  1063. Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  1064. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  1065. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  1066. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  1067. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  1068. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  1069. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  1070. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  1071. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  1072. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  1073. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  1074. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  1075. ... 15 common frames omitted
  1076. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10010ms.
  1077. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1078. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1079. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1080. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1081. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  1082. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  1083. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  1084. ... 25 common frames omitted
  1085. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1086. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1087. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1088. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1089. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1090. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1091. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1092. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1093. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1094. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1095. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1096. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1097. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1098. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1099. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1100. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1101. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1102. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1103. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1104. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1105. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1106. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1107. ... 1 common frames omitted
  1108. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1109. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1110. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1111. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1112. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1113. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1114. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1115. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1116. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1117. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1118. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1119. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1120. ... 16 common frames omitted
  1121. Caused by: java.net.SocketTimeoutException: connect timed out
  1122. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1123. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1124. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1125. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1126. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1127. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1128. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1129. at java.net.Socket.connect(Socket.java:589)
  1130. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1131. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1132. ... 18 common frames omitted
  1133. 2024-08-13 14:42:50 [http-nio-9100-exec-6] WARN o.s.b.a.j.DataSourceHealthIndicator - DataSource health check failed
  1134. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10013ms.
  1135. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  1136. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:330)
  1137. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:122)
  1138. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:105)
  1139. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:100)
  1140. at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82)
  1141. at org.springframework.boot.actuate.health.HealthIndicator.getHealth(HealthIndicator.java:37)
  1142. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:104)
  1143. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:46)
  1144. at org.springframework.boot.actuate.health.HealthEndpointSupport.getLoggedHealth(HealthEndpointSupport.java:172)
  1145. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:145)
  1146. at org.springframework.boot.actuate.health.HealthEndpointSupport.getAggregateContribution(HealthEndpointSupport.java:156)
  1147. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:141)
  1148. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:110)
  1149. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:81)
  1150. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:90)
  1151. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:79)
  1152. at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
  1153. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1154. at java.lang.reflect.Method.invoke(Method.java:498)
  1155. at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282)
  1156. at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:74)
  1157. at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:60)
  1158. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$ServletWebOperationAdapter.handle(AbstractWebMvcEndpointHandlerMapping.java:357)
  1159. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$OperationHandler.handle(AbstractWebMvcEndpointHandlerMapping.java:464)
  1160. at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
  1161. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1162. at java.lang.reflect.Method.invoke(Method.java:498)
  1163. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  1164. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  1165. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1166. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  1167. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  1168. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1169. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  1170. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  1171. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  1172. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  1173. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  1174. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  1175. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  1176. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  1177. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1178. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  1179. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1180. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1181. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  1182. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1183. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1184. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1185. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1186. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1187. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1188. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1189. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
  1190. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1191. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1192. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1193. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1194. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1195. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1196. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1197. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
  1198. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  1199. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  1200. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  1201. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  1202. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  1203. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  1204. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  1205. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  1206. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
  1207. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
  1208. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  1209. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  1210. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  1211. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  1212. at java.lang.Thread.run(Thread.java:748)
  1213. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10013ms.
  1214. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1215. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1216. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1217. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1218. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  1219. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  1220. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  1221. ... 77 common frames omitted
  1222. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1223. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1224. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1225. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1226. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1227. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1228. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1229. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1230. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1231. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1232. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1233. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1234. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1235. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1236. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1237. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1238. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1239. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1240. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1241. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1242. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1243. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1244. ... 1 common frames omitted
  1245. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1246. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1247. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1248. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1249. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1250. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1251. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1252. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1253. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1254. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1255. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1256. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1257. ... 16 common frames omitted
  1258. Caused by: java.net.SocketTimeoutException: connect timed out
  1259. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1260. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1261. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1262. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1263. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1264. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1265. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1266. at java.net.Socket.connect(Socket.java:589)
  1267. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1268. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1269. ... 18 common frames omitted
  1270. 2024-08-13 14:42:50 [http-nio-9100-exec-6] WARN o.s.b.a.health.HealthEndpointSupport - Health contributor org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator (db) took 10017ms to respond
  1271. 2024-08-13 14:42:51 [xxl-job, admin JobScheduleHelper#scheduleThread] ERROR c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread error:{}
  1272. java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10005ms.
  1273. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1274. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1275. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1276. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1277. at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:70)
  1278. at java.lang.Thread.run(Thread.java:748)
  1279. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1280. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1281. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1282. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1283. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1284. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1285. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1286. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1287. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1288. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1289. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1290. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1291. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1292. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1293. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1294. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1295. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1296. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1297. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1298. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1299. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1300. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1301. ... 1 common frames omitted
  1302. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1303. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1304. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1305. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1306. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1307. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1308. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1309. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1310. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1311. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1312. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1313. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1314. ... 16 common frames omitted
  1315. Caused by: java.net.SocketTimeoutException: connect timed out
  1316. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1317. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1318. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1319. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1320. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1321. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1322. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1323. at java.net.Socket.connect(Socket.java:589)
  1324. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1325. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1326. ... 18 common frames omitted
  1327. 2024-08-13 14:42:58 [xxl-job, admin JobLosedMonitorHelper] ERROR c.x.j.a.c.thread.JobCompleteHelper - >>>>>>>>>>> xxl-job, job fail monitor thread error:{}
  1328. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
  1329. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  1330. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  1331. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findLostJobIds
  1332. ### The error occurred while executing a query
  1333. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  1334. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
  1335. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  1336. at com.sun.proxy.$Proxy77.selectList(Unknown Source)
  1337. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  1338. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  1339. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  1340. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  1341. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  1342. at com.sun.proxy.$Proxy80.findLostJobIds(Unknown Source)
  1343. at com.xxl.job.admin.core.thread.JobCompleteHelper$3.run(JobCompleteHelper.java:81)
  1344. at java.lang.Thread.run(Thread.java:748)
  1345. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  1346. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  1347. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  1348. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findLostJobIds
  1349. ### The error occurred while executing a query
  1350. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  1351. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  1352. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  1353. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  1354. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  1355. at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
  1356. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1357. at java.lang.reflect.Method.invoke(Method.java:498)
  1358. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  1359. ... 9 common frames omitted
  1360. Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  1361. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  1362. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  1363. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  1364. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  1365. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  1366. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  1367. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  1368. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  1369. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  1370. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  1371. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  1372. ... 15 common frames omitted
  1373. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10000ms.
  1374. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1375. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1376. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1377. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1378. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  1379. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  1380. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  1381. ... 25 common frames omitted
  1382. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1383. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1384. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1385. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1386. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1387. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1388. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1389. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1390. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1391. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1392. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1393. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1394. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1395. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1396. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1397. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1398. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1399. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1400. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1401. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1402. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1403. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1404. ... 1 common frames omitted
  1405. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1406. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1407. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1408. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1409. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1410. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1411. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1412. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1413. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1414. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1415. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1416. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1417. ... 16 common frames omitted
  1418. Caused by: java.net.SocketTimeoutException: connect timed out
  1419. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1420. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1421. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1422. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1423. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1424. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1425. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1426. at java.net.Socket.connect(Socket.java:589)
  1427. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1428. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1429. ... 18 common frames omitted
  1430. 2024-08-13 14:43:00 [http-nio-9100-exec-7] WARN o.s.b.a.j.DataSourceHealthIndicator - DataSource health check failed
  1431. org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10008ms.
  1432. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  1433. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:330)
  1434. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.getProduct(DataSourceHealthIndicator.java:122)
  1435. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doDataSourceHealthCheck(DataSourceHealthIndicator.java:105)
  1436. at org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator.doHealthCheck(DataSourceHealthIndicator.java:100)
  1437. at org.springframework.boot.actuate.health.AbstractHealthIndicator.health(AbstractHealthIndicator.java:82)
  1438. at org.springframework.boot.actuate.health.HealthIndicator.getHealth(HealthIndicator.java:37)
  1439. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:104)
  1440. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.getHealth(HealthEndpointWebExtension.java:46)
  1441. at org.springframework.boot.actuate.health.HealthEndpointSupport.getLoggedHealth(HealthEndpointSupport.java:172)
  1442. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:145)
  1443. at org.springframework.boot.actuate.health.HealthEndpointSupport.getAggregateContribution(HealthEndpointSupport.java:156)
  1444. at org.springframework.boot.actuate.health.HealthEndpointSupport.getContribution(HealthEndpointSupport.java:141)
  1445. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:110)
  1446. at org.springframework.boot.actuate.health.HealthEndpointSupport.getHealth(HealthEndpointSupport.java:81)
  1447. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:90)
  1448. at org.springframework.boot.actuate.health.HealthEndpointWebExtension.health(HealthEndpointWebExtension.java:79)
  1449. at sun.reflect.GeneratedMethodAccessor50.invoke(Unknown Source)
  1450. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1451. at java.lang.reflect.Method.invoke(Method.java:498)
  1452. at org.springframework.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:282)
  1453. at org.springframework.boot.actuate.endpoint.invoke.reflect.ReflectiveOperationInvoker.invoke(ReflectiveOperationInvoker.java:74)
  1454. at org.springframework.boot.actuate.endpoint.annotation.AbstractDiscoveredOperation.invoke(AbstractDiscoveredOperation.java:60)
  1455. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$ServletWebOperationAdapter.handle(AbstractWebMvcEndpointHandlerMapping.java:357)
  1456. at org.springframework.boot.actuate.endpoint.web.servlet.AbstractWebMvcEndpointHandlerMapping$OperationHandler.handle(AbstractWebMvcEndpointHandlerMapping.java:464)
  1457. at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
  1458. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1459. at java.lang.reflect.Method.invoke(Method.java:498)
  1460. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  1461. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  1462. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  1463. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  1464. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  1465. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1466. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  1467. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  1468. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  1469. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  1470. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  1471. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  1472. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  1473. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  1474. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1475. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  1476. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1477. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1478. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  1479. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1480. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1481. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1482. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1483. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1484. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1485. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1486. at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
  1487. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1488. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1489. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1490. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1491. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1492. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1493. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1494. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:177)
  1495. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  1496. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  1497. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  1498. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  1499. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  1500. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  1501. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  1502. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  1503. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:891)
  1504. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1784)
  1505. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  1506. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  1507. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  1508. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  1509. at java.lang.Thread.run(Thread.java:748)
  1510. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10008ms.
  1511. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1512. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1513. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1514. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1515. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  1516. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  1517. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  1518. ... 77 common frames omitted
  1519. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1520. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1521. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1522. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1523. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1524. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1525. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1526. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1527. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1528. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1529. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1530. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1531. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1532. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1533. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1534. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1535. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1536. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1537. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1538. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1539. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1540. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1541. ... 1 common frames omitted
  1542. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1543. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1544. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1545. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1546. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1547. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1548. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1549. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1550. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1551. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1552. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1553. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1554. ... 16 common frames omitted
  1555. Caused by: java.net.SocketTimeoutException: connect timed out
  1556. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1557. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1558. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1559. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1560. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1561. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1562. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1563. at java.net.Socket.connect(Socket.java:589)
  1564. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1565. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1566. ... 18 common frames omitted
  1567. 2024-08-13 14:43:00 [http-nio-9100-exec-7] WARN o.s.b.a.health.HealthEndpointSupport - Health contributor org.springframework.boot.actuate.jdbc.DataSourceHealthIndicator (db) took 10009ms to respond
  1568. 2024-08-13 14:43:01 [xxl-job, admin JobScheduleHelper#scheduleThread] ERROR c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread error:{}
  1569. java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1570. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1571. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1572. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1573. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1574. at com.xxl.job.admin.core.thread.JobScheduleHelper$1.run(JobScheduleHelper.java:70)
  1575. at java.lang.Thread.run(Thread.java:748)
  1576. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1577. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1578. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1579. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1580. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1581. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1582. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1583. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1584. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1585. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1586. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1587. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1588. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1589. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1590. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1591. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1592. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1593. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1594. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1595. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1596. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1597. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1598. ... 1 common frames omitted
  1599. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1600. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1601. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1602. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1603. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1604. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1605. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1606. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1607. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1608. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1609. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1610. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1611. ... 16 common frames omitted
  1612. Caused by: java.net.SocketTimeoutException: connect timed out
  1613. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1614. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1615. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1616. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1617. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1618. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1619. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1620. at java.net.Socket.connect(Socket.java:589)
  1621. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1622. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1623. ... 18 common frames omitted
  1624. 2024-08-13 14:43:03 [xxl-job, admin JobLogReportHelper] ERROR c.x.j.a.c.thread.JobLogReportHelper - >>>>>>>>>>> xxl-job, job log report thread error:{}
  1625. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
  1626. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1627. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  1628. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findLogReport
  1629. ### The error occurred while executing a query
  1630. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1631. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
  1632. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  1633. at com.sun.proxy.$Proxy77.selectOne(Unknown Source)
  1634. at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
  1635. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
  1636. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  1637. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  1638. at com.sun.proxy.$Proxy80.findLogReport(Unknown Source)
  1639. at com.xxl.job.admin.core.thread.JobLogReportHelper$1.run(JobLogReportHelper.java:73)
  1640. at java.lang.Thread.run(Thread.java:748)
  1641. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  1642. ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1643. ### The error may exist in file [D:\idea\sy\ruoyi-plus\ruoyi-extend\ruoyi-xxl-job-admin\target\classes\mybatis-mapper\XxlJobLogMapper.xml]
  1644. ### The error may involve com.xxl.job.admin.dao.XxlJobLogDao.findLogReport
  1645. ### The error occurred while executing a query
  1646. ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1647. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  1648. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  1649. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  1650. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  1651. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
  1652. at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source)
  1653. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1654. at java.lang.reflect.Method.invoke(Method.java:498)
  1655. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  1656. ... 8 common frames omitted
  1657. Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1658. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:83)
  1659. at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
  1660. at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
  1661. at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:337)
  1662. at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:86)
  1663. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
  1664. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  1665. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  1666. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
  1667. at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
  1668. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  1669. ... 15 common frames omitted
  1670. Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 10001ms.
  1671. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
  1672. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
  1673. at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
  1674. at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
  1675. at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159)
  1676. at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117)
  1677. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
  1678. ... 25 common frames omitted
  1679. Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  1680. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  1681. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  1682. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  1683. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  1684. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  1685. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:894)
  1686. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:819)
  1687. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
  1688. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
  1689. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  1690. at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
  1691. at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
  1692. at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
  1693. at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
  1694. at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
  1695. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:726)
  1696. at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:712)
  1697. at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266)
  1698. at java.util.concurrent.FutureTask.run(FutureTask.java)
  1699. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  1700. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  1701. ... 1 common frames omitted
  1702. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  1703. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  1704. at sun.reflect.GeneratedConstructorAccessor51.newInstance(Unknown Source)
  1705. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  1706. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  1707. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  1708. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  1709. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  1710. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  1711. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  1712. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  1713. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:838)
  1714. ... 16 common frames omitted
  1715. Caused by: java.net.SocketTimeoutException: connect timed out
  1716. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  1717. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:85)
  1718. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  1719. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  1720. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  1721. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  1722. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  1723. at java.net.Socket.connect(Socket.java:589)
  1724. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  1725. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  1726. ... 18 common frames omitted
  1727. 2024-08-13 17:30:19 [xxl-job, admin JobScheduleHelper#scheduleThread] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#scheduleThread stop
  1728. 2024-08-13 17:30:20 [xxl-job, admin JobScheduleHelper#ringThread] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper#ringThread stop
  1729. 2024-08-13 17:30:20 [SpringApplicationShutdownHook] INFO c.x.j.a.c.thread.JobScheduleHelper - >>>>>>>>>>> xxl-job, JobScheduleHelper stop
  1730. 2024-08-13 17:30:20 [xxl-job, admin JobLogReportHelper] INFO c.x.j.a.c.thread.JobLogReportHelper - >>>>>>>>>>> xxl-job, job log report thread stop
  1731. 2024-08-13 17:30:20 [xxl-job, admin JobLosedMonitorHelper] INFO c.x.j.a.c.thread.JobCompleteHelper - >>>>>>>>>>> xxl-job, JobLosedMonitorHelper stop
  1732. 2024-08-13 17:30:20 [xxl-job, admin JobFailMonitorHelper] INFO c.x.j.a.c.t.JobFailMonitorHelper - >>>>>>>>>>> xxl-job, job fail monitor thread stop
  1733. 2024-08-13 17:30:20 [xxl-job, admin JobRegistryMonitorHelper-registryMonitorThread] INFO c.x.j.a.c.thread.JobRegistryHelper - >>>>>>>>>>> xxl-job, job registry monitor thread stop
  1734. 2024-08-13 17:30:20 [SpringApplicationShutdownHook] INFO c.x.j.a.c.t.JobTriggerPoolHelper - >>>>>>>>> xxl-job trigger thread pool shutdown success.
  1735. 2024-08-13 17:30:20 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Shutdown initiated...
  1736. 2024-08-13 17:30:20 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - HikariCP - Shutdown completed.