COP部署集群obshell报错

OceanBase 技术问题
,
#1

【 使用环境 】生产环境 or 测试环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】OCP部署的环境已经清理好几次了，一直卡在这，请问应该怎么调整一下
【复现路径】问题出现前后相关操作
【附件及日志】
obd.zip (61.9 KB)

Snipaste_2024-05-11_11-15-23
Snipaste_2024-05-11_11-15-231087×275 116 KB

查看Obshell服务是在的

1 个赞
#3
  1. 可以使用obdiag巡检下日志
  2. obdiag analyze log 日志分析
  3. obdiag gather scene run --scene=observer.unknown 未知问题信息采集回来
    obdiag文档：OceanBase分布式数据库-海量数据 笔笔算数1
    把结果先发出来，定位不了再把3收集的信息发出来
1 个赞
#4

image
image1316×717 21.7 KB

image
image1106×192 9.02 KB

安装不成功，是不是用不了obdiag，
obd.zip (127.2 KB)
这是ocp机器/home/admin/.obd/log/obd日志文件，能帮看看吗？部署好些次，都没成功。资源

1 个赞
#5

看是否可以登陆下数据库？
如果可以执行下create tenant ocp_meta replica_num=3,zone_list=(‘zone1’,‘zone2’,‘zone3’),primary_zone=‘RANDOM’,resource_pool_list=(‘ocp_meta_pool’)set ob_tcp_invited_nodes=’%’, ob_compatibility_mode = ‘mysql’ 看看

#6

登录不上，没有Obclient命令

#7

可以下载并安装一个那。

image
image945×316 17.1 KB

#8

image
image918×407 11.9 KB

创建前查了一下，现在有这个租房，但状态好像不对吧？

#9

[admin@host-209 ~]$ obclient -h192.168.175.209 -uroot@sys -P2883 -pSShy__111111 -c -A oceanbase
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3
Server version: OceanBase_CE 4.2.1.2 (r102010022023121415-f6752332b5001069034f96c6dbb620926dc666f0) (Built Dec 14 2023 15:39:00)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

