开发者社区 问答 正文

请问OceanBase数据中,这个报错怎么解决?

"2023-06-27 15:43:14 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-4af5a24c-4afc-4f6e-9b7b-9f47fd0a71ae.sh -m ob
2023-06-27 15:43:15 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host 192.168.66.42 failed
2023-06-27 15:43:15 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: x001b[32mMachine Role: ob [0m
[32mPeer IP List: [0m
x001b[32mMachine Type: PHY x001b[0m
[32mInspect Mode: FALSE x001b[0m

check CPU count: 16 > 8 ...[32m PASS x001b[0m
check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...x001b[31m FAIL [0m
[33mTIPS: replace another machine with more MEM[0m
check linux version: CentOS Linux release 7.9.2009 (Core) ...[32m PASS [0m
check SELinux status: Disabled ...[32m PASS x001b[0m
check account [admin] and home dir, exist ...x001b[32m PASS [0m
check service [firewalld]: inactive ...[32m PASS [0m
check service [firewalld]: disabled ...[32m PASS [0m

SUMMARY OF ISSUES IN PRE-CHECK

check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...[31m FAIL [0m
[33mTIPS: replace another machine with more MEM[0m
,
2023-06-27 15:43:15 - INFO - 1 - [ob_install.py:82] - clean obd dir
2023-06-27 15:43:15 - INFO - 1 - [ob_install.py:91] - install ob using obd
2023-06-27 15:43:15 - 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:
  • 192.168.66.42
    oceanbase-ce:
    global:
    appname: obcluster
    data_dir: /data/oceanbase/data
    devname: ens192
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/oceanbase/redo
    root_password: root123
    rpc_port: 2882
    server1:
    zone: zone1
    servers:
  • ip: 192.168.66.42
    name: server1
    user:
    key_file: ''
    password: a
    port: 36566
    timeout: 10
    username: admin

2023-06-27 15:43:15 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2023-06-27 15:43:33 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3-2.el7 is available.
Package oceanbase-ce-3.1.4-10000092022071511.el7 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 x
[ERROR] OBD-2000: (192.168.66.42) not enough memory. (Free: 4.6G, Need: 8.0G)

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

,
2023-06-27 15:48:15 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-a7704e81-3a90-4ec0-894d-d25f4943c866.sh -m ob
2023-06-27 15:48:15 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host 192.168.66.42 failed
2023-06-27 15:48:15 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: [32mMachine Role: ob [0m
x001b[32mPeer IP List: [0m
[32mMachine Type: PHY [0m
[32mInspect Mode: FALSE [0m

check CPU count: 16 > 8 ...[32m PASS [0m
check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...[31m FAIL [0m
[33mTIPS: replace another machine with more MEM[0m
check linux version: CentOS Linux release 7.9.2009 (Core) ...[32m PASS [0m
check SELinux status: Disabled ...[32m PASS x001b[0m
check account [admin] and home dir, exist ...[32m PASS [0m
check service [firewalld]: inactive ...[32m PASS [0m
check service [firewalld]: disabled ...[32m PASS [0m

SUMMARY OF ISSUES IN PRE-CHECK

check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...[31m FAIL [0m
[33mTIPS: replace another machine with more MEM[0m
,
2023-06-27 15:48:15 - INFO - 1 - [ob_install.py:82] - clean obd dir
2023-06-27 15:48:15 - INFO - 1 - [ob_install.py:91] - install ob using obd
2023-06-27 15:48:15 - 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:
  • 192.168.66.42
    oceanbase-ce:
    global:
    appname: obcluster
    data_dir: /data/oceanbase/data
    devname: ens192
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/oceanbase/redo
    root_password: root123
    rpc_port: 2882
    server1:
    zone: zone1
    servers:
  • ip: 192.168.66.42
    name: server1
    user:
    key_file: ''
    password: a
    port: 36566
    timeout: 10
    username: admin

2023-06-27 15:48:15 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2023-06-27 15:48:35 - INFO - 1 - [ob_install.py:104] - deploy obcluster got result Package obproxy-ce-3.2.3-2.el7 is available.
Package oceanbase-ce-3.1.4-10000092022071511.el7 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
Cluster status check ok
Initializes obproxy work home ok
Initializes observer work home x
[ERROR] OBD-1002: Fail to init server1(192.168.66.42) clog dir: /data/oceanbase/redo/clog is not empty.
[ERROR] OBD-1002: Fail to init server1(192.168.66.42) ilog dir: /data/oceanbase/redo/ilog is not empty.
[ERROR] OBD-1002: Fail to init server1(192.168.66.42) slog dir: /data/oceanbase/redo/slog is not empty.

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

,
2023-06-27 15:49:39 - INFO - 1 - [ob_precheck.py:28] - ob precheck using command: sudo /tmp/precheck-2441d691-230a-456f-a54b-74f2075d27da.sh -m ob
2023-06-27 15:49:39 - ERROR - 1 - [ob_precheck.py:32] - precheck for ocp on host 192.168.66.42 failed
2023-06-27 15:49:39 - INFO - 1 - [ob_precheck.py:35] - ob precheck result: x001b[32mMachine Role: ob [0m
[32mPeer IP List: [0m
[32mMachine Type: PHY [0m
[32mInspect Mode: FALSE [0m

check CPU count: 16 > 8 ...[32m PASS [0m
check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...[31m FAIL [0m
[33mTIPS: replace another machine with more MEMx001b[0m
check linux version: CentOS Linux release 7.9.2009 (Core) ...[32m PASS [0m
check SELinux status: Disabled ...[32m PASS [0m
check account [admin] and home dir, exist ...[32m PASS [0m
check service [firewalld]: inactive ...[32m PASS [0m
check service [firewalld]: disabled ...[32m PASS [0m

SUMMARY OF ISSUES IN PRE-CHECK

check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...[31m FAIL [0m
[33mTIPS: replace another machine with more MEM[0m
,
2023-06-27 15:49:39 - INFO - 1 - [ob_install.py:82] - clean obd dir
2023-06-27 15:49:39 - INFO - 1 - [ob_install.py:91] - install ob using obd
2023-06-27 15:49:39 - 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:
  • 192.168.66.42
    oceanbase-ce:
    global:
    appname: obcluster
    data_dir: /data/oceanbase/data
    devname: ens192
    home_path: /home/admin/oceanbase
    mysql_port: 2881
    redo_dir: /data/oceanbase/redo
    root_password: root123
    rpc_port: 2882
    server1:
    zone: zone1
    servers:
  • ip: 192.168.66.42
    name: server1
    user:
    key_file: ''
    password: a
    port: 36566
    timeout: 10
    username: admin

2023-06-27 15:49:39 - INFO - 1 - [ob_install.py:100] - deploy obcluster command: obd cluster autodeploy obcluster -c /tmp/ocp_cluster.yaml
2023-06-27 15:50:34 - 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 2147483648 --min-memory 2147483648
2023-06-27 15:50:39 - INFO - 1 - [ob_install.py:76] - create monitor tenant with command obd cluster tenant create obcluster -n monitor_tenant --max-cpu 2 --min-cpu 2 --max-memory 4294967296 --min-memory 4294967296
2023-06-27 15:50:43 - INFO - 1 - [ob_install.py:124] - create meta user
2023-06-27 15:50:43 - INFO - 1 - [ob_install.py:126] - grant privilege to meta user
2023-06-27 15:50:43 - INFO - 1 - [ob_install.py:128] - set meta user password
2023-06-27 15:50:43 - INFO - 1 - [ob_install.py:137] - create monitor user
2023-06-27 15:50:43 - INFO - 1 - [ob_install.py:139] - grant privilege to monitor user
2023-06-27 15:50:43 - INFO - 1 - [ob_install.py:141] - set monitor user password
2023-06-27 15:50:43 - INFO - 1 - [ocp_precheck.py:25] - ocp precheck using command: sudo /tmp/precheck-1986b9b7-97ef-4822-9873-2217e160945a.sh -m ocp
2023-06-27 15:50:43 - INFO - 1 - [ocp_precheck.py:31] - precheck for ocp on host 192.168.66.42 success
2023-06-27 15:50:44 - INFO - 1 - [ocp_precheck.py:32] - ocp precheck result: [32mMachine Role: ocp x001b[0m
x001b[32mPeer IP List: [0m
[32mMachine Type: PHY [0m
[32mInspect Mode: FALSE [0m

check CPU count: 16 > 8 ...[32m PASS [0m
check total MEM: 47 GB > 32 GB ...[32m PASS [0m
check linux version: CentOS Linux release 7.9.2009 (Core) ...[32m PASS [0m
check SELinux status: Disabled ...[32m PASS [0m
check account [admin] and home dir, exist ...[32m PASS [0m
check service [firewalld]: inactive ...[32m PASS [0m
check service [firewalld]: disabled ...[32m PASS [0m
check docker version: 1.13.1 ...[32m PASS [0m
,
2023-06-27 15:50:44 - INFO - 1 - [image_load.py:21] - check image got result: 0 c07588c96bd6

2023-06-27 15:50:44 - INFO - 1 - [image_load.py:23] - image reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:v4.0.0-ce already loaded
2023-06-27 15:50:44 - INFO - 1 - [metadb_init.py:13] - run with context: {'precheck_ignore': True, 'create_metadb_cluster': True, 'clean_metadb_cluster': False, 'ob_cluster': {'name': 'obcluster', 'home_path': '/home/admin/oceanbase', 'root_password': 'root123', 'data_path': '/data/oceanbase/data', 'redo_path': '/data/oceanbase/redo', 'sql_port': 2881, 'rpc_port': 2882, 'zones': [{'name': 'zone1', 'servers': ['192.168.66.42']}], 'custom_config': [{'key': 'devname', 'value': 'ens192'}], 'meta': {'tenant': 'meta_tenant', 'user': 'meta_user', 'password': 'meta_password', 'database': 'meta_database', 'cpu': 2, 'memory': 2}, 'monitor': {'tenant': 'monitor_tenant', 'user': 'monitor_user', 'password': 'monitor_password', 'database': 'monitor_database', 'cpu': 2, 'memory': 4}}, 'obproxy': {'home_path': '/home/admin/obproxy', 'port': 2883, 'servers': ['192.168.66.42'], 'vip': {'address': '192.168.66.42', 'port': 2883}}, 'ssh': {'port': 36566, 'user': 'admin', 'auth_method': 'password', 'timeout': 10, 'password': 'a', 'key_file': '/root/keys/id_rsa'}, 'ocp': {'name': 'ocp', 'process': {'port': 8080, 'log_dir': '/tmp/ocp/log'}, 'servers': ['192.168.66.42'], 'resource': {'cpu': 2, 'memory': 4}, 'auth': {'user': 'admin', 'password': 'a'}, 'options': {'enable_web_tracking': True}, 'metadb': {'host': '192.168.66.42', 'port': 2883, 'meta_user': 'meta_user@meta_tenant#obcluster', 'meta_password': 'meta_password', 'meta_database': 'meta_database', 'monitor_user': 'monitor_user@monitor_tenant#obcluster', 'monitor_password': 'monitor_password', 'monitor_database': 'monitor_database'}, 'image': '/root/ocp.tar.gz', 'vip': {'address': '192.168.66.42', 'port': 8080}, 'image_tag': 'reg.docker.alibaba-inc.com/oceanbase/ocp-all-in-one:v4.0.0-ce'}, 'operation': 'install'}
2023-06-27 15:50:44 - 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 192.168.66.42 2883 meta_user@meta_tenant#obcluster meta_password meta_database monitor_user@monitor_tenant#obcluster monitor_password monitor_database on host: 192.168.66.42
2023-06-27 16:00:32 - INFO - 1 - [metadb_init.py:43] - run init metadb script got result: Generated yml file:

OcpInitParameter:
METADB:
ip: &metadb_ip 192.168.66.42
username: &metadb_username meta_user@meta_tenant#obcluster
password: &metadb_password 'meta_password'
port: &metadb_port 2883
dbname: &metadb_dbname meta_database
MONITORDB:
ip: &monitordb_ip 192.168.66.42
username: &monitordb_username monitor_user@monitor_tenant#obcluster
password: &monitordb_password 'monitor_password'
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
replace table_group in sql file: ocp_metadb_tablegroup.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/ocp_metadb_tablegroup.sql > ../../sqls/real/ocp_metadb_tablegroup.sql
executing real sql script: real/ocp_metadb_tablegroup.sql
replace table_group in sql file: ocp_metadb_dml.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/ocp_metadb_dml.sql > ../../sqls/real/ocp_metadb_dml.sql
executing real sql script: real/ocp_metadb_dml.sql
replace table_group in sql file: update_ddl_2.2.0.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.2.0.sql > ../../sqls/real/update_ddl_2.2.0.sql
executing real sql script: real/update_ddl_2.2.0.sql
replace table_group in sql file: update_ddl_2.3.0.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.0.sql > ../../sqls/real/update_ddl_2.3.0.sql
executing real sql script: real/update_ddl_2.3.0.sql
[2023-06-27 15:51:59] run sql: alter table ocp_rpm_svn add column upgrade_post_checker varbinary(262144); failed, got duplicate column error 1060 (42S21): Duplicate column name 'upgrade_post_checker', just skip

replace table_group in sql file: update_ddl_2.3.1.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.1.sql > ../../sqls/real/update_ddl_2.3.1.sql
executing real sql script: real/update_ddl_2.3.1.sql
replace table_group in sql file: update_ddl_2.3.2.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.2.sql > ../../sqls/real/update_ddl_2.3.2.sql
executing real sql script: real/update_ddl_2.3.2.sql
replace table_group in sql file: update_ddl_2.3.3.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.3.sql > ../../sqls/real/update_ddl_2.3.3.sql
executing real sql script: real/update_ddl_2.3.3.sql
replace table_group in sql file: update_ddl_2.3.4.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.4.sql > ../../sqls/real/update_ddl_2.3.4.sql
executing real sql script: real/update_ddl_2.3.4.sql
replace table_group in sql file: update_ddl_2.3.5.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.5.sql > ../../sqls/real/update_ddl_2.3.5.sql
executing real sql script: real/update_ddl_2.3.5.sql
replace table_group in sql file: update_ddl_2.3.7.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.3.7.sql > ../../sqls/real/update_ddl_2.3.7.sql
executing real sql script: real/update_ddl_2.3.7.sql
replace table_group in sql file: update_ddl_2.4.0.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.0.sql > ../../sqls/real/update_ddl_2.4.0.sql
executing real sql script: real/update_ddl_2.4.0.sql
replace table_group in sql file: update_ddl_2.4.1.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.1.sql > ../../sqls/real/update_ddl_2.4.1.sql
executing real sql script: real/update_ddl_2.4.1.sql
[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_template_variable_meta ADD description3 varchar(512) NULL COMMENT 'zh_TW 变量描述'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'description3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_metric_meta ADD name3 varchar(64) NULL COMMENT 'zh_TW 指标名称'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'name3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_metric_meta ADD description3 varchar(512) NULL COMMENT 'zh_TW 指标描述'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'description3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_metric_meta ADD unit2 varchar(32) NULL COMMENT 'en_US 单位'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'unit2', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_metric_meta ADD unit3 varchar(32) NULL COMMENT 'zh_TW 单位'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'unit3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_rule ADD name3 varchar(64) NULL COMMENT 'zh_TW 告警项名称'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'name3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_rule ADD summary_template3 varchar(256) NULL COMMENT 'zh_TW 概述模板'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'summary_template3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_rule ADD description_template3 varchar(512) NULL COMMENT 'zh_TW 详情模板'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'description_template3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_channel ADD name2 varchar(64) NULL COMMENT 'en_US 名称'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'name2', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_channel ADD name3 varchar(64) NULL COMMENT 'zh_TW 名称'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'name3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_channel ADD message_template3 varchar(4096) NULL COMMENT 'en_US 消息模版'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'message_template3', just skip

[2023-06-27 15:52:06] run sql: ALTER TABLE ocp2_alarm_channel ADD aggregation_message_template3 varchar(4096) NULL COMMENT 'en_US 聚合消息模板'; failed, got duplicate column error 1060 (42S21): Duplicate column name 'aggregation_message_template3', just skip

replace table_group in sql file: update_ddl_2.4.2.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.2.sql > ../../sqls/real/update_ddl_2.4.2.sql
executing real sql script: real/update_ddl_2.4.2.sql
replace table_group in sql file: update_ddl_2.4.3.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.3.sql > ../../sqls/real/update_ddl_2.4.3.sql
executing real sql script: real/update_ddl_2.4.3.sql
replace table_group in sql file: update_ddl_2.4.4.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.4.sql > ../../sqls/real/update_ddl_2.4.4.sql
executing real sql script: real/update_ddl_2.4.4.sql
replace table_group in sql file: update_ddl_2.4.5.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.4.5.sql > ../../sqls/real/update_ddl_2.4.5.sql
executing real sql script: real/update_ddl_2.4.5.sql
replace table_group in sql file: update_ddl_2.5.0.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.5.0.sql > ../../sqls/real/update_ddl_2.5.0.sql
executing real sql script: real/update_ddl_2.5.0.sql
replace table_group in sql file: update_ddl_2.5.1.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.5.1.sql > ../../sqls/real/update_ddl_2.5.1.sql
executing real sql script: real/update_ddl_2.5.1.sql
replace table_group in sql file: update_ddl_2.5.4.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_2.5.4.sql > ../../sqls/real/update_ddl_2.5.4.sql
executing real sql script: real/update_ddl_2.5.4.sql
replace table_group in sql file: update_ddl_3.1.0.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.1.0.sql > ../../sqls/real/update_ddl_3.1.0.sql
executing real sql script: real/update_ddl_3.1.0.sql
replace table_group in sql file: update_ddl_3.1.1.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.1.1.sql > ../../sqls/real/update_ddl_3.1.1.sql
executing real sql script: real/update_ddl_3.1.1.sql
replace table_group in sql file: update_ddl_3.1.2.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.1.2.sql > ../../sqls/real/update_ddl_3.1.2.sql
executing real sql script: real/update_ddl_3.1.2.sql
replace table_group in sql file: update_ddl_3.2.0.sql
sed 's/$VAR_TABLEGROUP_NAME/meta_database/g' ../../sqls/update_ddl_3.2.0.sql > ../../sqls/real/update_ddl_3.2.0.sql
executing real sql script: real/update_ddl_3.2.0.sql
[2023-06-27 15:52:18] run sql: ALTER TABLE ocp2_alarm_filter ADD COLUMN filter_time_range_json varchar(2048) NOT NULL DEFAULT '{}' COMMENT '屏蔽时间段匹配条件 MatchTimeRange json数组'; failed, 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_TABLEGROUPNAME/meta"
请问OceanBase数据中,这个报错怎么解决?

展开
收起
十一0204 2023-07-19 15:41:46 198 分享 版权
来自: OceanBase
3 条回答
写回答
取消 提交回答
  • 北京阿里云ACE会长

    据报错信息,可以看到 precheck 检查失败的原因是机器的总内存不足 64GB,而实际只有 47GB,因此 precheck 判断检查失败。

    解决这个问题的方法,您可以考虑以下两个方向:

    更换内存更大的机器:由于 precheck 检查要求机器内存大于等于 64GB,因此您可以考虑更换内存更大的机器来满足要求。如果您已经使用了所有可用的机器,您可能需要考虑添加新的机器或者升级现有机器的内存。

    调整 precheck 检查要求:如果您无法更换内存更大的机器,您也可以尝试调整 precheck 检查要求,例如降低机器内存要求,或者关闭 precheck 检查等。不过,这种做法可能会影响到集群的稳定性和性能,因此需要谨慎评估和决策。

    2023-07-28 14:07:29
    赞同 展开评论
  • 云端行者觅知音, 技术前沿我独行。 前言探索无边界, 阿里风光引我情。

    check CPU count: 16 > 8 ...[32m PASS x001b[0m
    check total MEM: 47 GB < 64 GB ... EXPECT >= 64 GB ...x001b[31m FAIL

    感觉是内存不足。

    2023-07-21 15:47:39
    赞同 展开评论
  • 意中人就是我呀!

    你重重复复安装了好几次,都有服务在占用着端口在跑了,看你给的日志,重重复复执行安装。此回答整理至钉群“[社区]技术答疑群OceanBase”。

    2023-07-19 16:51:49
    赞同 展开评论