2025-02-12 17:01:49.265 [com.alibaba.nacos.client.naming.updater.0] ERROR com.alibaba.nacos.common.remote.client - Send request fail, request=ServiceQueryRequest{headers={}, requestId='null'}, retryTimes=0,errorMessage=java.util.concurrent.TimeoutException: Waited 3000 milliseconds (plus 593 milliseconds, 778800 nanoseconds delay) for com.alibaba.nacos.shaded.io.grpc.stub.ClientCalls$GrpcFuture@67d76a6d[status=PENDING, info=[GrpcFuture{clientCall={delegate={delegate=ClientCallImpl{method=MethodDescriptor{fullMethodName=Request/request, type=UNARY, idempotent=false, safe=false, sampledToLocalTracing=true, requestMarshaller=com.alibaba.nacos.shaded.io.grpc.protobuf.lite.ProtoLiteUtils$MessageMarshaller@44a2b294, responseMarshaller=com.alibaba.nacos.shaded.io.grpc.protobuf.lite.ProtoLiteUtils$MessageMarshaller@686a13bd, schemaDescriptor=com.alibaba.nacos.api.grpc.auto.RequestGrpc$RequestMethodDescriptorSupplier@655c1e8d}}}}}]]
|
2025-02-12 17:02:02.246 [com.alibaba.nacos.client.naming.updater.1] ERROR com.alibaba.nacos.common.remote.client - Send request fail, request=ServiceQueryRequest{headers={}, requestId='null'}, retryTimes=0,errorMessage=java.util.concurrent.TimeoutException: Waited 3000 milliseconds (plus 1493 milliseconds, 782600 nanoseconds delay) for com.alibaba.nacos.shaded.io.grpc.stub.ClientCalls$GrpcFuture@ead549d[status=PENDING, info=[GrpcFuture{clientCall={delegate={delegate=ClientCallImpl{method=MethodDescriptor{fullMethodName=Request/request, type=UNARY, idempotent=false, safe=false, sampledToLocalTracing=true, requestMarshaller=com.alibaba.nacos.shaded.io.grpc.protobuf.lite.ProtoLiteUtils$MessageMarshaller@44a2b294, responseMarshaller=com.alibaba.nacos.shaded.io.grpc.protobuf.lite.ProtoLiteUtils$MessageMarshaller@686a13bd, schemaDescriptor=com.alibaba.nacos.api.grpc.auto.RequestGrpc$RequestMethodDescriptorSupplier@655c1e8d}}}}}]]
|
2025-02-12 17:04:13.123 [http-nio-10038-exec-4] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. , jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, lastPacketReceivedIdleMillis : 125128
|
2025-02-12 17:04:13.140 [http-nio-10038-exec-4] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. , jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, lastPacketReceivedIdleMillis : 137925
|
2025-02-12 17:04:13.159 [http-nio-10038-exec-4] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. , jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, lastPacketReceivedIdleMillis : 137983
|
2025-02-12 17:04:44.002 [http-nio-10038-exec-3] ERROR com.doumee.config.handler.GlobalExceptionHandler -
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.project_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.project_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
|
at com.sun.proxy.$Proxy251.selectJoinList(Unknown Source)
|
at com.doumee.service.business.impl.YwRoomServiceImpl.getRoomContract(YwRoomServiceImpl.java:455)
|
at com.doumee.cloud.admin.YwRoomCloudController.getRoomContract(YwRoomCloudController.java:116)
|
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:497)
|
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:105)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.github.xiaoymin.knife4j.spring.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:87)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.doumee.core.servlet.ServletRewriteFilter.doFilter(ServletRewriteFilter.java:28)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
at java.lang.Thread.run(Thread.java:745)
|
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 'group by t.id' at line 6
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
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.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
|
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
|
at com.sun.proxy.$Proxy146.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
|
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy144.query(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:169)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:61)
|
at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
|
... 83 common frames omitted
|
2025-02-12 17:04:48.585 [http-nio-10038-exec-5] ERROR com.doumee.config.handler.GlobalExceptionHandler -
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
|
at com.sun.proxy.$Proxy251.selectJoinList(Unknown Source)
|
at com.doumee.service.business.impl.YwRoomServiceImpl.getRoomContract(YwRoomServiceImpl.java:455)
|
at com.doumee.cloud.admin.YwRoomCloudController.getRoomContract(YwRoomCloudController.java:116)
|
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:497)
|
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:105)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.github.xiaoymin.knife4j.spring.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:87)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.doumee.core.servlet.ServletRewriteFilter.doFilter(ServletRewriteFilter.java:28)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
at java.lang.Thread.run(Thread.java:745)
|
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 'group by t.id' at line 6
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
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.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
|
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
|
at com.sun.proxy.$Proxy146.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
|
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy144.query(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:169)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:61)
|
at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
|
... 83 common frames omitted
|
2025-02-12 17:04:48.737 [http-nio-10038-exec-8] ERROR com.doumee.config.handler.GlobalExceptionHandler -
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
|
at com.sun.proxy.$Proxy251.selectJoinList(Unknown Source)
|
at com.doumee.service.business.impl.YwRoomServiceImpl.getRoomContract(YwRoomServiceImpl.java:455)
|
at com.doumee.cloud.admin.YwRoomCloudController.getRoomContract(YwRoomCloudController.java:116)
|
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:497)
|
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:105)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.github.xiaoymin.knife4j.spring.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:87)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.doumee.core.servlet.ServletRewriteFilter.doFilter(ServletRewriteFilter.java:28)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
at java.lang.Thread.run(Thread.java:745)
|
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 'group by t.id' at line 6
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
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.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
|
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
|
at com.sun.proxy.$Proxy146.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
|
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy144.query(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:169)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:61)
|
at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
|
... 83 common frames omitted
|
2025-02-12 17:04:53.964 [http-nio-10038-exec-3] ERROR com.doumee.config.handler.GlobalExceptionHandler -
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
|
at com.sun.proxy.$Proxy251.selectJoinList(Unknown Source)
|
at com.doumee.service.business.impl.YwRoomServiceImpl.getRoomContract(YwRoomServiceImpl.java:455)
|
at com.doumee.cloud.admin.YwRoomCloudController.getRoomContract(YwRoomCloudController.java:116)
|
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:497)
|
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:105)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.github.xiaoymin.knife4j.spring.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:87)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.doumee.core.servlet.ServletRewriteFilter.doFilter(ServletRewriteFilter.java:28)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
at java.lang.Thread.run(Thread.java:745)
|
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 'group by t.id' at line 6
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
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.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
|
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
|
at com.sun.proxy.$Proxy146.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
|
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy144.query(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:169)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:61)
|
at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
|
... 83 common frames omitted
|
2025-02-12 17:04:55.674 [http-nio-10038-exec-1] ERROR com.doumee.config.handler.GlobalExceptionHandler -
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
org.springframework.jdbc.BadSqlGrammarException:
|
### Error querying 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 'group by t.id' at line 6
|
### The error may exist in com/doumee/dao/business/YwRoomMapper.java (best guess)
|
### The error may involve defaultParameterMap
|
### The error occurred while setting parameters
|
### SQL: SELECT t.id,t.creator,t.create_date,t.editor,t.edit_date,t.isdeleted,t.name,t.remark,t.status,t.sortnum,t.imgurl,t.code,t.room_num,t.is_investment,t.area,t.fee_area,t.rent_area,t.floor,t.project_id,t.building_id,t.lease_now_status,t.lease_rent_date FROM `yw_room` t LEFT JOIN `yw_contract_room` t1 ON (t1.room_id = t.id) WHERE (t.isdeleted = ? AND t.is_investment = ? AND t.status = ? AND t.building_id = ? AND t1.contract_id IN (?,?,?,?,?,?,?,?,?,?,?)) ORDER BY t.sortnum ASC group by t.id
|
### 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 'group by t.id' at line 6
|
; 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 'group by t.id' at line 6
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
|
at com.sun.proxy.$Proxy108.selectList(Unknown Source)
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
|
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
|
at com.sun.proxy.$Proxy251.selectJoinList(Unknown Source)
|
at com.doumee.service.business.impl.YwRoomServiceImpl.getRoomContract(YwRoomServiceImpl.java:455)
|
at com.doumee.cloud.admin.YwRoomCloudController.getRoomContract(YwRoomCloudController.java:116)
|
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:497)
|
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:105)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.github.xiaoymin.knife4j.spring.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:87)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
|
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
|
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
|
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
|
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
|
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
|
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at com.doumee.core.servlet.ServletRewriteFilter.doFilter(ServletRewriteFilter.java:28)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707)
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
at java.lang.Thread.run(Thread.java:745)
|
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 'group by t.id' at line 6
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
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.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
|
at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
|
at com.sun.proxy.$Proxy146.execute(Unknown Source)
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80)
|
at sun.reflect.GeneratedMethodAccessor121.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy144.query(Unknown Source)
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65)
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336)
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158)
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110)
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:169)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at sun.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:61)
|
at com.github.yulichang.interceptor.MPJInterceptor.intercept(MPJInterceptor.java:78)
|
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
|
at com.sun.proxy.$Proxy143.query(Unknown Source)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142)
|
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
at java.lang.reflect.Method.invoke(Method.java:497)
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
|
... 83 common frames omitted
|
2025-02-12 17:05:55.942 [http-nio-10038-exec-6] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. , jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, lastPacketReceivedIdleMillis : 60234
|
2025-02-12 17:05:55.961 [http-nio-10038-exec-6] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. , jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, lastPacketReceivedIdleMillis : 60281
|
2025-02-12 17:05:55.979 [http-nio-10038-exec-6] ERROR com.alibaba.druid.pool.DruidAbstractDataSource - discard long time none received connection. , jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, jdbcUrl : jdbc:mysql://sh-cdb-aiskr3vy.sql.tencentcdb.com:62443/funingyunwei?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai, lastPacketReceivedIdleMillis : 60380
|
