2022-08-30 14:44:43 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-a12b33ce-29f0-403f-8f60-08b587791401.sh -m ocp
2022-08-30 14:44:43 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 14:44: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: 40 > 8 ... PASS 
check total MEM: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 14:44:43 - INFO - 1 - [image_load.py:21] - check image got result: 0  
2022-08-30 14:47:51 - INFO - 1 - [image_load.py:31] - load image got result: 0  
2022-08-30 14:47:51 - INFO - 1 - [image_load.py:36] - load image successful
2022-08-30 14:47:51 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '1.1.1.1', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123!@', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123!@', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 14:47:51 - 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 1.1.1.1 2883 meta_user@meta_tenant#obcluster obd123!@ meta_database monitor_user@monitor_tenant#obcluster obd123!@ monitor_database on host: 200.168.201.21
2022-08-30 14:50:32 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-48732635-2f60-4c93-b177-14f496e0024f.sh -m ocp
2022-08-30 14:50:32 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 14:50:32 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 14:50:32 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-30 14:50:32 - 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-08-30 14:50:32 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.21', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123!@', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123!@', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 14:50:32 - 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 200.168.201.21 2883 meta_user@meta_tenant#obcluster obd123!@ meta_database monitor_user@monitor_tenant#obcluster obd123!@ monitor_database on host: 200.168.201.21
2022-08-30 14:52:15 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-278fba5c-a13a-47d1-8710-e68e46d9c475.sh -m ocp
2022-08-30 14:52:16 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 14:52:16 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 14:52:16 - INFO - 1 - [image_load.py:21] - check image got result: 0  
2022-08-30 14:55:18 - INFO - 1 - [image_load.py:31] - load image got result: 0  
2022-08-30 14:55:18 - INFO - 1 - [image_load.py:36] - load image successful
2022-08-30 14:55:18 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.21', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123!@', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123!@', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 14:55:18 - 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 200.168.201.21 2883 meta_user@meta_tenant#obcluster obd123!@ meta_database monitor_user@monitor_tenant#obcluster obd123!@ monitor_database on host: 200.168.201.21
2022-08-30 15:01:03 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-673a3940-b242-4903-bb9e-c836875206fa.sh -m ocp
2022-08-30 15:01:03 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 15:01:03 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 15:01:03 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-30 15:01:03 - 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-08-30 15:01:03 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.21', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 15:01:03 - 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 200.168.201.21 2883 meta_user@meta_tenant#obcluster obd123 meta_database monitor_user@monitor_tenant#obcluster obd123 monitor_database on host: 200.168.201.21
2022-08-30 15:04:08 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-cae924d2-2b62-4895-8527-e271afea0309.sh -m ocp
2022-08-30 15:04:08 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 15:04:08 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 15:04:08 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-30 15:04:08 - 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-08-30 15:04:08 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.21', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 15:04:08 - 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 200.168.201.21 2883 meta_user@meta_tenant#obcluster obd123 meta_database monitor_user@monitor_tenant#obcluster obd123 monitor_database on host: 200.168.201.21
2022-08-30 15:26:25 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-d09fe7b1-44a6-43a7-a2db-336744fb26ed.sh -m ocp
2022-08-30 15:26:25 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 15:26:25 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 15:26:26 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-30 15:26:26 - 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-08-30 15:26:26 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.21', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 15:26:26 - 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 200.168.201.21 2883 meta_user@meta_tenant#obcluster obd123 meta_database monitor_user@monitor_tenant#obcluster obd123 monitor_database on host: 200.168.201.21
2022-08-30 16:19:27 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-c2f4181f-e89b-41c4-a9a7-6771da55bda0.sh -m ob
2022-08-30 16:19:29 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:19:29 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:19:29 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-c8c555ac-75f3-4243-868c-2a5fc6b88d47.sh -m ob
2022-08-30 16:19:30 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:19:30 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:19:30 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-5810e82e-6e0d-4508-a1b9-8f38d019dd0f.sh -m ob
2022-08-30 16:19:31 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host 200.168.201.24 failed
2022-08-30 16:19:31 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Enforcing ... EXPECT Disabled ... FAIL 
TIPS: disable SELinux
  sed -i 's/enforcing/disabled/g' /etc/selinux/config
  /usr/sbin/setenforce 0
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 SELinux status: Enforcing ... EXPECT Disabled ... FAIL 
TIPS: disable SELinux
  sed -i 's/enforcing/disabled/g' /etc/selinux/config
  /usr/sbin/setenforce 0
