本文介绍teledb开通过程的相关问题处理案例。
环境说明
●mysql 内核版本：v5.7.x
问题现象

部分Teledb无法退订
原因分析

退订流程异常，无法通过退订操作进行退订，需要手工删除SET
解决方法

云翼上模拟回单退订teledb后清理控制台部分数据。

1、在keeper里面执行delset set_XXX

2、更新telemonitor数据库表中所涉及的记录

//更新paas_product表中pro_order_status = 2

//更新db_resource表中is_delete = 1，表示已删除

//更新db_monitor表中monitor = 2，表示不再监控该实例

//更新monitor_options表的monitor状态为0

//更新gateway_resource 表中is_delete = 1，表示已删除

//更新machine_resource表中is_delete = 1，表示已删除

模拟成功方法如下：

curl -H ""Content-Type: application/json"" -X POST --data '{""envProps"":{},""operOrderId"":1935,""operResult"":0,""operResultDesc"":""success"",""stepOrder"":3}' http://10.224.71.208:8890/admin/apiproxy/v1/notifyResult

改下operOrderId这个参数（工单ID）和回单地址

1、在keeper机器keeper bin目录里面执行delset set_XXX

./delset setname

2、更新telemonitor数据库表中所涉及的记录 2. 实例ID:实例id set_xxxx

//更新paas_product表中prod_order_status = 2

select * from paas_product limit 1\G

select * from paas_product where prod_inst_set_name ='set_xxxx' and outer_prod_inst_id = '实例id'\G

update paas_product set prod_order_status = 2 where prod_inst_set_name ='set_xxxx' and outer_prod_inst_id = '实例id';

//更新db_resource表中is_delete = 1，表示已删除

select * from db_resource limit 1\G

select * from db_resource where tags ='set_xxxx' and prod_inst_id =xxxx \G

update db_resource set is_delete =1 where tags ='set_xxxx' and prod_inst_id =xxxx ;

//更新db_monitor表中monitor = 2，表示不再监控该实例

select * from db_monitor limit 1\G

select * from db_monitor where res_id =136\G

select * from db_monitor where res_id in ('136','137')\G

update db_monitor set monitor = 2 where res_id =136;

update db_monitor set monitor = 2 where res_id =137;

//更新monitor_options表的monitor状态为0

select * from monitor_options limit 3\G

select * from monitor_options where prod_inst_id =xxxx\G

update monitor_options set monitor = 0 where prod_inst_id =xxxx;

//更新gateway_resource 表中is_delete = 1，表示已删除

select * from gateway_resource limit 2\G

select * from gateway_resource where prod_inst_id =xxxx \G

update gateway_resource set is_delete = 1 where prod_inst_id =xxxx;

//更新machine_resource表中is_delete = 1，表示已删除

select * from machine_resource limit 1\G

select * from machine_resource where prod_inst_id =xxxx\G

update machine_resource set is_delete = 1 where prod_inst_id =xxxx;