Skip to content

[Nacos3.0] Beta can't run with derby database. #13200

@KomachiSion

Description

@KomachiSion

Describe the bug
Nacos 3.0.0-Beta run with derby database failed, due to execute SQL failed:

SELECT COUNT(DISTINCT ci1.data_id, ci1.group_id) AS count FROM config_info ci1 WHERE ci1.tenant_id = 'public' AND (ci1.src_user <> ? OR ci1.src_user IS NULL) AND EXISTS (SELECT 1 FROM config_info ci2 WHERE ci2.data_id = ci1.data_id AND ci2.group_id = ci1.group_id AND ci2.tenant_id = '' AND (ci2.src_user <> ? OR ci2.src_user IS NULL))

The error message is sql parse failed in 1:34, which means the , of DISTINCT ci1.data_id, ci1.group_id.

And I try to close the migrate of namespace by failed.

I see the ConfigCompatibleConfig class without reset in constructor.

Expected behavior
start new 3.0 beta standalone mode with derby database successfully.

Actually behavior
start new 3.0 beta standalone mode with derby database failed.

How to Reproduce
Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See errors

Desktop (please complete the following information):

  • OS: [e.g. Centos]
  • Version [e.g. nacos-server 1.3.1, nacos-client 1.3.1]
  • Module [e.g. naming/config]
  • SDK [e.g. original, spring-cloud-alibaba-nacos, dubbo]

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    kind/bugCategory issues or prs related to bug.version/3.xNacos 3.0 Architecture Evolution

    Type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions