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

lighting/checkpoints: The table_info to be imported is too large lead to the err Data too long for column 'table_info' at row 1 #50711

Closed
zimulala opened this issue Jan 24, 2024 · 0 comments · Fixed by #51460
Labels
affects-7.1 affects-7.5 component/ddl This issue is related to DDL of TiDB. severity/major type/bug The issue is confirmed as a bug.

Comments

@zimulala
Copy link
Contributor

zimulala commented Jan 24, 2024

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

When importing DM, the length of the table information to be imported exceeds text (65536) after parsing, resulting in the following error: [Lightning:Checkpoint:ErrInitCheckpoint]init checkpoint error: insert checkpoints failed: Error 1406 (22001): Data too long for column 'table_info' at row 1
Table field info:

table_info text NOT NULL,

Marshal code:

tableInfo, err := json.Marshal(table.Desired)

2. What did you expect to see? (Required)

No error.

3. What did you see instead (Required)

Error: [Lightning:Checkpoint:ErrInitCheckpoint]init checkpoint error: insert checkpoints failed: Error 1406 (22001): Data too long for column 'table_info' at row 1

4. What is your TiDB version? (Required)

v7.5.0

@zimulala zimulala added type/bug The issue is confirmed as a bug. component/ddl This issue is related to DDL of TiDB. labels Jan 24, 2024
@lance6716 lance6716 added affects-5.3 This bug affects 5.3.x versions. affects-5.4 This bug affects 5.4.x versions. affects-6.1 affects-6.5 affects-7.1 affects-7.5 labels Mar 4, 2024
@lance6716 lance6716 removed the affects-5.3 This bug affects 5.3.x versions. label Mar 4, 2024
ti-chi-bot bot pushed a commit that referenced this issue Mar 4, 2024
@lance6716 lance6716 removed affects-5.4 This bug affects 5.4.x versions. affects-6.1 affects-6.5 labels Mar 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
affects-7.1 affects-7.5 component/ddl This issue is related to DDL of TiDB. severity/major type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants