为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
INSERT INTO "warn_info" (
"warn_name", "distinguish", "warn_type_distinguish", "warn_type_id",
"warn_level_id", "description", "config_id", "created", "warn_moment_value",
"eqp_resource", "resource_name", "dept_code", "space_code",
"handle_state", "is_need_control", "is_have_control", "apply_eqp_list",
"report_state", "last_remind_time", "remind_duration", "cust_code",
"data_resource_type", "project_code", "distinguish_type", "version", "resource_code","sync"
) VALUES (
'人群密度',
'alert',
9,
99,
4,
'10.17.6.66:人群密度92:人群人数:1,人群密度:2,',
96,
TIMESTAMP '2026-01-12 11:51:33.0',
'04990667516355500101#00317a85c90c4b7388a22341f13550b8',
6,
'10.17.6.66',
'BM063',
'10001',
0,
0,
0,
'04990667516355500101#00317a85c90c4b7388a22341f13550b8',
0,
TIMESTAMP '2026-01-12 11:51:33.0',
1200,
'56',
'threeWarnByType',
'huaerdun',
'apply',
1,
'04990667516355500101#00317a85c90c4b7388a22341f13550b8','anfang'
);执行失败,失败原因:
[-6128]:无效的数字
-6128: warn_info_sync line 14
执行当前语句报错
INSERT INTO "warn_info" (
"warn_name", "distinguish", "warn_type_distinguish", "warn_type_id",
"warn_level_id", "description", "config_id", "created", "warn_moment_value",
"eqp_resource", "resource_name", "dept_code", "space_code",
"handle_state", "is_need_control", "is_have_control", "apply_eqp_list",
"report_state", "last_remind_time", "remind_duration", "cust_code",
"data_resource_type", "project_code", "distinguish_type", "version", "sync"
) VALUES (
'人群密度',
'alert',
9,
99,
4,
'10.17.6.66:人群密度92:人群人数:1,人群密度:2,',
96,
TIMESTAMP '2026-01-12 11:51:33.0',
'04990667516355500101#00317a85c90c4b7388a22341f13550b8',
6,
'10.17.6.66',
'BM063',
'10001',
0,
0,
0,
'04990667516355500101#00317a85c90c4b7388a22341f13550b8',
0,
TIMESTAMP '2026-01-12 11:51:33.0',
1200,
'56',
'threeWarnByType',
'huaerdun',
'apply',
1,
'anfang'
);
执行成功,执行耗时338毫秒。
影响了1条记录。执行号: 15025305
执行完成
两个sql语句差一个resource_code字段,图片是resource_code的类型只相

看看表上有没有触发器,可能是触发器里面报的错,关注这个对象 warn_info_sync