陈冰洁,PLAT 2.0 新增网络设备失败，操作日志记录数据库错误
问题描述
在监控列表增加网络设备，点击确认后，页面提示消息已发送成功，但是页面上并没有找到新增的这个设备ip地址。查看操作日志，发现提示增加设备“x.x.x.x”失败，失败原因是数据库错误。
过程分析
查看res-dm日志，发现设备接口别名存在乱码，导致解析失败。
2022-11-01 17:26:18.928 [ERROR (1366)] [THREAD(2877253376)] [CQvDBConnADP::executeSQL] Execute "insert into tbl_if_info(dev_id,ifindex,ifdesc,iftype,ifspeed,ifphyaddress,ifadminstatus,ifoptstatus,ifmtu,iflastchange,ifalias,ifStatus, ifAlarmStatus, userifspeed, ifPhyAttribute,ifTrapFilterType, ifSendAlarmFlag, iflastchangetime,ifduplexstatus,iffeType,hold_flag,hold_flag_desc) values(245551873500651,101,'Ten-GigabitEthernet2/0/31',6,'1000000000','xx:xx:xx:xx:xx:xx',1,1,10000,' xxxxxxxx ','to zhqu-daiwai-s5130- 㾧 1/0/26 ',4,4,-1,0,0,0, DATE_FORMAT('2022-07-23 09:07:05','%Y-%m-%d %H:%i:%s') ,3,1,0,'')" failed, errorMsg:Incorrect string value: '\xE3>g1/0...' for column 'ifalias' at row 1
2022-11-01 17:26:18.928 [ERROR (10)] [THREAD(2877253376)] [CDevMgr::storeDevIFDataToDB] executeSQL() error, and SQL is: insert into tbl_if_info(dev_id,ifindex,ifdesc,iftype,ifspeed,ifphyaddress,ifadminstatus,ifoptstatus,ifmtu,iflastchange,ifalias,ifStatus, ifAlarmStatus, userifspeed, ifPhyAttribute,ifTrapFilterType, ifSendAlarmFlag, iflastchangetime,ifduplexstatus,iffeType,hold_flag,hold_flag_desc) values(245551873500651,101,'Ten-GigabitEthernet2/0/31',6,'1000000000',' xx:xx:xx:xx:xx:xx' ,1,1,10000,'xxxxxxxx','to zhqu-daiwai-s5130- 㾧 1/0/26 ',4,4,-1,0,0,0, DATE_FORMAT('2022-07-23 09:07:05','%Y-%m-%d %H:%i:%s') ,3,1,0,'')
2022-11-01 17:26:18.928 [ERROR (2003)] [THREAD(2877253376)] CDevMgr::storeDevDataToDB error, call storeDevIFDataToDB() error
解决方法
在设备上将对应接口的别名删掉或重新修改后，添加成功。
