3.3.12版本 varchar类型转decimal失败

💬 StarRocks 用户问答
#1

为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述

image
image4720×2486 1.7 MB

I20250814 08:47:35.917153 139658574952000 schema_change.cpp:639] [Alter Job:31438823, tablet:31436896]: begin to do request alter tablet: base_tablet_id=31436896, base_schema_hash=87312057, new_tablet_id=31438825, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.917190 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438835, task_count_in_queue=6
I20250814 08:47:35.917177 139658574952000 schema_change.cpp:689] [Alter Job:31438823, tablet:31436896]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436896.87312057.fc4536cb26c3d5b7-59d571bb166b6798 new_tablet=31438825.1905288877.694bd38fa142542b-d659a8a716b6a3ab
I20250814 08:47:35.917203 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438837, task_count_in_queue=7
I20250814 08:47:35.917208 139658558166592 schema_change.cpp:639] [Alter Job:31438823, tablet:31436898]: begin to do request alter tablet: base_tablet_id=31436898, base_schema_hash=87312057, new_tablet_id=31438827, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.917225 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438839, task_count_in_queue=8
I20250814 08:47:35.917243 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438841, task_count_in_queue=9
I20250814 08:47:35.917225 139658558166592 schema_change.cpp:689] [Alter Job:31438823, tablet:31436898]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436898.87312057.304b9a88dc8dbef3-a75f8cf7718dfbaf new_tablet=31438827.1905288877.b548f534b3d487fd-935fcd549668a390
I20250814 08:47:35.917255 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438843, task_count_in_queue=10
I20250814 08:47:35.917272 139700224390720 schema_change.cpp:639] [Alter Job:31438823, tablet:31436900]: begin to do request alter tablet: base_tablet_id=31436900, base_schema_hash=87312057, new_tablet_id=31438829, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.917273 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438845, task_count_in_queue=11
I20250814 08:47:35.917289 139700224390720 schema_change.cpp:689] [Alter Job:31438823, tablet:31436900]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436900.87312057.1a43552d325ef0e2-b1206276f4016dbd new_tablet=31438829.1905288877.63452c48f04457eb-2f1bed3760ee95b3
I20250814 08:47:35.917321 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438847, task_count_in_queue=12
I20250814 08:47:35.917337 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438849, task_count_in_queue=13
I20250814 08:47:35.917349 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438851, task_count_in_queue=14
I20250814 08:47:35.917360 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438853, task_count_in_queue=15
I20250814 08:47:35.917371 139788285376064 agent_server.cpp:550] Submit task success. type=ALTER, signature=31438855, task_count_in_queue=16
I20250814 08:47:35.918861 139700224390720 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436900]: convert_from start tablet:31438829 #pending:0 base_tablet:31436900 request_version:2
I20250814 08:47:35.918875 139658574952000 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436896]: convert_from start tablet:31438825 #pending:0 base_tablet:31436896 request_version:2
I20250814 08:47:35.918887 139658558166592 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436898]: convert_from start tablet:31438827 #pending:0 base_tablet:31436898 request_version:2
W20250814 08:47:35.920640 139658558166592 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.920681 139658558166592 tablet_updates.cpp:4356] failed to change data in chunk
W20250814 08:47:35.920645 139700224390720 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.920646 139658574952000 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.920716 139658574952000 tablet_updates.cpp:4356] failed to change data in chunk
W20250814 08:47:35.920699 139700224390720 tablet_updates.cpp:4356] failed to change data in chunk
W20250814 08:47:35.920727 139658558166592 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436898]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.920739 139700224390720 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436900]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.920742 139658574952000 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436896]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.920797 139700224390720 schema_change.cpp:806] [Alter Job:31438823, tablet:31436900]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
W20250814 08:47:35.920815 139658574952000 schema_change.cpp:806] [Alter Job:31438823, tablet:31436896]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
I20250814 08:47:35.920815 139700224390720 schema_change.cpp:657] [Alter Job:31438823, tablet:31436900]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 3ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.920823 139700224390720 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436900]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436900, base_schema_hash=87312057, new_tablet_id=31438829, new_schema_hash=1905288877
W20250814 08:47:35.920826 139658558166592 schema_change.cpp:806] [Alter Job:31438823, tablet:31436898]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
W20250814 08:47:35.920833 139700224390720 agent_task.cpp:130] [Alter Job:31438823, tablet:31436900]: alter failed. signature: 31438829
I20250814 08:47:35.920834 139658574952000 schema_change.cpp:657] [Alter Job:31438823, tablet:31436896]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 3ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.920874 139658574952000 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436896]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436896, base_schema_hash=87312057, new_tablet_id=31438825, new_schema_hash=1905288877
W20250814 08:47:35.920891 139658574952000 agent_task.cpp:130] [Alter Job:31438823, tablet:31436896]: alter failed. signature: 31438825
I20250814 08:47:35.920851 139658558166592 schema_change.cpp:657] [Alter Job:31438823, tablet:31436898]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 3ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.920949 139658558166592 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436898]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436898, base_schema_hash=87312057, new_tablet_id=31438827, new_schema_hash=1905288877
W20250814 08:47:35.920956 139658558166592 agent_task.cpp:130] [Alter Job:31438823, tablet:31436898]: alter failed. signature: 31438827
I20250814 08:47:35.935752 139700224390720 schema_change.cpp:639] [Alter Job:31438823, tablet:31436902]: begin to do request alter tablet: base_tablet_id=31436902, base_schema_hash=87312057, new_tablet_id=31438831, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.935774 139700224390720 schema_change.cpp:689] [Alter Job:31438823, tablet:31436902]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436902.87312057.6344c840b0ec8aef-2180a408066c7ab5 new_tablet=31438831.1905288877.2b4bf35e28301ef6-188b7ea015245f9d
I20250814 08:47:35.935775 139658558166592 schema_change.cpp:639] [Alter Job:31438823, tablet:31436904]: begin to do request alter tablet: base_tablet_id=31436904, base_schema_hash=87312057, new_tablet_id=31438833, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.935789 139658558166592 schema_change.cpp:689] [Alter Job:31438823, tablet:31436904]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436904.87312057.7c437d09dc7124fd-8aaafdd151c8ec99 new_tablet=31438833.1905288877.604ca782620f1648-cad85192d339eb93
I20250814 08:47:35.935845 139700224390720 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436902]: convert_from start tablet:31438831 #pending:0 base_tablet:31436902 request_version:2
I20250814 08:47:35.935860 139658558166592 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436904]: convert_from start tablet:31438833 #pending:0 base_tablet:31436904 request_version:2
I20250814 08:47:35.935965 139658574952000 schema_change.cpp:639] [Alter Job:31438823, tablet:31436906]: begin to do request alter tablet: base_tablet_id=31436906, base_schema_hash=87312057, new_tablet_id=31438835, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.935979 139658574952000 schema_change.cpp:689] [Alter Job:31438823, tablet:31436906]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436906.87312057.d944644f65c636a0-420003b2d86ba292 new_tablet=31438835.1905288877.764c9e12771cf55c-44a4adbbda6a958f
I20250814 08:47:35.936042 139658574952000 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436906]: convert_from start tablet:31438835 #pending:0 base_tablet:31436906 request_version:2
W20250814 08:47:35.936232 139700224390720 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.936254 139700224390720 tablet_updates.cpp:4356] failed to change data in chunk
W20250814 08:47:35.936244 139658558166592 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.936269 139658558166592 tablet_updates.cpp:4356] failed to change data in chunk
W20250814 08:47:35.936274 139700224390720 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436902]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.936315 139658558166592 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436904]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.936357 139700224390720 schema_change.cpp:806] [Alter Job:31438823, tablet:31436902]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
I20250814 08:47:35.936371 139700224390720 schema_change.cpp:657] [Alter Job:31438823, tablet:31436902]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 0ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.936373 139658558166592 schema_change.cpp:806] [Alter Job:31438823, tablet:31436904]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
W20250814 08:47:35.936374 139700224390720 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436902]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436902, base_schema_hash=87312057, new_tablet_id=31438831, new_schema_hash=1905288877
W20250814 08:47:35.936385 139700224390720 agent_task.cpp:130] [Alter Job:31438823, tablet:31436902]: alter failed. signature: 31438831
W20250814 08:47:35.936393 139658574952000 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.936415 139658574952000 tablet_updates.cpp:4356] failed to change data in chunk
I20250814 08:47:35.936395 139658558166592 schema_change.cpp:657] [Alter Job:31438823, tablet:31436904]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 0ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.936426 139658558166592 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436904]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436904, base_schema_hash=87312057, new_tablet_id=31438833, new_schema_hash=1905288877
W20250814 08:47:35.936434 139658558166592 agent_task.cpp:130] [Alter Job:31438823, tablet:31436904]: alter failed. signature: 31438833
W20250814 08:47:35.936436 139658574952000 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436906]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.936495 139658574952000 schema_change.cpp:806] [Alter Job:31438823, tablet:31436906]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
I20250814 08:47:35.936514 139658574952000 schema_change.cpp:657] [Alter Job:31438823, tablet:31436906]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 0ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.936518 139658574952000 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436906]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436906, base_schema_hash=87312057, new_tablet_id=31438835, new_schema_hash=1905288877
W20250814 08:47:35.936524 139658574952000 agent_task.cpp:130] [Alter Job:31438823, tablet:31436906]: alter failed. signature: 31438835
I20250814 08:47:35.936617 139700224390720 schema_change.cpp:639] [Alter Job:31438823, tablet:31436908]: begin to do request alter tablet: base_tablet_id=31436908, base_schema_hash=87312057, new_tablet_id=31438837, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.936623 139700224390720 schema_change.cpp:689] [Alter Job:31438823, tablet:31436908]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436908.87312057.6843afca3e0dd2a9-bcf37feda325ecb5 new_tablet=31438837.1905288877.7c49022dad4f065b-5a89c17de08da2ab
I20250814 08:47:35.936667 139700224390720 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436908]: convert_from start tablet:31438837 #pending:0 base_tablet:31436908 request_version:2
I20250814 08:47:35.936785 139658558166592 schema_change.cpp:639] [Alter Job:31438823, tablet:31436910]: begin to do request alter tablet: base_tablet_id=31436910, base_schema_hash=87312057, new_tablet_id=31438839, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.936795 139658558166592 schema_change.cpp:689] [Alter Job:31438823, tablet:31436910]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436910.87312057.214fe0ff0a3f3edb-30dd5641ca9ecca8 new_tablet=31438839.1905288877.e747cbcd242956b8-de1d3544e9d15bbb
I20250814 08:47:35.936808 139658574952000 schema_change.cpp:639] [Alter Job:31438823, tablet:31436912]: begin to do request alter tablet: base_tablet_id=31436912, base_schema_hash=87312057, new_tablet_id=31438841, new_schema_hash=1905288877, alter_version=2
I20250814 08:47:35.936819 139658574952000 schema_change.cpp:689] [Alter Job:31438823, tablet:31436912]: finish to validate alter tablet request. begin to convert data from base tablet to new tablet base_tablet=31436912.87312057.09447bcce0bd183c-c2492ea47faa8dbc new_tablet=31438841.1905288877.1b49a0a607afe772-fe359dfe929827bd
I20250814 08:47:35.936849 139658558166592 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436910]: convert_from start tablet:31438839 #pending:0 base_tablet:31436910 request_version:2
I20250814 08:47:35.936884 139658574952000 tablet_updates.cpp:4121] [Alter Job:31438823, tablet:31436912]: convert_from start tablet:31438841 #pending:0 base_tablet:31436912 request_version:2
W20250814 08:47:35.936946 139700224390720 schema_change_utils.cpp:344] failed to convert VARCHAR to DECIMAL128
W20250814 08:47:35.936961 139700224390720 tablet_updates.cpp:4356] failed to change data in chunk
W20250814 08:47:35.936973 139700224390720 tablet_updates.cpp:4220] [Alter Job:31438823, tablet:31436908]: failed to convert from base rowset, exit alter process, Internal error: failed to change data in chunk
W20250814 08:47:35.937004 139700224390720 schema_change.cpp:806] [Alter Job:31438823, tablet:31436908]: schema change new tablet load snapshot error: Internal error: failed to change data in chunk
I20250814 08:47:35.937019 139700224390720 schema_change.cpp:657] [Alter Job:31438823, tablet:31436908]: finished alter tablet process, status=Internal error: failed to change data in chunk duration: 0ms, peak_mem_usage: 0 bytes
W20250814 08:47:35.937022 139700224390720 engine_alter_tablet_task.cpp:74] [Alter Job:31438823, tablet:31436908]: failed to do alter task. status=Internal error: failed to change data in chunk base_tablet_id=31436908, base_schema_hash=87312057, new_tablet_id=31438837, new_schema_hash=1905288877
W20250814 08:47:35.937027 139700224390720 agent_task.cpp:130] [Alter Job:31438823, tablet:31436908]: alter failed. signature: 31438837

【背景】做过哪些操作？
【业务影响】
【是否存算分离】
【StarRocks版本】例如：3.3.12
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群16-可乐鸡或者邮箱，谢谢
【附件】

京ICP备2022026421号-1