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

exception after drop nested column #40672

Open
mofei920 opened this issue Aug 26, 2022 · 1 comment
Open

exception after drop nested column #40672

mofei920 opened this issue Aug 26, 2022 · 1 comment

Comments

@mofei920
Copy link

version: 21.8.9.13
engine: ReplicatedReplacingMergeTree

alter table t1 on cluster '{cluster}' drop column nest;

after drop a nested column like above on my production, then I found some exception in system.replication_queue, it seems the task retries all the time, the info in system.replication_queue show as below, how can i fix the exception?
unfortunately I can't reproduce. appreciate for any help.

type: MUTATE_PART
num_tries: 249116222
last_exception: Code: 47. DB::Exception: Missing columns: dropped nest column.
postpone_reson: Not executing log entry queue-0000001362 of type MUTATE_PART for part 202206_0_27562_17080_27567 because source parts size (307.86 KiB) is greater than the current maximum (0.00 B).
@mofei920 mofei920 added the question Question? label Aug 26, 2022
@alexey-milovidov alexey-milovidov changed the title exception after drop nestted column exception after drop nested column Aug 26, 2022
@melvynator melvynator self-assigned this Aug 26, 2022
@mofei920
Copy link
Author

mofei920 commented Aug 29, 2022

@melvynator is it possiable to fix it by creating a new table and replace the old table, at last drop the old table?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants