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

Auto table replication from MySQL might not work when using ClickHouse 23.3 #945

Open
Selfeer opened this issue Dec 9, 2024 · 0 comments
Assignees
Labels
bug Something isn't working kafka Issues related to Kafka version p2

Comments

@Selfeer
Copy link
Collaborator

Selfeer commented Dec 9, 2024

There seem to be instances in which the automatic table replication from a MySQL database to ClickHouse does not work, and the JDBC logs show an error indicating that the table does not exist in ClickHouse:

Code: 60. DB::Exception: Table test.truncate_612a961d_b3fd_11ef_bcd0_960003e77a13 doesn't exist. (UNKNOWN_TABLE) (version 23.3.22.3 (official build))

However, when checking manually, the table appears to be created:

echo -e "SHOW TABLES FROM test" | clickhouse client -n -u root --password root 2>&1
[clickhouse] truncate_612a961d_b3fd_11ef_bcd0_960003e77a13

Because of the error actions like INSERT are not replicated anymore.

@Selfeer Selfeer added bug Something isn't working kafka Issues related to Kafka version labels Dec 9, 2024
@subkanthi subkanthi added the p2 label Jan 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working kafka Issues related to Kafka version p2
Projects
None yet
Development

No branches or pull requests

2 participants