Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: tidb5.4.2升级6.1.2之后 text字段频繁出现数据对于字段过大的报错 。
|
username: heming
[TiDB Usage Environment] Production Environment / Test / Poc
Production
[TiDB Version]
6.1.2
[Reproduction Path] What operations were performed when the issue occurred
After upgrading from 5.4.2 to 6.1.2, this error frequently occurs.
Frequent “Data too long for column ‘video_material’ at row” errors: (also errors for the ‘image_material’ field)
CREATE TABLE `Synads_Tt_Qc_Creative` (
`creative_id` bigint(63) NOT NULL COMMENT 'Creative ID',
`ad_id` bigint(63) DEFAULT NULL COMMENT 'Plan ID',
`advertiser_id` bigint(63) DEFAULT NULL COMMENT 'Advertiser ID',
`status` varchar(500) DEFAULT NULL COMMENT 'Plan delivery status',
`opt_status` varchar(500) DEFAULT NULL COMMENT 'Plan operation status',
`image_mode` varchar(500) DEFAULT NULL COMMENT 'Creative material type',
`creative_create_time` varchar(100) DEFAULT NULL COMMENT 'Creative creation time, format: yyyy-mm-dd HH:MM:SS',
`creative_modify_time` varchar(100) DEFAULT NULL COMMENT 'Creative modification time, format: yyyy-mm-dd HH:MM:SS',
`video_material` text DEFAULT NULL COMMENT 'Video material information',
`image_material` text DEFAULT NULL COMMENT 'Image material information',
`title_material` text DEFAULT NULL COMMENT 'Title material information',
`promotion_card_material` varchar(1500) DEFAULT NULL COMMENT 'Promotion card information',
`Synch_Create_Date` varchar(25) NOT NULL COMMENT 'Format: yyyy-mm-dd',
`lab_ad_type` varchar(255) DEFAULT NULL COMMENT 'Managed plan type, NOT_LAB_AD: non-managed plan, LAB_AD: managed plan',
`Synch_Create_Hour` int(11) NOT NULL COMMENT 'Hour value range: 0~23',
`Synch_Time` char(19) DEFAULT NULL,
`marketing_goal` varchar(255) DEFAULT NULL COMMENT 'Marketing goal, allowed values: VIDEO_PROM_GOODS short video goods, LIVE_PROM_GOODS live goods',
`creative_material_mode` varchar(60) DEFAULT NULL COMMENT 'Creative presentation mode, CUSTOM_CREATIVE: custom creative, PROGRAMMATIC_CREATIVE: programmatic creative',
PRIMARY KEY (`creative_id`) /*T![clustered_index] CLUSTERED */,
KEY `creative_create_time` (`creative_create_time`),
KEY `creative_modify_time` (`creative_modify_time`),
KEY `Synch_Create_Date` (`Synch_Create_Date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
[Encountered Issues: Issue Phenomenon and Impact]
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]
2022/11/17 11:29:25.359 +08:00] [INFO] [conn.go:1149] [command dispatched failed] [conn=985285563792585879] [connInfo=id:985285563792585879, addr:!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQ\Temp%W@GJ$ACOF(TYDYECOKVDYB.png)192.168.6.29:64675 status:10, collation:utf8mb4_general_ci, user:dspwrite] [command=Execute] [status=inTxn:0, au[types:1406]Data too long for column ‘video_material’ at row 1!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQ\Temp%W@GJ$ACOF(TYDYECOKVDYB.png)ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQTempSys[5UQ[BL(6~BS2JV6W}N6[%S.png)github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQ\Temp%W@GJ$ACOF(TYDYECOKVDYB.png)ngithub.com/pingcap/errors.(*Error).GenWithStack\n\t/go/pkg/mod/!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQTempSys[5UQ[BL(6~BS2JV6W}N6[%S.png)github.com/pingcap/errors@v0.11.5-0.2021122
Path:/data/tidb/tidblog/tidb.log
2022/11/17 11:29:02.969 +08:00] [INFO] [conn.go:1149] [command dispatched failed] [conn=985285563792585877] [connInfo=id:985285563792585877, addr:!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQ\Temp%W@GJ$ACOF(TYDYECOKVDYB.png)192.168.6.29:46303 status:10, collation:utf8mb4_general_ci, user:dspwrite] [command=Execute] [status=inTxn:0, au[types:1406]Data too long for column ‘image_material’ at row 1!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQ\Temp%W@GJ$ACOF(TYDYECOKVDYB.png)ngithub.com/pingcap/errors.AddStack\n\t/go/pkg/mod/!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQTempSys[5UQ[BL(6~BS2JV6W}N6[%S.png)github.com/pingcap/errors@v0.11.5-0.20211224045212-9687c2b0f87c/errors.go:174!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQ\Temp%W@GJ$ACOF(TYDYECOKVDYB.png)ngithub.com/pingcap/errors.(*Error).GenWithStack\n\t/go/pkg/mod/!(file:///C:\Users\heming\AppData\Roaming\Tencent\QQTempSys[5UQ[BL(6~BS2JV6W}N6[%S.png)github.com/pingcap/errors@v0.11.5-0.2021122
[Attachments]:
- Related logs
- Configuration files
- Grafana monitoring (https://metricstool.pingcap.com/)
If the question is related to **performance optimization or fault troubleshooting**, please download the <a href="/uploads/short-url/uGisshjxFnxx1KgpFOYbfeZjsc6" download="info_gathering.py">script</a> and run it. Please **select all** and copy-paste the terminal output results and upload them.
|
username: 
|
username: 
|
username: 
|
username: