5.14.2升级到v6.0.0-ga.6导入upgrade.sql 提示Can't DROP 'dashboard_id'; check that column/key exists

Viewed 47

操作步骤:
关闭了n9e服务
数据库执行了:
alter table alerting_engines drop index instance;
alter table recording_rule add datasource_ids varchar(255) default '';
alter table alert_rule modify enable_stime char(255) not null default '00:00';
alter table alert_rule modify enable_etime char(255) not null default '23:59';
alter table alert_rule modify enable_days_of_week varchar(255) not null default '' comment 'eg: "0 1 2 3 4 5 6 ; 0 1 2"';
alter table task_record add event_id bigint not null comment 'event id' default 0 after group_id;
alter table task_record add index task_event_idx(event_id);
alter table alerting_engines change column cluster engine_cluster varchar(128) not null default '' comment 'n9e-alert cluster';

导入upgrade.sql时提示存在主键,不能删除

2 Answers

谢谢大佬

最后解决方法就是将提示存在、重复的,在 upgrade.sql将对应的sql语句删除了