, 
2022-08-30 16:22:42 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-b43d07cc-9913-4fe3-b53f-5130464235fa.sh -m ob
2022-08-30 16:22:43 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:22:43 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:22:43 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-a7e90bb8-d2df-4c9e-bce4-81b0645d0b7c.sh -m ob
2022-08-30 16:22:43 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:22:43 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:22:44 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-23629af2-eda4-4f9a-9dc9-9a30cbec49c8.sh -m ob
2022-08-30 16:22:44 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host 200.168.201.24 failed
2022-08-30 16:22:44 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Enforcing ... EXPECT Disabled ... FAIL 
TIPS: disable SELinux
  sed -i 's/enforcing/disabled/g' /etc/selinux/config
  /usr/sbin/setenforce 0
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 SELinux status: Enforcing ... EXPECT Disabled ... FAIL 
TIPS: disable SELinux
  sed -i 's/enforcing/disabled/g' /etc/selinux/config
  /usr/sbin/setenforce 0
, 
2022-08-30 16:23:37 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-d4b8e9f1-9ff1-4125-9f27-e8589d5aa33d.sh -m ob
2022-08-30 16:23:37 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:23:37 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:23:37 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-bb217d6b-f19a-4251-8dbe-160747bf688b.sh -m ob
2022-08-30 16:23:37 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:23:37 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:23:38 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-3c4209c9-3cd2-488c-a2f1-df24f16314a5.sh -m ob
2022-08-30 16:23:38 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host 200.168.201.24 failed
2022-08-30 16:23:38 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Enforcing ... EXPECT Disabled ... FAIL 
TIPS: disable SELinux
  sed -i 's/enforcing/disabled/g' /etc/selinux/config
  /usr/sbin/setenforce 0
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 SELinux status: Enforcing ... EXPECT Disabled ... FAIL 
TIPS: disable SELinux
  sed -i 's/enforcing/disabled/g' /etc/selinux/config
  /usr/sbin/setenforce 0
, 
2022-08-30 16:26:55 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-e0f3423a-fd3d-4527-a9c7-f06d50e92783.sh -m ob
2022-08-30 16:26:55 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:26:55 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:26:55 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-8c921a5c-a591-446a-9ce5-9acd5ee8451c.sh -m ob
2022-08-30 16:26:55 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:26:55 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:26:56 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-e0947f57-7b2e-47f3-bab8-b561ab24ef7e.sh -m ob
2022-08-30 16:26:56 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-30 16:26:56 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:26:56 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-30 16:26:56 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-30 16:26:56 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-30 16:26:56 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-30 16:28:20 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check !!
[WARN] server1(200.168.201.22) oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 require: libmariadb.so.3
[WARN] server2(200.168.201.23) oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 require: libmariadb.so.3
[WARN] server3(200.168.201.24) oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 require: libmariadb.so.3

Try to get lib-repository
Package oceanbase-ce-libs-3.1.4 is available.
install oceanbase-ce-libs-3.1.4 for local ok
Use oceanbase-ce-libs-3.1.4-6d5437b0cad486b55963f89b8ef3769af7995350 for oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6
Remote oceanbase-ce-libs-3.1.4-6d5437b0cad486b55963f89b8ef3769af7995350 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home ok
obcluster deployed
Get local repositories and plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start obproxy ok
Check before start observer x
[WARN] (200.168.201.22) clog and data use the same disk (/)
[WARN] (200.168.201.23) clog and data use the same disk (/)
[WARN] (200.168.201.24) clog and data use the same disk (/)
[ERROR] 200.168.201.22 has more than one network inferface. Please set `devname` for (200.168.201.22)
[ERROR] 200.168.201.23 has more than one network inferface. Please set `devname` for (200.168.201.23)
[ERROR] 200.168.201.24 has more than one network inferface. Please set `devname` for (200.168.201.24)

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .
























