Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

nacos 1.3.1 start with embedded mode:bad SQL grammar #3434

Closed
zhboseu opened this issue Jul 24, 2020 · 2 comments
Closed

nacos 1.3.1 start with embedded mode:bad SQL grammar #3434

zhboseu opened this issue Jul 24, 2020 · 2 comments
Labels
contribution welcome kind/bug Category issues or prs related to bug.
Milestone

Comments

@zhboseu
Copy link

zhboseu commented Jul 24, 2020

2020-07-18 08:37:50,884 ERROR [db-error] DataAccessException : caused: StatementCallback; bad SQL grammar [select 1 from config_info_beta limit 1]; nested exception is java.sql.SQLSyntaxErrorException: Syntax error: Encountered "1" at line 1, column 38.;caused: Syntax error: Encountered "1" at line 1, column 38.;caused: Syntax error: Encountered "1" at line 1, column 38.;

2020-07-18 08:37:50,884 ERROR There was an error querying the data, request : SelectRequest{queryType=1, sql='select 1 from config_info_beta limit 1', args=null, className='java.lang.Integer'}, error : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select 1 from config_info_beta limit 1]; nested exception is java.sql.SQLSyntaxErrorException: Syntax error: Encountered "1" at line 1, column 38.

2020-07-18 08:37:50,884 ERROR An exception occurred during the query operation : com.alibaba.nacos.config.server.exception.NJdbcException: BadSqlGrammarException:Syntax error: Encountered "1" at line 1, column 38.

2020-07-18 08:37:50,910 ERROR [db-error] DataAccessException : caused: StatementCallback; bad SQL grammar [select 1 from config_info_tag limit 1]; nested exception is java.sql.SQLSyntaxErrorException: Syntax error: Encountered "1" at line 1, column 37.;caused: Syntax error: Encountered "1" at line 1, column 37.;caused: Syntax error: Encountered "1" at line 1, column 37.;

2020-07-18 08:37:50,910 ERROR There was an error querying the data, request : SelectRequest{queryType=1, sql='select 1 from config_info_tag limit 1', args=null, className='java.lang.Integer'}, error : org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select 1 from config_info_tag limit 1]; nested exception is java.sql.SQLSyntaxErrorException: Syntax error: Encountered "1" at line 1, column 37.

2020-07-18 08:37:50,910 ERROR An exception occurred during the query operation : com.alibaba.nacos.config.server.exception.NJdbcException: BadSqlGrammarException:Syntax error: Encountered "1" at line 1, column 37.

Issue Description

bad SQL grammar

How to reproduce it (as minimally and precisely as possible)

  1. nacos 1.3.1 cluster, 3 nodes
  2. ./startup.sh -p embedded
  3. logs/config-fatal.log
@KomachiSion KomachiSion added kind/bug Category issues or prs related to bug. contribution welcome labels Jul 24, 2020
@KomachiSion KomachiSion added this to the 1.3.2 milestone Jul 24, 2020
@ljhrot
Copy link
Contributor

ljhrot commented Jul 25, 2020

@i will solve it@

@ljhrot
Copy link
Contributor

ljhrot commented Jul 26, 2020

@ready to close@

@KomachiSion KomachiSion mentioned this issue Aug 4, 2020
5 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
contribution welcome kind/bug Category issues or prs related to bug.
Projects
None yet
Development

No branches or pull requests

3 participants