2023-07-15 13:49:41 - INFO - 12 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-206e7ec6-e67d-4701-8632-afebc8b3481d.sh -m ob 2023-07-15 13:49:41 - INFO - 12 - [ob_precheck.py:34] - precheck for ocp on host 10.6.4.26 success 2023-07-15 13:49:41 - INFO - 12 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob  Peer IP List:  Machine Type: PHY  Inspect Mode: FALSE  check CPU count: 8 > 8 ... PASS  check total MEM: 78 GB > 64 GB ... PASS  check linux version: CentOS Linux release 7.6.1810 (Core) ... PASS  check SELinux status: Disabled ... PASS  check account [admin] and home dir, exist ... PASS  check service [firewalld]: inactive ... PASS  check service [firewalld]: disabled ... PASS  , 2023-07-15 13:49:42 - INFO - 12 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-26908c20-e423-46ad-a5ed-1393261ff278.sh -m ob 2023-07-15 13:49:42 - INFO - 12 - [ob_precheck.py:34] - precheck for ocp on host 10.6.4.27 success 2023-07-15 13:49:42 - INFO - 12 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob  Peer IP List:  Machine Type: PHY  Inspect Mode: FALSE  check CPU count: 8 > 8 ... PASS  check total MEM: 78 GB > 64 GB ... PASS  check linux version: CentOS Linux release 7.6.1810 (Core) ... PASS  check SELinux status: Disabled ... PASS  check account [admin] and home dir, exist ... PASS  check service [firewalld]: inactive ... PASS  check service [firewalld]: disabled ... PASS  , 2023-07-15 13:49:43 - INFO - 12 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-32ab5c50-3067-4130-aaee-6e2e83edb296.sh -m ob 2023-07-15 13:49:43 - INFO - 12 - [ob_precheck.py:34] - precheck for ocp on host 10.6.4.28 success 2023-07-15 13:49:43 - INFO - 12 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob  Peer IP List:  Machine Type: PHY  Inspect Mode: FALSE  check CPU count: 8 > 8 ... PASS  check total MEM: 78 GB > 64 GB ... PASS  check linux version: CentOS Linux release 7.6.1810 (Core) ... PASS  check SELinux status: Disabled ... PASS  check account [admin] and home dir, exist ... PASS  check service [firewalld]: inactive ... PASS  check service [firewalld]: disabled ... PASS  , 2023-07-15 13:49:43 - INFO - 12 - [ob_install.py:82] - clean obd dir 2023-07-15 13:49:43 - INFO - 12 - [ob_install.py:91] - install ob using obd 2023-07-15 13:49:43 - INFO - 12 - [ob_install.py:95] - deploy task with config:obproxy-ce: depends: - oceanbase-ce global: home_path: /obproxy listen_port: 2883 servers: - 10.6.4.26 oceanbase-ce: global: appname: obcluster data_dir: /oceanbase/data/1 datafile_size: 10G devname: ens192 home_path: /oceanbase/oceanbase memory_limit: 30G mysql_port: 2881 redo_dir: /oceanbase/data/log1 root_password: obcp rpc_port: 2882 system_memory: 8G server1: zone: zone0 server2: zone: zone1 server3: zone: zone2 servers: - ip: 10.6.4.26 name: server1 - ip: 10.6.4.27 name: server2 - ip: 10.6.4.28 name: server3 user: key_file: '' password: admin port: 22 timeout: 10 username: admin 2023-07-15 13:49:43 - INFO - 12 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml 2023-07-15 13:50:51 - INFO - 12 - [ob_install.py:71] - create meta tenant with command obd cluster tenant create obcluster -n meta_tenant --max-cpu 2 --min-cpu 2 --max-memory 4294967296 --min-memory 4294967296 2023-07-15 13:50:57 - INFO - 12 - [ob_install.py:76] - create monitor tenant with command obd cluster tenant create obcluster -n monitor_tenant --max-cpu 4 --min-cpu 4 --max-memory 8589934592 --min-memory 8589934592 2023-07-15 13:51:00 - INFO - 12 - [ob_install.py:124] - create meta user 2023-07-15 13:51:01 - INFO - 12 - [ob_install.py:126] - grant privilege to meta user 2023-07-15 13:51:01 - INFO - 12 - [ob_install.py:128] - set meta user password 2023-07-15 13:51:01 - INFO - 12 - [ob_install.py:137] - create monitor user 2023-07-15 13:51:02 - INFO - 12 - [ob_install.py:139] - grant privilege to monitor user 2023-07-15 13:51:02 - INFO - 12 - [ob_install.py:141] - set monitor user password 2023-07-15 13:51:02 - INFO - 12 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-c300cc2e-dd2b-473a-beb6-7e38a9f85389.sh -m ocp 2023-07-15 13:51:02 - INFO - 12 - [ocp_precheck.py:31] - precheck for ocp on host 10.6.132.243 success 2023-07-15 13:51:02 - INFO - 12 - [ocp_precheck.py:32] - ocp precheck result: Machine Role: ocp  Peer IP List:  Machine Type: PHY  Inspect Mode: FALSE  check CPU count: 40 > 8 ... PASS  check total MEM: 113 GB > 32 GB ... PASS  check linux version: CentOS Linux release 7.5.1804 (Core) ... PASS  check SELinux status: Disabled ... PASS  check account [admin] and home dir, exist ... PASS  check service [firewalld]: inactive ... PASS  check service [firewalld]: disabled ... PASS  check docker version: 1.13.1 ... PASS  , 2023-07-15 13:51:03 - INFO - 12 - [image_load.py:21] - check image got result: 0 463500f94c64 2023-07-15 13:51:03 - INFO - 12 - [image_load.py:23] - image reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp2 already loaded 2023-07-15 13:51:03 - INFO - 12 - [metadb_init.py:13] - run with context: {'precheck_ignore': True, 'create_metadb_cluster': True, 'clean_metadb_cluster': True, 'ob_cluster': {'name': 'obcluster', 'home_path': '/oceanbase/oceanbase', 'data_path': '/oceanbase/data/1', 'redo_path': '/oceanbase/data/log1', 'root_password': 'obcp', 'rpc_port': 2882, 'sql_port': 2881, 'zones': [{'name': 'zone0', 'servers': ['10.6.4.26']}, {'name': 'zone1', 'servers': ['10.6.4.27']}, {'name': 'zone2', 'servers': ['10.6.4.28']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obcp', 'cpu': 2, 'memory': 4, 'database': 'meta_database'}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obcp', 'cpu': 4, 'memory': 8, 'database': 'monitor_database'}, 'custom_config': [{'key': 'devname', 'value': 'ens192'}, {'key': 'memory_limit', 'value': '30G'}, {'key': 'system_memory', 'value': '8G'}, {'key': 'datafile_size', 'value': '10G'}]}, 'obproxy': {'home_path': '/obproxy', 'port': 2883, 'servers': ['10.6.4.26'], 'vip': {'address': '10.6.4.26', 'port': 2883}}, 'ssh': {'user': 'admin', 'port': 22, 'auth_method': 'password', 'password': 'admin', 'key_file': '/root/keys/id_rsa', 'timeout': 10}, 'ocp': {'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp2', 'image': '/root/ocp.tar.gz', 'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/u01/oceanbase/log'}, 'servers': ['10.6.132.243'], 'resource': {'cpu': 4, 'memory': 8}, 'vip': {'address': '10.6.132.243', 'port': 8080}, 'auth': None, 'metadb': {'host': '10.6.4.26', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obcp', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obcp', 'monitor_database': 'monitor_database'}}, 'task_id': '2f9e0990-2a9c-4284-a1ce-915194d248fc', 'operation': 'install'} 2023-07-15 13:51:03 - INFO - 12 - [metadb_init.py:35] - init ocp metadb with command: sudo docker run --rm --net=host --workdir=/home/admin/ocp-init/src/ocp-init --entrypoint=python -e PYTHONUNBUFFERED=1 -e TABLEGROUP_NAME=meta_database reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp2 create_metadb.py 10.6.4.26 2883 meta_user@meta_tenant#obcluster obcp meta_database monitor_user@monitor_tenant#obcluster obcp monitor_database on host: 10.6.132.243 2023-07-15 14:21:49 - INFO - 12 - [metadb_init.py:39] - run init metadb script got result: Generated yml file: OcpInitParameter: METADB: ip: &metadb_ip 10.6.4.26 username: &metadb_username meta_user@meta_tenant#obcluster password: &metadb_password 'obcp' port: &metadb_port 2883 dbname: &metadb_dbname meta_database MONITORDB: ip: &monitordb_ip 10.6.4.26 username: &monitordb_username monitor_user@monitor_tenant#obcluster password: &monitordb_password 'obcp' port: &monitordb_port 2883 dbname: &monitordb_dbname monitor_database CONFIGURATION: ocp.monitordb.host: *monitordb_ip ocp.monitordb.port: *monitordb_port ocp.monitordb.username: *monitordb_username ocp.monitordb.password: *monitordb_password ocp.monitordb.database: *monitordb_dbname ocp.iam.auth: local backup.dbname.prefix: &backup_dbname_prefix backup start create database meta_database table config_properties or ocp2_sys_property not exist generate ../../sqls/dynamic_config_properties.sql success generate ../../sqls/generate/iam_role.sql success generate ../../sqls/generate/ob_parameter_info.sql success generate ../../sqls/generate/obproxy_parameter_info.sql success generate ../../sqls/generate/ob_system_variable_info.sql success generate ../../sqls/generate/config_properties.sql success generate ../../sqls/generate/config_properties_deleted.sql success generate ../../sqls/generate/ob_cluster_event_info.sql success generate ../../sqls/generate/monitor_metric_ob_collect_config.sql success generate ../../sqls/generate/audit_event_meta.sql success generate ../../sqls/generate/ocp2_alarm_metric_meta.sql success generate ../../sqls/generate/ocp2_alarm_metric_meta_deleted.sql success generate ../../sqls/generate/ocp2_alarm_rule.sql success generate ../../sqls/generate/ocp2_alarm_rule_deleted.sql success generate ../../sqls/generate/ocp_alarm_detect_rule.sql success generate ../../sqls/generate/ocp_alarm_detect_rule_deleted.sql success generate ../../sqls/generate/ocp_alarm_group.sql success generate ../../sqls/generate/ocp_alarm_group_alarm_type.sql success generate ../../sqls/generate/ocp2_template_variable_meta.sql success generate ../../sqls/generate/mc_ocp_cluster_config.sql success generate ../../sqls/generate/ob_error_code.sql success generate ../../sqls/generate/metric_expression.sql success generate ../../sqls/generate/metric_expression_deleted.sql success generate ../../sqls/generate/metric_class.sql success generate ../../sqls/generate/metric_group.sql success generate ../../sqls/generate/metric_meta.sql success generate ../../sqls/generate/metric_class_deleted.sql success generate ../../sqls/generate/metric_group_deleted.sql success generate ../../sqls/generate/metric_meta_deleted.sql success all sql files: ['ocp_metadb_ddl.sql', 'ocp_metadb_tablegroup.sql', 'ocp_metadb_dml.sql', 'update_ddl_2.2.0.sql', 'update_ddl_2.3.0.sql', 'update_ddl_2.3.1.sql', 'update_ddl_2.3.2.sql', 'update_ddl_2.3.3.sql', 'update_ddl_2.3.4.sql', 'update_ddl_2.3.5.sql', 'update_ddl_2.3.7.sql', 'update_ddl_2.4.0.sql', 'update_ddl_2.4.1.sql', 'update_ddl_2.4.2.sql', 'update_ddl_2.4.3.sql', 'update_ddl_2.4.4.sql', 'update_ddl_2.4.5.sql', 'update_ddl_2.5.0.sql', 'update_ddl_2.5.1.sql', 'update_ddl_2.5.4.sql', 'update_ddl_3.1.0.sql', 'update_ddl_3.1.1.sql', 'update_ddl_3.1.2.sql', 'update_ddl_3.2.0.sql', 'update_dml_2.2.0.sql', 'update_dml_2.3.0.sql', 'update_dml_2.3.1.sql', 'update_dml_2.3.2.sql', 'update_dml_2.3.3.sql', 'update_dml_2.3.4.sql', 'update_dml_2.3.5.sql', 'update_dml_2.3.6.sql', 'update_dml_2.3.7.sql', 'update_dml_2.4.0.sql', 'update_dml_2.4.1.sql', 'update_dml_2.4.2.sql', 'update_dml_2.4.3.sql', 'update_dml_2.4.4.sql', 'update_dml_2.4.5.sql', 'update_dml_2.5.0.sql', 'update_dml_2.5.1.sql', 'update_dml_2.5.2.sql', 'update_dml_2.5.3.sql', 'update_dml_2.5.4.sql', 'update_dml_3.1.0.sql', 'update_dml_3.1.1.sql', 'update_dml_3.1.2.sql', 'update_dml_3.1.3.sql', 'update_dml_3.2.0.sql', 'update_ddl_3.2.1.sql', 'update_dml_3.2.1.sql', 'update_ddl_3.2.2.sql', 'update_ddl_3.2.3.sql', 'update_ddl_3.3.0.sql', 'update_dml_3.2.2.sql', 'update_dml_3.2.3.sql', 'update_dml_3.3.0.sql', 'generate/audit_event_meta.sql', 'generate/config_properties.sql', 'generate/config_properties_deleted.sql', 'generate/iam_role.sql', 'generate/inspection_script.sql', 'generate/mc_ocp_cluster_config.sql', 'generate/metric_class.sql', 'generate/metric_class_deleted.sql', 'generate/metric_expression.sql', 'generate/metric_expression_deleted.sql', 'generate/metric_group.sql', 'generate/metric_group_deleted.sql', 'generate/metric_meta.sql', 'generate/metric_meta_deleted.sql', 'generate/monitor_metric_ob_collect_config.sql', 'generate/ob_cluster_event_info.sql', 'generate/ob_error_code.sql', 'generate/ob_parameter_info.sql', 'generate/ob_system_variable_info.sql', 'generate/obproxy_parameter_info.sql', 'generate/ocp2_alarm_metric_meta.sql', 'generate/ocp2_alarm_metric_meta_deleted.sql', 'generate/ocp2_alarm_rule.sql', 'generate/ocp2_alarm_rule_deleted.sql', 'generate/ocp2_template_variable_meta.sql', 'generate/ocp_alarm_detect_rule.sql', 'generate/ocp_alarm_detect_rule_deleted.sql', 'generate/ocp_alarm_group.sql', 'generate/ocp_alarm_group_alarm_type.sql', 'dynamic_config_properties.sql'] start to load sqls replace table_group in sql file: ocp_metadb_ddl.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/ocp_metadb_ddl.sql > ../../sqls/real/ocp_metadb_ddl.sql executing real sql script: real/ocp_metadb_ddl.sql replace table_group in sql file: ocp_metadb_tablegroup.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/ocp_metadb_tablegroup.sql > ../../sqls/real/ocp_metadb_tablegroup.sql executing real sql script: real/ocp_metadb_tablegroup.sql replace table_group in sql file: ocp_metadb_dml.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/ocp_metadb_dml.sql > ../../sqls/real/ocp_metadb_dml.sql executing real sql script: real/ocp_metadb_dml.sql replace table_group in sql file: update_ddl_2.2.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.2.0.sql > ../../sqls/real/update_ddl_2.2.0.sql executing real sql script: real/update_ddl_2.2.0.sql replace table_group in sql file: update_ddl_2.3.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.0.sql > ../../sqls/real/update_ddl_2.3.0.sql executing real sql script: real/update_ddl_2.3.0.sql [2023-07-15 13:59:46] run sql alter table ocp_rpm_svn add column upgrade_post_checker varbinary(262144); got duplicate column error 1060 (42S21): Duplicate column name 'upgrade_post_checker', just skip replace table_group in sql file: update_ddl_2.3.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.1.sql > ../../sqls/real/update_ddl_2.3.1.sql executing real sql script: real/update_ddl_2.3.1.sql replace table_group in sql file: update_ddl_2.3.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.2.sql > ../../sqls/real/update_ddl_2.3.2.sql executing real sql script: real/update_ddl_2.3.2.sql replace table_group in sql file: update_ddl_2.3.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.3.sql > ../../sqls/real/update_ddl_2.3.3.sql executing real sql script: real/update_ddl_2.3.3.sql replace table_group in sql file: update_ddl_2.3.4.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.4.sql > ../../sqls/real/update_ddl_2.3.4.sql executing real sql script: real/update_ddl_2.3.4.sql replace table_group in sql file: update_ddl_2.3.5.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.5.sql > ../../sqls/real/update_ddl_2.3.5.sql executing real sql script: real/update_ddl_2.3.5.sql replace table_group in sql file: update_ddl_2.3.7.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.7.sql > ../../sqls/real/update_ddl_2.3.7.sql executing real sql script: real/update_ddl_2.3.7.sql replace table_group in sql file: update_ddl_2.4.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.0.sql > ../../sqls/real/update_ddl_2.4.0.sql executing real sql script: real/update_ddl_2.4.0.sql replace table_group in sql file: update_ddl_2.4.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.1.sql > ../../sqls/real/update_ddl_2.4.1.sql executing real sql script: real/update_ddl_2.4.1.sql [2023-07-15 14:00:11] run sql ALTER TABLE `ocp2_template_variable_meta` ADD `description3` varchar(512) NULL COMMENT 'zh_TW 变量描述'; got duplicate column error 1060 (42S21): Duplicate column name 'description3', just skip [2023-07-15 14:00:11] run sql ALTER TABLE `ocp2_alarm_metric_meta` ADD `name3` varchar(64) NULL COMMENT 'zh_TW 指标名称'; got duplicate column error 1060 (42S21): Duplicate column name 'name3', just skip [2023-07-15 14:00:11] run sql ALTER TABLE `ocp2_alarm_metric_meta` ADD `description3` varchar(512) NULL COMMENT 'zh_TW 指标描述'; got duplicate column error 1060 (42S21): Duplicate column name 'description3', just skip [2023-07-15 14:00:11] run sql ALTER TABLE `ocp2_alarm_metric_meta` ADD `unit2` varchar(32) NULL COMMENT 'en_US 单位'; got duplicate column error 1060 (42S21): Duplicate column name 'unit2', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_metric_meta` ADD `unit3` varchar(32) NULL COMMENT 'zh_TW 单位'; got duplicate column error 1060 (42S21): Duplicate column name 'unit3', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_rule` ADD `name3` varchar(64) NULL COMMENT 'zh_TW 告警项名称'; got duplicate column error 1060 (42S21): Duplicate column name 'name3', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_rule` ADD `summary_template3` varchar(256) NULL COMMENT 'zh_TW 概述模板'; got duplicate column error 1060 (42S21): Duplicate column name 'summary_template3', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_rule` ADD `description_template3` varchar(512) NULL COMMENT 'zh_TW 详情模板'; got duplicate column error 1060 (42S21): Duplicate column name 'description_template3', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_channel` ADD `name2` varchar(64) NULL COMMENT 'en_US 名称'; got duplicate column error 1060 (42S21): Duplicate column name 'name2', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_channel` ADD `name3` varchar(64) NULL COMMENT 'zh_TW 名称'; got duplicate column error 1060 (42S21): Duplicate column name 'name3', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_channel` ADD `message_template3` varchar(4096) NULL COMMENT 'en_US 消息模版'; got duplicate column error 1060 (42S21): Duplicate column name 'message_template3', just skip [2023-07-15 14:00:12] run sql ALTER TABLE `ocp2_alarm_channel` ADD `aggregation_message_template3` varchar(4096) NULL COMMENT 'en_US 聚合消息模板'; got duplicate column error 1060 (42S21): Duplicate column name 'aggregation_message_template3', just skip replace table_group in sql file: update_ddl_2.4.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.2.sql > ../../sqls/real/update_ddl_2.4.2.sql executing real sql script: real/update_ddl_2.4.2.sql replace table_group in sql file: update_ddl_2.4.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.3.sql > ../../sqls/real/update_ddl_2.4.3.sql executing real sql script: real/update_ddl_2.4.3.sql replace table_group in sql file: update_ddl_2.4.4.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.4.sql > ../../sqls/real/update_ddl_2.4.4.sql executing real sql script: real/update_ddl_2.4.4.sql replace table_group in sql file: update_ddl_2.4.5.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.5.sql > ../../sqls/real/update_ddl_2.4.5.sql executing real sql script: real/update_ddl_2.4.5.sql replace table_group in sql file: update_ddl_2.5.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.5.0.sql > ../../sqls/real/update_ddl_2.5.0.sql executing real sql script: real/update_ddl_2.5.0.sql replace table_group in sql file: update_ddl_2.5.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.5.1.sql > ../../sqls/real/update_ddl_2.5.1.sql executing real sql script: real/update_ddl_2.5.1.sql replace table_group in sql file: update_ddl_2.5.4.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.5.4.sql > ../../sqls/real/update_ddl_2.5.4.sql executing real sql script: real/update_ddl_2.5.4.sql replace table_group in sql file: update_ddl_3.1.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.1.0.sql > ../../sqls/real/update_ddl_3.1.0.sql executing real sql script: real/update_ddl_3.1.0.sql replace table_group in sql file: update_ddl_3.1.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.1.1.sql > ../../sqls/real/update_ddl_3.1.1.sql executing real sql script: real/update_ddl_3.1.1.sql replace table_group in sql file: update_ddl_3.1.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.1.2.sql > ../../sqls/real/update_ddl_3.1.2.sql executing real sql script: real/update_ddl_3.1.2.sql replace table_group in sql file: update_ddl_3.2.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.2.0.sql > ../../sqls/real/update_ddl_3.2.0.sql executing real sql script: real/update_ddl_3.2.0.sql [2023-07-15 14:00:50] run sql ALTER TABLE `ocp2_alarm_filter` ADD COLUMN `filter_time_range_json` varchar(2048) NOT NULL DEFAULT '{}' COMMENT '屏蔽时间段匹配条件 MatchTimeRange json数组'; got duplicate column error 1060 (42S21): Duplicate column name 'filter_time_range_json', just skip +++++++++++++++++++++++++++++++++ + wait for election, sleep 120S + +++++++++++++++++++++++++++++++++ replace table_group in sql file: update_dml_2.2.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.2.0.sql > ../../sqls/real/update_dml_2.2.0.sql executing real sql script: real/update_dml_2.2.0.sql replace table_group in sql file: update_dml_2.3.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.0.sql > ../../sqls/real/update_dml_2.3.0.sql executing real sql script: real/update_dml_2.3.0.sql replace table_group in sql file: update_dml_2.3.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.1.sql > ../../sqls/real/update_dml_2.3.1.sql executing real sql script: real/update_dml_2.3.1.sql replace table_group in sql file: update_dml_2.3.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.2.sql > ../../sqls/real/update_dml_2.3.2.sql executing real sql script: real/update_dml_2.3.2.sql replace table_group in sql file: update_dml_2.3.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.3.sql > ../../sqls/real/update_dml_2.3.3.sql executing real sql script: real/update_dml_2.3.3.sql replace table_group in sql file: update_dml_2.3.4.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.4.sql > ../../sqls/real/update_dml_2.3.4.sql executing real sql script: real/update_dml_2.3.4.sql replace table_group in sql file: update_dml_2.3.5.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.5.sql > ../../sqls/real/update_dml_2.3.5.sql executing real sql script: real/update_dml_2.3.5.sql replace table_group in sql file: update_dml_2.3.6.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.6.sql > ../../sqls/real/update_dml_2.3.6.sql executing real sql script: real/update_dml_2.3.6.sql replace table_group in sql file: update_dml_2.3.7.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.3.7.sql > ../../sqls/real/update_dml_2.3.7.sql executing real sql script: real/update_dml_2.3.7.sql replace table_group in sql file: update_dml_2.4.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.4.0.sql > ../../sqls/real/update_dml_2.4.0.sql executing real sql script: real/update_dml_2.4.0.sql replace table_group in sql file: update_dml_2.4.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.4.1.sql > ../../sqls/real/update_dml_2.4.1.sql executing real sql script: real/update_dml_2.4.1.sql replace table_group in sql file: update_dml_2.4.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.4.2.sql > ../../sqls/real/update_dml_2.4.2.sql executing real sql script: real/update_dml_2.4.2.sql replace table_group in sql file: update_dml_2.4.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.4.3.sql > ../../sqls/real/update_dml_2.4.3.sql executing real sql script: real/update_dml_2.4.3.sql replace table_group in sql file: update_dml_2.4.4.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.4.4.sql > ../../sqls/real/update_dml_2.4.4.sql executing real sql script: real/update_dml_2.4.4.sql replace table_group in sql file: update_dml_2.4.5.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.4.5.sql > ../../sqls/real/update_dml_2.4.5.sql executing real sql script: real/update_dml_2.4.5.sql replace table_group in sql file: update_dml_2.5.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.5.0.sql > ../../sqls/real/update_dml_2.5.0.sql executing real sql script: real/update_dml_2.5.0.sql replace table_group in sql file: update_dml_2.5.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.5.1.sql > ../../sqls/real/update_dml_2.5.1.sql executing real sql script: real/update_dml_2.5.1.sql replace table_group in sql file: update_dml_2.5.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.5.2.sql > ../../sqls/real/update_dml_2.5.2.sql executing real sql script: real/update_dml_2.5.2.sql replace table_group in sql file: update_dml_2.5.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.5.3.sql > ../../sqls/real/update_dml_2.5.3.sql executing real sql script: real/update_dml_2.5.3.sql replace table_group in sql file: update_dml_2.5.4.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_2.5.4.sql > ../../sqls/real/update_dml_2.5.4.sql executing real sql script: real/update_dml_2.5.4.sql replace table_group in sql file: update_dml_3.1.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.1.0.sql > ../../sqls/real/update_dml_3.1.0.sql executing real sql script: real/update_dml_3.1.0.sql replace table_group in sql file: update_dml_3.1.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.1.1.sql > ../../sqls/real/update_dml_3.1.1.sql executing real sql script: real/update_dml_3.1.1.sql replace table_group in sql file: update_dml_3.1.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.1.2.sql > ../../sqls/real/update_dml_3.1.2.sql executing real sql script: real/update_dml_3.1.2.sql replace table_group in sql file: update_dml_3.1.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.1.3.sql > ../../sqls/real/update_dml_3.1.3.sql executing real sql script: real/update_dml_3.1.3.sql replace table_group in sql file: update_dml_3.2.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.2.0.sql > ../../sqls/real/update_dml_3.2.0.sql executing real sql script: real/update_dml_3.2.0.sql replace table_group in sql file: update_ddl_3.2.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.2.1.sql > ../../sqls/real/update_ddl_3.2.1.sql executing real sql script: real/update_ddl_3.2.1.sql +++++++++++++++++++++++++++++++++ + wait for election, sleep 120S + +++++++++++++++++++++++++++++++++ replace table_group in sql file: update_dml_3.2.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.2.1.sql > ../../sqls/real/update_dml_3.2.1.sql executing real sql script: real/update_dml_3.2.1.sql replace table_group in sql file: update_ddl_3.2.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.2.2.sql > ../../sqls/real/update_ddl_3.2.2.sql executing real sql script: real/update_ddl_3.2.2.sql replace table_group in sql file: update_ddl_3.2.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.2.3.sql > ../../sqls/real/update_ddl_3.2.3.sql executing real sql script: real/update_ddl_3.2.3.sql replace table_group in sql file: update_ddl_3.3.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.3.0.sql > ../../sqls/real/update_ddl_3.3.0.sql executing real sql script: real/update_ddl_3.3.0.sql +++++++++++++++++++++++++++++++++ + wait for election, sleep 120S + +++++++++++++++++++++++++++++++++ replace table_group in sql file: update_dml_3.2.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.2.2.sql > ../../sqls/real/update_dml_3.2.2.sql executing real sql script: real/update_dml_3.2.2.sql replace table_group in sql file: update_dml_3.2.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.2.3.sql > ../../sqls/real/update_dml_3.2.3.sql executing real sql script: real/update_dml_3.2.3.sql replace table_group in sql file: update_dml_3.3.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_dml_3.3.0.sql > ../../sqls/real/update_dml_3.3.0.sql executing real sql script: real/update_dml_3.3.0.sql replace table_group in sql file: generate/audit_event_meta.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/audit_event_meta.sql > ../../sqls/real/audit_event_meta.sql executing real sql script: real/audit_event_meta.sql replace table_group in sql file: generate/config_properties.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/config_properties.sql > ../../sqls/real/config_properties.sql executing real sql script: real/config_properties.sql replace table_group in sql file: generate/config_properties_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/config_properties_deleted.sql > ../../sqls/real/config_properties_deleted.sql executing real sql script: real/config_properties_deleted.sql replace table_group in sql file: generate/iam_role.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/iam_role.sql > ../../sqls/real/iam_role.sql executing real sql script: real/iam_role.sql replace table_group in sql file: generate/inspection_script.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/inspection_script.sql > ../../sqls/real/inspection_script.sql executing real sql script: real/inspection_script.sql replace table_group in sql file: generate/mc_ocp_cluster_config.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/mc_ocp_cluster_config.sql > ../../sqls/real/mc_ocp_cluster_config.sql executing real sql script: real/mc_ocp_cluster_config.sql replace table_group in sql file: generate/metric_class.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_class.sql > ../../sqls/real/metric_class.sql executing real sql script: real/metric_class.sql replace table_group in sql file: generate/metric_class_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_class_deleted.sql > ../../sqls/real/metric_class_deleted.sql executing real sql script: real/metric_class_deleted.sql replace table_group in sql file: generate/metric_expression.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_expression.sql > ../../sqls/real/metric_expression.sql executing real sql script: real/metric_expression.sql replace table_group in sql file: generate/metric_expression_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_expression_deleted.sql > ../../sqls/real/metric_expression_deleted.sql executing real sql script: real/metric_expression_deleted.sql replace table_group in sql file: generate/metric_group.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_group.sql > ../../sqls/real/metric_group.sql executing real sql script: real/metric_group.sql replace table_group in sql file: generate/metric_group_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_group_deleted.sql > ../../sqls/real/metric_group_deleted.sql executing real sql script: real/metric_group_deleted.sql replace table_group in sql file: generate/metric_meta.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_meta.sql > ../../sqls/real/metric_meta.sql executing real sql script: real/metric_meta.sql replace table_group in sql file: generate/metric_meta_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/metric_meta_deleted.sql > ../../sqls/real/metric_meta_deleted.sql executing real sql script: real/metric_meta_deleted.sql replace table_group in sql file: generate/monitor_metric_ob_collect_config.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/monitor_metric_ob_collect_config.sql > ../../sqls/real/monitor_metric_ob_collect_config.sql executing real sql script: real/monitor_metric_ob_collect_config.sql replace table_group in sql file: generate/ob_cluster_event_info.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ob_cluster_event_info.sql > ../../sqls/real/ob_cluster_event_info.sql executing real sql script: real/ob_cluster_event_info.sql replace table_group in sql file: generate/ob_error_code.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ob_error_code.sql > ../../sqls/real/ob_error_code.sql executing real sql script: real/ob_error_code.sql replace table_group in sql file: generate/ob_parameter_info.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ob_parameter_info.sql > ../../sqls/real/ob_parameter_info.sql executing real sql script: real/ob_parameter_info.sql replace table_group in sql file: generate/ob_system_variable_info.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ob_system_variable_info.sql > ../../sqls/real/ob_system_variable_info.sql executing real sql script: real/ob_system_variable_info.sql replace table_group in sql file: generate/obproxy_parameter_info.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/obproxy_parameter_info.sql > ../../sqls/real/obproxy_parameter_info.sql executing real sql script: real/obproxy_parameter_info.sql replace table_group in sql file: generate/ocp2_alarm_metric_meta.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp2_alarm_metric_meta.sql > ../../sqls/real/ocp2_alarm_metric_meta.sql executing real sql script: real/ocp2_alarm_metric_meta.sql replace table_group in sql file: generate/ocp2_alarm_metric_meta_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp2_alarm_metric_meta_deleted.sql > ../../sqls/real/ocp2_alarm_metric_meta_deleted.sql executing real sql script: real/ocp2_alarm_metric_meta_deleted.sql replace table_group in sql file: generate/ocp2_alarm_rule.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp2_alarm_rule.sql > ../../sqls/real/ocp2_alarm_rule.sql executing real sql script: real/ocp2_alarm_rule.sql replace table_group in sql file: generate/ocp2_alarm_rule_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp2_alarm_rule_deleted.sql > ../../sqls/real/ocp2_alarm_rule_deleted.sql executing real sql script: real/ocp2_alarm_rule_deleted.sql replace table_group in sql file: generate/ocp2_template_variable_meta.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp2_template_variable_meta.sql > ../../sqls/real/ocp2_template_variable_meta.sql executing real sql script: real/ocp2_template_variable_meta.sql replace table_group in sql file: generate/ocp_alarm_detect_rule.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_detect_rule.sql > ../../sqls/real/ocp_alarm_detect_rule.sql executing real sql script: real/ocp_alarm_detect_rule.sql replace table_group in sql file: generate/ocp_alarm_detect_rule_deleted.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_detect_rule_deleted.sql > ../../sqls/real/ocp_alarm_detect_rule_deleted.sql executing real sql script: real/ocp_alarm_detect_rule_deleted.sql replace table_group in sql file: generate/ocp_alarm_group.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_group.sql > ../../sqls/real/ocp_alarm_group.sql executing real sql script: real/ocp_alarm_group.sql replace table_group in sql file: generate/ocp_alarm_group_alarm_type.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_group_alarm_type.sql > ../../sqls/real/ocp_alarm_group_alarm_type.sql executing real sql script: real/ocp_alarm_group_alarm_type.sql replace table_group in sql file: dynamic_config_properties.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/dynamic_config_properties.sql > ../../sqls/real/dynamic_config_properties.sql executing real sql script: real/dynamic_config_properties.sql finish to load sqls generate ../../sqls/generate/ocp_alarm_detect_rule_user_defined.sql success generate ../../sqls/generate/ocp_alarm_group_before321_migrate.sql success start to load sqls replace table_group in sql file: generate/ocp_alarm_detect_rule_user_defined.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_detect_rule_user_defined.sql > ../../sqls/real/ocp_alarm_detect_rule_user_defined.sql executing real sql script: real/ocp_alarm_detect_rule_user_defined.sql replace table_group in sql file: generate/ocp_alarm_group_before321_migrate.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_group_before321_migrate.sql > ../../sqls/real/ocp_alarm_group_before321_migrate.sql executing real sql script: real/ocp_alarm_group_before321_migrate.sql finish to load sqls generate ../../sqls/ocp_alarm_detect_rule_before330_migrate.sql success start to load sqls replace table_group in sql file: ocp_alarm_detect_rule_before330_migrate.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/ocp_alarm_detect_rule_before330_migrate.sql > ../../sqls/real/ocp_alarm_detect_rule_before330_migrate.sql executing real sql script: real/ocp_alarm_detect_rule_before330_migrate.sql finish to load sqls generate ../../sqls/generate/ocp_alarm_detect_rule_fix_names.sql success start to load sqls replace table_group in sql file: generate/ocp_alarm_detect_rule_fix_names.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/generate/ocp_alarm_detect_rule_fix_names.sql > ../../sqls/real/ocp_alarm_detect_rule_fix_names.sql executing real sql script: real/ocp_alarm_detect_rule_fix_names.sql finish to load sqls start create database monitor_database monitordb all sql files: ['monitordb_ddl_2.5.0.sql', 'monitordb_ddl_2.5.1.sql', 'monitordb_ddl_3.1.0.sql', 'monitordb_ddl_3.1.1.sql', 'monitordb_ddl_3.1.2.sql', 'monitordb_ddl_3.1.3.sql', 'monitordb_ddl_3.2.0.sql', 'monitordb_ddl_3.2.1.sql', 'monitordb_ddl_3.3.0.sql', 'monitordb_dml_3.2.0.sql', 'monitordb_dml_3.2.1.sql'] start to load sqls replace table_group in sql file: monitordb_ddl_2.5.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_2.5.0.sql > ../../sqls/real/monitordb_ddl_2.5.0.sql executing real sql script: real/monitordb_ddl_2.5.0.sql replace table_group in sql file: monitordb_ddl_2.5.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_2.5.1.sql > ../../sqls/real/monitordb_ddl_2.5.1.sql executing real sql script: real/monitordb_ddl_2.5.1.sql replace table_group in sql file: monitordb_ddl_3.1.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.1.0.sql > ../../sqls/real/monitordb_ddl_3.1.0.sql executing real sql script: real/monitordb_ddl_3.1.0.sql replace table_group in sql file: monitordb_ddl_3.1.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.1.1.sql > ../../sqls/real/monitordb_ddl_3.1.1.sql executing real sql script: real/monitordb_ddl_3.1.1.sql replace table_group in sql file: monitordb_ddl_3.1.2.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.1.2.sql > ../../sqls/real/monitordb_ddl_3.1.2.sql executing real sql script: real/monitordb_ddl_3.1.2.sql replace table_group in sql file: monitordb_ddl_3.1.3.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.1.3.sql > ../../sqls/real/monitordb_ddl_3.1.3.sql executing real sql script: real/monitordb_ddl_3.1.3.sql replace table_group in sql file: monitordb_ddl_3.2.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.2.0.sql > ../../sqls/real/monitordb_ddl_3.2.0.sql executing real sql script: real/monitordb_ddl_3.2.0.sql [2023-07-15 14:21:03] run sql alter table ob_hist_sqltext add column statement text after sql_text; got duplicate column error 1060 (42S21): Duplicate column name 'statement', just skip replace table_group in sql file: monitordb_ddl_3.2.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.2.1.sql > ../../sqls/real/monitordb_ddl_3.2.1.sql executing real sql script: real/monitordb_ddl_3.2.1.sql [2023-07-15 14:21:05] run sql alter table ob_hist_sqltext add column sql_type varchar(1024) COMMENT 'SQL的类型' after statement; got duplicate column error 1060 (42S21): Duplicate column name 'sql_type', just skip replace table_group in sql file: monitordb_ddl_3.3.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_ddl_3.3.0.sql > ../../sqls/real/monitordb_ddl_3.3.0.sql executing real sql script: real/monitordb_ddl_3.3.0.sql replace table_group in sql file: monitordb_dml_3.2.0.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_dml_3.2.0.sql > ../../sqls/real/monitordb_dml_3.2.0.sql executing real sql script: real/monitordb_dml_3.2.0.sql replace table_group in sql file: monitordb_dml_3.2.1.sql sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/monitordb_dml_3.2.1.sql > ../../sqls/real/monitordb_dml_3.2.1.sql executing real sql script: real/monitordb_dml_3.2.1.sql finish to load sqls SUCCESS. start create backup databases start create backup1472 loading sql script: backup_metadb_init.sql loading sql script: restore_metadb_init.sql end create backup1472 start create backup147x loading sql script: backup_metadb_init.sql loading sql script: restore_metadb_init.sql end create backup147x start create backup21 loading sql script: backup_metadb_init.sql loading sql script: restore_metadb_init.sql end create backup21 start create backup2230 loading sql script: backup_metadb_init.sql loading sql script: restore_metadb_init.sql end create backup2230 end create backup databases , create_metadb.py:21: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. data = yaml.load(file) /home/admin/ocp-init/src/ocp-init/generate/gen_dynamic_config_properties.py:14: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. data = yaml.load(file) /home/admin/ocp-init/src/ocp-init/generate/yml_to_table.py:69: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. data = yaml.load(file) No handlers could be found for logger "root" 2023-07-15 14:21:49 - INFO - 12 - [metadb_init.py:44] - customize site url: sudo docker run --rm --net=host --entrypoint=mysql reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp2 -h10.6.4.26 -P2883 -umeta_user@meta_tenant#obcluster -pobcp -Dmeta_database -e"update config_properties set value='http://10.6.132.243:8080' where \`key\` = 'ocp.site.url';" 2023-07-15 14:21:50 - INFO - 12 - [metadb_init.py:50] - customize server port: sudo docker run --rm --net=host --entrypoint=mysql reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp2 -h10.6.4.26 -P2883 -umeta_user@meta_tenant#obcluster -pobcp -Dmeta_database -e"update config_properties set value='8080' where \`key\` = 'server.port';" 2023-07-15 14:21:50 - INFO - 12 - [ocp_start.py:38] - prepare log dir on server: 10.6.132.243 with command: sudo mkdir -p /u01/oceanbase/log/{ocp,obproxy/log,obproxy/minidump,obproxy/etc} && sudo chown -R 500:500 /u01/oceanbase/log 2023-07-15 14:21:50 - INFO - 12 - [ocp_start.py:42] - start ocp docker on server: 10.6.132.243 with command: sudo docker run -d --name ocp --cpu-period 100000 --cpu-quota 400000 --memory=8G -e OCP_METADB_HOST=10.6.4.26 -e OCP_METADB_PORT=2883 -e OCP_METADB_USER=meta_user@meta_tenant#obcluster -e OCP_METADB_PASSWORD='obcp' -e OCP_METADB_DBNAME=meta_database -e OB_PORT=8080 -e observer_sys_password=f0455d5edb4833fa2e91762e71b61bc35d45cf0b -e observer_sys_password1=ee0e5138c912aed80b683c05303684be347ce81d -v /u01/oceanbase/log:/home/admin/logs --net=host --restart on-failure:5 reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp2 2023-07-15 14:21:51 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:21:56 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:01 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:06 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:11 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:16 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:21 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:26 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:31 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:36 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:41 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:46 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:51 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:22:56 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:01 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:06 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:11 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:16 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:21 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:26 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:31 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:36 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:41 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:46 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:51 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:23:56 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:01 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:06 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:11 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:16 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:21 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:26 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:31 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:36 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:41 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:46 - INFO - 12 - [ocp_check.py:23] - query ocp to check... 2023-07-15 14:24:51 - INFO - 12 - [ocp_check.py:35] - ocp still not ok, check failed