, 
2022-08-30 16:29:58 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-d0a5b9b1-43ad-48d5-9828-0c2c2f20ee3e.sh -m ob
2022-08-30 16:29:58 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:29:58 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:29:59 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-e6153cc9-1687-4dbf-a525-7b0e11fe6f0a.sh -m ob
2022-08-30 16:29:59 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:29:59 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:29:59 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-9636e117-9aa6-4f9c-8d7e-5a177d570094.sh -m ob
2022-08-30 16:30:00 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-30 16:30:00 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:30:00 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-30 16:30:00 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-30 16:30:00 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-30 16:30:00 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-30 16:30:32 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home x
[ERROR] OBD-1002: Fail to init server1(200.168.201.22) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server2(200.168.201.23) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server3(200.168.201.24) home path: /home/admin/oceanbase is not empty.

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .
















, 
2022-08-30 16:32:45 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-9b42dab5-0afe-4e5e-ab1c-60011283c195.sh -m ob
2022-08-30 16:32:45 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:32:45 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:32:46 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-7709470b-1e68-479e-9582-4a1cb746c049.sh -m ob
2022-08-30 16:32:46 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:32:46 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:32:46 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-a1bc4f8b-0ab5-4bf5-b35c-80b3eeb0426b.sh -m ob
2022-08-30 16:32:47 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-30 16:32:47 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:32:47 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-30 16:32:47 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-30 16:32:47 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-30 16:32:47 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-30 16:33:20 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home x
[ERROR] OBD-1002: Fail to init server1(200.168.201.22) data dir: /data/1 is not empty.
[ERROR] OBD-1002: Fail to init server2(200.168.201.23) data dir: /data/1 is not empty.
[ERROR] OBD-1002: Fail to init server3(200.168.201.24) data dir: /data/1 is not empty.

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .
















, 
2022-08-30 16:37:23 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-9fa15afd-46ba-4ae5-a4d7-e91ef3746dbb.sh -m ob
2022-08-30 16:37:23 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:37:23 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:37:23 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-34c5c031-5c96-40d8-8dbb-0f748186f4a4.sh -m ob
2022-08-30 16:37:24 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:37:24 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:37:24 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-d3f9cba4-2b63-4728-913f-5d0b001296de.sh -m ob
2022-08-30 16:37:24 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-30 16:37:24 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:37:24 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-30 16:37:24 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-30 16:37:24 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-30 16:37:24 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-30 16:38:05 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home ok
obcluster deployed
Get local repositories and plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start obproxy ok
Check before start observer x
[WARN] (200.168.201.22) clog and data use the same disk (/)
[WARN] (200.168.201.23) clog and data use the same disk (/)
[WARN] (200.168.201.24) clog and data use the same disk (/)
[ERROR] 200.168.201.22 has more than one network inferface. Please set `devname` for (200.168.201.22)
[ERROR] 200.168.201.23 has more than one network inferface. Please set `devname` for (200.168.201.23)
[ERROR] 200.168.201.24 has more than one network inferface. Please set `devname` for (200.168.201.24)

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .





















, 
2022-08-30 16:40:15 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-9eaaeecf-ce1e-482b-ab2e-cee9e0710c9a.sh -m ob
2022-08-30 16:40:15 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:40:15 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:40:16 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-08f4e112-d11c-48a4-8a3e-c327f755a7ec.sh -m ob
2022-08-30 16:40:16 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:40:16 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:40:16 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-9cd510bf-38f0-4da2-9e7d-4e94c9b04769.sh -m ob
2022-08-30 16:40:17 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-30 16:40:17 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:40:17 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-30 16:40:17 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-30 16:40:17 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-30 16:40:17 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-30 16:40:49 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home x
[ERROR] OBD-1002: Fail to init server1(200.168.201.22) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server2(200.168.201.23) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server3(200.168.201.24) home path: /home/admin/oceanbase is not empty.

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .
















, 
2022-08-30 16:43:55 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-d184d6de-085f-4164-b514-b686e96b7a8f.sh -m ob
2022-08-30 16:43:55 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-30 16:43:55 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:43:56 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-7b3b969f-23a1-4dee-a617-62c63d5e9412.sh -m ob
2022-08-30 16:43:56 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-30 16:43:56 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:43:56 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-ebbecb53-afb7-421a-a754-84ad96798ddd.sh -m ob
2022-08-30 16:43:57 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-30 16:43:57 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-30 16:43:57 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-30 16:43:57 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-30 16:43:57 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    devname: ens3f1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-30 16:43:57 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-30 16:45:06 - 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-08-30 16:45:13 - 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-08-30 16:45:18 - INFO - 1 - [ob_install.py:124] - create meta user
2022-08-30 16:45:19 - INFO - 1 - [ob_install.py:126] - grant privilege to meta user
2022-08-30 16:45:19 - INFO - 1 - [ob_install.py:128] - set meta user password
2022-08-30 16:45:19 - INFO - 1 - [ob_install.py:137] - create monitor user
2022-08-30 16:45:19 - INFO - 1 - [ob_install.py:139] - grant privilege to monitor user
2022-08-30 16:45:19 - INFO - 1 - [ob_install.py:141] - set monitor user password
2022-08-30 16:45:19 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-0451ec41-7408-477d-9cb8-cbc6d3ac5d64.sh -m ocp
2022-08-30 16:45:20 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-30 16:45:20 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-30 16:45:20 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-30 16:45:20 - 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-08-30 16:45:20 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': True, 'clean_metadb_cluster': True, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'custom_config': [{'key': 'devname', 'value': 'ens3f1'}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24'], 'vip': {'address': '200.168.201.22', 'port': 2883}}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.22', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123!@', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123!@', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-30 16:45:20 - 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 200.168.201.22 2883 meta_user@meta_tenant#obcluster obd123!@ meta_database monitor_user@monitor_tenant#obcluster obd123!@ monitor_database on host: 200.168.201.21
2022-08-30 16:56:10 - INFO - 1 - [metadb_init.py:39] - run init metadb script got result: Generated yml file: 

OcpInitParameter:
  METADB:
    ip: &metadb_ip 200.168.201.22
    username: &metadb_username meta_user@meta_tenant#obcluster
    password: &metadb_password 'obd123!@'
    port: &metadb_port 2883
    dbname: &metadb_dbname meta_database
  MONITORDB:
    ip: &monitordb_ip 200.168.201.22
    username: &monitordb_username monitor_user@monitor_tenant#obcluster
    password: &monitordb_password 'obd123!@'
    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-08-30 16:47:03] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47:21] 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-08-30 16:47: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
[2022-08-30 16:55:48] 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-08-30 16:55:49] 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"

2022-08-30 16:56:10 - 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 -h200.168.201.22 -P2883 -umeta_user@meta_tenant#obcluster -pobd123!@ -Dmeta_database -e"update config_properties set value='http://200.168.201.21:8080' where \`key\` = 'ocp.site.url';"
2022-08-30 16:56:11 - 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 -h200.168.201.22 -P2883 -umeta_user@meta_tenant#obcluster -pobd123!@ -Dmeta_database -e"update config_properties set value='8080' where \`key\` = 'server.port';"
2022-08-30 16:56:11 - INFO - 1 - [ocp_start.py:38] - prepare log dir on server: 200.168.201.21 with command: sudo mkdir -p /tmp/ocp/log/{ocp,obproxy/log,obproxy/minidump,obproxy/etc} && sudo chown -R 500:500 /tmp/ocp/log
2022-08-30 16:56:12 - INFO - 1 - [ocp_start.py:42] - start ocp docker on server: 200.168.201.21 with command: sudo docker run -d --name ocp --cpu-period 100000 --cpu-quota 400000 --memory=8G -e OCP_METADB_HOST=200.168.201.22 -e OCP_METADB_PORT=2883 -e OCP_METADB_USER=meta_user@meta_tenant#obcluster -e OCP_METADB_PASSWORD='obd123!@' -e OCP_METADB_DBNAME=meta_database -e OB_PORT=8080 -e observer_sys_password=f0455d5edb4833fa2e91762e71b61bc35d45cf0b -e observer_sys_password1=ee0e5138c912aed80b683c05303684be347ce81d -v /tmp/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-08-30 16:56:12 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:12 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:17 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:17 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:22 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:22 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:27 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:27 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:32 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:32 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:37 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:37 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:42 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:42 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:47 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:47 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:52 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:52 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:56:57 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:56:57 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:02 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:02 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:07 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:07 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:12 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:12 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:17 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:17 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:22 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:22 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:27 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:27 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:32 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:32 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:37 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:37 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:42 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:42 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:47 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:47 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:52 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:52 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:57:57 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:57:57 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:58:02 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:58:02 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:58:07 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:58:07 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-30 16:58:12 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-30 16:58:13 - INFO - 1 - [ocp_check.py:33] - check ocp server status ok
2022-08-30 16:58:22 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:28 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:33 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:38 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:43 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:48 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:54 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:58:59 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:59:04 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-30 16:59:09 - INFO - 1 - [proxyro_password_modify.py:41] - task finished with status: SUCCESSFUL
2022-08-31 11:55:03 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-f802b194-ce94-4527-80f6-131ca9900be8.sh -m ob
2022-08-31 11:55:03 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-31 11:55:03 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 11:55:04 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-f4483a90-c78b-4f7d-95c0-0b8f967b79f5.sh -m ob
2022-08-31 11:55:04 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-31 11:55:04 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-31 11:55:04 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-6423204b-be02-47e4-89c2-8998991452c9.sh -m ob
2022-08-31 11:55:05 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-31 11:55:05 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 11:55:05 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-31 11:55:05 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-31 11:55:05 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    devname: ens3f1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-31 11:55:05 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-31 11:55:25 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home x
[ERROR] OBD-1002: Fail to init server1(200.168.201.22) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server2(200.168.201.23) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server3(200.168.201.24) home path: /home/admin/oceanbase is not empty.

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .
















