sahara 删除不掉cluster，sahara掉cluster

sahara 删除不掉cluster，sahara掉cluster

MariaDB [sahara]> show databases;

MariaDB [sahara]> use sahara;

MariaDB [sahara]> show tables;

MariaDB [sahara]> select * from clusters;

MariaDB [sahara]> delete where id=60671a66-42e0-4a30-a57c-6146f3f824c7 from clusters;

MariaDB [sahara]> delete from clusters where id=60671a66-42e0-4a30-a57c-6146f3f824c7'

MariaDB [sahara]> delete from clusters where id=60671a66-42e0-4a30-a57c-6146f3f824c7'

MariaDB [sahara]> delete from clusters where id='60671a66-42e0-4a30-a57c-6146f3f824c7';

MariaDB [sahara]> select id,name from clusters;

MariaDB [sahara]> delete from cluster_provision_steps where cluster_id ='60671a66-42e0-4a30-a57c-6146f3f824c7';

MariaDB [sahara]> delete from cluster_verifications where cluster_id ='60671a66-42e0-4a30-a57c-6146f3f824c7';

MariaDB [sahara]> delete from instance where instance_name like 'cluster20180607110923%';

MariaDB [sahara]> delete from instance where instance_name like 'cluster20180607110923%';

MariaDB [sahara]> delete from instances where instance_name like 'cluster20180607110923%';

MariaDB [sahara]> delete from node_group where cluster_id ='60671a66-42e0-4a30-a57c-6146f3f824c7';

MariaDB [sahara]> delete from node_groups where cluster_id ='60671a66-42e0-4a30-a57c-6146f3f824c7';

MariaDB [sahara]> delete from clusters where name ='cluster20180607110923';

MariaDB [sahara]> select * from clusters;

MariaDB [sahara]> select id,name from clusters;

------------------

MariaDB [sahara]> delete from cluster_provision_steps where cluster_id ='43b164e4-ea73-4c3e-879e-a554948c7b7e';

Query OK, 20 rows affected (0.05 sec)

MariaDB [sahara]> delete from cluster_verifications where cluster_id ='43b164e4-ea73-4c3e-879e-a554948c7b7e';

Query OK, 1 row affected (0.02 sec)

MariaDB [sahara]> delete from instances where instance_name like 'cluster20180607124353%';

MariaDB [sahara]> delete from node_groups where cluster_id ='43b164e4-ea73-4c3e-879e-a554948c7b7e';