[root@oceanbase_ocp ocp-3.3.0-ce-bp1-x86_64]# ./ocp_installer.sh install -c config.yaml -k /root/.ssh/id_rsa -i ./ocp-installer.tar.gz -o ./ocp.tar.gz
install start
check docker on host
load installer docker image
Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.
Getting image source signatures
Copying blob be5fb02e6df2 skipped: already exists  
Copying blob 998d7efb3ee5 skipped: already exists  
Copying blob 3c6ca5b84fcd skipped: already exists  
Copying blob a9988590ee00 skipped: already exists  
Copying blob 370d3d972549 skipped: already exists  
Copying blob 327da332d3b8 skipped: already exists  
Copying blob 457113e28038 skipped: already exists  
Copying blob 40cf5b9db208 skipped: already exists  
Copying blob 174f56854903 skipped: already exists  
Copying blob f3cb6fc838d4 skipped: already exists  
Copying blob 2f88c3101f69 skipped: already exists  
Copying blob 20d17932af47 skipped: already exists  
Copying blob 49e5fe4bfefc skipped: already exists  
Copying blob e8e34e7f75b8 skipped: already exists  
Copying blob b8a6a67f9da6 skipped: already exists  
Copying blob 4a8a83df278d skipped: already exists  
Copying blob a351fb77e417 skipped: already exists  
Copying blob 9fb29d90a224 skipped: already exists  
Copying blob e533153cd3d7 skipped: already exists  
Copying blob d43f9f34b3b5 skipped: already exists  
Copying blob 09e61b8eb146 skipped: already exists  
Copying blob a58af37f2db6 skipped: already exists  
Copying blob ae9d163f3cff skipped: already exists  
Copying blob 05aa66bc91ce skipped: already exists  
Copying blob f927693e48ba skipped: already exists  
Copying blob 5e17f725c151 skipped: already exists  
Copying blob 3e0a7c2f34e7 skipped: already exists  
Copying blob 66c47857d7bc skipped: already exists  
Copying blob 9a746bfbc839 skipped: already exists  
Copying blob e7dee81c2afd skipped: already exists  
Copying blob b6fc164e739b skipped: already exists  
Copying blob 54728381e290 skipped: already exists  
Copying blob 266a1735634c skipped: already exists  
Copying blob c49b97cf9ea7 skipped: already exists  
Copying blob 9398ba1740c5 skipped: already exists  
Copying blob f580ecbfdb60 skipped: already exists  
Copying blob 14771117ff37 skipped: already exists  
Copying blob 610545845209 skipped: already exists  
Copying blob e61c6ab43de9 skipped: already exists  
Copying blob 626e477da5c3 skipped: already exists  
Copying config 4416b5374d done  
Writing manifest to image destination
Storing signatures
Loaded image: reg.docker.alibaba-inc.com/ocp2/ocp-installer:3.3.0-x86_64
make log dir
make obd dir
Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.
2022-10-12 13:18:11 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-d37fdd4e-ab9b-40c3-8c24-3923122951ce.sh -m ob
2022-10-12 13:18:12 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host xx.xx.xx.24 failed
2022-10-12 13:18:12 - INFO - 1 - [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: 68 GB > 64 GB ... PASS 
check linux version: Anolis OS release 8.6 ... EXPECT release 7.x ... WARN 
TIPS: OS is not standard RedHat release, if it is compatible with RHEL 7.x, you can ignore this warnning
check SELinux status: Disabled ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 


### SUMMARY OF ISSUES IN PRE-CHECK ###
check linux version: Anolis OS release 8.6 ... EXPECT release 7.x ... WARN 
TIPS: OS is not standard RedHat release, if it is compatible with RHEL 7.x, you can ignore this warnning
, 
2022-10-12 13:18:12 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-10-12 13:18:12 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-10-12 13:18:12 - INFO - 1 - [ob_install.py:95] - deploy task with config:obproxy-ce:
  depends:
  - oceanbase-ce
  global:
    home_path: /home/admin/obproxy
    listen_port: 2883
  servers:
  - xx.xx.xx.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /redo
    root_password: ZAQ!xsw2
    rpc_port: 2882
  server1:
    zone: zone1
  servers:
  - ip: xx.xx.xx.24
    name: server1
user:
  key_file: /root/keys/id_rsa
  password: ZAQ!xsw2
  port: 22
  timeout: 60
  username: root

2022-10-12 13:18:12 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-10-12 13:20:09 - INFO - 1 - [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
2022-10-12 13:20:26 - INFO - 1 - [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
2022-10-12 13:20:41 - INFO - 1 - [ob_install.py:124] - create meta user
2022-10-12 13:20:41 - INFO - 1 - [ob_install.py:126] - grant privilege to meta user
2022-10-12 13:20:42 - INFO - 1 - [ob_install.py:128] - set meta user password
2022-10-12 13:20:42 - INFO - 1 - [ob_install.py:137] - create monitor user
2022-10-12 13:20:42 - INFO - 1 - [ob_install.py:139] - grant privilege to monitor user
2022-10-12 13:20:42 - INFO - 1 - [ob_install.py:141] - set monitor user password
2022-10-12 13:20:43 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-449a8613-4a43-4d1e-a268-f1ecb7010458.sh -m ocp
2022-10-12 13:20:43 - INFO - 1 - [ocp_precheck.py:29] - precheck for ocp on host xx.xx.xx.24 failed
2022-10-12 13:20:43 - INFO - 1 - [ocp_precheck.py:32] - ocp precheck result: Machine Role: ocp 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 8 > 8 ... PASS 
check total MEM: 68 GB > 32 GB ... PASS 
check linux version: Anolis OS release 8.6 ... EXPECT release 7.x ... WARN 
TIPS: OS is not standard RedHat release, if it is compatible with RHEL 7.x, you can ignore this warnning
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: 4.1.1 ... PASS 


### SUMMARY OF ISSUES IN PRE-CHECK ###
check linux version: Anolis OS release 8.6 ... EXPECT release 7.x ... WARN 
TIPS: OS is not standard RedHat release, if it is compatible with RHEL 7.x, you can ignore this warnning
, Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.

2022-10-12 13:20:44 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.

2022-10-12 13:20:44 - INFO - 1 - [image_load.py:23] - image reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1 already loaded
2022-10-12 13:20:44 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': True, 'create_metadb_cluster': True, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'ZAQ!xsw2', 'data_path': '/data', 'redo_path': '/redo', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['xx.xx.xx.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'ZAQ!xsw2', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'ZAQ!xsw2', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['xx.xx.xx.24'], 'vip': {'address': 'xx.xx.xx.24', 'port': 2883}}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'pubkey', 'timeout': 60, 'password': 'ZAQ!xsw2', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/home/admin/ocp/log'}, 'servers': ['xx.xx.xx.24'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'ZAQ!xsw2'}, 'metadb': {'host': 'xx.xx.xx.24', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'ZAQ!xsw2', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'ZAQ!xsw2', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': 'xx.xx.xx.24', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-10-12 13:20:44 - INFO - 1 - [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-bp1 create_metadb.py xx.xx.xx.24 2883 meta_user@meta_tenant#obcluster ZAQ!xsw2 meta_database monitor_user@monitor_tenant#obcluster ZAQ!xsw2 monitor_database on host: xx.xx.xx.24
2022-10-12 13:46:15 - INFO - 1 - [metadb_init.py:39] - run init metadb script got result: Generated yml file: 

OcpInitParameter:
  METADB:
    ip: &metadb_ip xx.xx.xx.24
    username: &metadb_username meta_user@meta_tenant#obcluster
    password: &metadb_password 'ZAQ!xsw2'
    port: &metadb_port 2883
    dbname: &metadb_dbname meta_database
  MONITORDB:
    ip: &monitordb_ip xx.xx.xx.24
    username: &monitordb_username monitor_user@monitor_tenant#obcluster
    password: &monitordb_password 'ZAQ!xsw2'
    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
[2022-10-12 13:27:37] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:28:16] 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
[2022-10-12 13:29:16] 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
[2022-10-12 13:45:17] 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
[2022-10-12 13:45:21] 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 backup2230
loading sql script: backup_metadb_init.sql
loading sql script: restore_metadb_init.sql
end create backup2230
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
end create backup databases
, Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.
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"

2022-10-12 13:46:15 - INFO - 1 - [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-bp1 -hxx.xx.xx.24 -P2883 -umeta_user@meta_tenant#obcluster -pZAQ!xsw2 -Dmeta_database -e"update config_properties set value='http://xx.xx.xx.24:8080' where \`key\` = 'ocp.site.url';"
2022-10-12 13:46:17 - INFO - 1 - [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-bp1 -hxx.xx.xx.24 -P2883 -umeta_user@meta_tenant#obcluster -pZAQ!xsw2 -Dmeta_database -e"update config_properties set value='8080' where \`key\` = 'server.port';"
2022-10-12 13:46:18 - INFO - 1 - [ocp_start.py:38] - prepare log dir on server: xx.xx.xx.24 with command: sudo mkdir -p /home/admin/ocp/log/{ocp,obproxy/log,obproxy/minidump,obproxy/etc} && sudo chown -R 500:500 /home/admin/ocp/log
2022-10-12 13:46:19 - INFO - 1 - [ocp_start.py:42] - start ocp docker on server: xx.xx.xx.24 with command: sudo docker run -d --name ocp --cpu-period 100000 --cpu-quota 400000 --memory=8G -e OCP_METADB_HOST=xx.xx.xx.24 -e OCP_METADB_PORT=2883 -e OCP_METADB_USER=meta_user@meta_tenant#obcluster -e OCP_METADB_PASSWORD='ZAQ!xsw2' -e OCP_METADB_DBNAME=meta_database -e OB_PORT=8080 -e observer_sys_password=f0455d5edb4833fa2e91762e71b61bc35d45cf0b -e observer_sys_password1=ee0e5138c912aed80b683c05303684be347ce81d -v /home/admin/ocp/log:/home/admin/logs --net=host --restart on-failure:5 reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1
2022-10-12 13:46:19 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:20 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:25 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:25 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:30 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:30 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:35 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:35 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:40 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:40 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:45 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:45 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:50 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:50 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:46:55 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:46:55 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:00 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:00 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:05 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:05 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:10 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:10 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:15 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:15 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:20 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:20 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:25 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:25 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:30 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:30 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:35 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:35 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:40 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:40 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:45 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:45 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:50 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:50 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:47:55 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:47:55 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:00 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:00 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:05 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:05 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:10 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:10 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:15 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:15 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:20 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:20 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:25 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:25 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:30 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:30 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:35 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:35 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:40 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:40 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:45 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:45 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:50 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:50 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:48:55 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:48:55 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:49:00 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:49:00 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:49:05 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:49:05 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:49:10 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:49:10 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:49:15 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-10-12 13:49:15 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-10-12 13:49:20 - INFO - 1 - [ocp_check.py:35] - ocp still not ok, check failed
Traceback (most recent call last):
  File "install_ocp.py", line 43, in <module>
    run(context)
  File "install_ocp.py", line 33, in run
    install_ocp_pipeline.run()
  File "/root/installer/pipeline.py", line 10, in run
    task.run()
  File "/root/installer/task/ocp_check.py", line 36, in run
    raise Exception("ocp still not ok, check failed")
Exception: ocp still not ok, check failed