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

Can the temporary table name created during clickhouse-copier copying process be a non-fixed name? #51140

Closed
Tiakon opened this issue Jun 19, 2023 · 0 comments · Fixed by #61058
Labels
question Question?

Comments

@Tiakon
Copy link
Contributor

Tiakon commented Jun 19, 2023

Due to the lack of real-time data replication feature in clickhouse-copier, I have enabled two instances of clickhouse-copier for the same table - one for real-time data replication and the other for historical data replication. When both instances are used simultaneously, data loss occurs and is accompanied by the following two exceptions:
Exception 1: <Error> Application: Code: 517, e.displayText() = DB::Exception: Received from cn-xxx-xx-xxx-04-1id9:9100. DB::Exception: Cannot assign ALTER PARTITION, because another ALTER PARTITION query was concurrently executed. Stack trace:,
Exception 2: <Error> Application: Code: 60, e.displayText() = DB::Exception: Received from cn-xxx-xx-xxx-04-1id9:9100. DB::Exception: Table dispatch_db.dispatch_analysis_local_piece_0 doesn't exist. Stack trace:.

Later, it was discovered that the fixed temporary table name during the clickhouse-copier replication process was the cause.
May I ask if it is possible to remove this restriction in the new version?

@Tiakon Tiakon added the question Question? label Jun 19, 2023
@alexey-milovidov alexey-milovidov changed the title Can the temporary table name created during clickhouse-copy copying process be a non-fixed name? Can the temporary table name created during clickhouse-copier copying process be a non-fixed name? Jun 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Question?
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant