【 使用环境 】生产环境
【 OB or 其他组件 】ob-ce
【 使用版本 】主租户 ob-ce 4.3.5.0 、备租户 ob-ce 4.3.5.2
【问题描述】ob-ce 4.3.5.0 主备租户切换到 ob-ce 4.3.5.2 ,执行sql 语句约束失败
【复现路径】
UPDATE
hosts
SET
host = 'catlpdcimdb02',
name = 'catlpdcimdb02',
monitored_by = '2',
status = '0',
tls_connect = '2',
tls_accept = '2',
proxy_groupid = '1',
tls_psk_identity = 'CATL-EICC',
tls_psk = 'a0001a8b458ea0d6a3121ad15758a63b5060aa1845062f4571e9cf85a72182cf',
proxyid = NULL,
tls_issuer = '',
tls_subject = ''
WHERE
hostid = 15094
失败原因:
ErrorCode = 1451, SQLState = 23000, Details = Cannot delete or update a parent row: a foreign key constraint fails
【附件及日志】推荐使用OceanBase敏捷诊断工具obdiag收集诊断信息,详情参见链接(右键跳转查看):