root@192.168.175.209 16:33: [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANTS\G
*************************** 1. row ***************************
TENANT_ID: 1
TENANT_NAME: sys
TENANT_TYPE: SYS
CREATE_TIME: 2024-05-21 14:39:53.901900
MODIFY_TIME: 2024-05-21 14:39:53.901900
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: NULL
REPLAYABLE_SCN: NULL
READABLE_SCN: NULL
RECOVERY_UNTIL_SCN: NULL
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
COMPATIBLE: 4.2.1.2
MAX_LS_ID: 1
*************************** 2. row ***************************
TENANT_ID: 1001
TENANT_NAME: META$1002
TENANT_TYPE: META
CREATE_TIME: 2024-05-21 14:40:18.282054
MODIFY_TIME: 2024-05-21 14:59:30.693060
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: NULL
REPLAYABLE_SCN: NULL
READABLE_SCN: NULL
RECOVERY_UNTIL_SCN: NULL
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
COMPATIBLE: 4.2.1.2
MAX_LS_ID: 1
*************************** 3. row ***************************
TENANT_ID: 1002
TENANT_NAME: ocp_meta
TENANT_TYPE: USER
CREATE_TIME: 2024-05-21 14:40:18.287643
MODIFY_TIME: 2024-05-21 14:40:18.287643
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1, FULL{1}@zone2, FULL{1}@zone3
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: CREATING
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: 1716280424474107016
REPLAYABLE_SCN: 1716280424474107016
READABLE_SCN: 1716280424474107016
RECOVERY_UNTIL_SCN: 4611686018427387903
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
COMPATIBLE: 4.2.1.2
MAX_LS_ID: 1
3 rows in set (0.019 sec)

root@192.168.175.209 16:33: [oceanbase]>

#11

[2024-05-11 11:02:06.574] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – connect 192.168.175.208 -P2881 -uroot -pSShy__111111
[2024-05-11 11:02:10.000] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – connect 192.168.175.206 -P2881 -uroot -p
[2024-05-11 11:02:10.010] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – execute sql: select 1. args: None
[2024-05-11 11:02:10.014] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] - sub connect ref count to 0
[2024-05-11 11:02:10.015] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] - export connect
[2024-05-11 11:02:10.015] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [INFO] Initialize oceanbase-ce
[2024-05-11 11:02:10.015] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] - Call oceanbase-ce-py_script_bootstrap-4.2.2.0 for oceanbase-ce-4.3.0.1-100000242024032211.el7-c4a03c83614f50c99ddb1c37dda858fa5d9b14b7
[2024-05-11 11:02:10.016] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] - import bootstrap
[2024-05-11 11:02:10.018] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] - add bootstrap ref count to 1
[2024-05-11 11:02:10.018] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – bootstrap for components: dict_keys([‘oceanbase-ce’, ‘obproxy-ce’, ‘ocp-server-ce’])
[2024-05-11 11:02:10.019] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – execute sql: set session ob_query_timeout=1000000000
[2024-05-11 11:02:10.019] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – execute sql: set session ob_query_timeout=1000000000. args: None
[2024-05-11 11:02:10.022] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – execute sql: alter system bootstrap REGION “sys_region” ZONE “zone1” SERVER “192.168.175.206:2882”,REGION “sys_region” ZONE “zone2” SERVER “192.168.175.207:2882”,REGION “sys_region” ZONE “zone3” SERVER “192.168.175.208:2882”. args: None
[2024-05-11 11:03:13.911] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – execute sql: alter user “root” IDENTIFIED BY %s. args: [‘SShy__111111’]
[2024-05-11 11:03:13.990] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – execute sql: select * from oceanbase.__all_server. args: None
[2024-05-11 11:03:13.993] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.206 execute: ls /home/admin/oceanbase/.meta
[2024-05-11 11:03:14.013] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 2, error output:
[2024-05-11 11:03:14.013] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] ls: 无法访问/home/admin/oceanbase/.meta: 没有那个文件或目录
[2024-05-11 11:03:14.013] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.013] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] –
[2024-05-11 11:03:14.014] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – ls: 无法访问/home/admin/oceanbase/.meta: 没有那个文件或目录
[2024-05-11 11:03:14.014] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.014] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.206 execute: cat /home/admin/oceanbase/run/obshell.pid
[2024-05-11 11:03:14.073] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 1, error output:
[2024-05-11 11:03:14.073] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] cat: /home/admin/oceanbase/run/obshell.pid: 没有那个文件或目录
[2024-05-11 11:03:14.073] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.073] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.206 execute: strings /home/admin/oceanbase/etc/observer.conf.bin
[2024-05-11 11:03:14.208] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 1, error output:
[2024-05-11 11:03:14.209] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] strings: /home/admin/oceanbase/etc/observer.conf.bin：无此文件
[2024-05-11 11:03:14.209] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.209] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] –
[2024-05-11 11:03:14.209] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – strings: /home/admin/oceanbase/etc/observer.conf.bin：无此文件
[2024-05-11 11:03:14.209] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.209] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.207 execute: ls /home/admin/oceanbase/.meta
[2024-05-11 11:03:14.236] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 2, error output:
[2024-05-11 11:03:14.236] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] ls: 无法访问/home/admin/oceanbase/.meta: 没有那个文件或目录
[2024-05-11 11:03:14.236] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.237] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] –
[2024-05-11 11:03:14.238] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – ls: 无法访问/home/admin/oceanbase/.meta: 没有那个文件或目录
[2024-05-11 11:03:14.238] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.238] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.207 execute: cat /home/admin/oceanbase/run/obshell.pid
[2024-05-11 11:03:14.305] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 1, error output:
[2024-05-11 11:03:14.305] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] cat: /home/admin/oceanbase/run/obshell.pid: 没有那个文件或目录
[2024-05-11 11:03:14.306] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.306] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.207 execute: strings /home/admin/oceanbase/etc/observer.conf.bin
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 1, error output:
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] strings: /home/admin/oceanbase/etc/observer.conf.bin：无此文件
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] –
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – strings: /home/admin/oceanbase/etc/observer.conf.bin：无此文件
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.437] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.208 execute: ls /home/admin/oceanbase/.meta
[2024-05-11 11:03:14.458] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 2, error output:
[2024-05-11 11:03:14.458] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] ls: 无法访问/home/admin/oceanbase/.meta: 没有那个文件或目录
[2024-05-11 11:03:14.459] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.459] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] –
[2024-05-11 11:03:14.459] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – ls: 无法访问/home/admin/oceanbase/.meta: 没有那个文件或目录
[2024-05-11 11:03:14.459] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.459] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.208 execute: cat /home/admin/oceanbase/run/obshell.pid
[2024-05-11 11:03:14.516] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – exited code 1, error output:
[2024-05-11 11:03:14.516] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] cat: /home/admin/oceanbase/run/obshell.pid: 没有那个文件或目录
[2024-05-11 11:03:14.517] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG]
[2024-05-11 11:03:14.517] [192a2e2a-0f41-11ef-9d6c-000c29d6e9a8] [DEBUG] – admin@192.168.175.208 execute: strings /home/admin/oceanbase/etc/observer.conf.bin

#12

看日志是obshell接管失败，可以升级obd 到obd 2.8.0,obd版本是obd --version看的

#13

[admin@host-209 ~]$ obd --version
OceanBase Deploy: 2.6.2
REVISION: 01acdf3854db484d7443457f3e5bb210c9db6c0f
BUILD_BRANCH: HEAD
BUILD_TIME: Mar 01 2024 17:09:07OURCE
Copyright (C) 2021 OceanBase
License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

#14

[admin@host-209 ~]$ obd --version
OceanBase Deploy: 2.8.0
REVISION: b1bb9f0d1063f0b6fe4c9bd3c2f31bd1a7fd2e14
BUILD_BRANCH: HEAD
BUILD_TIME: Apr 18 2024 19:58:24OURCE
Copyright (C) 2021 OceanBase
License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.

升级 一下，我再试试

#15

obd.zip (100.3 KB)
还是不行 :sweat_smile:

#16

image
image1920×1082 387 KB

ch创建租户资源不足，需要注意一下ob的memory_limit和租户内存相关大小

#17

个人电脑虚拟机上搭建，资源比较小，内存32G，分4台机器，83+181，在集群配置页面datafile_size=15G,logfile_size=24G,memory_limit=8G,system_memory=3G,

Snipaste_2024-05-22_11-08-18
Snipaste_2024-05-22_11-08-181273×841 60.9 KB

请问应该怎么配置资源 ，我才能搭建起来呢？

#18

这里可以设置2G