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

add single field on mariadb: add multiple columns not implemented #100

Open
lufi78 opened this issue Jan 31, 2025 · 0 comments
Open

add single field on mariadb: add multiple columns not implemented #100

lufi78 opened this issue Jan 31, 2025 · 0 comments

Comments

@lufi78
Copy link

lufi78 commented Jan 31, 2025

By adding a column "price" to a table: decimal(10,2) I got this error:

[dbrepl mariadb_prod 2025-01-29 09:44:55,660 ERROR] unhandled exception
Traceback (most recent call last):
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 178, in run
self.run_realtime_replication()
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 379, in run_realtime_replication
self.handle_event(event)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 401, in handle_event
event_handlersevent.event_type
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 481, in handle_query_event
self.handle_alter_query(query, event.db_name)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 492, in handle_alter_query
self.converter.convert_alter_query(query, db_name)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 407, in convert_alter_query
self.__convert_alter_table_add_column(db_name, table_name, tokens)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 434, in __convert_alter_table_add_column
raise Exception('add multiple columns not implemented', tokens)
Exception: ('add multiple columns not implemented', ['price', 'NUMERIC(10,', '2)', 'DEFAULT', 'NULL'])
Traceback (most recent call last):
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/main.py", line 6, in
main()
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/main.py", line 152, in main
run_db_replicator(args, config)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/main.py", line 98, in run_db_replicator
db_replicator.run()
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 178, in run
self.run_realtime_replication()
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 379, in run_realtime_replication
self.handle_event(event)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 401, in handle_event
event_handlersevent.event_type
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 481, in handle_query_event
self.handle_alter_query(query, event.db_name)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/db_replicator.py", line 492, in handle_alter_query
self.converter.convert_alter_query(query, db_name)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 407, in convert_alter_query
self.__convert_alter_table_add_column(db_name, table_name, tokens)
File "/home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/mysql_ch_replicator/converter.py", line 434, in __convert_alter_table_add_column
raise Exception('add multiple columns not implemented', tokens)
Exception: ('add multiple columns not implemented', ['price', 'NUMERIC(10,', '2)', 'DEFAULT', 'NULL'])
[runner 2025-01-29 09:44:55,902 WARNING] Restarting dead process: < /home/xxxxx/mysql_ch_replicator/mysql_ch_replicator/main.py --config /home/xxxxx/mysql_ch_replicator/config.yaml --db mariadb_prod db_replicator >

Versions:
MariDB-Version: 10.6.20-MariaDB
ClickHouse 24.12.2.29 (revision: 54494

Thanks for fixing!

@lufi78 lufi78 changed the title add single filed on mariadb: add multiple columns not implemented add single field on mariadb: add multiple columns not implemented Jan 31, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant