[root@OceanBase-12834 ocp-4.0.0-ce-x86_64]# /u02/software/ocp-4.0.0-ce-x86_64/ocp_installer.sh install -c config.yaml -i /u02/software/ocp-4.0.0-ce-x86_64/ocp-installer.tar.gz -o /u02/software/ocp-4.0.0-ce-x86_64/ocp.tar.gz
install start
check docker on host
load installer docker image
c5974558e919: Loading layer [==================================================>]  298.7MB/298.7MB
0c1ce969e922: Loading layer [==================================================>]  2.048kB/2.048kB
fe09719433da: Loading layer [==================================================>]  3.584kB/3.584kB
92a4da7973a0: Loading layer [==================================================>]  2.048kB/2.048kB
11ba241bc6ba: Loading layer [==================================================>]   2.56kB/2.56kB
f73a056aeecd: Loading layer [==================================================>]  3.072kB/3.072kB
98c59d2aef5b: Loading layer [==================================================>]  3.072kB/3.072kB
d023669007c7: Loading layer [==================================================>]   5.12kB/5.12kB
618f6e952ad0: Loading layer [==================================================>]   2.56kB/2.56kB
d14f2e92c70b: Loading layer [==================================================>]   2.56kB/2.56kB
d7c925cc23a5: Loading layer [==================================================>]   2.56kB/2.56kB
8422da10b172: Loading layer [==================================================>]  407.4MB/407.4MB
574144b99534: Loading layer [==================================================>]  6.265MB/6.265MB
ec276a8cf09a: Loading layer [==================================================>]  3.072kB/3.072kB
f1d666eb5de7: Loading layer [==================================================>]  144.5MB/144.5MB
db181331214d: Loading layer [==================================================>]  49.61MB/49.61MB
c411fd0e0262: Loading layer [==================================================>]  162.3kB/162.3kB
a64258ff4ab1: Loading layer [==================================================>]  9.914MB/9.914MB
af073c54e247: Loading layer [==================================================>]  60.51MB/60.51MB
ef7ee04b9e03: Loading layer [==================================================>]  18.43kB/18.43kB
3e41eff2cfdb: Loading layer [==================================================>]  11.89MB/11.89MB
d5767be3f873: Loading layer [==================================================>]  24.43MB/24.43MB
879aebcc0533: Loading layer [==================================================>]  52.55MB/52.55MB
f5ba6c31cb6e: Loading layer [==================================================>]   5.12kB/5.12kB
6da1de090867: Loading layer [==================================================>]  172.5kB/172.5kB
19ea87a6f7bc: Loading layer [==================================================>]    150MB/150MB
e911243d2cbd: Loading layer [==================================================>]  5.777MB/5.777MB
1d0af4dc80f8: Loading layer [==================================================>]  3.072kB/3.072kB
e6aec86975d9: Loading layer [==================================================>]  1.612MB/1.612MB
Loaded image: reg.docker.alibaba-inc.com/ocp2/ocp-installer:4.0.0-ce-x86_64
make log dir
make obd dir
2023-01-18 16:17:58 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-7c3f3b5e-692e-4d83-9ec2-e314a63383e7.sh -m ocp
2023-01-18 16:17:59 - INFO - 1 - [ocp_precheck.py:29] - precheck for ocp on host 10.18.128.34 failed
2023-01-18 16:17:59 - INFO - 1 - [ocp_precheck.py:32] - ocp precheck result: Machine Role: ocp 
Peer IP List:  
Machine Type: PHY 
Inspect Mode: FALSE 

check CPU count: 8 > 8 ... PASS 
check total MEM: 15 GB < 32 GB ... EXPECT >= 32 GB ... FAIL 
TIPS: replace another machine with more MEM
check linux version: Red Hat Enterprise Linux Server release 7.6 (Maipo) ... 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: 18.06.3 ... PASS 


### SUMMARY OF ISSUES IN PRE-CHECK ###
check total MEM: 15 GB < 32 GB ... EXPECT >= 32 GB ... FAIL 
TIPS: replace another machine with more MEM
, 
2023-01-18 16:17:59 - INFO - 1 - [image_load.py:21] - check image got result: 0  
2023-01-18 16:22:30 - INFO - 1 - [image_load.py:31] - load image got result: 0  
2023-01-18 16:22:30 - INFO - 1 - [image_load.py:36] - load image successful
2023-01-18 16:22:30 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': True, 'create_metadb_cluster': False, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obocp', 'home_path': '/u01/ocp/oceanbase', 'root_password': 'Band4Chord', 'data_path': '/u01/ocp/data', 'redo_path': '/u01/ocp/redo', 'sql_port': 2883, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['10.18.128.34']}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'meta_user', 'database': 'meta_database', 'cpu': 1, 'memory': 2}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'monitor_user', 'database': 'monitor_database', 'cpu': 2, 'memory': 4}}, 'obproxy': {'home_path': '/u01/ocp/obproxy', 'port': 2881, 'servers': ['10.18.128.34']}, 'ssh': {'port': 22, 'user': 'root', 'auth_method': 'password', 'timeout': 100, 'password': 'Band4Chord', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/u01/ocp/tmp/ocp/log'}, 'servers': ['10.18.128.34'], 'resource': {'cpu': 2, 'memory': 4}, 'auth': {'user': 'admin', 'password': 'admin'}, 'options': {'enable_web_tracking': True}, 'metadb': {'host': '10.18.128.34', 'port': 2881, 'meta_user': 'meta_user@meta_tenant', 'meta_password': 'meta_user', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant', 'monitor_password': 'monitor_user', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '10.18.128.34', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:v4.0.0-ce'}, 'operation': 'install'}
2023-01-18 16:22:31 - INFO - 1 - [metadb_init.py:39] - 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:v4.0.0-ce create_metadb.py 10.18.128.34 2881 meta_user@meta_tenant meta_user meta_database monitor_user@monitor_tenant monitor_user monitor_database on host: 10.18.128.34
Traceback (most recent call last):
  File "pipeline/install_ocp.py", line 43, in <module>
    run(context)
  File "pipeline/install_ocp.py", line 33, in run
    install_ocp_pipeline.run()
  File "/root/installer/core/pipeline.py", line 10, in run
    task.run()
  File "/root/installer/task/metadb_init.py", line 42, in run
    raise Exception("init metadb failed, {} {} {}".format(init_metadb_result.code, init_metadb_result.stdout, init_metadb_result.stderr))
Exception: init metadb failed, 1 Generated yml file: 

OcpInitParameter:
  METADB:
    ip: &metadb_ip 10.18.128.34
    username: &metadb_username meta_user@meta_tenant
    password: &metadb_password 'meta_user'
    port: &metadb_port 2881
    dbname: &metadb_dbname meta_database
  MONITORDB:
    ip: &monitordb_ip 10.18.128.34
    username: &monitordb_username monitor_user@monitor_tenant
    password: &monitordb_password 'monitor_user'
    port: &monitordb_port 2881
    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_diagram_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_ddl_3.3.1.sql', 'update_ddl_3.3.2.sql', 'update_ddl_3.3.3.sql', 'update_ddl_3.3.4.sql', 'update_ddl_4.0.0.sql', 'update_dml_3.2.2.sql', 'update_dml_3.2.3.sql', 'update_dml_3.3.0.sql', 'update_dml_3.3.1.sql', 'update_dml_3.3.2.sql', 'update_dml_3.3.3.sql', 'update_dml_4.0.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/inspection_template.sql', 'generate/mc_ocp_cluster_config.sql', 'generate/metric_class.sql', 'generate/metric_diagram_deleted.sql', 'generate/metric_expression.sql', 'generate/metric_expression_deleted.sql', 'generate/metric_group.sql', 'generate/metric_meta.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
[2023-01-18 16:23:09] run sql: create tablegroup if not exists meta_database; failed, got exception Traceback (most recent call last):
  File "/home/admin/ocp-init/src/ocp-init/common.py", line 207, in source_sql_file
    run_sql_no_result(sql, config)
  File "/home/admin/ocp-init/src/ocp-init/common.py", line 77, in run_sql_no_result
    run_sql(sql, db_config, True)
  File "/home/admin/ocp-init/src/ocp-init/common.py", line 61, in run_sql
    cursor.execute(sql)
  File "/usr/lib64/python2.7/site-packages/mysql/connector/cursor.py", line 569, in execute
    self._handle_result(self._connection.cmd_query(stmt))
  File "/usr/lib64/python2.7/site-packages/mysql/connector/connection.py", line 590, in cmd_query
    result = self._handle_result(self._send_cmd(ServerCmd.QUERY, query))
  File "/usr/lib64/python2.7/site-packages/mysql/connector/connection.py", line 478, in _handle_result
    raise errors.get_exception(packet)
ProgrammingError: 1227 (42501): Access denied; you need (at least one of) the CREATE privilege(s) for this operation

 create_metadb.py:20: 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)
/home/admin/ocp-init/src/ocp-init/generate/gen_monitor_metric_ob_collect_config.py:47: 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"
Traceback (most recent call last):
  File "create_metadb.py", line 189, in <module>
    init_ocp(filename)
  File "create_metadb.py", line 63, in init_ocp
    init_meta_db(meta_db_connect_info)
  File "create_metadb.py", line 88, in init_meta_db
    metadb.source_sqls(db_connect_info, sqls)
  File "/home/admin/ocp-init/src/ocp-init/metadb.py", line 450, in source_sqls
    common.source_sql_file(config, "../../sqls/{}".format(real_file), force=force)
  File "/home/admin/ocp-init/src/ocp-init/common.py", line 217, in source_sql_file
    raise e
mysql.connector.errors.ProgrammingError: 1227 (42501): Access denied; you need (at least one of) the CREATE privilege(s) for this operation