lujiefsi opened a new issue, #8070:
URL: https://github.com/apache/inlong/issues/8070
### What happened
When i delete a users, an error happens:"There was an error in the
service...Please try again later! If there are still problems, please contact
the administrator"
After dig the log, i found ：
2023-05-23 02:47:08.456 -ERROR [http-nio-8083-exec-4]
w.c.ControllerExceptionHandler:150 - failed to handle request on path:
/inlong/manager/openapi/heartbeat/report by user:
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException:
Unknown column 'display_name' in 'field list'
### The error may exist in class path resource
[mappers/InlongClusterEntityMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select id, name, display_name, type, url,
cluster_tags, ext_tag, token, ext_params, description, heartbeat,
in_charges, status, is_deleted, creator, modifier, create_time, modify_time,
version from inlong_cluster WHERE is_deleted = 0
and type = ? and
name = ? order by modify_time desc
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'display_name'
in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException:
Unknown column 'display_name' in 'field list'
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
~[spring-jdbc-5.3.27.jar:5.3.27]
at
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
~[spring-jdbc-5.3.27.jar:5.3.27]
at
org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
~[mybatis-spring-2.0.5.jar:2.0.5]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
~[mybatis-spring-2.0.5.jar:2.0.5]
at com.sun.proxy.$Proxy95.selectOne(Unknown Source) ~[?:?]
at
org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
~[mybatis-spring-2.0.5.jar:2.0.5]
at
org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:152)
~[mybatis-3.5.5.jar:3.5.5]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
~[mybatis-3.5.5.jar:3.5.5]
at com.sun.proxy.$Proxy101.selectByNameAndType(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_342]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
~[spring-aop-5.3.18.jar:5.3.18]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
~[spring-aop-5.3.18.jar:5.3.18]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
~[spring-aop-5.3.18.jar:5.3.18]
at
org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
~[spring-tx-5.3.27.jar:5.3.27]
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
~[spring-aop-5.3.18.jar:5.3.18]
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
~[spring-aop-5.3.18.jar:5.3.18]
at com.sun.proxy.$Proxy102.selectByNameAndType(Unknown Source) ~[?:?]
at
org.apache.inlong.manager.service.heartbeat.HeartbeatManager.fetchCluster(HeartbeatManager.java:299)
~[manager-service-1.8.0-SNAPSHOT.jar:1.8.0-SNAPSHOT]
at
com.github.benmanes.caffeine.cache.LocalLoadingCache.lambda$newMappingFunction$2(LocalLoadingCache.java:145)
~[caffeine-2.9.3.jar:?]
at
com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2406)
~[caffeine-2.9.3.jar:?]
at
java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853)
~[?:1.8.0_342]
at
com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2404)
~[caffeine-2.9.3.jar:?]
at
com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2387)
~[caffeine-2.9.3.jar:?]
at
com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:108)
~[caffeine-2.9.3.jar:?]
at
com.github.benmanes.caffeine.cache.LocalLoadingCache.get(LocalLoadingCache.java:56)
~[caffeine-2.9.3.jar:?]
at
org.apache.inlong.manager.service.heartbeat.HeartbeatManager.reportHeartbeat(HeartbeatManager.java:131)
~[manager-service-1.8.0-SNAPSHOT.jar:1.8.0-SNAPSHOT]
at
org.apache.inlong.manager.service.heartbeat.HeartbeatManager$$FastClassBySpringCGLIB$$8a098cb4.invoke(<generated>)
~[manager-service-1.8.0-SNAPSHOT.jar:1.8.0-SNAPSHOT]
at
org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
~[spring-core-5.3.27.jar:5.3.27]
at
org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
~[spring-aop-5.3.18.jar:5.3.18]
at
org.apache.inlong.manager.service.heartbeat.HeartbeatManager$$EnhancerBySpringCGLIB$$883fec4d.reportHeartbeat(<generated>)
~[manager-service-1.8.0-SNAPSHOT.jar:1.8.0-SNAPSHOT]
at
org.apache.inlong.manager.service.heartbeat.HeartbeatServiceImpl.reportHeartbeat(HeartbeatServiceImpl.java:81)
~[manager-service-1.8.0-SNAPSHOT.jar:1.8.0-SNAPSHOT]
at
org.apache.inlong.manager.web.controller.openapi.OpenHeartbeatController.reportHeartbeat(OpenHeartbeatController.java:45)
~[manager-web.jar:1.8.0-SNAPSHOT]
at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_342]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
at
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
~[spring-web-5.3.27.jar:5.3.27]
at
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
~[spring-web-5.3.27.jar:5.3.27]
at
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
~[spring-webmvc-5.3.18.jar:5.3.18]
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
~[spring-webmvc-5.3.18.jar:5.3.18]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
~[tomcat-embed-core-9.0.60.jar:4.0.FR]
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
~[spring-webmvc-5.3.18.jar:5.3.18]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
~[tomcat-embed-core-9.0.60.jar:4.0.FR]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
~[tomcat-embed-websocket-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:458)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:373)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
~[shiro-core-1.10.1.jar:1.10.1]
at
org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
~[shiro-core-1.10.1.jar:1.10.1]
at
org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
~[shiro-core-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:370)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154)
~[shiro-web-1.10.1.jar:1.10.1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
~[spring-web-5.3.27.jar:5.3.27]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
~[spring-web-5.3.27.jar:5.3.27]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
~[spring-web-5.3.27.jar:5.3.27]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
~[spring-web-5.3.27.jar:5.3.27]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
~[spring-web-5.3.27.jar:5.3.27]
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
~[spring-web-5.3.27.jar:5.3.27]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
~[tomcat-embed-core-9.0.60.jar:9.0.60]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_342]
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'display_name'
in 'field list'
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
~[mysql-connector-java-8.0.27.jar:8.0.27]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
~[mysql-connector-java-8.0.27.jar:8.0.27]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
~[mysql-connector-java-8.0.27.jar:8.0.27]
at
com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
~[mysql-connector-java-8.0.27.jar:8.0.27]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
~[druid-1.2.6.jar:1.2.6]
at
com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:660)
~[druid-1.2.6.jar:1.2.6]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
~[druid-1.2.6.jar:1.2.6]
at
com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
~[druid-1.2.6.jar:1.2.6]
at
com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
~[druid-1.2.6.jar:1.2.6]
at
com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
~[druid-1.2.6.jar:1.2.6]
at
com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
~[druid-1.2.6.jar:1.2.6]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.5.jar:3.5.5]
at
com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
~[pagehelper-5.3.0.jar:?]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
~[mybatis-3.5.5.jar:3.5.5]
at com.sun.proxy.$Proxy226.query(Unknown Source) ~[?:?]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.5.jar:3.5.5]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
~[mybatis-3.5.5.jar:3.5.5]
at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_342]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_342]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
~[mybatis-spring-2.0.5.jar:2.0.5]
... 98 more
### What you expected to happen
admin can delete the user without any execetions
### How to reproduce
1. startup inlong by docker-compose, docker image version of inlong is latest
2. add a user
3. delete the user
### Environment
docker-compose, version is latest.
### InLong version
master
### InLong Component
InLong Manager
### Are you willing to submit PR?
- [ ] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
