sys-error.2024-02-22.log 102 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115
  1. 11:22:47.351 [http-nio-8080-exec-5] ERROR c.x.c.e.GlobalExceptionHandler - [globalExceptionHandler,34] -
  2. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  3. ### The error may exist in file [D:\java\workplace\target\classes\mapper\textbook\TextbookWarehouseRecordMapper.xml]
  4. ### The error may involve com.xjrsoft.module.textbook.mapper.TextbookWarehouseRecordMapper.getPage-Inline
  5. ### The error occurred while setting parameters
  6. ### SQL: SELECT COUNT(*) AS total FROM textbook_warehouse_record t1 LEFT JOIN xjr_user t2 ON t1.create_user_id = t2.id LEFT JOIN textbook t3 ON t1.textbook_id = t3.id LEFT JOIN subject_group t4 ON t3.subject_group_id = t4.id LEFT JOIN base_course_subject t5 ON t3.course_subject_id = t5.id LEFT JOIN xjr_dictionary_detail t6 ON t3.textbook_type = t6.code AND t6.item_id = 1739209191193636865 LEFT JOIN base_grade t7 ON t3.grade_id = t7.id WHERE t1.delete_mark = 0 AND t3.class_id LIKE concat('%', ?, '%')
  7. ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  8. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  9. org.springframework.jdbc.BadSqlGrammarException:
  10. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  11. ### The error may exist in file [D:\java\workplace\target\classes\mapper\textbook\TextbookWarehouseRecordMapper.xml]
  12. ### The error may involve com.xjrsoft.module.textbook.mapper.TextbookWarehouseRecordMapper.getPage-Inline
  13. ### The error occurred while setting parameters
  14. ### SQL: SELECT COUNT(*) AS total FROM textbook_warehouse_record t1 LEFT JOIN xjr_user t2 ON t1.create_user_id = t2.id LEFT JOIN textbook t3 ON t1.textbook_id = t3.id LEFT JOIN subject_group t4 ON t3.subject_group_id = t4.id LEFT JOIN base_course_subject t5 ON t3.course_subject_id = t5.id LEFT JOIN xjr_dictionary_detail t6 ON t3.textbook_type = t6.code AND t6.item_id = 1739209191193636865 LEFT JOIN base_grade t7 ON t3.grade_id = t7.id WHERE t1.delete_mark = 0 AND t3.class_id LIKE concat('%', ?, '%')
  15. ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  16. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  17. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  18. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  19. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  20. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  21. at com.sun.proxy.$Proxy140.selectList(Unknown Source)
  22. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  23. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
  24. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
  25. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
  26. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
  27. at com.sun.proxy.$Proxy348.getPage(Unknown Source)
  28. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl.getPage(TextbookWarehouseRecordServiceImpl.java:28)
  29. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl$$FastClassBySpringCGLIB$$d1b58705.invoke(<generated>)
  30. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  31. at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
  32. at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
  33. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
  34. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl$$EnhancerBySpringCGLIB$$b179c019.getPage(<generated>)
  35. at com.xjrsoft.module.textbook.controller.TextbookWarehouseRecordController.page(TextbookWarehouseRecordController.java:49)
  36. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  37. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  38. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  39. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  40. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  41. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  42. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  43. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  44. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  45. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  46. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  47. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  48. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  49. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  50. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  51. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  52. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  53. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  54. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  55. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  56. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  57. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  58. at com.xjrsoft.common.xss.XssFilter.doFilter(XssFilter.java:28)
  59. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  60. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  61. at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
  62. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  63. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  64. at cn.dev33.satoken.filter.SaServletFilter.doFilter(SaServletFilter.java:157)
  65. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  66. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  67. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  68. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  69. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  70. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  71. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  72. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  73. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  74. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  75. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  76. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  77. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  78. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  79. at org.ssssssss.magicapi.servlet.javaee.MagicJavaEECorsFilter.doFilter(MagicJavaEECorsFilter.java:15)
  80. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  81. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  82. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  83. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  84. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  85. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  86. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  87. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  88. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  89. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  90. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  91. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
  92. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
  93. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  94. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  95. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  96. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  97. at java.base/java.lang.Thread.run(Thread.java:834)
  98. Caused by: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_id' in 'where clause'
  99. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  100. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  101. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  102. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  103. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  104. at jdk.internal.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
  105. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  106. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  107. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  108. at com.sun.proxy.$Proxy172.execute(Unknown Source)
  109. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  110. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  111. at jdk.internal.reflect.GeneratedMethodAccessor308.invoke(Unknown Source)
  112. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  113. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  114. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  115. at com.sun.proxy.$Proxy733.query(Unknown Source)
  116. at jdk.internal.reflect.GeneratedMethodAccessor308.invoke(Unknown Source)
  117. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  118. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  119. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  120. at com.sun.proxy.$Proxy733.query(Unknown Source)
  121. at jdk.internal.reflect.GeneratedMethodAccessor308.invoke(Unknown Source)
  122. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  123. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  124. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  125. at com.sun.proxy.$Proxy733.query(Unknown Source)
  126. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  127. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  128. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  129. at com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:135)
  130. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)
  131. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  132. at com.sun.proxy.$Proxy732.query(Unknown Source)
  133. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
  134. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  135. at com.sun.proxy.$Proxy732.query(Unknown Source)
  136. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
  137. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  138. at com.sun.proxy.$Proxy732.query(Unknown Source)
  139. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  140. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  141. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  142. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  143. at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
  144. at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
  145. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  146. at com.sun.proxy.$Proxy732.query(Unknown Source)
  147. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
  148. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  149. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  150. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  151. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  152. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  153. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  154. ... 77 common frames omitted
  155. 11:25:14.001 [http-nio-8080-exec-1] ERROR c.x.c.e.GlobalExceptionHandler - [globalExceptionHandler,34] -
  156. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  157. ### The error may exist in file [D:\java\workplace\target\classes\mapper\textbook\TextbookWarehouseRecordMapper.xml]
  158. ### The error may involve com.xjrsoft.module.textbook.mapper.TextbookWarehouseRecordMapper.getPage-Inline
  159. ### The error occurred while setting parameters
  160. ### SQL: SELECT COUNT(*) AS total FROM textbook_warehouse_record t1 LEFT JOIN xjr_user t2 ON t1.create_user_id = t2.id LEFT JOIN textbook t3 ON t1.textbook_id = t3.id LEFT JOIN subject_group t4 ON t3.subject_group_id = t4.id LEFT JOIN base_course_subject t5 ON t3.course_subject_id = t5.id LEFT JOIN xjr_dictionary_detail t6 ON t3.textbook_type = t6.code AND t6.item_id = 1739209191193636865 LEFT JOIN base_grade t7 ON t3.grade_id = t7.id WHERE t1.delete_mark = 0 AND t3.class_ids LIKE concat('%', ?, '%')
  161. ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  162. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  163. org.springframework.jdbc.BadSqlGrammarException:
  164. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  165. ### The error may exist in file [D:\java\workplace\target\classes\mapper\textbook\TextbookWarehouseRecordMapper.xml]
  166. ### The error may involve com.xjrsoft.module.textbook.mapper.TextbookWarehouseRecordMapper.getPage-Inline
  167. ### The error occurred while setting parameters
  168. ### SQL: SELECT COUNT(*) AS total FROM textbook_warehouse_record t1 LEFT JOIN xjr_user t2 ON t1.create_user_id = t2.id LEFT JOIN textbook t3 ON t1.textbook_id = t3.id LEFT JOIN subject_group t4 ON t3.subject_group_id = t4.id LEFT JOIN base_course_subject t5 ON t3.course_subject_id = t5.id LEFT JOIN xjr_dictionary_detail t6 ON t3.textbook_type = t6.code AND t6.item_id = 1739209191193636865 LEFT JOIN base_grade t7 ON t3.grade_id = t7.id WHERE t1.delete_mark = 0 AND t3.class_ids LIKE concat('%', ?, '%')
  169. ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  170. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  171. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  172. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  173. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  174. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  175. at com.sun.proxy.$Proxy140.selectList(Unknown Source)
  176. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  177. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
  178. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
  179. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
  180. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
  181. at com.sun.proxy.$Proxy348.getPage(Unknown Source)
  182. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl.getPage(TextbookWarehouseRecordServiceImpl.java:28)
  183. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl$$FastClassBySpringCGLIB$$d1b58705.invoke(<generated>)
  184. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  185. at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
  186. at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
  187. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
  188. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl$$EnhancerBySpringCGLIB$$44398912.getPage(<generated>)
  189. at com.xjrsoft.module.textbook.controller.TextbookWarehouseRecordController.page(TextbookWarehouseRecordController.java:49)
  190. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  191. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  192. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  193. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  194. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  195. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  196. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  197. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  198. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  199. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  200. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  201. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  202. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  203. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  204. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  205. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  206. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  207. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  208. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  209. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  210. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  211. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  212. at com.xjrsoft.common.xss.XssFilter.doFilter(XssFilter.java:28)
  213. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  214. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  215. at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
  216. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  217. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  218. at cn.dev33.satoken.filter.SaServletFilter.doFilter(SaServletFilter.java:157)
  219. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  220. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  221. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  222. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  223. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  224. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  225. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  226. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  227. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  228. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  229. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  230. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  231. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  232. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  233. at org.ssssssss.magicapi.servlet.javaee.MagicJavaEECorsFilter.doFilter(MagicJavaEECorsFilter.java:15)
  234. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  235. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  236. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  237. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  238. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  239. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  240. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  241. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  242. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  243. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  244. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  245. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
  246. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
  247. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  248. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  249. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  250. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  251. at java.base/java.lang.Thread.run(Thread.java:834)
  252. Caused by: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  253. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  254. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  255. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  256. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  257. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  258. at jdk.internal.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
  259. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  260. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  261. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  262. at com.sun.proxy.$Proxy172.execute(Unknown Source)
  263. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  264. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  265. at jdk.internal.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
  266. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  267. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  268. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  269. at com.sun.proxy.$Proxy733.query(Unknown Source)
  270. at jdk.internal.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
  271. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  272. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  273. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  274. at com.sun.proxy.$Proxy733.query(Unknown Source)
  275. at jdk.internal.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
  276. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  277. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  278. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  279. at com.sun.proxy.$Proxy733.query(Unknown Source)
  280. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  281. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  282. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  283. at com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:135)
  284. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)
  285. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  286. at com.sun.proxy.$Proxy732.query(Unknown Source)
  287. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
  288. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  289. at com.sun.proxy.$Proxy732.query(Unknown Source)
  290. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
  291. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  292. at com.sun.proxy.$Proxy732.query(Unknown Source)
  293. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  294. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  295. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  296. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  297. at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
  298. at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
  299. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  300. at com.sun.proxy.$Proxy732.query(Unknown Source)
  301. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
  302. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  303. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  304. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  305. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  306. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  307. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  308. ... 77 common frames omitted
  309. 11:26:10.375 [main] ERROR o.s.b.SpringApplication - [reportFailure,824] - Application run failed
  310. java.lang.IllegalStateException: Failed to execute CommandLineRunner
  311. at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:774)
  312. at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:755)
  313. at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
  314. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
  315. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
  316. at com.xjrsoft.XjrSoftApplication.main(XjrSoftApplication.java:19)
  317. Caused by: org.springframework.data.redis.RedisSystemException: Redis exception; nested exception is io.lettuce.core.RedisException: java.io.IOException: 远程主机强迫关闭了一个现有的连接。
  318. at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:74)
  319. at org.springframework.data.redis.connection.lettuce.LettuceExceptionConverter.convert(LettuceExceptionConverter.java:41)
  320. at org.springframework.data.redis.PassThroughExceptionTranslationStrategy.translate(PassThroughExceptionTranslationStrategy.java:44)
  321. at org.springframework.data.redis.FallbackExceptionTranslationStrategy.translate(FallbackExceptionTranslationStrategy.java:42)
  322. at org.springframework.data.redis.connection.lettuce.LettuceConnection.convertLettuceAccessException(LettuceConnection.java:278)
  323. at org.springframework.data.redis.connection.lettuce.LettuceConnection.await(LettuceConnection.java:1086)
  324. at org.springframework.data.redis.connection.lettuce.LettuceConnection.lambda$doInvoke$4(LettuceConnection.java:939)
  325. at org.springframework.data.redis.connection.lettuce.LettuceInvoker$Synchronizer.invoke(LettuceInvoker.java:673)
  326. at org.springframework.data.redis.connection.lettuce.LettuceInvoker$DefaultSingleInvocationSpec.get(LettuceInvoker.java:589)
  327. at org.springframework.data.redis.connection.lettuce.LettuceStringCommands.set(LettuceStringCommands.java:123)
  328. at org.springframework.data.redis.connection.DefaultedRedisConnection.set(DefaultedRedisConnection.java:314)
  329. at org.springframework.data.redis.connection.DefaultStringRedisConnection.set(DefaultStringRedisConnection.java:1121)
  330. at org.springframework.data.redis.core.DefaultValueOperations$7.inRedis(DefaultValueOperations.java:309)
  331. at org.springframework.data.redis.core.AbstractOperations$ValueDeserializingRedisCallback.doInRedis(AbstractOperations.java:61)
  332. at org.springframework.data.redis.core.RedisTemplate.execute(RedisTemplate.java:224)
  333. at org.springframework.data.redis.core.RedisTemplate.execute(RedisTemplate.java:191)
  334. at org.springframework.data.redis.core.AbstractOperations.execute(AbstractOperations.java:97)
  335. at org.springframework.data.redis.core.DefaultValueOperations.set(DefaultValueOperations.java:305)
  336. at com.xjrsoft.common.utils.RedisUtil.set(RedisUtil.java:45)
  337. at com.xjrsoft.common.utils.RedisUtil.set(RedisUtil.java:52)
  338. at com.xjrsoft.common.runner.OrganizationCacheRunner.loadUserCache(OrganizationCacheRunner.java:67)
  339. at com.xjrsoft.common.runner.OrganizationCacheRunner.run(OrganizationCacheRunner.java:54)
  340. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  341. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  342. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  343. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  344. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  345. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
  346. at com.sun.proxy.$Proxy201.run(Unknown Source)
  347. at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:771)
  348. ... 5 common frames omitted
  349. Caused by: io.lettuce.core.RedisException: java.io.IOException: 远程主机强迫关闭了一个现有的连接。
  350. at io.lettuce.core.internal.Exceptions.bubble(Exceptions.java:83)
  351. at io.lettuce.core.internal.Futures.awaitOrCancel(Futures.java:250)
  352. at io.lettuce.core.LettuceFutures.awaitOrCancel(LettuceFutures.java:74)
  353. at org.springframework.data.redis.connection.lettuce.LettuceConnection.await(LettuceConnection.java:1084)
  354. ... 29 common frames omitted
  355. Caused by: java.io.IOException: 远程主机强迫关闭了一个现有的连接。
  356. at java.base/sun.nio.ch.SocketDispatcher.read0(Native Method)
  357. at java.base/sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:43)
  358. at java.base/sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:276)
  359. at java.base/sun.nio.ch.IOUtil.read(IOUtil.java:233)
  360. at java.base/sun.nio.ch.IOUtil.read(IOUtil.java:223)
  361. at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:358)
  362. at io.netty.buffer.PooledByteBuf.setBytes(PooledByteBuf.java:259)
  363. at io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:1132)
  364. at io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:357)
  365. at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:151)
  366. at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
  367. at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
  368. at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
  369. at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
  370. at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
  371. at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
  372. at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
  373. at java.base/java.lang.Thread.run(Thread.java:834)
  374. 11:26:29.669 [main] ERROR c.a.d.util.JdbcUtils - [close,96] - close connection error
  375. java.sql.SQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
  376. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  377. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  378. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  379. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  380. at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1835)
  381. at com.mysql.cj.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:1693)
  382. at com.mysql.cj.jdbc.ConnectionImpl.close(ConnectionImpl.java:713)
  383. at com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:94)
  384. at com.alibaba.druid.pool.DruidDataSource.discardConnection(DruidDataSource.java:1528)
  385. at com.alibaba.druid.pool.DruidDataSource.handleFatalError(DruidDataSource.java:1846)
  386. at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1770)
  387. at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:133)
  388. at com.alibaba.druid.pool.DruidPooledConnection.setAutoCommit(DruidPooledConnection.java:717)
  389. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:287)
  390. at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
  391. at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  392. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
  393. at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:71)
  394. at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)
  395. at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)
  396. at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
  397. at org.camunda.bpm.engine.impl.interceptor.ExceptionCodeInterceptor.execute(ExceptionCodeInterceptor.java:55)
  398. at org.camunda.bpm.engine.impl.metrics.reporter.MetricsCollectionTask.collectMetrics(MetricsCollectionTask.java:76)
  399. at org.camunda.bpm.engine.impl.metrics.reporter.MetricsCollectionTask.run(MetricsCollectionTask.java:53)
  400. at org.camunda.bpm.engine.impl.metrics.reporter.DbMetricsReporter.reportNow(DbMetricsReporter.java:76)
  401. at org.camunda.bpm.engine.impl.metrics.reporter.DbMetricsReporter.stop(DbMetricsReporter.java:70)
  402. at org.camunda.bpm.engine.impl.ProcessEngineImpl.close(ProcessEngineImpl.java:171)
  403. at org.camunda.bpm.engine.spring.ProcessEngineFactoryBean.destroy(ProcessEngineFactoryBean.java:42)
  404. at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:213)
  405. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:587)
  406. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:559)
  407. at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingleton(DefaultListableBeanFactory.java:1163)
  408. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:520)
  409. at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingletons(DefaultListableBeanFactory.java:1156)
  410. at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1106)
  411. at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1075)
  412. at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.doClose(ServletWebServerApplicationContext.java:174)
  413. at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1021)
  414. at org.springframework.boot.SpringApplication.handleRunFailure(SpringApplication.java:790)
  415. at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
  416. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
  417. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
  418. at com.xjrsoft.XjrSoftApplication.main(XjrSoftApplication.java:19)
  419. 11:26:29.671 [main] ERROR c.a.d.p.DruidDataSource - [handleFatalError,1849] - discard connection
  420. com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
  421. The last packet successfully received from the server was 41,463 milliseconds ago. The last packet sent successfully to the server was 41,694 milliseconds ago.
  422. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
  423. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
  424. at com.mysql.cj.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:2050)
  425. at com.alibaba.druid.pool.DruidPooledConnection.setAutoCommit(DruidPooledConnection.java:713)
  426. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:287)
  427. at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
  428. at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
  429. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137)
  430. at org.camunda.bpm.engine.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:71)
  431. at org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)
  432. at org.camunda.bpm.engine.impl.interceptor.CommandCounterInterceptor.execute(CommandCounterInterceptor.java:35)
  433. at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
  434. at org.camunda.bpm.engine.impl.interceptor.ExceptionCodeInterceptor.execute(ExceptionCodeInterceptor.java:55)
  435. at org.camunda.bpm.engine.impl.metrics.reporter.MetricsCollectionTask.collectMetrics(MetricsCollectionTask.java:76)
  436. at org.camunda.bpm.engine.impl.metrics.reporter.MetricsCollectionTask.run(MetricsCollectionTask.java:53)
  437. at org.camunda.bpm.engine.impl.metrics.reporter.DbMetricsReporter.reportNow(DbMetricsReporter.java:76)
  438. at org.camunda.bpm.engine.impl.metrics.reporter.DbMetricsReporter.stop(DbMetricsReporter.java:70)
  439. at org.camunda.bpm.engine.impl.ProcessEngineImpl.close(ProcessEngineImpl.java:171)
  440. at org.camunda.bpm.engine.spring.ProcessEngineFactoryBean.destroy(ProcessEngineFactoryBean.java:42)
  441. at org.springframework.beans.factory.support.DisposableBeanAdapter.destroy(DisposableBeanAdapter.java:213)
  442. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroyBean(DefaultSingletonBeanRegistry.java:587)
  443. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingleton(DefaultSingletonBeanRegistry.java:559)
  444. at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingleton(DefaultListableBeanFactory.java:1163)
  445. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.destroySingletons(DefaultSingletonBeanRegistry.java:520)
  446. at org.springframework.beans.factory.support.DefaultListableBeanFactory.destroySingletons(DefaultListableBeanFactory.java:1156)
  447. at org.springframework.context.support.AbstractApplicationContext.destroyBeans(AbstractApplicationContext.java:1106)
  448. at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:1075)
  449. at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.doClose(ServletWebServerApplicationContext.java:174)
  450. at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:1021)
  451. at org.springframework.boot.SpringApplication.handleRunFailure(SpringApplication.java:790)
  452. at org.springframework.boot.SpringApplication.run(SpringApplication.java:318)
  453. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
  454. at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295)
  455. at com.xjrsoft.XjrSoftApplication.main(XjrSoftApplication.java:19)
  456. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  457. The last packet successfully received from the server was 41,463 milliseconds ago. The last packet sent successfully to the server was 41,694 milliseconds ago.
  458. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  459. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  460. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  461. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  462. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  463. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  464. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  465. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  466. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:581)
  467. at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:761)
  468. at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:700)
  469. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1051)
  470. at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:997)
  471. at com.mysql.cj.NativeSession.execSQL(NativeSession.java:663)
  472. at com.mysql.cj.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:2033)
  473. ... 31 common frames omitted
  474. Caused by: java.net.SocketTimeoutException: Read timed out
  475. at java.base/java.net.SocketInputStream.socketRead0(Native Method)
  476. at java.base/java.net.SocketInputStream.socketRead(SocketInputStream.java:115)
  477. at java.base/java.net.SocketInputStream.read(SocketInputStream.java:168)
  478. at java.base/java.net.SocketInputStream.read(SocketInputStream.java:140)
  479. at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484)
  480. at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478)
  481. at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70)
  482. at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1334)
  483. at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:977)
  484. at java.base/java.io.FilterInputStream.read(FilterInputStream.java:133)
  485. at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64)
  486. at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81)
  487. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
  488. at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
  489. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52)
  490. at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41)
  491. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54)
  492. at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44)
  493. at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:575)
  494. ... 37 common frames omitted
  495. 11:27:53.575 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  496. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  497. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  498. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  499. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  500. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  501. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  502. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  503. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  504. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  505. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  506. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  507. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  508. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  509. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  510. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  511. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  512. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  513. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  514. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  515. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  516. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  517. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  518. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  519. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  520. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  521. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  522. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  523. ... 7 common frames omitted
  524. Caused by: java.net.ConnectException: Connection timed out: connect
  525. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  526. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  527. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  528. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  529. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  530. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  531. at java.base/java.net.Socket.connect(Socket.java:608)
  532. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  533. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  534. ... 9 common frames omitted
  535. 11:29:00.708 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  536. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  537. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  538. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  539. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  540. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  541. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  542. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  543. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  544. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  545. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  546. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  547. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  548. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  549. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  550. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  551. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  552. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  553. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  554. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  555. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  556. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  557. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  558. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  559. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  560. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  561. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  562. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  563. ... 7 common frames omitted
  564. Caused by: java.net.ConnectException: Connection timed out: connect
  565. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  566. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  567. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  568. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  569. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  570. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  571. at java.base/java.net.Socket.connect(Socket.java:608)
  572. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  573. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  574. ... 9 common frames omitted
  575. 11:30:08.315 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  576. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  577. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  578. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  579. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  580. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  581. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  582. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  583. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  584. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  585. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  586. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  587. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  588. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  589. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  590. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  591. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  592. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  593. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  594. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  595. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  596. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  597. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  598. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  599. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  600. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  601. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  602. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  603. ... 7 common frames omitted
  604. Caused by: java.net.ConnectException: Connection timed out: connect
  605. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  606. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  607. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  608. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  609. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  610. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  611. at java.base/java.net.Socket.connect(Socket.java:608)
  612. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  613. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  614. ... 9 common frames omitted
  615. 11:31:15.951 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  616. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  617. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  618. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  619. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  620. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  621. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  622. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  623. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  624. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  625. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  626. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  627. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  628. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  629. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  630. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  631. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  632. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  633. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  634. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  635. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  636. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  637. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  638. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  639. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  640. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  641. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  642. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  643. ... 7 common frames omitted
  644. Caused by: java.net.ConnectException: Connection timed out: connect
  645. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  646. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  647. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  648. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  649. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  650. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  651. at java.base/java.net.Socket.connect(Socket.java:608)
  652. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  653. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  654. ... 9 common frames omitted
  655. 11:32:23.570 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  656. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  657. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  658. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  659. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  660. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  661. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  662. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  663. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  664. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  665. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  666. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  667. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  668. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  669. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  670. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  671. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  672. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  673. at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  674. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  675. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  676. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  677. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  678. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  679. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  680. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  681. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  682. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  683. ... 7 common frames omitted
  684. Caused by: java.net.ConnectException: Connection timed out: connect
  685. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  686. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  687. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  688. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  689. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  690. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  691. at java.base/java.net.Socket.connect(Socket.java:608)
  692. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  693. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  694. ... 9 common frames omitted
  695. 11:33:31.255 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  696. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  697. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  698. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  699. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  700. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  701. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  702. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  703. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  704. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  705. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  706. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  707. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  708. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  709. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  710. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  711. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  712. at jdk.internal.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
  713. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  714. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  715. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  716. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  717. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  718. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  719. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  720. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  721. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  722. ... 7 common frames omitted
  723. Caused by: java.net.ConnectException: Connection timed out: connect
  724. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  725. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  726. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  727. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  728. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  729. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  730. at java.base/java.net.Socket.connect(Socket.java:608)
  731. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  732. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  733. ... 9 common frames omitted
  734. 11:34:38.890 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  735. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  736. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  737. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  738. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  739. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  740. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  741. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  742. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  743. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  744. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  745. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  746. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  747. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  748. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  749. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  750. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  751. at jdk.internal.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
  752. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  753. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  754. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  755. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  756. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  757. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  758. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  759. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  760. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  761. ... 7 common frames omitted
  762. Caused by: java.net.ConnectException: Connection timed out: connect
  763. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  764. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  765. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  766. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  767. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  768. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  769. at java.base/java.net.Socket.connect(Socket.java:608)
  770. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  771. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  772. ... 9 common frames omitted
  773. 11:35:46.549 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  774. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  775. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  776. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  777. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  778. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  779. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  780. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  781. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  782. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  783. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  784. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  785. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  786. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  787. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  788. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  789. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  790. at jdk.internal.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
  791. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  792. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  793. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  794. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  795. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  796. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  797. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  798. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  799. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  800. ... 7 common frames omitted
  801. Caused by: java.net.ConnectException: Connection timed out: connect
  802. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  803. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  804. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  805. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  806. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  807. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  808. at java.base/java.net.Socket.connect(Socket.java:608)
  809. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  810. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  811. ... 9 common frames omitted
  812. 11:36:54.156 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  813. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  814. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  815. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  816. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  817. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  818. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  819. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  820. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  821. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  822. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  823. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  824. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  825. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  826. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  827. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  828. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  829. at jdk.internal.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
  830. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  831. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  832. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  833. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  834. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  835. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  836. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  837. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  838. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  839. ... 7 common frames omitted
  840. Caused by: java.net.ConnectException: Connection timed out: connect
  841. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  842. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  843. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  844. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  845. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  846. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  847. at java.base/java.net.Socket.connect(Socket.java:608)
  848. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  849. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  850. ... 9 common frames omitted
  851. 11:38:01.799 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  852. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  853. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  854. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  855. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  856. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  857. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  858. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  859. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  860. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  861. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  862. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  863. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  864. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  865. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  866. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  867. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  868. at jdk.internal.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
  869. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  870. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  871. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  872. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  873. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  874. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  875. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  876. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  877. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  878. ... 7 common frames omitted
  879. Caused by: java.net.ConnectException: Connection timed out: connect
  880. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  881. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  882. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  883. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  884. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  885. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  886. at java.base/java.net.Socket.connect(Socket.java:608)
  887. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  888. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  889. ... 9 common frames omitted
  890. 11:39:09.459 [Druid-ConnectionPool-Create-333890884] ERROR c.a.d.p.DruidDataSource - [run,2781] - create connection SQLException, url: jdbc:mysql://10.150.10.139:3306/tl?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true&autoReconnect=true&failOverReadOnly=false, errorCode 0, state 08001
  891. java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  892. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  893. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  894. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  895. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  896. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
  897. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
  898. at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
  899. at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
  900. at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
  901. at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
  902. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1644)
  903. at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1710)
  904. at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2779)
  905. Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
  906. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  907. at jdk.internal.reflect.GeneratedConstructorAccessor71.newInstance(Unknown Source)
  908. at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  909. at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
  910. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
  911. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
  912. at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
  913. at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
  914. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
  915. at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
  916. at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
  917. ... 7 common frames omitted
  918. Caused by: java.net.ConnectException: Connection timed out: connect
  919. at java.base/java.net.PlainSocketImpl.connect0(Native Method)
  920. at java.base/java.net.PlainSocketImpl.socketConnect(PlainSocketImpl.java:101)
  921. at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412)
  922. at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255)
  923. at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237)
  924. at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  925. at java.base/java.net.Socket.connect(Socket.java:608)
  926. at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
  927. at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
  928. ... 9 common frames omitted
  929. 11:47:46.389 [http-nio-8080-exec-2] ERROR c.x.c.e.GlobalExceptionHandler - [globalExceptionHandler,34] -
  930. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  931. ### The error may exist in file [D:\java\workplace\target\classes\mapper\textbook\TextbookWarehouseRecordMapper.xml]
  932. ### The error may involve com.xjrsoft.module.textbook.mapper.TextbookWarehouseRecordMapper.getPage-Inline
  933. ### The error occurred while setting parameters
  934. ### SQL: SELECT COUNT(*) AS total FROM textbook_warehouse_record t1 LEFT JOIN xjr_user t2 ON t1.create_user_id = t2.id LEFT JOIN textbook t3 ON t1.textbook_id = t3.id LEFT JOIN subject_group t4 ON t3.subject_group_id = t4.id LEFT JOIN base_course_subject t5 ON t3.course_subject_id = t5.id LEFT JOIN xjr_dictionary_detail t6 ON t3.textbook_type = t6.code AND t6.item_id = 1739209191193636865 LEFT JOIN base_grade t7 ON t3.grade_id = t7.id WHERE t1.delete_mark = 0 AND t3.class_ids LIKE concat('%', ?, '%')
  935. ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  936. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  937. org.springframework.jdbc.BadSqlGrammarException:
  938. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  939. ### The error may exist in file [D:\java\workplace\target\classes\mapper\textbook\TextbookWarehouseRecordMapper.xml]
  940. ### The error may involve com.xjrsoft.module.textbook.mapper.TextbookWarehouseRecordMapper.getPage-Inline
  941. ### The error occurred while setting parameters
  942. ### SQL: SELECT COUNT(*) AS total FROM textbook_warehouse_record t1 LEFT JOIN xjr_user t2 ON t1.create_user_id = t2.id LEFT JOIN textbook t3 ON t1.textbook_id = t3.id LEFT JOIN subject_group t4 ON t3.subject_group_id = t4.id LEFT JOIN base_course_subject t5 ON t3.course_subject_id = t5.id LEFT JOIN xjr_dictionary_detail t6 ON t3.textbook_type = t6.code AND t6.item_id = 1739209191193636865 LEFT JOIN base_grade t7 ON t3.grade_id = t7.id WHERE t1.delete_mark = 0 AND t3.class_ids LIKE concat('%', ?, '%')
  943. ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  944. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  945. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  946. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  947. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
  948. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
  949. at com.sun.proxy.$Proxy140.selectList(Unknown Source)
  950. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  951. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
  952. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
  953. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
  954. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
  955. at com.sun.proxy.$Proxy348.getPage(Unknown Source)
  956. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl.getPage(TextbookWarehouseRecordServiceImpl.java:28)
  957. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl$$FastClassBySpringCGLIB$$d1b58705.invoke(<generated>)
  958. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  959. at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
  960. at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
  961. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
  962. at com.xjrsoft.module.textbook.service.impl.TextbookWarehouseRecordServiceImpl$$EnhancerBySpringCGLIB$$44398912.getPage(<generated>)
  963. at com.xjrsoft.module.textbook.controller.TextbookWarehouseRecordController.page(TextbookWarehouseRecordController.java:49)
  964. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  965. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  966. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  967. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  968. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  969. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  970. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  971. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  972. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  973. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  974. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
  975. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
  976. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  977. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  978. at javax.servlet.http.HttpServlet.service(HttpServlet.java:670)
  979. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  980. at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
  981. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  982. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  983. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  984. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  985. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  986. at com.xjrsoft.common.xss.XssFilter.doFilter(XssFilter.java:28)
  987. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  988. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  989. at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
  990. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  991. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  992. at cn.dev33.satoken.filter.SaServletFilter.doFilter(SaServletFilter.java:157)
  993. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  994. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  995. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  996. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  997. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  998. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  999. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  1000. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1001. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1002. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1003. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  1004. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  1005. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1006. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1007. at org.ssssssss.magicapi.servlet.javaee.MagicJavaEECorsFilter.doFilter(MagicJavaEECorsFilter.java:15)
  1008. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  1009. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  1010. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  1011. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  1012. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
  1013. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  1014. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  1015. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  1016. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
  1017. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
  1018. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  1019. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
  1020. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
  1021. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  1022. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  1023. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  1024. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  1025. at java.base/java.lang.Thread.run(Thread.java:834)
  1026. Caused by: java.sql.SQLSyntaxErrorException: Unknown column 't3.class_ids' in 'where clause'
  1027. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  1028. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  1029. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
  1030. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
  1031. at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
  1032. at jdk.internal.reflect.GeneratedMethodAccessor191.invoke(Unknown Source)
  1033. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1034. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  1035. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  1036. at com.sun.proxy.$Proxy172.execute(Unknown Source)
  1037. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  1038. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  1039. at jdk.internal.reflect.GeneratedMethodAccessor313.invoke(Unknown Source)
  1040. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1041. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  1042. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  1043. at com.sun.proxy.$Proxy733.query(Unknown Source)
  1044. at jdk.internal.reflect.GeneratedMethodAccessor313.invoke(Unknown Source)
  1045. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1046. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  1047. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  1048. at com.sun.proxy.$Proxy733.query(Unknown Source)
  1049. at jdk.internal.reflect.GeneratedMethodAccessor313.invoke(Unknown Source)
  1050. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1051. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  1052. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  1053. at com.sun.proxy.$Proxy733.query(Unknown Source)
  1054. at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
  1055. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  1056. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  1057. at com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:135)
  1058. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)
  1059. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  1060. at com.sun.proxy.$Proxy732.query(Unknown Source)
  1061. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
  1062. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  1063. at com.sun.proxy.$Proxy732.query(Unknown Source)
  1064. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
  1065. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  1066. at com.sun.proxy.$Proxy732.query(Unknown Source)
  1067. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1068. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1069. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1070. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  1071. at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
  1072. at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
  1073. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  1074. at com.sun.proxy.$Proxy732.query(Unknown Source)
  1075. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
  1076. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  1077. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1078. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  1079. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  1080. at java.base/java.lang.reflect.Method.invoke(Method.java:566)
  1081. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
  1082. ... 77 common frames omitted
  1083. 20:27:37.885 [MQTT Ping: tleeb2ec23ca5244db98091b6b9ba9d573] ERROR o.e.p.m.c.i.ClientState - [logToJsr47,210] - tleeb2ec23ca5244db98091b6b9ba9d573: Timed out as no write activity, keepAlive=180,000,000,000 lastOutboundActivity=736,633,587,516,300 lastInboundActivity=736,633,631,878,100 time=737,780,642,746,200 lastPing=736,633,587,521,600
  1084. 20:31:50.183 [MQTT Snd: tleeb2ec23ca5244db98091b6b9ba9d573] ERROR o.e.p.m.c.i.CommsSender - [logToJsr47,210] - tleeb2ec23ca5244db98091b6b9ba9d573: exception
  1085. java.net.SocketException: Socket closed
  1086. at java.base/java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
  1087. at java.base/java.net.SocketOutputStream.write(SocketOutputStream.java:150)
  1088. at java.base/java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:81)
  1089. at java.base/java.io.BufferedOutputStream.flush(BufferedOutputStream.java:142)
  1090. at org.eclipse.paho.mqttv5.client.wire.MqttOutputStream.flush(MqttOutputStream.java:53)
  1091. at org.eclipse.paho.mqttv5.client.internal.CommsSender.run(CommsSender.java:147)
  1092. at java.base/java.lang.Thread.run(Thread.java:834)
  1093. 20:33:32.732 [MQTT Snd: tleeb2ec23ca5244db98091b6b9ba9d573] ERROR o.e.p.m.c.i.CommsSender - [logToJsr47,210] - tleeb2ec23ca5244db98091b6b9ba9d573: exception
  1094. java.net.SocketException: Socket closed
  1095. at java.base/java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
  1096. at java.base/java.net.SocketOutputStream.write(SocketOutputStream.java:150)
  1097. at java.base/java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:81)
  1098. at java.base/java.io.BufferedOutputStream.flush(BufferedOutputStream.java:142)
  1099. at org.eclipse.paho.mqttv5.client.wire.MqttOutputStream.flush(MqttOutputStream.java:53)
  1100. at org.eclipse.paho.mqttv5.client.internal.CommsSender.run(CommsSender.java:147)
  1101. at java.base/java.lang.Thread.run(Thread.java:834)
  1102. 20:42:32.195 [MQTT Ping: tleeb2ec23ca5244db98091b6b9ba9d573] ERROR o.e.p.m.c.i.ClientState - [logToJsr47,210] - tleeb2ec23ca5244db98091b6b9ba9d573: Timed out as no write activity, keepAlive=180,000,000,000 lastOutboundActivity=738,139,085,499,600 lastInboundActivity=738,139,326,667,900 time=738,674,953,220,000 lastPing=736,633,587,521,600