8000 Restore replicated engine database · Issue #1664 · Altinity/clickhouse-operator · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Restore replicated engine database #1664

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.

Sign up for GitHub

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

Jump to bottom
Open
R-omk opened this issue Mar 24, 2025 · 0 comments
Open

Restore replicated engine database #1664

R-omk opened this issue Mar 24, 2025 · 0 comments

Comments

@R-omk
Copy link
R-omk commented Mar 24, 2025

follow up #969

Current error

Code: 253, Message: Replica chi-***-clickhouse-cluster-s0r2 of shard shard0 of replicated database at /clickhouse/*** already exists. 
*** 
*** for SQL:  CREATE DATABASE IF NOT EXISTS ****  ENGINE=Replicated('/clickhouse/****', '{shard}', '{replica}') ;

--

how i got around this error manually

SYSTEM DROP DATABASE REPLICA 'chi-***-clickhouse-cluster-s0r2' FROM SHARD 'shard0' FROM ZKPATH '/clickhouse/****';

After this, the operator was able to restore the database
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@R-omk
0