, 
2022-08-31 11:58:54 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-225d0577-f41f-4669-927e-bc9d70e39eea.sh -m ob
2022-08-31 11:58:55 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-31 11:58:55 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 11:58:55 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-b452c3a5-7747-4c05-a72a-d629caa28652.sh -m ob
2022-08-31 11:58:55 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-31 11:58:55 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-31 11:58:56 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-cbe1222e-1fb2-4aea-bd8d-ceabbf781f80.sh -m ob
2022-08-31 11:58:56 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-31 11:58:56 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 11:58:56 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-31 11:58:56 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-31 11:58:56 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    devname: ens3f1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-31 11:58:56 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-31 12:00:08 - 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-08-31 12:00:16 - 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-08-31 12:00:20 - INFO - 1 - [ob_install.py:124] - create meta user
2022-08-31 12:00:21 - INFO - 1 - [ob_install.py:126] - grant privilege to meta user
2022-08-31 12:00:21 - INFO - 1 - [ob_install.py:128] - set meta user password
2022-08-31 12:00:21 - INFO - 1 - [ob_install.py:137] - create monitor user
2022-08-31 12:00:21 - INFO - 1 - [ob_install.py:139] - grant privilege to monitor user
2022-08-31 12:00:21 - INFO - 1 - [ob_install.py:141] - set monitor user password
2022-08-31 12:00:21 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-168cfded-04fe-47cb-8c1a-cbeb4b8e1af8.sh -m ocp
2022-08-31 12:00:22 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-31 12:00:22 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-31 12:00:22 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-31 12:00:22 - 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-08-31 12:00:22 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': True, 'clean_metadb_cluster': True, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'custom_config': [{'key': 'devname', 'value': 'ens3f1'}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24'], 'vip': {'address': '200.168.201.22', 'port': 2883}}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.22', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123!@', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123!@', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-31 12:00:22 - 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 200.168.201.22 2883 meta_user@meta_tenant#obcluster obd123!@ meta_database monitor_user@monitor_tenant#obcluster obd123!@ monitor_database on host: 200.168.201.21
2022-08-31 12:11:17 - INFO - 1 - [metadb_init.py:39] - run init metadb script got result: Generated yml file: 

OcpInitParameter:
  METADB:
    ip: &metadb_ip 200.168.201.22
    username: &metadb_username meta_user@meta_tenant#obcluster
    password: &metadb_password 'obd123!@'
    port: &metadb_port 2883
    dbname: &metadb_dbname meta_database
  MONITORDB:
    ip: &monitordb_ip 200.168.201.22
    username: &monitordb_username monitor_user@monitor_tenant#obcluster
    password: &monitordb_password 'obd123!@'
    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-08-31 12:02:07] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:25] 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-08-31 12:02:54] 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-08-31 12:10:54] 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-08-31 12:10:55] 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"

