使用gorm-gbase8s链接数据库后,部分表数据插入失败,是否是 sql中的字段值和表中的字段类型不匹配导致的?
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【GBase版本】: 363
【操作系统】:centos7.6
【CPU】:4核
【问题描述】*:使用gorm-gbase8s库,正确配置环境变量,使用GSDK后,成功 链接数据库后,在运行插入sql语句时,部分表提示插入失败
以下是我的两张表结构和相关的插入sql语句,其中ds_confer_member表是插入成功的,但是ds_confer_conferinfo是插入失败的,我想知道的是是否是因为sql语句传值的问题,如果是的话,大概是哪些字段类型或者默认值设置的问题? 或者是插入sql语句中相关字段对应的值的类型问题?
希望可以解答下我的问题,感觉适配好难啊 。。。
其中两张表字段内容分别如下:
我的sql插入语句相关日志运行情况如下:
失败的:
2025-12-18 16:40:31.509 ERROR gorm@v1.30.0/callbacks.go:134 SQL执行出错: INSERT INTO "ds_confer_conferinfo" ("CONFER_ID","ELOGO","ROOM_ID","URL","TYPE","STATUS","THEME","FIRE_DATE","IS_PUBLIC","POP_UI_SWITCH","MODEL","FIRE_PERSON","FIRE_PERSON_NAME","PASS_WORD","ROOM_TYPE","VERSION","PLATFORM","PROVIDER","VOUCHER","END_DATE","GROUP_ID","ISPUSH_TEMPMSG","DEGREEOFSECRETS","CONFER_TEMPLATE_STATUS","MRID","EXPECT_END_DATE","IP_PORT","RESOLUTION") VALUES ('533638269','bxy','21256856927-1766047221893','https://192.168.140.244:10670/o/NkTMbDzNrkjM4MjY5','unbindconfer','doing','llll9009',1766047227901,1,'On','micro','21256856927','5Y2c6ZSm5YWD','','confer','1','','','',0,'','','{}','','',0,'192.168.140.244:10670','') | 影响行数: 0 | 耗时: 321.881728ms | 错误: ERROR: -391: 23000 : Integrity constraint violation
2025-12-18 16:40:31.509 ERROR impl/confer.go:956 conferDBService--StructInsertConferInfo failed, error:ERROR: -391: 23000 : Integrity constraint violation
主要错误是: ERROR: -391: 23000 : Integrity constraint violation
成功的:
2025-12-18 16:40:31.509 DEBUG impl/confer_member.go:21 conferDBService--获取ConferMemberDaoImpl实例
2025-12-18 16:40:31.509 DEBUG impl/confer_member.go:87 conferDBService--StructInsertConferMember 批量插入会议成员信息
2025-12-18 16:40:31.509 DEBUG impl/common.go:26 当前的数据库类型是:gbase8s,转化后:gbase8s,查询的结果是:%!s(bool=true)
2025-12-18 16:40:31.837 INFO gorm@v1.30.0/callbacks.go:134 SQL执行成功: DELETE FROM "ds_confer_member" WHERE "ROOM_ID" ='21256856927-1766047221893' AND "MEMBER" ='21256856927' | 影响行数: 0 | 耗时: 327.415092ms
2025-12-18 16:40:31.837 DEBUG impl/confer_member.go:105 conferDBService--StructInsertConferMember delete ConferMember: RowsAffected:0
2025-12-18 16:40:32.425 INFO gorm@v1.30.0/callbacks.go:134 SQL执行成功: INSERT INTO "ds_confer_member" ("CONFER_ID","ELOGO","ROOM_ID","MEMBER","IS_MANAGER","ENTER_STATUS","NAME","RANK","SECRET_KEY","FIRSTENTRYTIME","LASTLEAVETIME","TOTALTIME","ENTRYNUMBER","PLATFORM") VALUES ('533638269','bxy','21256856927-1766047221893','21256856927',1,0,'5Y2c6ZSm5YWD','onwer','','','','','','') | 影响行数: 1 | 耗时: 587.968936ms
2025-12-18 16:40:32.425 DEBUG impl/confer_member.go:127 conferDBService--StructInsertConferMember Insert ConferMember: RowsAffected:1
2025-12-18 16:40:32.425 DEBUG ServerLib/ConferDataBaseService.go:877 conferDBService--PostMicroInfo end
热门帖子
- 12025-12-01浏览数:182759
- 22023-05-09浏览数:25044
- 42023-09-25浏览数:18519
- 52020-05-11浏览数:17526