ocp4.0安装初始化数据库报错

[barryy]

【 使用环境 】测试环境
【 OCP 】
【 使用版本 】
ocp-4.0.0-ce-bp1-x86_64
【问题描述】
执行ocp安装后失败，具体执行命令和报错如下：
./ocp_installer.sh install -c config.yaml -i ./ocp-installer.tar.gz -o ./ocp.tar.gz
install start
check docker on host
load installer docker image
Loaded image: reg.docker.alibaba-inc.com/ocp2/ocp-installer:4.0.0-ce-x86_64
make log dir
make obd dir
2023-03-05 22:48:16 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-a5e1d97c-e14f-41d8-9f3f-1276862d414e.sh -m ocp
2023-03-05 22:48:16 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 192.168.1.70 success
2023-03-05 22:48: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: 8 > 8 … PASS
check total MEM: 47 GB > 32 GB … PASS
check linux version: Red Hat Enterprise Linux Server release 7.9 (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: 20.10.18 … PASS
,
2023-03-05 22:48:16 - INFO - 1 - [image_load.py:21] - check image got result: 0 43808a7c5a36

2023-03-05 22:48:16 - INFO - 1 - [image_load.py:23] - image reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:4.0.0-ce-bp1-20230119103000 already loaded
2023-03-05 22:48:16 - INFO - 1 - [metadb_init.py:13] - run with context: {‘precheck_ignore’: True, ‘create_metadb_cluster’: False, ‘clean_metadb_cluster’: True, ‘ob_cluster’: {‘name’: ‘obcluster’, ‘home_path’: ‘/home/admin/oceanbase’, ‘root_password’: ‘redhat’, ‘data_path’: ‘/data/1’, ‘redo_path’: ‘/data/log1’, ‘sql_port’: 2881, ‘rpc_port’: 2882, ‘zones’: [{‘name’: ‘zone1’, ‘servers’: [‘192.168.1.70’]}], ‘meta’: {‘tenant’: ‘meta_tenant’, ‘user’: ‘meta_user@meta_tenant#obcluster’, ‘password’: ‘Ab123456’, ‘database’: ‘meta_database’, ‘cpu’: 2, ‘memory’: 4}, ‘monitor’: {‘tenant’: ‘monitor_tenant’, ‘user’: ‘monitor_user@meta_tenant#obcluster’, ‘password’: ‘Ab123456’, ‘database’: ‘monitor_database’, ‘cpu’: 2, ‘memory’: 2}}, ‘obproxy’: {‘home_path’: ‘/home/admin/obproxy’, ‘port’: 2883, ‘servers’: [‘192.168.1.71’, ‘192.168.1.72’, ‘192.168.1.73’]}, ‘ssh’: {‘port’: 22, ‘user’: ‘admin’, ‘auth_method’: ‘password’, ‘timeout’: 10, ‘password’: ‘redhat’, ‘key_file’: ‘/root/keys/id_rsa’}, ‘ocp’: {‘name’: ‘ocp’, ‘process’: {‘port’: 8080, ‘log_dir’: ‘/tmp/ocp/log’}, ‘servers’: [‘192.168.1.70’], ‘resource’: {‘cpu’: 2, ‘memory’: 4}, ‘auth’: {‘user’: ‘admin’, ‘password’: ‘Ab123456’}, ‘options’: {‘enable_web_tracking’: True}, ‘metadb’: {‘host’: ‘192.168.1.73’, ‘port’: 2883, ‘meta_user’: ‘meta_user@meta_tenant#obcluster’, ‘meta_password’: ‘Ab123456’, ‘meta_database’: ‘meta_database’, ‘monitor_user’: ‘monitor_user@monitor_tenant#obcluster’, ‘monitor_password’: ‘Ab123456’, ‘monitor_database’: ‘monitor_database’}, ‘image’: ‘/root/ocp.tar.gz’, ‘vip’: {‘address’: ‘192.168.1.70’, ‘port’: 8080}, ‘image_tag’: ‘reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:4.0.0-ce-bp1-20230119103000’}, ‘operation’: ‘install’}
2023-03-05 22:48:16 - 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:4.0.0-ce-bp1-20230119103000 create_metadb.py 192.168.1.73 2883 meta_user@meta_tenant#obcluster Ab123456 meta_database monitor_user@monitor_tenant#obcluster Ab123456 monitor_database on host: 192.168.1.70
Traceback (most recent call last):
File “pipeline/install_ocp.py”, line 43, in
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 192.168.1.73
username: &metadb_username meta_user@meta_tenant#obcluster
password: &metadb_password ‘Ab123456’
port: &metadb_port 2883
dbname: &metadb_dbname meta_database
MONITORDB:
ip: &monitordb_ip 192.168.1.73
username: &monitordb_username monitor_user@monitor_tenant#obcluster
password: &monitordb_password ‘Ab123456’
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_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
[2023-03-05 22:48:52] run sql: CREATE TABLE meta_id_map (
id int(11) NOT NULL AUTO_INCREMENT,
value varchar(256) DEFAULT ‘’,
gmt_create timestamp NULL DEFAULT CURRENT_TIMESTAMP,
gmt_modified timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY value (value) BLOCK_SIZE 16384
) AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COMPRESSION = ‘lz4_1.0’ REPLICA_NUM = 2 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10; 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)
DatabaseError: 4012 (HY000): RPC send error

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 forfull 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
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.DatabaseError: 4012 (HY000): RPC send error