2022-08-31 12:11:17 - 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 -h200.168.201.22 -P2883 -umeta_user@meta_tenant#obcluster -pobd123!@ -Dmeta_database -e"update config_properties set value='http://200.168.201.21:8080' where \`key\` = 'ocp.site.url';"
2022-08-31 12:11: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 -h200.168.201.22 -P2883 -umeta_user@meta_tenant#obcluster -pobd123!@ -Dmeta_database -e"update config_properties set value='8080' where \`key\` = 'server.port';"
2022-08-31 12:11:18 - INFO - 1 - [ocp_start.py:38] - prepare log dir on server: 200.168.201.21 with command: sudo mkdir -p /tmp/ocp/log/{ocp,obproxy/log,obproxy/minidump,obproxy/etc} && sudo chown -R 500:500 /tmp/ocp/log
2022-08-31 12:11:18 - INFO - 1 - [ocp_start.py:42] - start ocp docker on server: 200.168.201.21 with command: sudo docker run -d --name ocp --cpu-period 100000 --cpu-quota 400000 --memory=8G -e OCP_METADB_HOST=200.168.201.22 -e OCP_METADB_PORT=2883 -e OCP_METADB_USER=meta_user@meta_tenant#obcluster -e OCP_METADB_PASSWORD='obd123!@' -e OCP_METADB_DBNAME=meta_database -e OB_PORT=8080 -e observer_sys_password=f0455d5edb4833fa2e91762e71b61bc35d45cf0b -e observer_sys_password1=ee0e5138c912aed80b683c05303684be347ce81d -v /tmp/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-08-31 12:11:19 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:19 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:24 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:24 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:29 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:29 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:34 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:34 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:39 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:39 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:44 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:44 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:49 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:49 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:54 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:54 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:11:59 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:11:59 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:04 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:04 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:09 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:09 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:14 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:14 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:19 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:19 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:24 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:24 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:29 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:29 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:34 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:34 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:39 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:39 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:44 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:44 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:49 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:49 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:54 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:54 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:12:59 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:12:59 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:13:04 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:13:04 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:13:09 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:13:09 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:13:14 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:13:14 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:13:19 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:13:19 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:13:24 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:13:24 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 12:13:29 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 12:13:29 - INFO - 1 - [ocp_check.py:33] - check ocp server status ok
2022-08-31 12:13:37 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:13:42 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:13:47 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:13:53 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:13:58 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:14:03 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:14:08 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:14:13 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:14:19 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 12:14:24 - INFO - 1 - [proxyro_password_modify.py:41] - task finished with status: SUCCESSFUL
2022-08-31 14:14:22 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-f7393f47-65b0-4a9d-8b88-1c495ea0720a.sh -m ob
2022-08-31 14:14:23 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-31 14:14:23 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 14:14:23 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-c39e7063-078a-4155-a426-77fbb2aadd73.sh -m ob
2022-08-31 14:14:23 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-31 14:14:23 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-31 14:14:24 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-d39ca85e-5079-46cc-8ea8-802d74b46ff6.sh -m ob
2022-08-31 14:14:24 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-31 14:14:24 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 14:14:24 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-31 14:14:24 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-31 14:14:24 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    devname: ens3f1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-31 14:14:24 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-31 14:14:45 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3 is available.
Package oceanbase-ce-3.1.4 is available.
install obproxy-ce-3.2.3 for local ok
install oceanbase-ce-3.1.4 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate observer configuration ok
obproxy-ce-3.2.3 already installed.
oceanbase-ce-3.1.4 already installed.
+-------------------------------------------------------------------------------------------+
|                                          Packages                                         |
+--------------+---------+-----------------------+------------------------------------------+
| Repository   | Version | Release               | Md5                                      |
+--------------+---------+-----------------------+------------------------------------------+
| obproxy-ce   | 3.2.3   | 2.el7                 | bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 |
| oceanbase-ce | 3.1.4   | 10000092022071511.el7 | c5cd94f4f190317b6a883c58a26460a506205ce6 |
+--------------+---------+-----------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Open ssh connection ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository install ok
Remote obproxy-ce-3.2.3-bdd299bda2bdf71fd0fd3f155b6a2e39dffd2be1 repository lib check ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository install ok
Remote oceanbase-ce-3.1.4-c5cd94f4f190317b6a883c58a26460a506205ce6 repository lib check ok
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home x
[ERROR] OBD-1002: Fail to init server1(200.168.201.22) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server2(200.168.201.23) home path: /home/admin/oceanbase is not empty.
[ERROR] OBD-1002: Fail to init server3(200.168.201.24) home path: /home/admin/oceanbase is not empty.

