Bug: CREATE TABLE ... LIKE fails with "Could not determine structure for source table"

[VladimirDVV]

The replicator crashes when encountering a CREATE TABLE ... LIKE statement in the MySQL binary log.
Environment:
Source: MySQL (Percona 8.0.43)
Target: ClickHouse 25.8
Tool version: Latest (Docker image)

Configuration:

binlog_replicator:
  data_dir: "/app/data/"
  records_per_file: 100000
initial_replication_threads: 2
enable_optimize_final: False
skip_initial_replication: True
ignore_deletes: false
optimize_interval: 86400
databases: "test"
tables: ['transactions']
target_databases:
  test: test2
log_level: "info"

mysql_ch_replicator_log_2.txt

[VladimirDVV]

Configuration:

...
tables: ['tag']
target_databases:
  test: test2
log_level: "info"

mysql query

ALTER TABLE `tag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

log

Traceback (most recent call last):
File "/app/main.py", line 6, in <module>
main()
File "/app/mysql_ch_replicator/main.py", line 207, in main
run_db_replicator(args, config)
File "/app/mysql_ch_replicator/main.py", line 117, in run_db_replicator
db_replicator.run()
File "/app/mysql_ch_replicator/db_replicator.py", line 226, in run
self.run_realtime_replication()
File "/app/mysql_ch_replicator/db_replicator.py", line 284, in run_realtime_replication
self.realtime_replicator.run_realtime_replication()
File "/app/mysql_ch_replicator/db_replicator_realtime.py", line 73, in run_realtime_replication
self.handle_event(event)
File "/app/mysql_ch_replicator/db_replicator_realtime.py", line 94, in handle_event
event_handlers[event.event_type](event)
File "/app/mysql_ch_replicator/db_replicator_realtime.py", line 185, in handle_query_event
self.handle_alter_query(query, event.db_name)
File "/app/mysql_ch_replicator/db_replicator_realtime.py", line 199, in handle_alter_query
self.replicator.converter.convert_alter_query(query, db_name)
File "/app/mysql_ch_replicator/converter.py", line 781, in convert_alter_query
raise Exception(f'operation {op_name} not implement, query: {subquery}, full query: {mysql_query}')
Exception: operation convert not implement, query: CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, full query: ALTER TABLE `tag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
[runner 2026-03-11 17:12:56,058 WARNING] Process dead (exit code: 1), restarting: < /app/main.py --config /app/config.yaml --db  db_replicator >
[dbrepl ph-db 2026-03-11 17:12:56,944 INFO] launched db_replicator
[dbrepl ph-db 2026-03-11 17:12:57,014 INFO] running realtime replication from the position: ('mysql-bin-log.000102', 161634)
[dbrepl ph-db 2026-03-11 17:12:57,019 INFO] set position to /app/data/test/1.bin
[dbrepl ph-db 2026-03-11 17:12:57,020 INFO] found transaction ('mysql-bin-log.000102', 161634) inside /app/data/ph-db/1.bin
[dbrepl ph-db 2026-03-11 17:12:57,026 ERROR] unhandled exception

[bakwc]

For the future please report issue as a bug, not the discussion.

[bakwc]

ALTER TABLE `tag` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

This one fixed here: #245

[bakwc]

Fix for CREATE TABLE ... LIKE here: #246

[bakwc]

Fixed in v0.1.12