欧拉2403LTS版本部署OPC失败

OceanBase 技术问题
#1

[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package oceanbase-ce-4.3.2.1-100000102024081217.el7 is available.
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package obproxy-ce-4.3.1.0-4.el7 is available.
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package ocp-server-ce-4.3.1-20240805192406.el7 is available.
±--------------------------------------------------------------------------------------------+
| Packages |
±--------------±--------±-----------------------±-----------------------------------------+
| Repository | Version | Release | Md5 |
±--------------±--------±-----------------------±-----------------------------------------+
| oceanbase-ce | 4.3.2.1 | 100000102024081217.el7 | 8f61ee3cb7c07eed1b2bd5be45085f2451411e96 |
| obproxy-ce | 4.3.1.0 | 4.el7 | 835f4803c1f4da186439323b66c51db4662678a3 |
| ocp-server-ce | 4.3.1 | 20240805192406.el7 | bd4512f9f708fb510d98f245b1be0b03a05e2cba |
±--------------±--------±-----------------------±-----------------------------------------+
Repository integrity check ok
Load param plugin ok
Open ssh connection ok
Generate ocp server configuration ok
Parameter check ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
Initializes ocp-server-ce work home ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository install ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository lib check !!
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository install ok
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository lib check ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository install ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository lib check !!
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Remote oceanbase-ce-libs-4.3.2.1-100000102024081217.el7-679f5aa9c94bd13c0a601c647c285d9837d196d8 repository install ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository lib check ok
Remote openjdk-jre-1.8.0_322-b09.el7-051aa69c5abb8697d15c2f0dcb1392b3f815f7ed repository install ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository lib check ok
my deployed
Search plugins ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-2000: (192.168.20.71) not enough memory. (Free: 15420M, Need: 16946M)
[WARN] OBD-1012: (192.168.20.71) clog and data use the same disk (/)
[WARN] OBD-1012: (192.168.20.103) clog and data use the same disk (/)

cluster scenario: htap
Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Create tenant ocp_meta ok
Create tenant ocp_monitor ok
optimize tenant with scenario: htap ok
Wait for observer init ok
±-------------------------------------------------+
| observer |
±---------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±---------------±--------±-----±------±-------+
| 192.168.20.103 | 4.3.2.1 | 2881 | zone2 | ACTIVE |
| 192.168.20.71 | 4.3.2.1 | 2881 | zone1 | ACTIVE |
±---------------±--------±-----±------±-------+
obclient -h192.168.20.103 -P2881 -uroot -p’xf2024**AA’ -Doceanbase -A

cluster unique id: a72a3694-7200-5aad-90bd-e3c9ad5d50b6-1916d54eb5d-01020304

succeed
Search plugins ok
Load cluster param plugin ok
Check before start obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
±-------------------------------------------------+
| obproxy |
±---------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±---------------±-----±----------------±-------+
| 192.168.20.71 | 2883 | 2884 | active |
| 192.168.20.103 | 2883 | 2884 | active |
±---------------±-----±----------------±-------+
obclient -h192.168.20.71 -P2883 -uroot@proxysys -p’xf2024**AA’ -Doceanbase -A

succeed
Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
Start ocp-server-ce ok
ocp-server-ce program health check ok
[ERROR] ocp-server-ce-py_script_start-4.2.1 RuntimeError: (2013, ‘Lost connection to MySQL server during query’)
[ERROR] ocp-server-ce start failed
Drop tenant ocp_meta ok
Drop tenant ocp_monitor ok

2 个赞
#3

obd.txt (356.5 KB)
obd 日志文件

2 个赞
#4

日志显示集群创建完成了，使用密码登陆时候报错了，看看是不是网络当时有波动或者换个密码试试

2 个赞
#5

显示部署失败 obd 重启报错密码不对 这个密码怎么修改
[root@ha1 ~]# obd cluster start my
Get local repositories ok
Search plugins ok
Load cluster param plugin ok
Open ssh connection ok
Check before start observer ok
Check before start obproxy ok
Check before start ocp-server ok
cluster scenario: htap
Start observer ok
observer program health check ok
obshell program health check ok
Connect to observer 192.168.20.71:2881 ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
[ERROR] ocp-server-ce-py_script_start-4.2.1 RuntimeError: (1045, “Access denied for user ‘root@ocp_meta’@‘192.168.20.71’ (using password: YES)”)
[ERROR] ocp-server-ce start failed
Wait for observer init ok
±-------------------------------------------------+
| observer |
±---------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±---------------±--------±-----±------±-------+
| 192.168.20.103 | 4.3.2.1 | 2881 | zone2 | ACTIVE |
| 192.168.20.71 | 4.3.2.1 | 2881 | zone1 | ACTIVE |
±---------------±--------±-----±------±-------+
obclient -h192.168.20.103 -P2881 -uroot -p’xf2024**AA’ -Doceanbase -A

cluster unique id: 90312c97-a663-59aa-b50f-2ae836a0d870-1916d9483bc-01020304

±-------------------------------------------------+
| obproxy |
±---------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±---------------±-----±----------------±-------+
| 192.168.20.71 | 2883 | 2884 | active |
| 192.168.20.103 | 2883 | 2884 | active |
±---------------±-----±----------------±-------+
obclient -h192.168.20.71 -P2883 -uroot@proxysys -p’wtt27VeCMU’ -Doceanbase -A

See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 6734feb2-5f03-11ef-9d33-5254000d58c3
If you want to view detailed obd logs, please run: obd display-trace 6734feb2-5f03-11ef-9d33-5254000d58c3

2 个赞
#6

是不是之前黑屏化改过密码，黑屏化修改obd是探测不到的。现在的ocp_meta的root租户密码是啥

1 个赞
#7

没有改过密码 会不是是内存不足引起的 我把虚拟机内存调到32G 在试试。

1 个赞
#8

WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package oceanbase-ce-4.3.2.1-100000102024081217.el7 is available.
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package obproxy-ce-4.3.1.0-4.el7 is available.
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package ocp-server-ce-4.3.1-20240805192406.el7 is available.
±--------------------------------------------------------------------------------------------+
| Packages |
±--------------±--------±-----------------------±-----------------------------------------+
| Repository | Version | Release | Md5 |
±--------------±--------±-----------------------±-----------------------------------------+
| oceanbase-ce | 4.3.2.1 | 100000102024081217.el7 | 8f61ee3cb7c07eed1b2bd5be45085f2451411e96 |
| obproxy-ce | 4.3.1.0 | 4.el7 | 835f4803c1f4da186439323b66c51db4662678a3 |
| ocp-server-ce | 4.3.1 | 20240805192406.el7 | bd4512f9f708fb510d98f245b1be0b03a05e2cba |
±--------------±--------±-----------------------±-----------------------------------------+
Repository integrity check ok
Load param plugin ok
Open ssh connection ok
Generate ocp server configuration ok
Parameter check ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
Initializes ocp-server-ce work home ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository install ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository lib check !!
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository install ok
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository lib check ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository install ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository lib check ok
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Remote oceanbase-ce-libs-4.3.2.1-100000102024081217.el7-679f5aa9c94bd13c0a601c647c285d9837d196d8 repository install ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository lib check ok
my deployed
Search plugins ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1012: (192.168.20.71) clog and data use the same disk (/)
[WARN] OBD-1012: (192.168.20.103) clog and data use the same disk (/)

cluster scenario: htap
Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Create tenant ocp_meta ok
Create tenant ocp_monitor ok
optimize tenant with scenario: htap ok
Wait for observer init ok
±-------------------------------------------------+
| observer |
±---------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±---------------±--------±-----±------±-------+
| 192.168.20.103 | 4.3.2.1 | 2881 | zone2 | ACTIVE |
| 192.168.20.71 | 4.3.2.1 | 2881 | zone1 | ACTIVE |
±---------------±--------±-----±------±-------+
obclient -h192.168.20.103 -P2881 -uroot -p’xf2024**AA’ -Doceanbase -A

cluster unique id: 54358466-369c-59c4-8888-f028c3537a8e-19172c138c0-01020304

succeed
Search plugins ok
Load cluster param plugin ok
Check before start obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
±-------------------------------------------------+
| obproxy |
±---------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±---------------±-----±----------------±-------+
| 192.168.20.71 | 2883 | 2884 | active |
| 192.168.20.103 | 2883 | 2884 | active |
±---------------±-----±----------------±-------+
obclient -h192.168.20.71 -P2883 -uroot@proxysys -p’xf2024**AA’ -Doceanbase -A

succeed
Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
Start ocp-server-ce ok
ocp-server-ce program health check ok
[ERROR] ocp-server-ce-py_script_start-4.2.1 RuntimeError: (2013, ‘Lost connection to MySQL server during query’)
[ERROR] ocp-server-ce start failed
Drop tenant ocp_meta ok
Drop tenant ocp_monitor ok
升级内存还是一样报错

#9

还是报错1045 是不是不支持欧拉OPC 2403 ,按装OCP Express 不选择OBConfigServer工具安装就正常 ，选择OBConfigServer工具 就和OPC 报错一样 ，用龙晰的8.9系统 安装opc 很正常

log.txt (41.2 KB)

1 个赞
#10

[2024-08-21 10:35:00.107] [ERROR] ocp-server-ce-py_script_start-4.2.1 RuntimeError: (1045, “Access denied for user ‘root@ocp_meta’@‘192.168.20.71’ (using password: YES)”)

看报错还是密码问题，目前该版本是支持部署的

1 个赞
#11

ocp各个租户的配置内存多少，密码呢
ocp参数的memory_limit和system_memory是多少，可以截图看看

1 个赞
#13

memory_limit参数是要大于system_memory的
建议：
memory_limit=10G，system_memory=2G
ocp的租户都设置为2G试试

#14

image
image756×561 16.1 KB
默认的内存 机器内存32G

#15

这几个租户都该为2G或4G内存
密码不要用*号

#16

好的

#17

OK

#18

[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package oceanbase-ce-4.3.2.1-100000102024081217.el7 is available.
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package obproxy-ce-4.3.1.0-4.el7 is available.
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Package ocp-server-ce-4.3.1-20240805192406.el7 is available.
±--------------------------------------------------------------------------------------------+
| Packages |
±--------------±--------±-----------------------±-----------------------------------------+
| Repository | Version | Release | Md5 |
±--------------±--------±-----------------------±-----------------------------------------+
| oceanbase-ce | 4.3.2.1 | 100000102024081217.el7 | 8f61ee3cb7c07eed1b2bd5be45085f2451411e96 |
| obproxy-ce | 4.3.1.0 | 4.el7 | 835f4803c1f4da186439323b66c51db4662678a3 |
| ocp-server-ce | 4.3.1 | 20240805192406.el7 | bd4512f9f708fb510d98f245b1be0b03a05e2cba |
±--------------±--------±-----------------------±-----------------------------------------+
Repository integrity check ok
Load param plugin ok
Open ssh connection ok
Generate ocp server configuration ok
Parameter check ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
Initializes ocp-server-ce work home ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository install ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository lib check !!
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository install ok
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository lib check ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository install ok
Remote ocp-server-ce-4.3.1-20240805192406.el7-bd4512f9f708fb510d98f245b1be0b03a05e2cba repository lib check ok
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
[WARN] Use centos 7 remote mirror repository for openEuler 24.03
Remote oceanbase-ce-libs-4.3.2.1-100000102024081217.el7-679f5aa9c94bd13c0a601c647c285d9837d196d8 repository install ok
Remote oceanbase-ce-4.3.2.1-100000102024081217.el7-8f61ee3cb7c07eed1b2bd5be45085f2451411e96 repository lib check ok
my deployed
Search plugins ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1012: (192.168.20.71) clog and data use the same disk (/)

cluster scenario: htap
Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Create tenant ocp_meta ok
Create tenant ocp_monitor ok
optimize tenant with scenario: htap ok
Wait for observer init ok
±------------------------------------------------+
| observer |
±--------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±--------------±--------±-----±------±-------+
| 192.168.20.71 | 4.3.2.1 | 2881 | zone1 | ACTIVE |
±--------------±--------±-----±------±-------+
obclient -h192.168.20.71 -P2881 -uroot -p’xf2024++AA’ -Doceanbase -A

cluster unique id: d38f62d9-ec28-5ab6-a30f-8b74d1f5180d-19173cd98d8-01020304

succeed
Search plugins ok
Load cluster param plugin ok
Check before start obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
±------------------------------------------------+
| obproxy |
±--------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±--------------±-----±----------------±-------+
| 192.168.20.71 | 2883 | 2884 | active |
±--------------±-----±----------------±-------+
obclient -h192.168.20.71 -P2883 -uroot@proxysys -p’xf2024++AA’ -Doceanbase -A

succeed
Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
Start ocp-server-ce ok
ocp-server-ce program health check ok
[ERROR] ocp-server-ce-py_script_start-4.2.1 RuntimeError: (2013, ‘Lost connection to MySQL server during query ([Errno 104] Connection reset by peer)’)
[ERROR] ocp-server-ce start failed
Drop tenant ocp_meta ok
Drop tenant ocp_monitor ok
还是报错超时 用欧拉2203 sp3 sp4 部署一下就OK 没有任何报错

#19

[root@ha1 ~]# obd cluster stop my
Get local repositories ok
Search plugins ok
Open ssh connection ok
Stop observer ok
Stop obshell ok
Stop obproxy ok
Stop ocp-server-ce ok
my stopped
Trace ID: 0942140c-5f8f-11ef-baf2-5254000d58c3
If you want to view detailed obd logs, please run: obd display-trace 0942140c-5f8f-11ef-baf2-5254000d58c3
[root@ha1 ~]# obd cluster start my
Get local repositories ok
Search plugins ok
Load cluster param plugin ok
Open ssh connection ok
Check before start observer ok
[WARN] OBD-2000: (192.168.20.71) not enough memory. (Free: 26346M, Need: 27810M)

Check before start obproxy ok
Check before start ocp-server ok
cluster scenario: htap
Start observer ok
observer program health check ok
obshell program health check ok
Connect to observer 192.168.20.71:2881 ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
[ERROR] ocp-server-ce-py_script_start-4.2.1 RuntimeError: (1045, “Access denied for user ‘root@ocp_meta’@‘192.168.20.71’ (using password: YES)”)
[ERROR] ocp-server-ce start failed
Wait for observer init ok
±------------------------------------------------+
| observer |
±--------------±--------±-----±------±-------+
| ip | version | port | zone | status |
±--------------±--------±-----±------±-------+
| 192.168.20.71 | 4.3.2.1 | 2881 | zone1 | ACTIVE |
±--------------±--------±-----±------±-------+
obclient -h192.168.20.71 -P2881 -uroot -p’xf2024++AA’ -Doceanbase -A

cluster unique id: d38f62d9-ec28-5ab6-a30f-8b74d1f5180d-19173cd98d8-01020304

±------------------------------------------------+
| obproxy |
±--------------±-----±----------------±-------+
| ip | port | prometheus_port | status |
±--------------±-----±----------------±-------+
| 192.168.20.71 | 2883 | 2884 | active |
±--------------±-----±----------------±-------+
obclient -h192.168.20.71 -P2883 -uroot@proxysys -p’xf2024++AA’ -Doceanbase -A

See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: 1304e906-5f8f-11ef-9d8b-5254000d58c3
If you want to view detailed obd logs, please run: obd display-trace 1304e906-5f8f-11ef-9d8b-5254000d58c3
还是报错密码错误

#20

欧拉2403 目前没有查到官方明确说明支持文档，按理说是可以安装的
能提供安装期间的obd和ob日志么，这边再帮忙排查下
obd日志： 默认保存在安装obd的用户home路径： cd ~/.obd/log/
observer日志 ：进入/home/admin/myoceanbase/oceanbase/log目录，提取出observer.log或rootservice.log日志

#21

obd.txt (1.7 MB)
observer.zip (8.6 MB)

#22

欧拉2403安装ocpex 没问题 完整版云平台就是不行