healchow opened a new issue, #4583: URL: https://github.com/apache/incubator-inlong/issues/4583
### What happened Cannot see any inlong group: <img width="1204" alt="image" src="https://user-images.githubusercontent.com/31994335/172534156-0d7eedd9-d2ee-4d5f-80b5-ced7dc64fee8.png";> the log info: ``` 2022-06-08 12:42:21.536 -ERROR [nio-8083-exec-8] w.c.ControllerExceptionHandler : failed to handle request on path: /api/inlong/manager/group/list by user: admin 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 'LIMIT 10' at line 12 ### The error may exist in class path resource [mappers/InlongGroupEntityMapper.xml] ### The error may involve org.apache.inlong.manager.dao.mapper.InlongGroupEntityMapper.selectByCondition-Inline ### The error occurred while setting parameters ### SQL: select id, inlong_group_id, name, description, mq_type, mq_resource, daily_records, daily_storage, peak_records, max_length, enable_zookeeper, enable_create_resource, lightweight, inlong_cluster_tag, ext_params, in_charges, followers, status, previous_status, is_deleted, creator, modifier, create_time, modify_time from inlong_group WHERE is_deleted = 0 order by modify_time desc limit 100 LIMIT ? ### 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 'LIMIT 10' at line 12 ; 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 'LIMIT 10' at line 12 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.20.jar:5.3.20] ``` ### What you expected to happen No errors happen. ### How to reproduce Use the latest code, and open the dashboard, it can not see any inlong group. ### Environment _No response_ ### InLong version master ### InLong Component InLong Manager ### Are you willing to submit PR? - [X] 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]
![https://user-images.githubusercontent.com/31994335/172534156-0d7eedd9-d2ee-4d5f-80b5-ced7dc64fee8.png"](https://user-images.githubusercontent.com/31994335/172534156-0d7eedd9-d2ee-4d5f-80b5-ced7dc64fee8.png"){kind=link}