按文档标准安装后,启动失败,操作系统openEuler 22.03 ,文档问题

感谢您的反馈。既然您已经使用 root 用户进行安装和启动,但仍然遇到问题,我们可以进一步排查一些常见的问题和解决方案。

详细排查步骤

  1. 检查日志文件
    查看详细的日志文件,特别是 oceanbase 的日志文件,以获取更多关于启动失败的详细信息。

    tail -f /home/admin/oceanbase/log_obshell/*.log
    
  2. 检查配置文件
    确认 /etc/oceanbase.cnf 配置文件中的各项设置是否正确。特别是以下几点:

    • data_dirredo_dir 是否指向正确的目录。
    • server_ip 是否正确设置为当前服务器的 IP 地址。
    • cluster_namezone_name 是否正确设置。
  3. 检查端口占用情况
    确认 OceanBase 所需的端口是否被其他服务占用。

    netstat -tunlp | grep 2881
    netstat -tunlp | grep 2882
    netstat -tunlp | grep 2883
    netstat -tunlp | grep 2884
    
  4. 检查依赖项
    确认所有必要的依赖项是否已安装。您可以使用以下命令检查依赖项:

    rpm -q libaio numactl
    
  5. 手动启动
    尝试手动启动 observer 进程,以查看是否有更详细的错误信息。

    /home/admin/oceanbase/bin/observer -c /home/admin/oceanbase/etc/observer.ini
    
  6. 检查 SELinux 设置
    如果您的系统启用了 SELinux,可能会导致权限问题。您可以临时禁用 SELinux 进行测试:

    setenforce 0
    
  7. 检查防火墙设置
    确认防火墙没有阻止 OceanBase 所需的端口。

    firewall-cmd --list-all
    

示例命令

  1. 查看日志文件

    tail -f /home/admin/oceanbase/log_obshell/*.log
    
  2. 检查配置文件

    cat /etc/oceanbase.cnf
    
  3. 检查端口占用情况

    netstat -tunlp | grep 2881
    netstat -tunlp | grep 2882
    netstat -tunlp | grep 2883
    netstat -tunlp | grep 2884
    
  4. 检查依赖项

    rpm -q libaio numactl
    
  5. 手动启动

    /home/admin/oceanbase/bin/observer -c /home/admin/oceanbase/etc/observer.ini
    
  6. 检查 SELinux 设置

    setenforce 0
    
  7. 检查防火墙设置

    firewall-cmd --list-all
    

参考文档

  • [2] 提到了安装和启动过程中的常见问题和解决方案。
  • [5] 提到了环境和配置检查的详细步骤。

希望这些步骤能够帮助您解决问题。如果问题仍然存在,请提供更多的日志信息,以便进一步诊断。

更多信息请查看:

  1. 撤销角色中的权限
  2. 撤销权限
  3. ALTER TENANT
  4. CANCEL RESTORE
  5. RESTORE
  6. CANCEL CLONE
  7. CANCEL TRANSFER PARTITION
  8. CANCEL BALANCE JOB
  9. (可选)配置时钟源
  10. CREATE TENANT

(小助手的答复已结束,如未能解决您的问题,请继续提问并等待其他同学的回复,谢谢!)

1 个赞

如你所说,与什么工具确实没关系。但按我的理解,如果是标准化安装,一个全新的干净环境,符合安装要求,按文档步骤一步步,启动都失败的话,就会感受很不好,会怀疑写这个文档的人根本没在这个文档所述的环境里实际验证过。

最后报错信息也根本没法很直接看到,就是个失败了。 我想找报错关键字去搜索也根本不知道搜什么,入门就很不友好。

于是只能来发帖啦。 不知道下一步怎么排查

@linguanren

1 个赞

确实很对,写的systemd这一块的安装的报错显示其实设计的很差
不过验证是有的,只不过我们的环境比较“友好”

回到“最后报错信息也根本没法很直接看到”这个问题:
其实这个确实有一定的困难与局限性
比如如果observer在报错,要从几百个报错中找到最关键或者是根本原因的报错是非常困难的,现阶段只有研发看才是能解决的
这也是现在开源相比商业服务所欠缺的部分。

回到你这次安装本身:
你可以先卸载掉之前的,把安装目录清空,或者是整个新环境部署一下oceanbase
仅仅就部署一次即可,然后将systemctl -u oceanbase的结果发到这里,我会帮你继续排查

2 个赞

感谢感谢

附件为打包的日志
euler_log.tar.gz (19.3 MB)

全新的系统环境以及安装部署操作步骤如下

[root@euler157 ~]# 
[root@euler157 ~]# cat /etc/os-release 
NAME="openEuler"
VERSION="22.03 (LTS-SP2)"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 (LTS-SP2)"
ANSI_COLOR="0;31"

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# uname -ra
Linux euler157.local 5.10.0-153.56.0.134.oe2203sp2.x86_64 #1 SMP Wed May 29 14:04:28 CST 2024 x86_64 x86_64 x86_64 GNU/Linux
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status firewalld
○ firewalld.service - firewalld - dynamic firewall daemon
     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
     Active: inactive (dead) since Fri 2024-10-18 11:46:09 CST; 38s ago
       Docs: man:firewalld(1)
    Process: 1000 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)
   Main PID: 1000 (code=exited, status=0/SUCCESS)

10月 16 11:15:42 euler157.local systemd[1]: Starting firewalld - dynamic firewall daemon...
10月 16 11:15:44 euler157.local systemd[1]: Started firewalld - dynamic firewall daemon.
10月 18 11:46:09 euler157.local systemd[1]: Stopping firewalld - dynamic firewall daemon...
10月 18 11:46:09 euler157.local systemd[1]: firewalld.service: Deactivated successfully.
10月 18 11:46:09 euler157.local systemd[1]: Stopped firewalld - dynamic firewall daemon.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# iptables -L -vn
Chain INPUT (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         

Chain OUTPUT (policy ACCEPT 0 packets, 0 bytes)
 pkts bytes target     prot opt in     out     source               destination         
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# getenforce 
Permissive
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# netstat -tunlp
-bash: netstat:未找到命令
[root@euler157 ~]# 
[root@euler157 ~]# yum install net-tools
Last metadata expiration check: 0:01:27 ago on 2024年10月18日 星期五 11时46分10秒.
Dependencies resolved.
========================================================================================================================================================
 Package                             Architecture                     Version                                     Repository                       Size
========================================================================================================================================================
Installing:
 net-tools                           x86_64                           2.10-3.oe2203sp2                            local                           199 k

Transaction Summary
========================================================================================================================================================
Install  1 Package

Total size: 199 k
Installed size: 881 k
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                1/1 
  Installing       : net-tools-2.10-3.oe2203sp2.x86_64                                                                                              1/1 
  Running scriptlet: net-tools-2.10-3.oe2203sp2.x86_64                                                                                              1/1 
  Verifying        : net-tools-2.10-3.oe2203sp2.x86_64                                                                                              1/1 

Installed:
  net-tools-2.10-3.oe2203sp2.x86_64                                                                                                                     

Complete!
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1029/sshd: /usr/sbi 
tcp6       0      0 :::22                   :::*                    LISTEN      1029/sshd: /usr/sbi 
udp        0      0 127.0.0.1:323           0.0.0.0:*                           993/chronyd         
udp6       0      0 ::1:323                 :::*                                993/chronyd         
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# groupadd admin
[root@euler157 ~]# useradd -g admin admin
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# ls -al /home/
总用量 12
drwxr-xr-x.  3 root  root  4096 10月 18 11:48 .
dr-xr-xr-x. 19 root  root  4096  9月 28 21:14 ..
drwx------.  2 admin admin 4096 10月 18 11:48 admin
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# yum install oceanbase-ce oceanbase-ce-libs obclient
Last metadata expiration check: 0:02:20 ago on 2024年10月18日 星期五 11时46分10秒.
Dependencies resolved.
========================================================================================================================================================
 Package                               Architecture               Version                                               Repository                 Size
========================================================================================================================================================
Installing:
 obclient                              x86_64                     2.2.6-1.el7                                           local                      11 M
 oceanbase-ce                          x86_64                     4.3.3.0-100000142024101215.el7                        local                     138 M
 oceanbase-ce-libs                     x86_64                     4.3.3.0-100000142024101215.el7                        local                     155 k
Installing dependencies:
 jq                                    x86_64                     1.6-2.oe2203sp2                                       local                     167 k
 oniguruma                             x86_64                     6.9.6-1.oe2203sp2                                     local                     160 k

Transaction Summary
========================================================================================================================================================
Install  5 Packages

Total size: 150 M
Installed size: 747 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                1/1 
  Installing       : oniguruma-6.9.6-1.oe2203sp2.x86_64                                                                                             1/5 
  Installing       : jq-1.6-2.oe2203sp2.x86_64                                                                                                      2/5 
  Running scriptlet: jq-1.6-2.oe2203sp2.x86_64                                                                                                      2/5 
  Installing       : oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64                                                                        3/5 
  Running scriptlet: oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                                             4/5 
execute pre install script

  Installing       : oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                                             4/5 
  Running scriptlet: oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                                             4/5 
execute post install script
To configure OceanBase : edit /etc/oceanbase.cnf
To start OceanBase     : systemctl start oceanbase
To enable OceanBase auto reboot  : systemctl enable oceanbase
To get more infomation : https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000640297

  Running scriptlet: obclient-2.2.6-1.el7.x86_64                                                                                                    5/5 
  Installing       : obclient-2.2.6-1.el7.x86_64                                                                                                    5/5 
  Running scriptlet: obclient-2.2.6-1.el7.x86_64                                                                                                    5/5 
  Verifying        : jq-1.6-2.oe2203sp2.x86_64                                                                                                      1/5 
  Verifying        : obclient-2.2.6-1.el7.x86_64                                                                                                    2/5 
  Verifying        : oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                                             3/5 
  Verifying        : oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64                                                                        4/5 
  Verifying        : oniguruma-6.9.6-1.oe2203sp2.x86_64                                                                                             5/5 

Installed:
  jq-1.6-2.oe2203sp2.x86_64                                  obclient-2.2.6-1.el7.x86_64           oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64   
  oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64    oniguruma-6.9.6-1.oe2203sp2.x86_64   

Complete!
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# cat /etc/oceanbase.cnf 
# The IP can only be configured during the initial startup.
# By default, the IP is set to the output of hostname -i unless specified otherwise.
# To modify the observer IP after startup, you must uninstall OceanBase and remove the data directory.
# Afterward, you can reinstall and launch OceanBase with the new IP address.
# For instance, to set the observer IP to 127.0.0.1, you would use the line:
# ip=127.0.0.1
mysql_port=2881
rpc_port=2882
obshell_port=2886
root_pwd=""
redo_dir=/var/lib/oceanbase/redo
data_dir=/var/lib/oceanbase/data
datafile_size=2G
datafile_next=2G
datafile_maxsize=20G
cpu_count=16
memory_limit=6G
system_memory=1G
log_disk_size=13G
enable_syslog_wf=false
enable_syslog_recycle=true
max_syslog_file_count=4
__min_full_resource_pool_memory=1073741824
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase
○ oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: inactive (dead)

10月 18 11:49:18 euler157.local systemd[1]: /etc/systemd/system/oceanbase.service:7: Unit configured to use KillMode=none. This is unsafe, as it disabl>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# cd /home/admin/
[root@euler157 admin]# ls -al
总用量 24
drwx------. 3 admin admin 4096 10月 18 11:48 .
drwxr-xr-x. 3 root  root  4096 10月 18 11:48 ..
-rw-r--r--. 1 admin admin   75  6月 28  2023 .bash_logout
-rw-r--r--. 1 admin admin   71  6月 28  2023 .bash_profile
-rw-r--r--. 1 admin admin  138  6月 28  2023 .bashrc
drwxr-xr-x. 7 root  root  4096 10月 18 11:48 oceanbase
[root@euler157 admin]# 
[root@euler157 admin]# 
[root@euler157 admin]# chown -R admin:admin /home/admin/oceanbase
[root@euler157 admin]# 
[root@euler157 admin]# 
[root@euler157 admin]# 
[root@euler157 admin]# ls -al
总用量 24
drwx------. 3 admin admin 4096 10月 18 11:48 .
drwxr-xr-x. 3 root  root  4096 10月 18 11:48 ..
-rw-r--r--. 1 admin admin   75  6月 28  2023 .bash_logout
-rw-r--r--. 1 admin admin   71  6月 28  2023 .bash_profile
-rw-r--r--. 1 admin admin  138  6月 28  2023 .bashrc
drwxr-xr-x. 7 admin admin 4096 10月 18 11:48 oceanbase
[root@euler157 admin]# 
[root@euler157 admin]# 
[root@euler157 admin]# 
[root@euler157 admin]# 
[root@euler157 admin]# cd
[root@euler157 ~]# 
[root@euler157 ~]# free -h
               total        used        free      shared  buff/cache   available
Mem:           7.3Gi       441Mi       4.7Gi       8.7Mi       2.5Gi       6.8Gi
Swap:          4.0Gi          0B       4.0Gi
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl start oceanbase
Job for oceanbase.service failed because the control process exited with error code.
See "systemctl status oceanbase.service" and "journalctl -xeu oceanbase.service" for details.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:00 CST; 3s ago
Cntrl PID: 6440 (bash)
      Tasks: 419 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 6440 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 6994 sleep 6

10月 18 11:52:00 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:00 euler157.local bash[6440]: oceanbase service started at 2024-10-18 11:52:00
10月 18 11:52:02 euler157.local bash[6440]: change etc owner to root
10月 18 11:52:02 euler157.local bash[6440]: daemon process with PID 5831 is running.
10月 18 11:52:02 euler157.local bash[6440]: The agent service is exist
10月 18 11:52:02 euler157.local bash[6440]: The observer is already bootstrap, please start it immediately
10月 18 11:52:02 euler157.local bash[6440]: the start observer trace id is 23232261533028865
10月 18 11:52:02 euler157.local bash[6440]: the response state is READY
10月 18 11:52:02 euler157.local bash[6440]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:00 CST; 6s ago
Cntrl PID: 6440 (bash)
      Tasks: 419 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 6440 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 6994 sleep 6

10月 18 11:52:00 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:00 euler157.local bash[6440]: oceanbase service started at 2024-10-18 11:52:00
10月 18 11:52:02 euler157.local bash[6440]: change etc owner to root
10月 18 11:52:02 euler157.local bash[6440]: daemon process with PID 5831 is running.
10月 18 11:52:02 euler157.local bash[6440]: The agent service is exist
10月 18 11:52:02 euler157.local bash[6440]: The observer is already bootstrap, please start it immediately
10月 18 11:52:02 euler157.local bash[6440]: the start observer trace id is 23232261533028865
10月 18 11:52:02 euler157.local bash[6440]: the response state is READY
10月 18 11:52:02 euler157.local bash[6440]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 11:52:09 CST; 399ms ago
    Process: 6440 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 417 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 11:52:09 CST; 3s ago
    Process: 6440 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 417 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 11:52:09 CST; 5s ago
    Process: 6440 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 417 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 11:52:09 CST; 7s ago
    Process: 6440 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 417 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:19 CST; 486ms ago
Cntrl PID: 7011 (bash)
      Tasks: 420 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 7011 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             ├─ 7017 /bin/bash /home/admin/oceanbase/profile/telemetry.sh 3 10
             └─ 7126 "[bash]"

10月 18 11:52:19 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:19 euler157.local bash[7011]: oceanbase service started at 2024-10-18 11:52:19
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:19 CST; 2s ago
Cntrl PID: 7011 (bash)
      Tasks: 418 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 7011 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 7563 "[curl]"

10月 18 11:52:19 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:19 euler157.local bash[7011]: oceanbase service started at 2024-10-18 11:52:19
10月 18 11:52:21 euler157.local bash[7011]: change etc owner to root
10月 18 11:52:21 euler157.local bash[7011]: daemon process with PID 5831 is running.
10月 18 11:52:21 euler157.local bash[7011]: The agent service is exist
10月 18 11:52:21 euler157.local bash[7011]: The observer is already bootstrap, please start it immediately
10月 18 11:52:21 euler157.local bash[7011]: the start observer trace id is 23232261533028866
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:19 CST; 4s ago
Cntrl PID: 7011 (bash)
      Tasks: 418 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 7011 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 7569 sleep 6

10月 18 11:52:19 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:19 euler157.local bash[7011]: oceanbase service started at 2024-10-18 11:52:19
10月 18 11:52:21 euler157.local bash[7011]: change etc owner to root
10月 18 11:52:21 euler157.local bash[7011]: daemon process with PID 5831 is running.
10月 18 11:52:21 euler157.local bash[7011]: The agent service is exist
10月 18 11:52:21 euler157.local bash[7011]: The observer is already bootstrap, please start it immediately
10月 18 11:52:21 euler157.local bash[7011]: the start observer trace id is 23232261533028866
10月 18 11:52:21 euler157.local bash[7011]: the response state is READY
10月 18 11:52:21 euler157.local bash[7011]: wait 6s and the retry
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:19 CST; 5s ago
Cntrl PID: 7011 (bash)
      Tasks: 418 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 7011 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 7569 sleep 6

10月 18 11:52:19 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:19 euler157.local bash[7011]: oceanbase service started at 2024-10-18 11:52:19
10月 18 11:52:21 euler157.local bash[7011]: change etc owner to root
10月 18 11:52:21 euler157.local bash[7011]: daemon process with PID 5831 is running.
10月 18 11:52:21 euler157.local bash[7011]: The agent service is exist
10月 18 11:52:21 euler157.local bash[7011]: The observer is already bootstrap, please start it immediately
10月 18 11:52:21 euler157.local bash[7011]: the start observer trace id is 23232261533028866
10月 18 11:52:21 euler157.local bash[7011]: the response state is READY
10月 18 11:52:21 euler157.local bash[7011]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 


1 个赞

刚才字数限制,补充查看信息如下

[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 11:52:19 CST; 8s ago
Cntrl PID: 7011 (bash)
      Tasks: 418 (limit: 47367)
     Memory: 1.9G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
             ├─ 7011 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 7569 sleep 6

10月 18 11:52:19 euler157.local systemd[1]: Starting oceanbase...
10月 18 11:52:19 euler157.local bash[7011]: oceanbase service started at 2024-10-18 11:52:19
10月 18 11:52:21 euler157.local bash[7011]: change etc owner to root
10月 18 11:52:21 euler157.local bash[7011]: daemon process with PID 5831 is running.
10月 18 11:52:21 euler157.local bash[7011]: The agent service is exist
10月 18 11:52:21 euler157.local bash[7011]: The observer is already bootstrap, please start it immediately
10月 18 11:52:21 euler157.local bash[7011]: the start observer trace id is 23232261533028866
10月 18 11:52:21 euler157.local bash[7011]: the response state is READY
10月 18 11:52:21 euler157.local bash[7011]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# journalctl -xeu oceanbase.service
░░ 
░░ The process' exit code is 'exited' and its exit status is 1.
10月 18 11:52:27 euler157.local systemd[1]: oceanbase.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ The unit oceanbase.service has entered the 'failed' state with result 'exit-code'.
10月 18 11:52:27 euler157.local systemd[1]: oceanbase.service: Unit process 5831 (obshell) remains running after unit stopped.
10月 18 11:52:27 euler157.local systemd[1]: oceanbase.service: Unit process 5852 (obshell) remains running after unit stopped.
10月 18 11:52:27 euler157.local systemd[1]: oceanbase.service: Unit process 5946 (observer) remains running after unit stopped.
10月 18 11:52:27 euler157.local systemd[1]: Failed to start oceanbase.
░░ Subject: oceanbase.service 单元已失败
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ oceanbase.service 单元已失败。
░░ 
░░ 结果为“failed”。
10月 18 11:52:37 euler157.local systemd[1]: oceanbase.service: Scheduled restart job, restart counter is at 3.
░░ Subject: Automatic restarting of a unit has been scheduled
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ Automatic restarting of the unit oceanbase.service has been scheduled, as the result for
░░ the configured Restart= setting for the unit.
10月 18 11:52:37 euler157.local systemd[1]: Stopped oceanbase.
░░ Subject: oceanbase.service 单元已结束停止操作
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ oceanbase.service 单元已结束停止操作。
10月 18 11:52:37 euler157.local systemd[1]: oceanbase.service: Found left-over process 5831 (obshell) in control group while starting unit. Ignoring.
10月 18 11:52:37 euler157.local systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
10月 18 11:52:37 euler157.local systemd[1]: oceanbase.service: Found left-over process 5852 (obshell) in control group while starting unit. Ignoring.
10月 18 11:52:37 euler157.local systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
10月 18 11:52:37 euler157.local systemd[1]: oceanbase.service: Found left-over process 5946 (observer) in control group while starting unit. Ignoring.
10月 18 11:52:37 euler157.local systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
10月 18 11:52:37 euler157.local systemd[1]: Starting oceanbase...
░░ Subject: oceanbase.service 单元已开始启动
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░ 
░░ oceanbase.service 单元已开始启动。
10月 18 11:52:37 euler157.local bash[7580]: oceanbase service started at 2024-10-18 11:52:37
10月 18 11:52:40 euler157.local bash[7580]: change etc owner to root
10月 18 11:52:40 euler157.local bash[7580]: daemon process with PID 5831 is running.
10月 18 11:52:40 euler157.local bash[7580]: The agent service is exist
10月 18 11:52:40 euler157.local bash[7580]: The observer is already bootstrap, please start it immediately
10月 18 11:52:40 euler157.local bash[7580]: the start observer trace id is 23232261533028867
10月 18 11:52:40 euler157.local bash[7580]: the response state is RUNNING
10月 18 11:52:40 euler157.local bash[7580]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl -u oceanbase
systemctl: invalid option -- 'u'
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# cd /home/
[root@euler157 home]# cd admin/
[root@euler157 admin]# ls
oceanbase
[root@euler157 admin]# cd oceanbase/
[root@euler157 oceanbase]# ls -al
总用量 412
drwxr-xr-x. 13 admin admin   4096 10月 18 11:53 .
drwx------.  3 admin admin   4096 10月 18 11:48 ..
drwxr-xr-x.  2 admin admin   4096 10月 18 11:48 admin
drwxr-xr-x.  2 root  root    4096 10月 18 11:50 audit
drwxr-sr-x.  2 admin admin   4096 10月 18 11:48 bin
drwxr-sr-x.  2 root  root    4096 10月 18 11:51 etc
drwxr-xr-x.  2 root  root    4096 10月 18 11:51 etc2
drwxr-xr-x.  2 root  root    4096 10月 18 11:51 etc3
drwxr-sr-x.  2 admin admin   4096 10月 18 11:48 lib
drwxr-xr-x.  3 root  root    4096 10月 18 11:50 log
drwxr-xr-x.  2 root  root    4096 10月 18 11:50 log_obshell
-rw-r--r--.  1 root  root  364544 10月 18 11:53 .meta
drwxr-sr-x.  2 admin admin   4096 10月 18 11:53 profile
drwxr-xr-x.  2 root  root    4096 10月 18 11:51 run
lrwxrwxrwx.  1 root  root      23 10月 18 11:50 store -> /var/lib/oceanbase/data
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# cd log
[root@euler157 log]# ls
alert  election.log  election.log.wf  observer.log  observer.log.wf  rootservice.log  rootservice.log.wf  trace.log
[root@euler157 log]# ls -al
总用量 226528
drwxr-xr-x.  3 root  root      4096 10月 18 11:50 .
drwxr-xr-x. 13 admin admin     4096 10月 18 11:53 ..
drwxr-xr-x.  2 root  root      4096 10月 18 11:50 alert
-rw-r--r--.  1 root  root    383139 10月 18 11:53 election.log
-rw-r--r--.  1 root  root         0 10月 18 11:50 election.log.wf
-rw-r--r--.  1 root  root  93467313 10月 18 11:53 observer.log
-rw-r--r--.  1 root  root         0 10月 18 11:50 observer.log.wf
-rw-r--r--.  1 root  root  55787956 10月 18 11:53 rootservice.log
-rw-r--r--.  1 root  root         0 10月 18 11:50 rootservice.log.wf
-rw-r--r--.  1 root  root  82302747 10月 18 11:51 trace.log
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# ls -al
总用量 227240
drwxr-xr-x.  3 root  root      4096 10月 18 11:50 .
drwxr-xr-x. 13 admin admin     4096 10月 18 11:53 ..
drwxr-xr-x.  2 root  root      4096 10月 18 11:50 alert
-rw-r--r--.  1 root  root    390902 10月 18 11:53 election.log
-rw-r--r--.  1 root  root         0 10月 18 11:50 election.log.wf
-rw-r--r--.  1 root  root  94133487 10月 18 11:53 observer.log
-rw-r--r--.  1 root  root         0 10月 18 11:50 observer.log.wf
-rw-r--r--.  1 root  root  55845021 10月 18 11:53 rootservice.log
-rw-r--r--.  1 root  root         0 10月 18 11:50 rootservice.log.wf
-rw-r--r--.  1 root  root  82302747 10月 18 11:51 trace.log
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# 
[root@euler157 log]# cd ..
[root@euler157 oceanbase]# ls
admin  audit  bin  etc  etc2  etc3  lib  log  log_obshell  profile  run  store
[root@euler157 oceanbase]# tar zcvf euler_log.tar.gz log
log/
log/trace.log
log/observer.log
tar: log/observer.log: 在我们读入文件时文件发生了变化
log/alert/
log/alert/alert.log
log/election.log
log/election.log.wf
log/rootservice.log
tar: log/rootservice.log: 在我们读入文件时文件发生了变化
log/rootservice.log.wf
log/observer.log.wf
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# du -sh euler_log.tar.gz 
20M	euler_log.tar.gz
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# 
[root@euler157 oceanbase]# 
1 个赞

10月 18 11:52:19 euler157.local systemd[1]: Starting oceanbase…
10月 18 11:52:19 euler157.local bash[7011]: oceanbase service started at 2024-10-18 11:52:19
10月 18 11:52:21 euler157.local bash[7011]: change etc owner to root
10月 18 11:52:21 euler157.local bash[7011]: daemon process with PID 5831 is running.
10月 18 11:52:21 euler157.local bash[7011]: The agent service is exist
10月 18 11:52:21 euler157.local bash[7011]: The observer is already bootstrap, please start it immediately
10月 18 11:52:21 euler157.local bash[7011]: the start observer trace id is 23232261533028866
10月 18 11:52:21 euler157.local bash[7011]: the response state is READY
10月 18 11:52:21 euler157.local bash[7011]: wait 6s and the retry

这个后面还有吗,想看报错前的最后一个trace id

1 个赞

不过这个理论上也是最后一个了

curl -XGET --unix-socket /home/admin/oceanbase/run/obshell.sock http://localhost/api/v1/task/dag/23232261533028866 | jq

执行一下发出来

1 个赞
[root@euler157 ~]# 
[root@euler157 ~]# curl -XGET --unix-socket /home/admin/oceanbase/run/obshell.sock http://localhost/api/v1/task/dag/23232261533028866 | jq
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  4082    0  4082    0     0   786k      0 --:--:-- --:--:-- --:--:-- 1328k
{
  "successful": true,
  "timestamp": "2024-10-18T12:49:15.877531938+08:00",
  "duration": 2,
  "status": 200,
  "traceId": "86d6d750460e7975",
  "data": {
    "id": "23232261533028866",
    "dag_id": 6,
    "name": "Start OB",
    "stage": 2,
    "max_stage": 6,
    "state": "FAILED",
    "operator": "RUN",
    "start_time": "2024-10-18T11:52:22.353988791+08:00",
    "end_time": "2024-10-18T11:52:25.376142784+08:00",
    "additional_data": {},
    "nodes": [
      {
        "id": "232322615330288622",
        "node_id": 22,
        "name": "Inform all agents to start observer",
        "state": "SUCCEED",
        "operator": "RUN",
        "start_time": "2024-10-18T11:52:22.356450382+08:00",
        "end_time": "2024-10-18T11:52:23.362314245+08:00",
        "additional_data": null,
        "sub_tasks": [
          {
            "id": "232322615330288622",
            "task_id": 22,
            "name": "Inform all agents to start observer",
            "state": "SUCCEED",
            "operator": "RUN",
            "start_time": "2024-10-18T11:52:22.360671363+08:00",
            "end_time": "2024-10-18T11:52:22.365712005+08:00",
            "additional_data": null,
            "execute_times": 1,
            "execute_agent": {
              "ip": "192.168.101.157",
              "port": 2886
            },
            "task_logs": [
              "Inform 192.168.101.157:2886 to create the task",
              "ERROR: OcsAgentError: code = 1010, message = Known error: agent is under maintenance"
            ]
          }
        ]
      },
      {
        "id": "232322615330288623",
        "node_id": 23,
        "name": "Make sure all agents are ready",
        "state": "FAILED",
        "operator": "RUN",
        "start_time": "2024-10-18T11:52:24.367748826+08:00",
        "end_time": "2024-10-18T11:52:25.373802645+08:00",
        "additional_data": null,
        "sub_tasks": [
          {
            "id": "232322615330288623",
            "task_id": 23,
            "name": "Make sure all agents are ready",
            "state": "FAILED",
            "operator": "RUN",
            "start_time": "2024-10-18T11:52:24.372044068+08:00",
            "end_time": "2024-10-18T11:52:24.374305674+08:00",
            "additional_data": null,
            "execute_times": 1,
            "execute_agent": {
              "ip": "192.168.101.157",
              "port": 2886
            },
            "task_logs": [
              "ERROR: check sub dag created failed: Not all tasks created. main dag failed"
            ]
          }
        ]
      },
      {
        "id": "232322615330288624",
        "node_id": 24,
        "name": "Advance agents to execute the task",
        "state": "PENDING",
        "operator": "RUN",
        "start_time": "2024-10-18T11:52:21.601423297+08:00",
        "end_time": "2024-10-18T11:52:21.601423297+08:00",
        "additional_data": null,
        "sub_tasks": [
          {
            "id": "232322615330288624",
            "task_id": 24,
            "name": "Advance agents to execute the task",
            "state": "PENDING",
            "operator": "RUN",
            "start_time": "2024-10-18T11:52:21.60150983+08:00",
            "end_time": "2024-10-18T11:52:21.60150983+08:00",
            "additional_data": null,
            "execute_times": 0,
            "execute_agent": {
              "ip": "192.168.101.157",
              "port": 2886
            },
            "task_logs": null
          }
        ]
      },
      {
        "id": "232322615330288625",
        "node_id": 25,
        "name": "Wait for all agents to execute tasks successfully",
        "state": "PENDING",
        "operator": "RUN",
        "start_time": "2024-10-18T11:52:21.601609925+08:00",
        "end_time": "2024-10-18T11:52:21.601609925+08:00",
        "additional_data": null,
        "sub_tasks": [
          {
            "id": "232322615330288625",
            "task_id": 25,
            "name": "Wait for all agents to execute tasks successfully",
            "state": "PENDING",
            "operator": "RUN",
            "start_time": "2024-10-18T11:52:21.601693682+08:00",
            "end_time": "2024-10-18T11:52:21.601693682+08:00",
            "additional_data": null,
            "execute_times": 0,
            "execute_agent": {
              "ip": "192.168.101.157",
              "port": 2886
            },
            "task_logs": null
          }
        ]
      },
      {
        "id": "232322615330288626",
        "node_id": 26,
        "name": "Start Zone",
        "state": "PENDING",
        "operator": "RUN",
        "start_time": "2024-10-18T11:52:21.601803455+08:00",
        "end_time": "2024-10-18T11:52:21.601803455+08:00",
        "additional_data": null,
        "sub_tasks": [
          {
            "id": "232322615330288626",
            "task_id": 26,
            "name": "Start Zone",
            "state": "PENDING",
            "operator": "RUN",
            "start_time": "2024-10-18T11:52:21.601910835+08:00",
            "end_time": "2024-10-18T11:52:21.601910835+08:00",
            "additional_data": null,
            "execute_times": 0,
            "execute_agent": {
              "ip": "192.168.101.157",
              "port": 2886
            },
            "task_logs": null
          }
        ]
      },
      {
        "id": "232322615330288627",
        "node_id": 27,
        "name": "Inform all agents to end the task",
        "state": "PENDING",
        "operator": "RUN",
        "start_time": "2024-10-18T11:52:21.602004081+08:00",
        "end_time": "2024-10-18T11:52:21.602004081+08:00",
        "additional_data": null,
        "sub_tasks": [
          {
            "id": "232322615330288627",
            "task_id": 27,
            "name": "Inform all agents to end the task",
            "state": "PENDING",
            "operator": "RUN",
            "start_time": "2024-10-18T11:52:21.602083404+08:00",
            "end_time": "2024-10-18T11:52:21.602083404+08:00",
            "additional_data": null,
            "execute_times": 0,
            "execute_agent": {
              "ip": "192.168.101.157",
              "port": 2886
            },
            "task_logs": null
          }
        ]
      }
    ]
  }
}
[root@euler157 ~]# 
[root@euler157 ~]# 

这我只能呼个同事了,这是下面的组件在报错

您好,请辛苦执行下/home/admin/oceanbase/bin/obshell task show 看下,应该会显示有未完成的任务,然后可以 执行下 /home/admin/oceanbase/bin/obshell task show -i ${id} -d 看下任务详细,辛苦贴个截图。并且请提供下 /home/admin/oceanbase/log_obshell 下的日志文件。非常感谢!

第一个命令 太多了,我列了刚开始的3个详情


[root@euler157 ~]# /home/admin/oceanbase/bin/obshell task show -i 23232261533028864 -d
Check and start obshell daemon 
Get task 23232261533028864 detail 
id: 23232261533028864
dag_id: 4
name: Initialize cluster
stage: 11
max_stage: 12
state: FAILED
operator: RUN
start_time: 2024-10-18T11:50:19.701653523+08:00
end_time: 2024-10-18T11:51:48.298330768+08:00
nodes:
  id: 23232261533028864
  node_id: 4
  name: Integrate config
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:50:19.704132673+08:00
  end_time: 2024-10-18T11:50:20.710221488+08:00
  subtasks:
    id: 23232261533028864
    task_id: 4
    name: Integrate config
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:50:19.70825089+08:00
    end_time: 2024-10-18T11:50:19.73362144+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - get all agents
    - get global config
    - init all zone config
    - build zone1 zone config
    - merge zone1 zone config
    - Integrating 192.168.101.157:2886 agent config
    - get 192.168.101.157:2886 agent config
    - merge 192.168.101.157:2886 agent config
    - fill 192.168.101.157:2886 agent config
    - setting bootstrap config
  id: 23232261533028865
  node_id: 5
  name: Create observer workdir
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:50:21.774178271+08:00
  end_time: 2024-10-18T11:50:22.780055951+08:00
  subtasks:
    id: 23232261533028865
    task_id: 5
    name: Create observer workdir
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:50:21.778461943+08:00
    end_time: 2024-10-18T11:50:21.798341067+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - 'mkdir data_dir: /var/lib/oceanbase/data'
    - 'mkdir redo_dir: /var/lib/oceanbase/redo'
    - 'mkdir clog_dir: /var/lib/oceanbase/redo/clog'
    - 'mkdir slog_dir: /var/lib/oceanbase/data/slog'
    - 'symlink /var/lib/oceanbase/data: /home/admin/oceanbase/store'
    - 'symlink /var/lib/oceanbase/redo: /home/admin/oceanbase/store'
    - 'symlink /var/lib/oceanbase/redo/clog: /home/admin/oceanbase/store/clog'
    - 'symlink /var/lib/oceanbase/data/slog: /home/admin/oceanbase/store/slog'
    - mkdir /home/admin/oceanbase/etc
    - mkdir /home/admin/oceanbase/log
    - mkdir /home/admin/oceanbase/store/sstable
  id: 23232261533028866
  node_id: 6
  name: Start observer
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:50:23.842502661+08:00
  end_time: 2024-10-18T11:50:26.851836037+08:00
  subtasks:
    id: 23232261533028866
    task_id: 6
    name: Start observer
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:50:23.847651355+08:00
    end_time: 2024-10-18T11:50:26.127059184+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - start observer
    - check if first start
    - generate start cmd
    - 'start cmd: export LD_LIBRARY_PATH=''/home/admin/oceanbase/lib''; /home/admin/oceanbase/bin/observer  -n
      ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P
      2882  -o ''max_syslog_file_count=4,__min_full_resource_pool_memory=1073741824,cpu_count=16,datafile_next=2G,datafile_size=2G,log_disk_size=13G,system_memory=1G,enable_syslog_recycle=true,memory_limit=6G,datafile_maxsize=20G,enable_syslog_wf=false'''
    - observer health check, retry [1/300]
    - update self OB port
    - update OB port in all_agent
  id: 23232261533028867
  node_id: 7
  name: Cluster boostrap
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:50:27.914785602+08:00
  end_time: 2024-10-18T11:51:31.029752615+08:00
  subtasks:
    id: 23232261533028867
    task_id: 7
    name: Cluster boostrap
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:50:27.919539503+08:00
    end_time: 2024-10-18T11:51:30.644007588+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - try to connect to observer
    - 'bootstrap cmd: ALTER SYSTEM BOOTSTRAP ZONE ''zone1'' SERVER ''192.168.101.157:2882'''
  id: 23232261533028868
  node_id: 8
  name: Migrate table
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:51:32.035742435+08:00
  end_time: 2024-10-18T11:51:36.077736345+08:00
  subtasks:
    id: 23232261533028868
    task_id: 8
    name: Migrate table
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:51:32.068946453+08:00
    end_time: 2024-10-18T11:51:35.300549803+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - try to connect to observer
  id: 23232261533028869
  node_id: 9
  name: Modify password
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:51:37.084827186+08:00
  end_time: 2024-10-18T11:51:38.090835422+08:00
  subtasks:
    id: 23232261533028869
    task_id: 9
    name: Modify password
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:51:37.089394354+08:00
    end_time: 2024-10-18T11:51:37.161845241+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - try to connect to observer
    - Successfully connected to OceanBase. Try to modify password.
    - Save root password
    - Reload oceanbase connection
    - Reload oceanbase connection successfully
  id: 232322615330288610
  node_id: 10
  name: Migrate data
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:51:39.098897935+08:00
  end_time: 2024-10-18T11:51:40.106750885+08:00
  subtasks:
    id: 232322615330288610
    task_id: 10
    name: Migrate data
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:51:39.105440165+08:00
    end_time: 2024-10-18T11:51:39.146978209+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - migrate all agents
  id: 232322615330288611
  node_id: 11
  name: Convert follower to cluster agent
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:51:41.11282361+08:00
  end_time: 2024-10-18T11:51:42.120808147+08:00
  subtasks:
    id: 232322615330288611
    task_id: 11
    name: Convert follower to cluster agent
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:51:41.119647833+08:00
    end_time: 2024-10-18T11:51:41.134783431+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288612
  node_id: 12
  name: Synchronize agent from cluster
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:51:43.126827115+08:00
  end_time: 2024-10-18T11:51:44.133337734+08:00
  subtasks:
    id: 232322615330288612
    task_id: 12
    name: Synchronize agent from cluster
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:51:43.132653468+08:00
    end_time: 2024-10-18T11:51:43.20316754+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - try to connect
    - connect succeed, dump password
    - synchronize agent from oceanbase
    - sync agent data
  id: 232322615330288613
  node_id: 13
  name: Convert master to cluster agent
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:51:45.141503361+08:00
  end_time: 2024-10-18T11:51:46.148336839+08:00
  subtasks:
    id: 232322615330288613
    task_id: 13
    name: Convert master to cluster agent
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:51:45.147270314+08:00
    end_time: 2024-10-18T11:51:45.201151681+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - convert self to cluster agent
    - synchronize agent from oceanbase
  id: 232322615330288614
  node_id: 14
  name: Import script for tenant
  state: FAILED
  operator: RUN
  start_time: 2024-10-18T11:51:47.155869445+08:00
  end_time: 2024-10-18T11:51:48.296044079+08:00
  subtasks:
    id: 232322615330288614
    task_id: 14
    name: Import script for tenant
    state: FAILED
    operator: RUN
    start_time: 2024-10-18T11:51:47.295290594+08:00
    end_time: 2024-10-18T11:51:47.35251677+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - Checking if python is installed.
    - 'ERROR: Python is not installed, please install it first.'
  id: 232322615330288615
  node_id: 15
  name: Synchronize agent from cluster
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:50:19.10438071+08:00
  end_time: 2024-10-18T11:50:19.10438071+08:00
  subtasks:
    id: 232322615330288615
    task_id: 15
    name: Synchronize agent from cluster
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:50:19.104459372+08:00
    end_time: 2024-10-18T11:50:19.104459372+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# /home/admin/oceanbase/bin/obshell task show -i 23232261533028865 -d
Check and start obshell daemon 
Get task 23232261533028865 detail 
id: 23232261533028865
dag_id: 5
name: Start OB
stage: 2
max_stage: 6
state: FAILED
operator: RUN
start_time: 2024-10-18T11:52:03.315230077+08:00
end_time: 2024-10-18T11:52:06.338738461+08:00
nodes:
  id: 232322615330288616
  node_id: 16
  name: Inform all agents to start observer
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:52:03.317775498+08:00
  end_time: 2024-10-18T11:52:04.323743557+08:00
  subtasks:
    id: 232322615330288616
    task_id: 16
    name: Inform all agents to start observer
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:52:03.322343267+08:00
    end_time: 2024-10-18T11:52:03.327127313+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - Inform 192.168.101.157:2886 to create the task
    - 'ERROR: OcsAgentError: code = 1010, message = Known error: agent is under maintenance'
  id: 232322615330288617
  node_id: 17
  name: Make sure all agents are ready
  state: FAILED
  operator: RUN
  start_time: 2024-10-18T11:52:05.329264443+08:00
  end_time: 2024-10-18T11:52:06.336107544+08:00
  subtasks:
    id: 232322615330288617
    task_id: 17
    name: Make sure all agents are ready
    state: FAILED
    operator: RUN
    start_time: 2024-10-18T11:52:05.335017875+08:00
    end_time: 2024-10-18T11:52:05.337211703+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - 'ERROR: check sub dag created failed: Not all tasks created. main dag failed'
  id: 232322615330288618
  node_id: 18
  name: Advance agents to execute the task
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:02.846113671+08:00
  end_time: 2024-10-18T11:52:02.846113671+08:00
  subtasks:
    id: 232322615330288618
    task_id: 18
    name: Advance agents to execute the task
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:02.846203502+08:00
    end_time: 2024-10-18T11:52:02.846203502+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288619
  node_id: 19
  name: Wait for all agents to execute tasks successfully
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:02.846303611+08:00
  end_time: 2024-10-18T11:52:02.846303611+08:00
  subtasks:
    id: 232322615330288619
    task_id: 19
    name: Wait for all agents to execute tasks successfully
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:02.846392315+08:00
    end_time: 2024-10-18T11:52:02.846392315+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288620
  node_id: 20
  name: Start Zone
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:02.846490054+08:00
  end_time: 2024-10-18T11:52:02.846490054+08:00
  subtasks:
    id: 232322615330288620
    task_id: 20
    name: Start Zone
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:02.846575129+08:00
    end_time: 2024-10-18T11:52:02.846575129+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288621
  node_id: 21
  name: Inform all agents to end the task
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:02.846671862+08:00
  end_time: 2024-10-18T11:52:02.846671862+08:00
  subtasks:
    id: 232322615330288621
    task_id: 21
    name: Inform all agents to end the task
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:02.846756951+08:00
    end_time: 2024-10-18T11:52:02.846756951+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# /home/admin/oceanbase/bin/obshell task show -i 23232261533028866 -d
Check and start obshell daemon 
Get task 23232261533028866 detail 
id: 23232261533028866
dag_id: 6
name: Start OB
stage: 2
max_stage: 6
state: FAILED
operator: RUN
start_time: 2024-10-18T11:52:22.353988791+08:00
end_time: 2024-10-18T11:52:25.376142784+08:00
nodes:
  id: 232322615330288622
  node_id: 22
  name: Inform all agents to start observer
  state: SUCCEED
  operator: RUN
  start_time: 2024-10-18T11:52:22.356450382+08:00
  end_time: 2024-10-18T11:52:23.362314245+08:00
  subtasks:
    id: 232322615330288622
    task_id: 22
    name: Inform all agents to start observer
    state: SUCCEED
    operator: RUN
    start_time: 2024-10-18T11:52:22.360671363+08:00
    end_time: 2024-10-18T11:52:22.365712005+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - Inform 192.168.101.157:2886 to create the task
    - 'ERROR: OcsAgentError: code = 1010, message = Known error: agent is under maintenance'
  id: 232322615330288623
  node_id: 23
  name: Make sure all agents are ready
  state: FAILED
  operator: RUN
  start_time: 2024-10-18T11:52:24.367748826+08:00
  end_time: 2024-10-18T11:52:25.373802645+08:00
  subtasks:
    id: 232322615330288623
    task_id: 23
    name: Make sure all agents are ready
    state: FAILED
    operator: RUN
    start_time: 2024-10-18T11:52:24.372044068+08:00
    end_time: 2024-10-18T11:52:24.374305674+08:00
    execute_times: 1
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs:
    - 'ERROR: check sub dag created failed: Not all tasks created. main dag failed'
  id: 232322615330288624
  node_id: 24
  name: Advance agents to execute the task
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:21.601423297+08:00
  end_time: 2024-10-18T11:52:21.601423297+08:00
  subtasks:
    id: 232322615330288624
    task_id: 24
    name: Advance agents to execute the task
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:21.60150983+08:00
    end_time: 2024-10-18T11:52:21.60150983+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288625
  node_id: 25
  name: Wait for all agents to execute tasks successfully
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:21.601609925+08:00
  end_time: 2024-10-18T11:52:21.601609925+08:00
  subtasks:
    id: 232322615330288625
    task_id: 25
    name: Wait for all agents to execute tasks successfully
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:21.601693682+08:00
    end_time: 2024-10-18T11:52:21.601693682+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288626
  node_id: 26
  name: Start Zone
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:21.601803455+08:00
  end_time: 2024-10-18T11:52:21.601803455+08:00
  subtasks:
    id: 232322615330288626
    task_id: 26
    name: Start Zone
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:21.601910835+08:00
    end_time: 2024-10-18T11:52:21.601910835+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []
  id: 232322615330288627
  node_id: 27
  name: Inform all agents to end the task
  state: PENDING
  operator: RUN
  start_time: 2024-10-18T11:52:21.602004081+08:00
  end_time: 2024-10-18T11:52:21.602004081+08:00
  subtasks:
    id: 232322615330288627
    task_id: 27
    name: Inform all agents to end the task
    state: PENDING
    operator: RUN
    start_time: 2024-10-18T11:52:21.602083404+08:00
    end_time: 2024-10-18T11:52:21.602083404+08:00
    execute_times: 0
    execute_agent:
      ip: 192.168.101.157
      port: 2886
    task_logs: []

[root@euler157 ~]# 

[root@euler157 ~]# 
[root@euler157 ~]# /home/admin/oceanbase/bin/obshell task show
Check and start obshell daemon 
Get all unfinished tasks 
id: 23232261533028864
dag_id: 4
name: Initialize cluster
stage: 11
max_stage: 12
state: FAILED
operator: RUN
start_time: 2024-10-18T11:50:19.701653523+08:00
end_time: 2024-10-18T11:51:48.298330768+08:00


id: 23232261533028865
dag_id: 5
name: Start OB
stage: 2
max_stage: 6
state: FAILED
operator: RUN
start_time: 2024-10-18T11:52:03.315230077+08:00
end_time: 2024-10-18T11:52:06.338738461+08:00


id: 23232261533028866
dag_id: 6
name: Start OB
stage: 2
max_stage: 6
state: FAILED
operator: RUN
start_time: 2024-10-18T11:52:22.353988791+08:00
end_time: 2024-10-18T11:52:25.376142784+08:00


id: 23232261533028867
dag_id: 7
name: Start OB
stage: 2
max_stage: 6
state: FAILED
operator: RUN
start_time: 2024-10-18T11:52:40.392390213+08:00
end_time: 2024-10-18T11:52:43.420724158+08:00


log_obs.tar.gz (297.5 KB)

/home/admin/oceanbase/log_obshell 下的日志文件. 见附件

麻烦两位啦。

您好~
/home/admin/oceanbase/bin/obshell task show 命令可以查看当前ob未完成的任务。发现第一个任务是 Initialize cluster 。显示状态 failed
/home/admin/oceanbase/bin/obshell task show -i 23232261533028864 -d 可以查看任务详细内容。发现任务失败在 stage: 11。到对应stage查看发现子任务为 Import script for tenant。日志显示为 'ERROR: Python is not installed, please install it first.'。这里是有个 python 环境的要求。

可以先手动装下 python3(py2也可以,建议py3)。
然后手动执行下 /home/admin/oceanbase/bin/obshell task retry -i 23232261533028864 即可继续 ob集群初始化任务。

非常抱歉,这里是个新的改动,使用起来并不是很友好,我们已经在修改了,下个版本会优化。
可以尝试下,有问题继续沟通,感谢!

系统默认是有python3 。我软链接了一下python命令。

完成后按你说的操作,还是不行。

[root@euler157 ~]# which python3
/usr/bin/python3
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# ln -sf /usr/bin/python3 /usr/bin/python
[root@euler157 ~]# python
Python 3.9.9 (main, Oct 25 2023, 15:16:57) 
[GCC 10.3.1] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> 
>>> 
>>> exit
Use exit() or Ctrl-D (i.e. EOF) to exit
>>> 
>>> 
>>> 
>>> exit()
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# /home/admin/oceanbase/bin/obshell task retry -i 23232261533028864
Check and start obshell daemon 
Please confirm if you need to retry the task with ID 23232261533028864  [Y/N]: Y
Get task 23232261533028864 detail 
id: 23232261533028864
dag_id: 4
name: Initialize cluster
stage: 11
max_stage: 12
state: FAILED
operator: RUN
start_time: 2024-10-18T11:50:19.701653523+08:00
end_time: 2024-10-18T11:51:48.298330768+08:00

[SUCCEED] Congratulations! Task with ID 23232261533028864 has been successfully retried.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:32:54 CST; 9s ago
    Process: 400178 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 15:33:04 CST; 6s ago
Cntrl PID: 400748 (bash)
      Tasks: 410 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─   5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─   5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─   5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_>
             ├─ 400748 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 401302 sleep 6

10月 18 15:33:04 euler157.local systemd[1]: Starting oceanbase...
10月 18 15:33:04 euler157.local bash[400748]: oceanbase service started at 2024-10-18 15:33:04
10月 18 15:33:06 euler157.local bash[400748]: change etc owner to root
10月 18 15:33:06 euler157.local bash[400748]: daemon process with PID 5831 is running.
10月 18 15:33:06 euler157.local bash[400748]: The agent service is exist
10月 18 15:33:06 euler157.local bash[400748]: The observer is already bootstrap, please start it immediately
10月 18 15:33:06 euler157.local bash[400748]: the start observer trace id is 2323226153302886709
10月 18 15:33:07 euler157.local bash[400748]: the response state is READY
10月 18 15:33:07 euler157.local bash[400748]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:33:13 CST; 875ms ago
    Process: 400748 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:33:13 CST; 3s ago
    Process: 400748 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:33:13 CST; 8s ago
    Process: 400748 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:33:31 CST; 7s ago
    Process: 401315 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1029/sshd: /usr/sbi 
tcp        0      0 0.0.0.0:2881            0.0.0.0:*               LISTEN      5946/observer       
tcp        0      0 0.0.0.0:2882            0.0.0.0:*               LISTEN      5946/observer       
tcp        0      0 192.168.101.157:2886    0.0.0.0:*               LISTEN      5852/obshell        
tcp6       0      0 :::22                   :::*                    LISTEN      1029/sshd: /usr/sbi 
tcp6       0      0 :::2882                 :::*                    LISTEN      5946/observer       
udp        0      0 127.0.0.1:323           0.0.0.0:*                           993/chronyd         
udp6       0      0 ::1:323                 :::*                                993/chronyd         
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:33:50 CST; 6s ago
    Process: 401877 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>

10月 18 15:33:50 euler157.local systemd[1]: oceanbase.service: Unit process 5852 (obshell) remains running after unit stopped.
10月 18 15:33:50 euler157.local systemd[1]: oceanbase.service: Unit process 5946 (observer) remains running after unit stopped.
10月 18 15:33:50 euler157.local systemd[1]: Failed to start oceanbase.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 15:34:00 CST; 4s ago
Cntrl PID: 402439 (bash)
      Tasks: 410 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─   5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─   5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─   5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_>
             ├─ 402439 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 402993 sleep 6

10月 18 15:34:00 euler157.local systemd[1]: Starting oceanbase...
10月 18 15:34:00 euler157.local bash[402439]: oceanbase service started at 2024-10-18 15:34:00
10月 18 15:34:03 euler157.local bash[402439]: change etc owner to root
10月 18 15:34:03 euler157.local bash[402439]: daemon process with PID 5831 is running.
10月 18 15:34:03 euler157.local bash[402439]: The agent service is exist
10月 18 15:34:03 euler157.local bash[402439]: The observer is already bootstrap, please start it immediately
10月 18 15:34:03 euler157.local bash[402439]: the start observer trace id is 2323226153302886712
10月 18 15:34:03 euler157.local bash[402439]: the response state is READY
10月 18 15:34:03 euler157.local bash[402439]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:34:09 CST; 4s ago
    Process: 402439 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:34:28 CST; 2s ago
    Process: 403002 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:34:28 CST; 6s ago
    Process: 403002 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service

● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:34:28 CST; 9s ago
    Process: 403002 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 15:34:38 CST; 2s ago
Cntrl PID: 403567 (bash)
      Tasks: 410 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─   5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─   5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─   5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_>
             ├─ 403567 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 404121 sleep 6

10月 18 15:34:38 euler157.local systemd[1]: Starting oceanbase...
10月 18 15:34:38 euler157.local bash[403567]: oceanbase service started at 2024-10-18 15:34:38
10月 18 15:34:41 euler157.local bash[403567]: change etc owner to root
10月 18 15:34:41 euler157.local bash[403567]: daemon process with PID 5831 is running.
10月 18 15:34:41 euler157.local bash[403567]: The agent service is exist
10月 18 15:34:41 euler157.local bash[403567]: The observer is already bootstrap, please start it immediately
10月 18 15:34:41 euler157.local bash[403567]: the start observer trace id is 2323226153302886714
10月 18 15:34:41 euler157.local bash[403567]: the response state is READY
10月 18 15:34:41 euler157.local bash[403567]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:34:47 CST; 126ms ago
    Process: 403567 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl stop oceanbase.service
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
○ oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: inactive (dead) (Result: exit-code) since Fri 2024-10-18 15:34:54 CST; 2s ago
    Process: 403567 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>

10月 18 15:34:54 euler157.local systemd[1]: Stopped oceanbase.
[root@euler157 ~]# systemctl status oceanbase.service
○ oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: inactive (dead) (Result: exit-code) since Fri 2024-10-18 15:34:54 CST; 6s ago
    Process: 403567 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>

10月 18 15:34:54 euler157.local systemd[1]: Stopped oceanbase.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
○ oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: inactive (dead) (Result: exit-code) since Fri 2024-10-18 15:34:54 CST; 10s ago
    Process: 403567 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>

10月 18 15:34:54 euler157.local systemd[1]: Stopped oceanbase.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl start oceanbase.service
Job for oceanbase.service failed because the control process exited with error code.
See "systemctl status oceanbase.service" and "journalctl -xeu oceanbase.service" for details.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:35:19 CST; 4s ago
    Process: 404140 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:35:19 CST; 9s ago
    Process: 404140 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 15:35:29 CST; 3s ago
Cntrl PID: 404703 (bash)
      Tasks: 410 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─   5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─   5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─   5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_>
             ├─ 404703 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 405257 sleep 6

10月 18 15:35:29 euler157.local systemd[1]: Starting oceanbase...
10月 18 15:35:29 euler157.local bash[404703]: oceanbase service started at 2024-10-18 15:35:29
10月 18 15:35:32 euler157.local bash[404703]: change etc owner to root
10月 18 15:35:32 euler157.local bash[404703]: daemon process with PID 5831 is running.
10月 18 15:35:32 euler157.local bash[404703]: The agent service is exist
10月 18 15:35:32 euler157.local bash[404703]: The observer is already bootstrap, please start it immediately
10月 18 15:35:32 euler157.local bash[404703]: the start observer trace id is 2323226153302886716
10月 18 15:35:32 euler157.local bash[404703]: the response state is READY
10月 18 15:35:32 euler157.local bash[404703]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (start) since Fri 2024-10-18 15:35:29 CST; 6s ago
Cntrl PID: 404703 (bash)
      Tasks: 410 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─   5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─   5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             ├─   5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_>
             ├─ 404703 /bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start
             └─ 405257 sleep 6

10月 18 15:35:29 euler157.local systemd[1]: Starting oceanbase...
10月 18 15:35:29 euler157.local bash[404703]: oceanbase service started at 2024-10-18 15:35:29
10月 18 15:35:32 euler157.local bash[404703]: change etc owner to root
10月 18 15:35:32 euler157.local bash[404703]: daemon process with PID 5831 is running.
10月 18 15:35:32 euler157.local bash[404703]: The agent service is exist
10月 18 15:35:32 euler157.local bash[404703]: The observer is already bootstrap, please start it immediately
10月 18 15:35:32 euler157.local bash[404703]: the start observer trace id is 2323226153302886716
10月 18 15:35:32 euler157.local bash[404703]: the response state is READY
10月 18 15:35:32 euler157.local bash[404703]: wait 6s and the retry
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:35:38 CST; 1s ago
    Process: 404703 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:35:38 CST; 4s ago
    Process: 404703 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:35:38 CST; 6s ago
    Process: 404703 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: activating (auto-restart) (Result: exit-code) since Fri 2024-10-18 15:35:38 CST; 9s ago
    Process: 404703 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=1/FAILURE)
      Tasks: 408 (limit: 47367)
     Memory: 3.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5831 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5852 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5946 /home/admin/oceanbase/bin/observer -n ob -z zone1 -c 1 -d /home/admin/oceanbase/store -I 192.168.101.157 -p 2881 -P 2882 -o max_sy>
[root@euler157 ~]# 
[root@euler157 ~]# 




另外,在 python 安装好了之后,还需要执行pip install mysql-connector。
之后在通过 /home/admin/oceanbase/bin/obshell task retry -i 23232261533028864 重试即可。

您好,可以再执行下 /home/admin/oceanbase/bin/obshell task show -i 23232261533028864 -d 看下任务具体是什么

再执行一下/home/admin/oceanbase/bin/obshell task show -i 23232261533028864 -d,看看任务报错是不是import mysql.connector失败,如果是的话,执行一下pip install mysql-connector,然后重试一下这个任务即可。

几位大哥,终于好了。感谢啊。一会我再全部重新来一次,复验下。

文档缺失东西 ,以下命令必须能成功,才能确保安装成功。

1: 不仅是python环境,需要直接执行python命令能进环境
2: pip install mysql-connector

遗留问题 obclient执行失败,少了依赖。

[root@euler157 ~]# 
[root@euler157 ~]# obclient 
obclient: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 

[root@euler157 ~]# python
Python 3.9.9 (main, Oct 25 2023, 15:16:57) 
[GCC 10.3.1] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> 
>>> 
>>> import mysql.connector
>>> 
>>> 
>>> 
[root@euler157 ~]# 

[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase.service
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: active (running) since Fri 2024-10-18 16:17:02 CST; 1min 45s ago
    Process: 1704 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=0/SUCCESS)
   Main PID: 2335 (observer)
      Tasks: 425 (limit: 47367)
     Memory: 2.4G
     CGroup: /system.slice/oceanbase.service
             ├─ 2263 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 2284 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 2335 /home/admin/oceanbase/bin/observer

10月 18 16:16:36 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:16:42 euler157.local bash[1704]: the response state is RUNNING
10月 18 16:16:42 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:16:48 euler157.local bash[1704]: the response state is RUNNING
10月 18 16:16:48 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:16:54 euler157.local bash[1704]: the response state is RUNNING
10月 18 16:16:54 euler157.local bash[1704]: wait 6s and the retry
10月 18 16:17:00 euler157.local bash[1704]: the response state is SUCCEED
10月 18 16:17:00 euler157.local bash[1704]: start observer request successfully
10月 18 16:17:02 euler157.local systemd[1]: Started oceanbase.
[root@euler157 ~]# 
[root@euler157 ~]# 

非常抱歉,我们会针对本次帖子完整自查一下有问题的地方。感谢使用,有问题请继续沟通

1 个赞

全新安装验证如下,可参考下面操作记录,再次感谢各位帮忙排查

一次通过

环境信息如下 , 注意官方文档,需要强调python依赖,确保python可以执行。

同时安装连接依赖包 pip install mysql-connector

[root@euler157 ~]# 
[root@euler157 ~]# cat /etc/os-release 
NAME="openEuler"
VERSION="22.03 (LTS-SP2)"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 (LTS-SP2)"
ANSI_COLOR="0;31"

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# cat /proc/version 
Linux version 5.10.0-153.56.0.134.oe2203sp2.x86_64 (root@dc-64g.compass-ci) (gcc_old (GCC) 10.3.1, GNU ld (GNU Binutils) 2.37) #1 SMP Wed May 29 14:04:28 CST 2024
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# uname -ra
Linux euler157.local 5.10.0-153.56.0.134.oe2203sp2.x86_64 #1 SMP Wed May 29 14:04:28 CST 2024 x86_64 x86_64 x86_64 GNU/Linux
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# free -h
               total        used        free      shared  buff/cache   available
Mem:           7.3Gi       2.3Gi       1.9Gi       8.7Mi       3.4Gi       5.0Gi
Swap:          4.0Gi          0B       4.0Gi
[root@euler157 ~]# 
[root@euler157 ~]# df -h
文件系统                    容量  已用  可用 已用% 挂载点
devtmpfs                    4.0M     0  4.0M    0% /dev
tmpfs                       3.7G     0  3.7G    0% /dev/shm
tmpfs                       1.5G  8.7M  1.5G    1% /run
tmpfs                       4.0M     0  4.0M    0% /sys/fs/cgroup
/dev/mapper/openeuler-root   45G   22G   21G   51% /
tmpfs                       3.7G     0  3.7G    0% /tmp
/dev/sda1                   974M  226M  682M   25% /boot
[root@euler157 ~]# 
[root@euler157 ~]# 

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# free -h
               total        used        free      shared  buff/cache   available
Mem:           7.3Gi       427Mi       6.9Gi       8.7Mi       220Mi       6.8Gi
Swap:          4.0Gi          0B       4.0Gi
[root@euler157 ~]# getenforce 
Enforcing
[root@euler157 ~]# setenforce 0
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# getenforce 
Permissive
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# ln -sf /usr/bin/python3 /usr/bin/python
[root@euler157 ~]# yum install tar
Last metadata expiration check: 0:09:27 ago on 2024年10月18日 星期五 17时21分00秒.
Dependencies resolved.
==================================================================================================================================
 Package                  Architecture                Version                                   Repository                   Size
==================================================================================================================================
Installing:
 tar                      x86_64                      2:1.34-5.oe2203sp2                        update                      784 k

Transaction Summary
==================================================================================================================================
Install  1 Package

Total download size: 784 k
Installed size: 3.3 M
Is this ok [y/N]: y
Downloading Packages:
tar-1.34-5.oe2203sp2.x86_64.rpm                                                                   340 kB/s | 784 kB     00:02    
----------------------------------------------------------------------------------------------------------------------------------
Total                                                                                             314 kB/s | 784 kB     00:02     
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                          1/1 
  Running scriptlet: tar-2:1.34-5.oe2203sp2.x86_64                                                                            1/1 
  Installing       : tar-2:1.34-5.oe2203sp2.x86_64                                                                            1/1 
  Running scriptlet: tar-2:1.34-5.oe2203sp2.x86_64                                                                            1/1 
  Verifying        : tar-2:1.34-5.oe2203sp2.x86_64                                                                            1/1 

Installed:
  tar-2:1.34-5.oe2203sp2.x86_64                                                                                                   

Complete!
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# cat /etc/os-release 
NAME="openEuler"
VERSION="22.03 (LTS-SP2)"
ID="openEuler"
VERSION_ID="22.03"
PRETTY_NAME="openEuler 22.03 (LTS-SP2)"
ANSI_COLOR="0;31"

[root@euler157 ~]# 
[root@euler157 ~]# uname -ra
Linux euler157.local 5.10.0-153.56.0.134.oe2203sp2.x86_64 #1 SMP Wed May 29 14:04:28 CST 2024 x86_64 x86_64 x86_64 GNU/Linux
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# getenforce 
Permissive
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# which python
/usr/bin/python
[root@euler157 ~]# 
[root@euler157 ~]#
[root@euler157 ~]# tar zxvf mysql-connector-2.2.9.tar.gz 
mysql-connector-2.2.9/
mysql-connector-2.2.9/CHANGES.txt
mysql-connector-2.2.9/LICENSE.txt
mysql-connector-2.2.9/MANIFEST.in
mysql-connector-2.2.9/PKG-INFO
mysql-connector-2.2.9/README.txt
mysql-connector-2.2.9/docs/
mysql-connector-2.2.9/docs/README_DOCS.txt
mysql-connector-2.2.9/examples/
mysql-connector-2.2.9/examples/__init__.py
mysql-connector-2.2.9/examples/dates.py
mysql-connector-2.2.9/examples/engines.py
mysql-connector-2.2.9/examples/inserts.py
mysql-connector-2.2.9/examples/microseconds.py
mysql-connector-2.2.9/examples/multi_resultsets.py
mysql-connector-2.2.9/examples/mysql_warnings.py
mysql-connector-2.2.9/examples/prepared_statements.py
mysql-connector-2.2.9/examples/transaction.py
mysql-connector-2.2.9/examples/unicode.py
mysql-connector-2.2.9/examples/warnings.py
mysql-connector-2.2.9/lib/
mysql-connector-2.2.9/lib/__init__.py
mysql-connector-2.2.9/lib/cpy_distutils.py
mysql-connector-2.2.9/lib/mysql/
mysql-connector-2.2.9/lib/mysql/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/
mysql-connector-2.2.9/lib/mysql/connector/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/abstracts.py
mysql-connector-2.2.9/lib/mysql/connector/authentication.py
mysql-connector-2.2.9/lib/mysql/connector/catch23.py
mysql-connector-2.2.9/lib/mysql/connector/charsets.py
mysql-connector-2.2.9/lib/mysql/connector/connection.py
mysql-connector-2.2.9/lib/mysql/connector/connection_cext.py
mysql-connector-2.2.9/lib/mysql/connector/constants.py
mysql-connector-2.2.9/lib/mysql/connector/conversion.py
mysql-connector-2.2.9/lib/mysql/connector/cursor.py
mysql-connector-2.2.9/lib/mysql/connector/cursor_cext.py
mysql-connector-2.2.9/lib/mysql/connector/custom_types.py
mysql-connector-2.2.9/lib/mysql/connector/dbapi.py
mysql-connector-2.2.9/lib/mysql/connector/django/
mysql-connector-2.2.9/lib/mysql/connector/django/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/django/base.py
mysql-connector-2.2.9/lib/mysql/connector/django/client.py
mysql-connector-2.2.9/lib/mysql/connector/django/compiler.py
mysql-connector-2.2.9/lib/mysql/connector/django/creation.py
mysql-connector-2.2.9/lib/mysql/connector/django/features.py
mysql-connector-2.2.9/lib/mysql/connector/django/introspection.py
mysql-connector-2.2.9/lib/mysql/connector/django/operations.py
mysql-connector-2.2.9/lib/mysql/connector/django/schema.py
mysql-connector-2.2.9/lib/mysql/connector/django/validation.py
mysql-connector-2.2.9/lib/mysql/connector/errorcode.py
mysql-connector-2.2.9/lib/mysql/connector/errors.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/
mysql-connector-2.2.9/lib/mysql/connector/fabric/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/balancing.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/caching.py
mysql-connector-2.2.9/lib/mysql/connector/fabric/connection.py
mysql-connector-2.2.9/lib/mysql/connector/locales/
mysql-connector-2.2.9/lib/mysql/connector/locales/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/locales/eng/
mysql-connector-2.2.9/lib/mysql/connector/locales/eng/__init__.py
mysql-connector-2.2.9/lib/mysql/connector/locales/eng/client_error.py
mysql-connector-2.2.9/lib/mysql/connector/network.py
mysql-connector-2.2.9/lib/mysql/connector/optionfiles.py
mysql-connector-2.2.9/lib/mysql/connector/pooling.py
mysql-connector-2.2.9/lib/mysql/connector/protocol.py
mysql-connector-2.2.9/lib/mysql/connector/utils.py
mysql-connector-2.2.9/lib/mysql/connector/version.py
mysql-connector-2.2.9/lib/mysql_connector.egg-info/
mysql-connector-2.2.9/lib/mysql_connector.egg-info/PKG-INFO
mysql-connector-2.2.9/lib/mysql_connector.egg-info/SOURCES.txt
mysql-connector-2.2.9/lib/mysql_connector.egg-info/dependency_links.txt
mysql-connector-2.2.9/lib/mysql_connector.egg-info/top_level.txt
mysql-connector-2.2.9/lib/mysqlx/
mysql-connector-2.2.9/lib/mysqlx/__init__.py
mysql-connector-2.2.9/lib/mysqlx/authentication.py
mysql-connector-2.2.9/lib/mysqlx/charsets.py
mysql-connector-2.2.9/lib/mysqlx/compat.py
mysql-connector-2.2.9/lib/mysqlx/connection.py
mysql-connector-2.2.9/lib/mysqlx/constants.py
mysql-connector-2.2.9/lib/mysqlx/crud.py
mysql-connector-2.2.9/lib/mysqlx/dbdoc.py
mysql-connector-2.2.9/lib/mysqlx/errorcode.py
mysql-connector-2.2.9/lib/mysqlx/errors.py
mysql-connector-2.2.9/lib/mysqlx/expr.py
mysql-connector-2.2.9/lib/mysqlx/expr_unparser.py
mysql-connector-2.2.9/lib/mysqlx/locales/
mysql-connector-2.2.9/lib/mysqlx/locales/__init__.py
mysql-connector-2.2.9/lib/mysqlx/locales/eng/
mysql-connector-2.2.9/lib/mysqlx/locales/eng/__init__.py
mysql-connector-2.2.9/lib/mysqlx/locales/eng/client_error.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/
mysql-connector-2.2.9/lib/mysqlx/protobuf/__init__.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_connection_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_crud_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_datatypes_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_expect_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_expr_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_notice_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_resultset_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_session_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/mysqlx_sql_pb2.py
mysql-connector-2.2.9/lib/mysqlx/protobuf/t.py
mysql-connector-2.2.9/lib/mysqlx/protocol.py
mysql-connector-2.2.9/lib/mysqlx/result.py
mysql-connector-2.2.9/lib/mysqlx/statement.py
mysql-connector-2.2.9/setup.cfg
mysql-connector-2.2.9/setup.py
mysql-connector-2.2.9/setupinfo.py
mysql-connector-2.2.9/src/
mysql-connector-2.2.9/src/exceptions.c
mysql-connector-2.2.9/src/force_cpp_linkage.cc
mysql-connector-2.2.9/src/include/
mysql-connector-2.2.9/src/include/catch23.h
mysql-connector-2.2.9/src/include/exceptions.h
mysql-connector-2.2.9/src/include/mysql_capi.h
mysql-connector-2.2.9/src/include/mysql_capi_conversion.h
mysql-connector-2.2.9/src/include/mysql_connector.h
mysql-connector-2.2.9/src/mysql_capi.c
mysql-connector-2.2.9/src/mysql_capi_conversion.c
mysql-connector-2.2.9/src/mysql_connector.c
mysql-connector-2.2.9/tests/
mysql-connector-2.2.9/tests/__init__.py
mysql-connector-2.2.9/tests/cext/
mysql-connector-2.2.9/tests/cext/__init__.py
mysql-connector-2.2.9/tests/cext/test_cext_api.py
mysql-connector-2.2.9/tests/cext/test_cext_connection.py
mysql-connector-2.2.9/tests/cext/test_cext_cursor.py
mysql-connector-2.2.9/tests/data/
mysql-connector-2.2.9/tests/data/local_data.csv
mysql-connector-2.2.9/tests/data/option_files/
mysql-connector-2.2.9/tests/data/option_files/dup_groups.cnf
mysql-connector-2.2.9/tests/data/option_files/include_files/
mysql-connector-2.2.9/tests/data/option_files/include_files/1.cnf
mysql-connector-2.2.9/tests/data/option_files/include_files/2.cnf
mysql-connector-2.2.9/tests/data/option_files/my.cnf
mysql-connector-2.2.9/tests/data/option_files/pool.cnf
mysql-connector-2.2.9/tests/data/random_big_bin.csv
mysql-connector-2.2.9/tests/data/ssl/
mysql-connector-2.2.9/tests/data/ssl/tests_CA_cert.pem
mysql-connector-2.2.9/tests/data/ssl/tests_CA_key.pem
mysql-connector-2.2.9/tests/data/ssl/tests_client_cert.pem
mysql-connector-2.2.9/tests/data/ssl/tests_client_key.pem
mysql-connector-2.2.9/tests/data/ssl/tests_server_cert.pem
mysql-connector-2.2.9/tests/data/ssl/tests_server_key.pem
mysql-connector-2.2.9/tests/issues/
mysql-connector-2.2.9/tests/issues/__init__.py
mysql-connector-2.2.9/tests/issues/test_bug21449207.py
mysql-connector-2.2.9/tests/issues/test_bug21449996.py
mysql-connector-2.2.9/tests/issues/test_bug21879859.py
mysql-connector-2.2.9/tests/issues/test_bug21879914.py
mysql-connector-2.2.9/tests/issues/test_bug22545879.py
mysql-connector-2.2.9/tests/mysqld.py
mysql-connector-2.2.9/tests/py26.py
mysql-connector-2.2.9/tests/test_abstracts.py
mysql-connector-2.2.9/tests/test_authentication.py
mysql-connector-2.2.9/tests/test_bugs.py
mysql-connector-2.2.9/tests/test_connection.py
mysql-connector-2.2.9/tests/test_constants.py
mysql-connector-2.2.9/tests/test_conversion.py
mysql-connector-2.2.9/tests/test_cursor.py
mysql-connector-2.2.9/tests/test_django.py
mysql-connector-2.2.9/tests/test_errorcode.py
mysql-connector-2.2.9/tests/test_errors.py
mysql-connector-2.2.9/tests/test_examples.py
mysql-connector-2.2.9/tests/test_fabric.py
mysql-connector-2.2.9/tests/test_locales.py
mysql-connector-2.2.9/tests/test_mysql_datatypes.py
mysql-connector-2.2.9/tests/test_mysqlx_connection.py
mysql-connector-2.2.9/tests/test_mysqlx_crud.py
mysql-connector-2.2.9/tests/test_mysqlx_errorcode.py
mysql-connector-2.2.9/tests/test_mysqlx_errors.py
mysql-connector-2.2.9/tests/test_network.py
mysql-connector-2.2.9/tests/test_optionfiles.py
mysql-connector-2.2.9/tests/test_pep249.py
mysql-connector-2.2.9/tests/test_pooling.py
mysql-connector-2.2.9/tests/test_protocol.py
mysql-connector-2.2.9/tests/test_setup.py
mysql-connector-2.2.9/tests/test_style.py
mysql-connector-2.2.9/tests/test_utils.py
mysql-connector-2.2.9/unittests.py
[root@euler157 ~]# cd mysql-connector-2.2.9
[root@euler157 mysql-connector-2.2.9]# pip install .
WARNING: Running pip install with root privileges is generally not a good idea. Try `pip install --user` instead.
Processing /root/mysql-connector-2.2.9
  Preparing metadata (setup.py) ... done
Using legacy 'setup.py install' for mysql-connector, since package 'wheel' is not installed.
Installing collected packages: mysql-connector
    Running setup.py install for mysql-connector ... done
Successfully installed mysql-connector-2.2.9
WARNING: Running pip as the 'root' user can result in broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv
[root@euler157 mysql-connector-2.2.9]# 
[root@euler157 mysql-connector-2.2.9]# python
Python 3.9.9 (main, Oct 25 2023, 15:16:57) 
[GCC 10.3.1] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> 
>>> 
>>> import mysql.connector
>>> 
>>> 
>>> 
[root@euler157 mysql-connector-2.2.9]# 
[root@euler157 mysql-connector-2.2.9]# 
[root@euler157 mysql-connector-2.2.9]# 
[root@euler157 mysql-connector-2.2.9]# 
[root@euler157 mysql-connector-2.2.9]# 
[root@euler157 mysql-connector-2.2.9]# cd
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[
[root@euler157 ~]# 
[root@euler157 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1027/sshd: /usr/sbi 
tcp6       0      0 :::22                   :::*                    LISTEN      1027/sshd: /usr/sbi 
udp        0      0 127.0.0.1:323           0.0.0.0:*                           999/chronyd         
udp6       0      0 ::1:323                 :::*                                999/chronyd         
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# yum install oceanbase-ce oceanbase-ce-libs obclient
Last metadata expiration check: 0:03:08 ago on 2024年10月18日 星期五 17时32分43秒.
Dependencies resolved.
==================================================================================================================================
 Package                          Architecture          Version                                        Repository            Size
==================================================================================================================================
Installing:
 obclient                         x86_64                2.2.6-1.el7                                    local                 11 M
 oceanbase-ce                     x86_64                4.3.3.0-100000142024101215.el7                 local                138 M
 oceanbase-ce-libs                x86_64                4.3.3.0-100000142024101215.el7                 local                155 k
Installing dependencies:
 jq                               x86_64                1.6-2.oe2203sp2                                local                167 k
 oniguruma                        x86_64                6.9.6-1.oe2203sp2                              local                160 k

Transaction Summary
==================================================================================================================================
Install  5 Packages

Total size: 150 M
Installed size: 747 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                          1/1 
  Installing       : oniguruma-6.9.6-1.oe2203sp2.x86_64                                                                       1/5 
  Installing       : jq-1.6-2.oe2203sp2.x86_64                                                                                2/5 
  Running scriptlet: jq-1.6-2.oe2203sp2.x86_64                                                                                2/5 
  Installing       : oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64                                                  3/5 
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root

  Running scriptlet: oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                       4/5 
execute pre install script

  Installing       : oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                       4/5 
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root

警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root
警告:user admin does not exist - using root
警告:group admin does not exist - using root

  Running scriptlet: oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                       4/5 
execute post install script
To configure OceanBase : edit /etc/oceanbase.cnf
To start OceanBase     : systemctl start oceanbase
To enable OceanBase auto reboot  : systemctl enable oceanbase
To get more infomation : https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000640297

  Running scriptlet: obclient-2.2.6-1.el7.x86_64                                                                              5/5 
  Installing       : obclient-2.2.6-1.el7.x86_64                                                                              5/5 
  Running scriptlet: obclient-2.2.6-1.el7.x86_64                                                                              5/5 
  Verifying        : jq-1.6-2.oe2203sp2.x86_64                                                                                1/5 
  Verifying        : obclient-2.2.6-1.el7.x86_64                                                                              2/5 
  Verifying        : oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64                                                       3/5 
  Verifying        : oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64                                                  4/5 
  Verifying        : oniguruma-6.9.6-1.oe2203sp2.x86_64                                                                       5/5 

Installed:
  jq-1.6-2.oe2203sp2.x86_64                                     obclient-2.2.6-1.el7.x86_64                                       
  oceanbase-ce-4.3.3.0-100000142024101215.el7.x86_64            oceanbase-ce-libs-4.3.3.0-100000142024101215.el7.x86_64           
  oniguruma-6.9.6-1.oe2203sp2.x86_64                           

Complete!
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase
○ oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: inactive (dead)

10月 18 17:36:26 euler157.local systemd[1]: /etc/systemd/system/oceanbase.service:7: Unit configured to use KillMode=none. This i>
[root@euler157 ~]# 

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl start oceanbase




[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: active (running) since Fri 2024-10-18 17:38:33 CST; 16s ago
    Process: 5290 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=0/SUCCESS)
   Main PID: 5950 (observer)
      Tasks: 416 (limit: 47367)
     Memory: 2.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5835 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5856 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5950 /home/admin/oceanbase/bin/observer -c 1 -d /home/admin/oceanbase/store -z zone1 -p 2881 -n ob -I 192.168.101>

10月 18 17:38:08 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:14 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:14 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:20 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:20 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:26 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:26 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:32 euler157.local bash[5290]: the response state is SUCCEED
10月 18 17:38:32 euler157.local bash[5290]: start observer request successfully
10月 18 17:38:33 euler157.local systemd[1]: Started oceanbase.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# systemctl status oceanbase
● oceanbase.service - oceanbase
     Loaded: loaded (/etc/systemd/system/oceanbase.service; disabled; vendor preset: disabled)
     Active: active (running) since Fri 2024-10-18 17:38:33 CST; 20s ago
    Process: 5290 ExecStart=/bin/bash /home/admin/oceanbase/profile/oceanbase-service.sh start (code=exited, status=0/SUCCESS)
   Main PID: 5950 (observer)
      Tasks: 416 (limit: 47367)
     Memory: 2.1G
     CGroup: /system.slice/oceanbase.service
             ├─ 5835 /home/admin/oceanbase/bin/obshell daemon --ip 192.168.101.157 --port 2886
             ├─ 5856 /home/admin/oceanbase/bin/obshell server --ip 192.168.101.157 --port 2886
             └─ 5950 /home/admin/oceanbase/bin/observer -c 1 -d /home/admin/oceanbase/store -z zone1 -p 2881 -n ob -I 192.168.101>

10月 18 17:38:08 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:14 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:14 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:20 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:20 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:26 euler157.local bash[5290]: the response state is RUNNING
10月 18 17:38:26 euler157.local bash[5290]: wait 6s and the retry
10月 18 17:38:32 euler157.local bash[5290]: the response state is SUCCEED
10月 18 17:38:32 euler157.local bash[5290]: start observer request successfully
10月 18 17:38:33 euler157.local systemd[1]: Started oceanbase.
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 

[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# netstat -tunlp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name    
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      1027/sshd: /usr/sbi 
tcp        0      0 0.0.0.0:2881            0.0.0.0:*               LISTEN      5950/observer       
tcp        0      0 0.0.0.0:2882            0.0.0.0:*               LISTEN      5950/observer       
tcp        0      0 192.168.101.157:2886    0.0.0.0:*               LISTEN      5856/obshell        
tcp6       0      0 :::22                   :::*                    LISTEN      1027/sshd: /usr/sbi 
tcp6       0      0 :::2882                 :::*                    LISTEN      5950/observer       
udp        0      0 127.0.0.1:323           0.0.0.0:*                           999/chronyd         
udp6       0      0 ::1:323                 :::*                                999/chronyd         
[root@euler157 ~]# 
[root@euler157 ~]# 
[root@euler157 ~]# 
root@euler157 ~]# 
[root@euler157 ~]# mysql -h 127.0.0.1 -u root --port=2881 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3221487622
Server version: 5.7.25 OceanBase_CE 4.3.3.0 (r100000142024101215-0723f9774e5f77a1253149261ba75a94414625d0) (Built Oct 12 2024 15:58:11)

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> 
mysql> 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LBACSYS            |
| mysql              |
| oceanbase          |
| ocs                |
| ORAAUDITOR         |
| SYS                |
| sys_external_tbs   |
| test               |
+--------------------+
9 rows in set (0.00 sec)

mysql> 
mysql> 







1 个赞