See https://open.oceanbase.com/docs/obd-cn/V1.4.0/10000000000436999 .
















, 
2022-08-31 14:16:06 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-006b1f9e-225f-4cce-9d4d-2e754c91e6d4.sh -m ob
2022-08-31 14:16:06 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.22 success
2022-08-31 14:16:06 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 14:16:07 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-8e46ea17-25d5-4cc5-9956-4e2bb21aa4f4.sh -m ob
2022-08-31 14:16:07 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.23 success
2022-08-31 14:16:07 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-31 14:16:07 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-bcf14aed-bb3f-42a2-ab19-4d72817fb816.sh -m ob
2022-08-31 14:16:08 - INFO - 1 - [ob_precheck.py:34] - precheck for ocp on host 200.168.201.24 success
2022-08-31 14:16:08 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: Machine Role: ob 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 40 > 8 ... PASS 
check total MEM: 125 GB > 64 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (Core) ... PASS 
check SELinux status: Permissive, selinux=disabled is in /etc/selinux/config ... PASS 
check account [admin] and home dir, exist ... PASS 
check service [firewalld]: inactive ... PASS 
check service [firewalld]: disabled ... PASS 
, 
2022-08-31 14:16:08 - INFO - 1 - [ob_install.py:82] - clean obd dir
2022-08-31 14:16:08 - INFO - 1 - [ob_install.py:91] - install ob using obd
2022-08-31 14:16:08 - 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:
  - 200.168.201.22
  - 200.168.201.23
  - 200.168.201.24
oceanbase-ce:
  global:
    appname: obcluster
    data_dir: /data/1
    devname: ens3f1
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/log1
    root_password: obd123!@
    rpc_port: 2882
  server1:
    zone: zone1
  server2:
    zone: zone2
  server3:
    zone: zone3
  servers:
  - ip: 200.168.201.22
    name: server1
  - ip: 200.168.201.23
    name: server2
  - ip: 200.168.201.24
    name: server3
user:
  key_file: ''
  password: Admin123!@
  port: 22
  timeout: 10
  username: root

2022-08-31 14:16:08 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2022-08-31 14:17:19 - 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-08-31 14:17:28 - 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-08-31 14:17:32 - INFO - 1 - [ob_install.py:124] - create meta user
2022-08-31 14:17:33 - INFO - 1 - [ob_install.py:126] - grant privilege to meta user
2022-08-31 14:17:33 - INFO - 1 - [ob_install.py:128] - set meta user password
2022-08-31 14:17:33 - INFO - 1 - [ob_install.py:137] - create monitor user
2022-08-31 14:17:33 - INFO - 1 - [ob_install.py:139] - grant privilege to monitor user
2022-08-31 14:17:33 - INFO - 1 - [ob_install.py:141] - set monitor user password
2022-08-31 14:17:33 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-f16cacab-f7d0-45ee-916a-9c7a0a5a7b25.sh -m ocp
2022-08-31 14:17:34 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 200.168.201.21 success
2022-08-31 14:17:34 - INFO - 1 - [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: 125 GB > 32 GB ... PASS 
check linux version: CentOS Linux release 7.9.2009 (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 
, 
2022-08-31 14:17:34 - INFO - 1 - [image_load.py:21] - check image got result: 0 5c0bd54ece38
 
2022-08-31 14:17:34 - 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-08-31 14:17:34 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': False, 'create_metadb_cluster': True, 'clean_metadb_cluster': True, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'obd123!@', 'data_path': '/data/1', 'redo_path': '/data/log1', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['200.168.201.22']}, {'name': 'zone2', 'servers': ['200.168.201.23']}, {'name': 'zone3', 'servers': ['200.168.201.24']}], 'custom_config': [{'key': 'devname', 'value': 'ens3f1'}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'obd123!@', 'database': 'meta_database', 'cpu': 2, 'memory': 4}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'obd123!@', 'database': 'monitor_database', 'cpu': 4, 'memory': 8}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['200.168.201.22', '200.168.201.23', '200.168.201.24'], 'vip': {'address': '200.168.201.22', 'port': 2883}}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 10, 'password': 'Admin123!@', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['200.168.201.21'], 'resource': {'cpu': 4, 'memory': 8}, 'auth': {'user': 'admin', 'password': 'obd123!@'}, 'metadb': {'host': '200.168.201.22', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'obd123!@', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'obd123!@', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '200.168.201.21', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:3.3.0-ce-bp1'}, 'operation': 'install'}
2022-08-31 14:17:34 - 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 200.168.201.22 2883 meta_user@meta_tenant#obcluster obd123!@ meta_database monitor_user@monitor_tenant#obcluster obd123!@ monitor_database on host: 200.168.201.21
2022-08-31 14:28:25 - INFO - 1 - [metadb_init.py:39] - run init metadb script got result: Generated yml file: 

