x2openEuler删除修改升级task和节点
cd /usr/local/x2openEuler/portal/src/
sqlite3 db.sqlite3
sqlite> .tables
sqlite> .schema taskmanager_task # 查看表结构,确定id字段
sqlite> select * from taskmanager_task;
sqlite> delete from taskmanager_task where id=4; # 可以对应任务名进行删除
sqlite> delete from taskmanager_node where ip_address="192.168.137.14";
升级成功之后状态没有变化的修改数据库
UPDATE taskmanager_task SET status = 'in_progress' WHERE ID = 4;
升级成功之后并重启-状态没有变化的修改数据库
sqlite> select * from taskmanager_step; # system_upgrade|upgrade_success
3|1|connectivity_test|connectivity_test_success|100|in node < id:1 ip:192.168.137.11 > 保留的路径都存在|2023-02-06 11:07:03.708543|2023-02-06 11:07:12.575980
4|1|check|check_success|100|硬件检查执行成功，检查结果为成功|2023-02-06 11:08:57.359138|2023-02-06 11:08:57.364133
5|1|system_upgrade|upgrade_success|0|重启成功|2023-02-06 15:43:05.427616|2023-02-17 15:01:22.382519
sqlite> UPDATE taskmanager_step SET current_step_state = 'upgrade_success' WHERE ID = 5;
sqlite> select * from taskmanager_node; # upgrade_success
1|1|centos01|test01|192.168.137.11|22|root|password_auth|{"encrypted": "1Uz8bDGX3WEPFKEFhE2vZ6JYg7q2vHdv4w0fjLRmsLtdN84E7LhX+NpRhzvIObzjQQGjeT3uRGq89uX4XPPY5TwFqZwezVH/pHIztiVQr2Y=", "encrypted_iv": "Ol2dur0l9oA101+GuAh5RQ==", "work_key_encrypted": "WreE2ROhVKdNpjhRL27T+3oxyvdEQDmRslfD1t96mAI=", "work_key_encrypted_iv": "zWl1dlyhykDr04dEsEmyOg==", "half_key1": "w5rWdfG0ehEnguYO"}|1||||centos7.6|openEuler20.03-LTS-SP1|/usr,/run,/boot,/var,/etc|||||||0||0||0|2023-02-03 19:29:25.954701|2023-02-17 15:01:22.379778|system_upgrade|upgrade_success|0|重启成功|reboot_in_progress|{"systemStructure": "x86_64", "productName": "", "manufacture": "", "supplier": "", "systemVersion": "", "modelName": ""}|1||1|CentOS Linux release 7.6.1810 (Core) |3.10.0-957.el7.x86_64|3.3G|52.6G|56.0G|||||||
sqlite> .schema taskmanager_node
CREATE TABLE "taskmanager_node" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "task_id" integer NOT NULL, "node_name" varchar(63) NULL, "node_alias_name" varchar(63) NULL, "ip_address" char(39) NULL, "port" varchar(15) NULL, "username" varchar(31) NULL, "auth_type" varchar(31) NULL, "secret_json" text NULL, "repo_id" integer NOT NULL, "persist_rpm" text NULL, "business_persist_rpm" text NULL, "persist_path" text NULL, "source_system_version" varchar(63) NULL, "target_system_version" varchar(63) NULL, "bak_dir" text NULL, "bak_dir_save_path" text NULL, "ignored_dir" text NULL, "conflict_software_config" text NULL, "cmdline_config" text NULL, "swap_software_config" text NULL, "pre_script_path" text NULL, "pre_script_state" integer NOT NULL, "un_reboot_post_script_path" text NULL, "un_reboot_post_script_state" integer NOT NULL, "rebooted_post_script_path" text NULL, "rebooted_post_script_state" integer NOT NULL, "created_time" datetime NOT NULL, "modified_time" datetime NOT NULL, "current_step" varchar(31) NULL, "current_step_state" varchar(63) NULL, "current_step_state_progress" integer NULL, "current_step_message" text NULL, "previous_step_state" varchar(63) NULL, "system_detail_info" text NULL, "rollback_state" integer NOT NULL, "src_config_info_path" text NULL, "env_need_clean_state" integer NOT NULL, "real_source_system_version" varchar(63) NULL, "source_system_kernel_version" varchar(63) NULL, "dev_used_space" varchar(31) NULL, "dev_avail_space" varchar(31) NULL, "dev_space" varchar(31) NULL, "dst_node_alias_name" varchar(63) NULL, "dst_ip_address" char(39) NULL, "dst_port" varchar(15) NULL, "dst_username" varchar(31) NULL, "dst_auth_type" varchar(31) NULL, "dst_secret_json" text NULL, "dst_node_name" varchar(63) NULL);
sqlite> UPDATE taskmanager_node SET current_step_state = 'upgrade_success' WHERE ID = 1;
升级前的检查的状态：
CHECK_SUCESS = "check_success"
CHECK_SUCCESS_IGONRE_ERROR = "check_success_ignore_error"
CHECK_IN_PROCESS = "check_in_progress"
CHECK_FAIL = "check_fail"
CHECK_OUTAGE = "check_outage"
升级过程中
REBOOT_IN_PROCESS = "reboot_in_progress"
WAIT_FOR_PPGRADE = "wait_for_upgrade"
UPGRADE_IN_PROGRESS = "upgrade_in_progress"
UPGRADE_FAIL = "upgrade_fail"
UPGRADE_STOP = "upgrade_stop"
UPGRADE_SUCCESS = "upgrade_success"
UPGRADE_STOP 代表升级完成待重启
UPGRADE_SUCCESS 升级完成已重启成功