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

[Issue] The Open API of namespaces list can't be access #12665

Open
mercyblitz opened this issue Sep 19, 2024 · 1 comment
Open

[Issue] The Open API of namespaces list can't be access #12665

mercyblitz opened this issue Sep 19, 2024 · 1 comment
Labels
kind/bug Category issues or prs related to bug.

Comments

@mercyblitz
Copy link
Member

Describe the bug
The SQL error on accessing the Open API of namespaces list(/v2/console/namespace/list).

Expected behavior
The expected response content:

{
  "code": 0,
  "message": "success",
  "data": [
          {
                  "namespace": "",
                  "namespaceShowName": "public",
                  "namespaceDesc": null,
                  "quota": 200,
                  "configCount": 1,
                  "type": 0
          }
  ]
}

Actually behavior
The actual response content :

{
  "code": 10002,
  "message": "data access error",
  "data": "PreparedStatementCallback; bad SQL grammar [SELECT id,quota,`usage`,`max_size`,max_aggr_count,max_aggr_size,tenant_id FROM tenant_capacity WHERE tenant_id = ?]; nested exception is java.sql.SQLSyntaxErrorException: Lexical error at line 1, column 17.  Encountered: \"`\" (96), after : \"\"."
}

How to Reproduce
Steps to reproduce the behavior:

  1. Start Nacos Server on the Docker environment
  2. Access the Open API /v2/console/namespace/list
  3. Get the unexpected result

Desktop (please complete the following information):

  • OS: Windows and Linux
  • Version: Nacos Server Docker Image 2.4.2
  • Module: Open API - Namespaces list
@mercyblitz mercyblitz added the kind/bug Category issues or prs related to bug. label Sep 19, 2024
@Bo-Qiu
Copy link
Contributor

Bo-Qiu commented Sep 19, 2024

FYI
#12625

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/bug Category issues or prs related to bug.
Projects
None yet
Development

No branches or pull requests

2 participants