OcpInitParameter:
  METADB:
    ip: &metadb_ip 200.168.201.22
    username: &metadb_username meta_user@meta_tenant#obcluster
    password: &metadb_password 'obd123!@'
    port: &metadb_port 2883
    dbname: &metadb_dbname meta_database
  MONITORDB:
    ip: &monitordb_ip 200.168.201.22
    username: &monitordb_username monitor_user@monitor_tenant#obcluster
    password: &monitordb_password 'obd123!@'
    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-08-31 14:19:17] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:34] 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-08-31 14:19:35] 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-08-31 14:19:35] 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-08-31 14:19:35] 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-08-31 14:20:03] 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-08-31 14:28: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
[2022-08-31 14:28:04] 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"

2022-08-31 14:28:25 - 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 -h200.168.201.22 -P2883 -umeta_user@meta_tenant#obcluster -pobd123!@ -Dmeta_database -e"update config_properties set value='http://200.168.201.21:8080' where \`key\` = 'ocp.site.url';"
2022-08-31 14:28:26 - 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 -h200.168.201.22 -P2883 -umeta_user@meta_tenant#obcluster -pobd123!@ -Dmeta_database -e"update config_properties set value='8080' where \`key\` = 'server.port';"
2022-08-31 14:28:27 - INFO - 1 - [ocp_start.py:38] - prepare log dir on server: 200.168.201.21 with command: sudo mkdir -p /tmp/ocp/log/{ocp,obproxy/log,obproxy/minidump,obproxy/etc} && sudo chown -R 500:500 /tmp/ocp/log
2022-08-31 14:28:27 - INFO - 1 - [ocp_start.py:42] - start ocp docker on server: 200.168.201.21 with command: sudo docker run -d --name ocp --cpu-period 100000 --cpu-quota 400000 --memory=8G -e OCP_METADB_HOST=200.168.201.22 -e OCP_METADB_PORT=2883 -e OCP_METADB_USER=meta_user@meta_tenant#obcluster -e OCP_METADB_PASSWORD='obd123!@' -e OCP_METADB_DBNAME=meta_database -e OB_PORT=8080 -e observer_sys_password=f0455d5edb4833fa2e91762e71b61bc35d45cf0b -e observer_sys_password1=ee0e5138c912aed80b683c05303684be347ce81d -v /tmp/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-08-31 14:28:27 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:27 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:28:32 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:32 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:28:37 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:37 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:28:42 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:42 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:28:47 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:47 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:28:52 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:52 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:28:57 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:28:57 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:02 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:02 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:07 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:07 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:12 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:12 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:17 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:17 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:22 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:22 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:27 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:27 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:32 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:32 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:37 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:37 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:42 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:42 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:47 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:47 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:52 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:52 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:29:57 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:29:57 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:30:02 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:30:02 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:30:07 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:30:07 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:30:12 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:30:12 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:30:17 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:30:17 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:30:22 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:30:22 - INFO - 1 - [ocp_check.py:30] - ocp still not active
2022-08-31 14:30:27 - INFO - 1 - [ocp_check.py:23] - query ocp to check...
2022-08-31 14:30:28 - INFO - 1 - [ocp_check.py:33] - check ocp server status ok
2022-08-31 14:30:39 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:30:45 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:30:50 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:30:55 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:31:00 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:31:05 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:31:11 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:31:16 - INFO - 1 - [proxyro_password_modify.py:44] - task still not finished
2022-08-31 14:31:21 - INFO - 1 - [proxyro_password_modify.py:41] - task finished with status: SUCCESSFUL