2023-07-10 14:58:15.658 INFO 21948 --- [restartedMain] com.mindskip.xzs.XzsApplication : Starting XzsApplication on DESKTOP-7A2KHS1 with PID 21948 (E:\ycll\qyksxt\target\classes started by qirong in E:\ycll\qyksxt)
|
2023-07-10 14:58:15.662 INFO 21948 --- [restartedMain] com.mindskip.xzs.XzsApplication : The following profiles are active: dev
|
2023-07-10 14:58:15.738 INFO 21948 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
|
2023-07-10 14:58:15.738 INFO 21948 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
|
2023-07-10 14:58:19.830 INFO 21948 --- [restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$d1000f65] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
|
2023-07-10 14:58:20.305 WARN 21948 --- [restartedMain] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used
|
2023-07-10 14:58:20.339 INFO 21948 --- [restartedMain] io.undertow.servlet : Initializing Spring embedded WebApplicationContext
|
2023-07-10 14:58:20.339 INFO 21948 --- [restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 4600 ms
|
2023-07-10 14:58:22.273 INFO 21948 --- [restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
|
2023-07-10 14:58:22.514 INFO 21948 --- [restartedMain] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5e1b5fd8, org.springframework.security.web.context.SecurityContextPersistenceFilter@183f8850, org.springframework.security.web.header.HeaderWriterFilter@40940bb5, org.springframework.web.filter.CorsFilter@4a74d34f, org.springframework.security.web.authentication.logout.LogoutFilter@2ec64f7, com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter@1a719c43, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@39c415dd, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@4f379a6b, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@3ed041dd, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@4dc6f710, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@67653ff6, org.springframework.security.web.session.SessionManagementFilter@5ec3102a, org.springframework.security.web.access.ExceptionTranslationFilter@82e067f, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@69283615]
|
2023-07-10 14:58:22.543 INFO 21948 --- [restartedMain] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)]
|
2023-07-10 14:58:23.056 INFO 21948 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed
|
2023-07-10 14:58:23.083 INFO 21948 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s)
|
2023-07-10 14:58:23.143 INFO 21948 --- [restartedMain] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references
|
2023-07-10 14:58:23.367 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: taskUsingPOST_1
|
2023-07-10 14:58:23.411 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_1
|
2023-07-10 14:58:23.434 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: listUsingPOST_1
|
2023-07-10 14:58:23.442 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_1
|
2023-07-10 14:58:23.446 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_1
|
2023-07-10 14:58:23.495 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_2
|
2023-07-10 14:58:23.525 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: answerSubmitUsingPOST_1
|
2023-07-10 14:58:23.527 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_1
|
2023-07-10 14:58:23.529 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_3
|
2023-07-10 14:58:23.531 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_1
|
2023-07-10 14:58:23.534 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_1
|
2023-07-10 14:58:23.545 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_2
|
2023-07-10 14:58:23.553 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_4
|
2023-07-10 14:58:23.556 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_2
|
2023-07-10 14:58:23.560 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_3
|
2023-07-10 14:58:23.566 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_5
|
2023-07-10 14:58:23.569 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_3
|
2023-07-10 14:58:23.574 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_6
|
2023-07-10 14:58:23.576 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_4
|
2023-07-10 14:58:23.581 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_7
|
2023-07-10 14:58:23.589 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_8
|
2023-07-10 14:58:23.593 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_5
|
2023-07-10 14:58:23.597 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_2
|
2023-07-10 14:58:23.599 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_4
|
2023-07-10 14:58:23.621 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_9
|
2023-07-10 14:58:23.624 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_6
|
2023-07-10 14:58:23.629 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_3
|
2023-07-10 14:58:23.633 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_5
|
2023-07-10 14:58:23.641 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_10
|
2023-07-10 14:58:23.646 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_7
|
2023-07-10 14:58:23.653 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingGET_1
|
2023-07-10 14:58:23.654 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingHEAD_1
|
2023-07-10 14:58:23.655 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPOST_1
|
2023-07-10 14:58:23.655 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPUT_1
|
2023-07-10 14:58:23.656 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPATCH_1
|
2023-07-10 14:58:23.658 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingDELETE_1
|
2023-07-10 14:58:23.658 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingOPTIONS_1
|
2023-07-10 14:58:23.658 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingTRACE_1
|
2023-07-10 14:58:23.681 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_2
|
2023-07-10 14:58:23.686 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_2
|
2023-07-10 14:58:23.690 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_1
|
2023-07-10 14:58:23.691 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: logUsingPOST_1
|
2023-07-10 14:58:23.697 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: messagePageListUsingPOST_1
|
2023-07-10 14:58:23.698 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_3
|
2023-07-10 14:58:23.702 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: registerUsingPOST_1
|
2023-07-10 14:58:23.704 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: unReadCountUsingPOST_1
|
2023-07-10 14:58:23.707 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_3
|
2023-07-10 14:58:23.713 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_2
|
2023-07-10 14:58:23.714 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_4
|
2023-07-10 14:58:23.719 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_6
|
2023-07-10 14:58:23.727 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: importUserUsingPOST_1
|
2023-07-10 14:58:23.733 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_11
|
2023-07-10 14:58:23.735 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_8
|
2023-07-10 14:58:23.739 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_4
|
2023-07-10 14:58:23.741 INFO 21948 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: addUsingPOST_1
|
2023-07-10 14:58:23.809 INFO 21948 --- [restartedMain] org.xnio : XNIO version 3.3.8.Final
|
2023-07-10 14:58:23.823 INFO 21948 --- [restartedMain] org.xnio.nio : XNIO NIO Implementation Version 3.3.8.Final
|
2023-07-10 14:58:23.913 INFO 21948 --- [restartedMain] o.s.b.w.e.u.UndertowServletWebServer : Undertow started on port(s) 8000 (http) with context path ''
|
2023-07-10 14:58:23.918 INFO 21948 --- [restartedMain] com.mindskip.xzs.XzsApplication : Started XzsApplication in 9.141 seconds (JVM running for 11.839)
|
2023-07-10 15:39:26.419 INFO 21948 --- [XNIO-1 task-1] io.undertow.servlet : Initializing Spring DispatcherServlet 'dispatcherServlet'
|
2023-07-10 15:39:26.437 INFO 21948 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
|
2023-07-10 15:39:26.569 INFO 21948 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 131 ms
|
2023-07-10 15:48:42.406 INFO 21948 --- [XNIO-1 task-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
|
2023-07-10 15:48:46.006 ERROR 21948 --- [XNIO-1 task-3] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
|
|
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy139.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.getUserByUserName(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.getUserByUserName(UserServiceImpl.java:48)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$f2e21405.getUserByUserName(<generated>)
|
at com.mindskip.xzs.configuration.spring.security.RestAuthenticationProvider.authenticate(RestAuthenticationProvider.java:57)
|
at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175)
|
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$AuthenticationManagerDelegator.authenticate(WebSecurityConfigurerAdapter.java:513)
|
at com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter.attemptAuthentication(RestLoginAuthenticationFilter.java:49)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
|
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:150)
|
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:947)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
|
... 100 common frames omitted
|
Caused by: java.net.ConnectException: Connection refused: connect
|
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
|
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81)
|
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
|
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
|
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200)
|
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162)
|
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394)
|
at java.net.Socket.connect(Socket.java:606)
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
|
... 103 common frames omitted
|
|
2023-07-10 15:48:46.040 ERROR 21948 --- [XNIO-1 task-3] io.undertow.request : UT005023: Exception handling request to /api/user/login
|
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.getUserByUserName
|
### The error occurred while executing a query
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
|
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.getUserByUserName(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.getUserByUserName(UserServiceImpl.java:48)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$f2e21405.getUserByUserName(<generated>)
|
at com.mindskip.xzs.configuration.spring.security.RestAuthenticationProvider.authenticate(RestAuthenticationProvider.java:57)
|
at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175)
|
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$AuthenticationManagerDelegator.authenticate(WebSecurityConfigurerAdapter.java:513)
|
at com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter.attemptAuthentication(RestLoginAuthenticationFilter.java:49)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.getUserByUserName
|
### The error occurred while executing a query
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
... 68 common frames omitted
|
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy139.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
... 75 common frames omitted
|
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
|
... 87 common frames omitted
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
|
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:150)
|
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:947)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
|
... 100 common frames omitted
|
Caused by: java.net.ConnectException: Connection refused: connect
|
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
|
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81)
|
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
|
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
|
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200)
|
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162)
|
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394)
|
at java.net.Socket.connect(Socket.java:606)
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
|
... 103 common frames omitted
|
|
2023-07-10 15:48:46.146 INFO 21948 --- [XNIO-1 task-3] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/error
|
2023-07-10 15:51:02.377 INFO 21948 --- [XNIO-1 task-4] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
|
2023-07-10 15:51:05.688 ERROR 21948 --- [XNIO-1 task-4] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
|
|
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy139.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.getUserByUserName(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.getUserByUserName(UserServiceImpl.java:48)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$f2e21405.getUserByUserName(<generated>)
|
at com.mindskip.xzs.configuration.spring.security.RestAuthenticationProvider.authenticate(RestAuthenticationProvider.java:57)
|
at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175)
|
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$AuthenticationManagerDelegator.authenticate(WebSecurityConfigurerAdapter.java:503)
|
at com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter.attemptAuthentication(RestLoginAuthenticationFilter.java:49)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
|
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:150)
|
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:947)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
|
... 100 common frames omitted
|
Caused by: java.net.ConnectException: Connection refused: connect
|
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
|
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81)
|
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
|
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
|
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200)
|
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162)
|
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394)
|
at java.net.Socket.connect(Socket.java:606)
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
|
... 103 common frames omitted
|
|
2023-07-10 15:51:05.727 ERROR 21948 --- [XNIO-1 task-4] io.undertow.request : UT005023: Exception handling request to /api/user/login
|
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.getUserByUserName
|
### The error occurred while executing a query
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
|
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.getUserByUserName(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.getUserByUserName(UserServiceImpl.java:48)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$f2e21405.getUserByUserName(<generated>)
|
at com.mindskip.xzs.configuration.spring.security.RestAuthenticationProvider.authenticate(RestAuthenticationProvider.java:57)
|
at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175)
|
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$AuthenticationManagerDelegator.authenticate(WebSecurityConfigurerAdapter.java:503)
|
at com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter.attemptAuthentication(RestLoginAuthenticationFilter.java:49)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.getUserByUserName
|
### The error occurred while executing a query
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
... 68 common frames omitted
|
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy139.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
... 75 common frames omitted
|
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
|
... 87 common frames omitted
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
|
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:150)
|
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:947)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
|
... 100 common frames omitted
|
Caused by: java.net.ConnectException: Connection refused: connect
|
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
|
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81)
|
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
|
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
|
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200)
|
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162)
|
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394)
|
at java.net.Socket.connect(Socket.java:606)
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
|
... 103 common frames omitted
|
|
2023-07-10 15:51:05.771 INFO 21948 --- [XNIO-1 task-4] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/error
|
2023-07-10 15:51:16.784 INFO 21948 --- [XNIO-1 task-5] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
|
2023-07-10 15:51:20.777 ERROR 21948 --- [XNIO-1 task-5] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
|
|
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy139.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.getUserByUserName(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.getUserByUserName(UserServiceImpl.java:48)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$f2e21405.getUserByUserName(<generated>)
|
at com.mindskip.xzs.configuration.spring.security.RestAuthenticationProvider.authenticate(RestAuthenticationProvider.java:57)
|
at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175)
|
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$AuthenticationManagerDelegator.authenticate(WebSecurityConfigurerAdapter.java:503)
|
at com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter.attemptAuthentication(RestLoginAuthenticationFilter.java:49)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
|
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:150)
|
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:947)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
|
... 100 common frames omitted
|
Caused by: java.net.ConnectException: Connection refused: connect
|
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
|
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81)
|
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
|
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
|
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200)
|
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162)
|
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394)
|
at java.net.Socket.connect(Socket.java:606)
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
|
... 103 common frames omitted
|
|
2023-07-10 15:51:20.780 ERROR 21948 --- [XNIO-1 task-5] io.undertow.request : UT005023: Exception handling request to /api/user/login
|
|
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.getUserByUserName
|
### The error occurred while executing a query
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
|
at com.sun.proxy.$Proxy83.selectOne(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.getUserByUserName(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.getUserByUserName(UserServiceImpl.java:48)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$f2e21405.getUserByUserName(<generated>)
|
at com.mindskip.xzs.configuration.spring.security.RestAuthenticationProvider.authenticate(RestAuthenticationProvider.java:57)
|
at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175)
|
at org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter$AuthenticationManagerDelegator.authenticate(WebSecurityConfigurerAdapter.java:503)
|
at com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter.attemptAuthentication(RestLoginAuthenticationFilter.java:49)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: org.apache.ibatis.exceptions.PersistenceException:
|
### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.getUserByUserName
|
### The error occurred while executing a query
|
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
... 68 common frames omitted
|
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
|
at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
|
at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:108)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy139.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
... 75 common frames omitted
|
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:827)
|
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:447)
|
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:237)
|
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
|
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
|
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
|
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
|
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
|
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:541)
|
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
|
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
|
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:157)
|
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:115)
|
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:78)
|
... 87 common frames omitted
|
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
|
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
|
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
|
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
|
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
|
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:91)
|
at com.mysql.cj.NativeSession.connect(NativeSession.java:150)
|
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:947)
|
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:817)
|
... 100 common frames omitted
|
Caused by: java.net.ConnectException: Connection refused: connect
|
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
|
at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:81)
|
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:476)
|
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:218)
|
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:200)
|
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:162)
|
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:394)
|
at java.net.Socket.connect(Socket.java:606)
|
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:155)
|
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:65)
|
... 103 common frames omitted
|
|
2023-07-10 15:51:20.784 INFO 21948 --- [XNIO-1 task-5] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/error
|
2023-07-10 15:55:13.498 INFO 21948 --- [Thread-28] io.undertow.servlet : Destroying Spring FrameworkServlet 'dispatcherServlet'
|
2023-07-10 15:55:24.571 INFO 14748 --- [restartedMain] com.mindskip.xzs.XzsApplication : Starting XzsApplication on DESKTOP-7A2KHS1 with PID 14748 (E:\ycll\qyksxt\target\classes started by qirong in E:\ycll\qyksxt)
|
2023-07-10 15:55:24.575 INFO 14748 --- [restartedMain] com.mindskip.xzs.XzsApplication : The following profiles are active: dev
|
2023-07-10 15:55:24.656 INFO 14748 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
|
2023-07-10 15:55:24.656 INFO 14748 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
|
2023-07-10 15:55:29.368 INFO 14748 --- [restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$df1d98cc] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
|
2023-07-10 15:55:29.939 WARN 14748 --- [restartedMain] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used
|
2023-07-10 15:55:29.984 INFO 14748 --- [restartedMain] io.undertow.servlet : Initializing Spring embedded WebApplicationContext
|
2023-07-10 15:55:29.984 INFO 14748 --- [restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 5327 ms
|
2023-07-10 15:55:32.347 INFO 14748 --- [restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
|
2023-07-10 15:55:32.624 INFO 14748 --- [restartedMain] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@47c36275, org.springframework.security.web.context.SecurityContextPersistenceFilter@3ed2723, org.springframework.security.web.header.HeaderWriterFilter@7756811, org.springframework.web.filter.CorsFilter@28939846, org.springframework.security.web.authentication.logout.LogoutFilter@50ded436, com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter@7928c3cf, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@50646de4, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@7886d9ce, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@3b78dfeb, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@5097da17, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2c99817, org.springframework.security.web.session.SessionManagementFilter@336bc2a9, org.springframework.security.web.access.ExceptionTranslationFilter@328ba2d7, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@2ca79095]
|
2023-07-10 15:55:32.657 INFO 14748 --- [restartedMain] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)]
|
2023-07-10 15:55:33.267 INFO 14748 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed
|
2023-07-10 15:55:33.331 INFO 14748 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s)
|
2023-07-10 15:55:33.383 INFO 14748 --- [restartedMain] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references
|
2023-07-10 15:55:33.629 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: taskUsingPOST_1
|
2023-07-10 15:55:33.663 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_1
|
2023-07-10 15:55:33.687 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_1
|
2023-07-10 15:55:33.700 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: listUsingPOST_1
|
2023-07-10 15:55:33.707 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_1
|
2023-07-10 15:55:33.771 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_1
|
2023-07-10 15:55:33.775 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_2
|
2023-07-10 15:55:33.799 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: answerSubmitUsingPOST_1
|
2023-07-10 15:55:33.805 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_3
|
2023-07-10 15:55:33.808 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_1
|
2023-07-10 15:55:33.818 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_4
|
2023-07-10 15:55:33.822 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_2
|
2023-07-10 15:55:33.825 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_1
|
2023-07-10 15:55:33.838 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_2
|
2023-07-10 15:55:33.848 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_5
|
2023-07-10 15:55:33.850 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_3
|
2023-07-10 15:55:33.856 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_3
|
2023-07-10 15:55:33.860 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_6
|
2023-07-10 15:55:33.862 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_4
|
2023-07-10 15:55:33.869 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_7
|
2023-07-10 15:55:33.882 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_8
|
2023-07-10 15:55:33.886 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_5
|
2023-07-10 15:55:33.890 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_2
|
2023-07-10 15:55:33.892 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_4
|
2023-07-10 15:55:33.958 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_9
|
2023-07-10 15:55:33.961 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_6
|
2023-07-10 15:55:33.965 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_3
|
2023-07-10 15:55:33.968 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_5
|
2023-07-10 15:55:33.975 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_10
|
2023-07-10 15:55:33.980 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_7
|
2023-07-10 15:55:33.991 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingGET_1
|
2023-07-10 15:55:33.992 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingHEAD_1
|
2023-07-10 15:55:33.992 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPOST_1
|
2023-07-10 15:55:33.993 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPUT_1
|
2023-07-10 15:55:33.994 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPATCH_1
|
2023-07-10 15:55:33.995 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingDELETE_1
|
2023-07-10 15:55:33.995 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingOPTIONS_1
|
2023-07-10 15:55:33.996 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingTRACE_1
|
2023-07-10 15:55:34.015 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_2
|
2023-07-10 15:55:34.022 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_2
|
2023-07-10 15:55:34.024 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_1
|
2023-07-10 15:55:34.026 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: logUsingPOST_1
|
2023-07-10 15:55:34.028 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: messagePageListUsingPOST_1
|
2023-07-10 15:55:34.029 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_3
|
2023-07-10 15:55:34.031 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: registerUsingPOST_1
|
2023-07-10 15:55:34.032 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: unReadCountUsingPOST_1
|
2023-07-10 15:55:34.034 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_3
|
2023-07-10 15:55:34.042 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_2
|
2023-07-10 15:55:34.043 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_4
|
2023-07-10 15:55:34.049 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_6
|
2023-07-10 15:55:34.058 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: importUserUsingPOST_1
|
2023-07-10 15:55:34.064 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_11
|
2023-07-10 15:55:34.066 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_8
|
2023-07-10 15:55:34.074 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_4
|
2023-07-10 15:55:34.077 INFO 14748 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: addUsingPOST_1
|
2023-07-10 15:55:34.183 INFO 14748 --- [restartedMain] org.xnio : XNIO version 3.3.8.Final
|
2023-07-10 15:55:34.200 INFO 14748 --- [restartedMain] org.xnio.nio : XNIO NIO Implementation Version 3.3.8.Final
|
2023-07-10 15:55:34.344 INFO 14748 --- [restartedMain] o.s.b.w.e.u.UndertowServletWebServer : Undertow started on port(s) 8000 (http) with context path ''
|
2023-07-10 15:55:34.349 INFO 14748 --- [restartedMain] com.mindskip.xzs.XzsApplication : Started XzsApplication in 10.637 seconds (JVM running for 13.418)
|
2023-07-10 15:56:11.018 INFO 14748 --- [XNIO-1 task-1] io.undertow.servlet : Initializing Spring DispatcherServlet 'dispatcherServlet'
|
2023-07-10 15:56:11.018 INFO 14748 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
|
2023-07-10 15:56:11.033 INFO 14748 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 15 ms
|
2023-07-10 15:56:11.140 INFO 14748 --- [XNIO-1 task-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
|
2023-07-10 15:56:12.839 INFO 14748 --- [XNIO-1 task-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
|
2023-07-10 15:56:12.850 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1
|
2023-07-10 15:56:12.878 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String)
|
2023-07-10 15:56:12.943 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1
|
2023-07-10 15:56:14.025 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1
|
2023-07-10 15:56:14.025 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String)
|
2023-07-10 15:56:14.052 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1
|
2023-07-10 15:56:14.077 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.U.insertSelective : ==> Preparing: insert into t_user_event_log ( user_id, user_name, real_name, content, create_time ) values ( ?, ?, ?, ?, ? )
|
2023-07-10 15:56:14.081 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.U.insertSelective : ==> Parameters: 2(Integer), admin(String), 管理员(String), admin 登录了考试系统(String), 2023-07-10 15:56:14.053(Timestamp)
|
2023-07-10 15:56:14.136 DEBUG 14748 --- [XNIO-1 task-1] r.c.m.x.r.U.insertSelective : <== Updates: 1
|
2023-07-10 15:58:45.898 INFO 14748 --- [XNIO-1 task-2] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/user/import
|
2023-07-10 15:59:00.681 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.DepartmentMapper.getName : ==> Preparing: select id , name,deleted from t_department where deleted=0 and name = ?
|
2023-07-10 15:59:00.681 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.DepartmentMapper.getName : ==> Parameters: ceshi(String)
|
2023-07-10 15:59:00.700 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.DepartmentMapper.getName : <== Total: 1
|
2023-07-10 15:59:00.703 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.DepartmentMapper.getName : ==> Preparing: select id , name,deleted from t_department where deleted=0 and name = ?
|
2023-07-10 15:59:00.703 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.DepartmentMapper.getName : ==> Parameters: ceshi(String)
|
2023-07-10 15:59:00.728 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.DepartmentMapper.getName : <== Total: 1
|
2023-07-10 15:59:20.214 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.UserMapper.insertUsers : ==> Preparing: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
2023-07-10 15:59:20.225 DEBUG 14748 --- [XNIO-1 task-2] r.c.m.x.r.UserMapper.insertUsers : ==> Parameters: 54bed396-fbe0-40e7-a14c-7756dfe8fd05(String), 1231231(String), iPLW3IFzzsRwrmDGLYj4P8zjbK7mFYNDSkuWTMb5Y1+ggT7+ZmKfRr9vIbHdWeD4c/lgTzf1nf7jgtzNIXDYwHdzBZDkLp9FrpMLTAdmOkyVuSKJC3oNWOsDADykqjKXtG5VvYVgdp8m+AK9Ol1WVEPw1K3YdGwFXc5tNnrBc8A=(String), 123123(String), 2023-07-10 15:59:00.703(Timestamp), 1(Integer), 1(Integer), 15(Integer), 1917beea-8493-4ff7-98c2-b451d8954dc0(String), 1231231(String), JYVEoNO7GATvosghtMbGMW6JapCPogc8XJj7/s7++QjHbilxXk6SeBN3/SwoO3+Xu8EnhK55lV2wEAplZa9EF5DOChpDFc5VTYfY+i3p2qSF7oA85hKQXGSkZ2LxXyVs4N2ePD0XbhnY0dES5X7RqL5fbMKz4f+gr1Y8t7BjUNo=(String), 123123(String), 2023-07-10 15:59:00.729(Timestamp), 1(Integer), 1(Integer), 15(Integer)
|
2023-07-10 15:59:22.603 ERROR 14748 --- [XNIO-1 task-2] c.m.x.c.s.exception.ExceptionHandle : test BusinessException roll back
|
|
com.mindskip.xzs.exception.BusinessException: test BusinessException roll back
|
at com.mindskip.xzs.service.impl.UserServiceImpl.insertUsers(UserServiceImpl.java:113)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$34a6676e.insertUsers(<generated>)
|
at com.mindskip.xzs.controller.admin.UserController.importUser(UserController.java:174)
|
at com.mindskip.xzs.controller.admin.UserController$$FastClassBySpringCGLIB$$366b89eb.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
|
at com.mindskip.xzs.controller.admin.UserController$$EnhancerBySpringCGLIB$$f9f245b1.importUser(<generated>)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:665)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
|
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
|
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:158)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
|
2023-07-10 16:00:28.266 INFO 14748 --- [Thread-31] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
|
2023-07-10 16:00:28.280 INFO 14748 --- [Thread-31] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
|
2023-07-10 16:00:28.284 INFO 14748 --- [Thread-31] io.undertow.servlet : Destroying Spring FrameworkServlet 'dispatcherServlet'
|
2023-07-10 16:00:37.622 INFO 19324 --- [restartedMain] com.mindskip.xzs.XzsApplication : Starting XzsApplication on DESKTOP-7A2KHS1 with PID 19324 (E:\ycll\qyksxt\target\classes started by qirong in E:\ycll\qyksxt)
|
2023-07-10 16:00:37.627 INFO 19324 --- [restartedMain] com.mindskip.xzs.XzsApplication : The following profiles are active: dev
|
2023-07-10 16:00:37.756 INFO 19324 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
|
2023-07-10 16:00:37.756 INFO 19324 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
|
2023-07-10 16:00:39.921 INFO 19324 --- [restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$dc8ef418] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
|
2023-07-10 16:00:40.430 WARN 19324 --- [restartedMain] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used
|
2023-07-10 16:00:40.456 INFO 19324 --- [restartedMain] io.undertow.servlet : Initializing Spring embedded WebApplicationContext
|
2023-07-10 16:00:40.456 INFO 19324 --- [restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 2699 ms
|
2023-07-10 16:00:42.156 INFO 19324 --- [restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729
|
2023-07-10 16:00:42.344 INFO 19324 --- [restartedMain] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@2236930a, org.springframework.security.web.context.SecurityContextPersistenceFilter@86064b0, org.springframework.security.web.header.HeaderWriterFilter@228f5cf5, org.springframework.web.filter.CorsFilter@300a9f2c, org.springframework.security.web.authentication.logout.LogoutFilter@58a823ff, com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter@7c2b9f52, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@76842f5, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@a97fba7, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@11df89d8, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@39c7bf0f, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2a05818c, org.springframework.security.web.session.SessionManagementFilter@17e91739, org.springframework.security.web.access.ExceptionTranslationFilter@5485e823, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@7d1d008b]
|
2023-07-10 16:00:42.376 INFO 19324 --- [restartedMain] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)]
|
2023-07-10 16:00:42.880 INFO 19324 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed
|
2023-07-10 16:00:42.914 INFO 19324 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s)
|
2023-07-10 16:00:42.980 INFO 19324 --- [restartedMain] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references
|
2023-07-10 16:00:43.213 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: taskUsingPOST_1
|
2023-07-10 16:00:43.245 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_1
|
2023-07-10 16:00:43.264 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_1
|
2023-07-10 16:00:43.270 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: listUsingPOST_1
|
2023-07-10 16:00:43.275 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_1
|
2023-07-10 16:00:43.310 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_1
|
2023-07-10 16:00:43.321 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_2
|
2023-07-10 16:00:43.342 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: answerSubmitUsingPOST_1
|
2023-07-10 16:00:43.346 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_3
|
2023-07-10 16:00:43.348 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_1
|
2023-07-10 16:00:43.358 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_1
|
2023-07-10 16:00:43.371 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_2
|
2023-07-10 16:00:43.378 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_4
|
2023-07-10 16:00:43.381 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_2
|
2023-07-10 16:00:43.392 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_5
|
2023-07-10 16:00:43.393 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_3
|
2023-07-10 16:00:43.396 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_3
|
2023-07-10 16:00:43.398 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_6
|
2023-07-10 16:00:43.400 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_4
|
2023-07-10 16:00:43.406 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_7
|
2023-07-10 16:00:43.415 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_8
|
2023-07-10 16:00:43.420 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_5
|
2023-07-10 16:00:43.423 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_2
|
2023-07-10 16:00:43.425 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_4
|
2023-07-10 16:00:43.455 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_9
|
2023-07-10 16:00:43.458 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_6
|
2023-07-10 16:00:43.462 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_3
|
2023-07-10 16:00:43.465 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_5
|
2023-07-10 16:00:43.472 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_10
|
2023-07-10 16:00:43.474 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_7
|
2023-07-10 16:00:43.481 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingGET_1
|
2023-07-10 16:00:43.481 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingHEAD_1
|
2023-07-10 16:00:43.482 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPOST_1
|
2023-07-10 16:00:43.482 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPUT_1
|
2023-07-10 16:00:43.483 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPATCH_1
|
2023-07-10 16:00:43.483 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingDELETE_1
|
2023-07-10 16:00:43.485 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingOPTIONS_1
|
2023-07-10 16:00:43.485 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingTRACE_1
|
2023-07-10 16:00:43.502 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_4
|
2023-07-10 16:00:43.512 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_6
|
2023-07-10 16:00:43.521 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: importUserUsingPOST_1
|
2023-07-10 16:00:43.526 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_11
|
2023-07-10 16:00:43.527 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_8
|
2023-07-10 16:00:43.531 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_2
|
2023-07-10 16:00:43.536 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_1
|
2023-07-10 16:00:43.569 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_2
|
2023-07-10 16:00:43.574 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_3
|
2023-07-10 16:00:43.577 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_2
|
2023-07-10 16:00:43.578 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: logUsingPOST_1
|
2023-07-10 16:00:43.581 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: messagePageListUsingPOST_1
|
2023-07-10 16:00:43.582 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_3
|
2023-07-10 16:00:43.585 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: registerUsingPOST_1
|
2023-07-10 16:00:43.586 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: unReadCountUsingPOST_1
|
2023-07-10 16:00:43.589 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_4
|
2023-07-10 16:00:43.592 INFO 19324 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: addUsingPOST_1
|
2023-07-10 16:00:43.702 INFO 19324 --- [restartedMain] org.xnio : XNIO version 3.3.8.Final
|
2023-07-10 16:00:43.716 INFO 19324 --- [restartedMain] org.xnio.nio : XNIO NIO Implementation Version 3.3.8.Final
|
2023-07-10 16:00:43.825 INFO 19324 --- [restartedMain] o.s.b.w.e.u.UndertowServletWebServer : Undertow started on port(s) 8000 (http) with context path ''
|
2023-07-10 16:00:43.829 INFO 19324 --- [restartedMain] com.mindskip.xzs.XzsApplication : Started XzsApplication in 6.98 seconds (JVM running for 8.445)
|
2023-07-10 16:00:51.477 INFO 19324 --- [XNIO-1 task-1] io.undertow.servlet : Initializing Spring DispatcherServlet 'dispatcherServlet'
|
2023-07-10 16:00:51.478 INFO 19324 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet'
|
2023-07-10 16:00:51.491 INFO 19324 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 13 ms
|
2023-07-10 16:00:51.604 INFO 19324 --- [XNIO-1 task-1] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/user/import
|
2023-07-10 16:00:53.790 INFO 19324 --- [XNIO-1 task-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
|
2023-07-10 16:00:54.199 INFO 19324 --- [XNIO-1 task-1] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
|
2023-07-10 16:00:54.212 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.DepartmentMapper.getName : ==> Preparing: select id , name,deleted from t_department where deleted=0 and name = ?
|
2023-07-10 16:00:54.245 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.DepartmentMapper.getName : ==> Parameters: ceshi(String)
|
2023-07-10 16:00:54.302 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.DepartmentMapper.getName : <== Total: 1
|
2023-07-10 16:00:54.949 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.DepartmentMapper.getName : ==> Preparing: select id , name,deleted from t_department where deleted=0 and name = ?
|
2023-07-10 16:00:54.949 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.DepartmentMapper.getName : ==> Parameters: ceshi(String)
|
2023-07-10 16:00:54.971 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.DepartmentMapper.getName : <== Total: 1
|
2023-07-10 16:00:56.001 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.insertUsers : ==> Preparing: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
2023-07-10 16:00:56.005 DEBUG 19324 --- [XNIO-1 task-1] r.c.m.x.r.UserMapper.insertUsers : ==> Parameters: 4a79425b-4202-4d2d-8e24-588d8ce11174(String), 1231231(String), cxRrY8jl8Hh78K7BVQVwYtn5l14G3qhcdpFKrITwHwUbg5tGJEcnPFfQESV3tv/PeTTpO80ndmfvwl441wLrJcaCbKYqm1TK3oPW3yPVEUWsAVlv2Qfh+PQTd3HWYKn5WViqSDFzlD0EsjMEhShGUBxnmQcNtk2wsySA3ArQYdU=(String), 123123(String), 2023-07-10 16:00:54.929(Timestamp), 1(Integer), 1(Integer), 15(Integer), ba7735f4-4b26-47c2-ad68-084c25ab0b65(String), 1231231(String), I8h0Rc2GK5YJawCQCAZ+vggmNQkrdAr6+uUae4P3sZvftHv2NKUTyxCu/VdY4HpYG+rQs1Tn9NQxOXQutWYZeS11j3cG24FwutmMSqY1LAVK991Afq/AD/cCELkJuqFSUzWOfrZM6UqwTFoNjcwr69W/WRE4RLDTJSBMktwM2Ww=(String), 123123(String), 2023-07-10 16:00:54.972(Timestamp), 1(Integer), 1(Integer), 15(Integer)
|
2023-07-10 16:00:56.194 ERROR 19324 --- [XNIO-1 task-1] c.m.x.c.s.exception.ExceptionHandle :
|
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.insertUsers-Inline
|
### The error occurred while setting parameters
|
### SQL: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.insertUsers-Inline
|
### The error occurred while setting parameters
|
### SQL: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
|
at com.sun.proxy.$Proxy83.insert(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.insertUsers(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.insertUsers(UserServiceImpl.java:110)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$6f13c7e3.insertUsers(<generated>)
|
at com.mindskip.xzs.controller.admin.UserController.importUser(UserController.java:174)
|
at com.mindskip.xzs.controller.admin.UserController$$FastClassBySpringCGLIB$$366b89eb.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
|
at com.mindskip.xzs.controller.admin.UserController$$EnhancerBySpringCGLIB$$18a61424.importUser(<generated>)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:665)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
|
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
|
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:158)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:143)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''ba7735f4-4b26-47c2-ad68-084c25ab0b65','1231231','I8h0Rc2GK5YJawCQCAZ+vggmNQkrdA' at line 1
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
at com.sun.proxy.$Proxy142.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
|
at com.sun.proxy.$Proxy140.update(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
... 120 common frames omitted
|
|
2023-07-10 16:01:49.561 INFO 19324 --- [XNIO-1 task-3] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/user/import
|
2023-07-10 16:01:52.221 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.DepartmentMapper.getName : ==> Preparing: select id , name,deleted from t_department where deleted=0 and name = ?
|
2023-07-10 16:01:52.221 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.DepartmentMapper.getName : ==> Parameters: ceshi(String)
|
2023-07-10 16:01:52.244 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.DepartmentMapper.getName : <== Total: 1
|
2023-07-10 16:01:52.245 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.DepartmentMapper.getName : ==> Preparing: select id , name,deleted from t_department where deleted=0 and name = ?
|
2023-07-10 16:01:52.245 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.DepartmentMapper.getName : ==> Parameters: ceshi(String)
|
2023-07-10 16:01:52.277 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.DepartmentMapper.getName : <== Total: 1
|
2023-07-10 16:01:53.379 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.insertUsers : ==> Preparing: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
2023-07-10 16:01:53.381 DEBUG 19324 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.insertUsers : ==> Parameters: 73d8121c-bdac-4d57-b8ad-b3b4a60ea5b0(String), 1231231(String), Bg7iafprxSBJFtn3xKtCQhxnW6Pbgqb43pD6unjrfZOeOAEjhKYkDaT0yy/fXvNVDcMjbyfyiSOdRwkvTgUqTCMcXbrQk3OfKvo/n26rVL4SKNHPGXN3J7VMp4bAlBwu0YlF0fLCuP3nkCuiUEfYhU3cDLcu9EhDSOdcgoMUFb0=(String), 123123(String), 2023-07-10 16:01:52.245(Timestamp), 1(Integer), 1(Integer), 15(Integer), cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4(String), 123123(String), MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiWdH0+/FwTfopE/k8iE2K8H48fl2v/iDol27eD04V93cPIUolSfxWCKOT0l6dS8n5px/dY1DYiiP5wAeIhyh51Q+WMXxCKBEu9oE7r5I5+u4Z3cY6JwgReaClWJwZEZ4Ea/2sEaUKiHdb4=(String), 123120(String), 2023-07-10 16:01:52.279(Timestamp), 1(Integer), 1(Integer), 15(Integer)
|
2023-07-10 16:01:53.505 ERROR 19324 --- [XNIO-1 task-3] c.m.x.c.s.exception.ExceptionHandle :
|
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.insertUsers-Inline
|
### The error occurred while setting parameters
|
### SQL: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
### The error may exist in file [E:\ycll\qyksxt\target\classes\mapper\UserMapper.xml]
|
### The error may involve com.mindskip.xzs.repository.UserMapper.insertUsers-Inline
|
### The error occurred while setting parameters
|
### SQL: insert into t_user (user_uuid,user_name,password,real_name,last_active_time,role,status,user_level,deleted) values (?,?,?,?, ?,?,?,?,0) ; (?,?,?,?, ?,?,?,?,0)
|
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
|
at com.sun.proxy.$Proxy83.insert(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
|
at com.sun.proxy.$Proxy84.insertUsers(Unknown Source)
|
at com.mindskip.xzs.service.impl.UserServiceImpl.insertUsers(UserServiceImpl.java:110)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$FastClassBySpringCGLIB$$921573c2.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:295)
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
|
at com.mindskip.xzs.service.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$6f13c7e3.insertUsers(<generated>)
|
at com.mindskip.xzs.controller.admin.UserController.importUser(UserController.java:174)
|
at com.mindskip.xzs.controller.admin.UserController$$FastClassBySpringCGLIB$$366b89eb.invoke(<generated>)
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
|
at com.mindskip.xzs.controller.admin.UserController$$EnhancerBySpringCGLIB$$18a61424.importUser(<generated>)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:665)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
|
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
|
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
|
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:158)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
|
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
|
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
|
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
|
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
|
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
|
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
|
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
|
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
|
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
|
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
|
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
|
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
|
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
|
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
|
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
|
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
|
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
|
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
|
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
|
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
|
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
|
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
|
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
|
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
|
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:364)
|
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
|
at java.lang.Thread.run(Thread.java:750)
|
Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''cbf214bb-3a7f-4e93-94a4-9f7229c9a3a4','123123','MHlwBr/Z9yb9VlRWhBD84eWwAXSgBiW' at line 1
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:370)
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
at com.sun.proxy.$Proxy142.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
|
at com.sun.proxy.$Proxy140.update(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
|
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
|
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
|
... 120 common frames omitted
|
|
2023-07-10 16:02:58.862 INFO 19324 --- [Thread-21] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
|
2023-07-10 16:02:58.912 INFO 19324 --- [Thread-21] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
|
2023-07-10 16:02:58.915 INFO 19324 --- [Thread-21] io.undertow.servlet : Destroying Spring FrameworkServlet 'dispatcherServlet'
|
