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.

Sign up for GitHub

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

Jump to bottom

DM may report error of [types:1074]Column length too big for column '<name>' (max = 16383); use BLOB or TEXT instead #4637

Closed
lance6716 opened this issue Feb 21, 2022 · 1 comment · Fixed by #4638
Closed

DM may report error of [types:1074]Column length too big for column '<name>' (max = 16383); use BLOB or TEXT instead #4637

lance6716 opened this issue Feb 21, 2022 · 1 comment · Fixed by #4638
Labels
affects-5.4 This bug affects the 5.4.x(LTS) versions. area/dm Issues or PRs related to DM. severity/moderate type/bug The issue is confirmed as a bug.

Comments

@lance6716
Copy link
Contributor

lance6716 commented Feb 21, 2022 •
edited by D3Hunter
Loading

What did you do?

https://asktug.com/t/topic/573546

downstream CREATE TABLE t (c VARCHAR(20000)) CHARSET=utf8 and start task

What did you expect to see?

no error

What did you see instead?

[types:1074]Column length too big for column '' (max = 16383); use BLOB or TEXT instead

Versions of the cluster

DM v5.4

current status of DM cluster (execute query-status <task-name> in dmctl)

(paste current status of DM cluster here)
@lance6716 lance6716 added type/bug The issue is confirmed as a bug. area/dm Issues or PRs related to DM. severity/moderate labels Feb 21, 2022
@lance6716 lance6716 added affects-5.3 affects-5.4 This bug affects the 5.4.x(LTS) versions. labels Feb 21, 2022
@lance6716
Copy link
Contributor Author

lance6716 commented Feb 21, 2022 •
edited
Loading

DM will always fetch downstream table structures, however it reconstructs TableInfo by ddl.MockTableInfo. This function will not respect CHARSET in CRAETE TABLE and always use default charset. TiDB somehow has changed the default charset so will cause this problem.

@lance6716 lance6716 changed the title DM may report error of [types:1074]Column length too big for column '<name>' (max = 16383); use BLOB or TEXT instead [WIP]DM may report error of [types:1074]Column length too big for column '<name>' (max = 16383); use BLOB or TEXT instead Feb 21, 2022
@lance6716 lance6716 changed the title [WIP]DM may report error of [types:1074]Column length too big for column '<name>' (max = 16383); use BLOB or TEXT instead DM may report error of [types:1074]Column length too big for column '<name>' (max = 16383); use BLOB or TEXT instead Feb 21, 2022
@lance6716 lance6716 mentioned this issue Feb 21, 2022
Merged
ti-chi-bot pushed a commit that referenced this issue Feb 21, 2022
@lance6716
tracker(dm): respect CHARSET when build TableInfo (#4638)
efc0658 
close #4637
This was referenced Feb 21, 2022
Merged
Merged
ti-chi-bot added a commit that referenced this issue Feb 22, 2022
@ti-chi-bot
tracker(dm): respect CHARSET when build TableInfo (#4638) (#4645)
122ac4c 
close #4637
ti-chi-bot added a commit that referenced this issue Feb 28, 2022
@ti-chi-bot
tracker(dm): respect CHARSET when build TableInfo (#4638) (#4646)
7defc78 
close #4637
This was referenced Feb 28, 2022
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affects-5.4 This bug affects the 5.4.x(LTS) versions. area/dm Issues or PRs related to DM. severity/moderate type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

tracker(dm): respect CHARSET when build TableInfo lance6716/ticdc
1 participant
@lance6716