Oceanbase 修改服务器IP后无法启动

之前安装好的Oceanbase数据库,在配置文件修改本机服务器IP后无法启动错误码为2002

配置文件:/root/.obd/cluster/obtest5/config.yaml

1 个赞

日志:
[2024-02-21 15:21:30.257] [DEBUG] - cmd: [‘obtest5’]
[2024-02-21 15:21:30.257] [DEBUG] - opts: {‘servers’: None, ‘components’: None, ‘force_delete’: None, ‘strict_check’: None, ‘without_parameter’: None}
[2024-02-21 15:21:30.257] [DEBUG] - mkdir /root/.obd/lock/
[2024-02-21 15:21:30.257] [DEBUG] - unknown lock mode
[2024-02-21 15:21:30.257] [DEBUG] - try to get share lock /root/.obd/lock/global
[2024-02-21 15:21:30.258] [DEBUG] - share lock /root/.obd/lock/global, count 1
[2024-02-21 15:21:30.258] [DEBUG] - Get Deploy by name
[2024-02-21 15:21:30.258] [DEBUG] - mkdir /root/.obd/cluster/
[2024-02-21 15:21:30.258] [DEBUG] - mkdir /root/.obd/config_parser/
[2024-02-21 15:21:30.258] [DEBUG] - try to get exclusive lock /root/.obd/lock/deploy_obtest5
[2024-02-21 15:21:30.258] [DEBUG] - exclusive lock /root/.obd/lock/deploy_obtest5, count 1
[2024-02-21 15:21:30.262] [DEBUG] - Deploy status judge
[2024-02-21 15:21:30.262] [INFO] Get local repositories
[2024-02-21 15:21:30.263] [DEBUG] - mkdir /root/.obd/repository
[2024-02-21 15:21:30.263] [DEBUG] - Get local repository oceanbase-ce-4.2.1.1-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.264] [DEBUG] - Search repository oceanbase-ce version: 4.2.1.1, tag: e98c6ef860b5644c36f806e6fa2265255572b40a, release: None, package_hash: None
[2024-02-21 15:21:30.264] [DEBUG] - try to get share lock /root/.obd/lock/mirror_and_repo
[2024-02-21 15:21:30.264] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo, count 1
[2024-02-21 15:21:30.264] [DEBUG] - mkdir /root/.obd/repository/oceanbase-ce
[2024-02-21 15:21:30.266] [DEBUG] - Found repository oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.394] [DEBUG] - Get deploy config
[2024-02-21 15:21:30.407] [INFO] Search plugins
[2024-02-21 15:21:30.408] [DEBUG] - Searching start_check plugin for components …
[2024-02-21 15:21:30.408] [DEBUG] - Searching start_check plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.408] [DEBUG] - mkdir /root/.obd/plugins
[2024-02-21 15:21:30.409] [DEBUG] - Found for oceanbase-ce-py_script_start_check-4.2.0.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.409] [DEBUG] - Searching create_tenant plugin for components …
[2024-02-21 15:21:30.409] [DEBUG] - Searching create_tenant plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.410] [DEBUG] - Found for oceanbase-ce-py_script_create_tenant-4.2.0.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.410] [DEBUG] - Searching start plugin for components …
[2024-02-21 15:21:30.410] [DEBUG] - Searching start plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.410] [DEBUG] - Found for oceanbase-ce-py_script_start-4.2.0.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.410] [DEBUG] - Searching connect plugin for components …
[2024-02-21 15:21:30.410] [DEBUG] - Searching connect plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.411] [DEBUG] - Found for oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.411] [DEBUG] - Searching bootstrap plugin for components …
[2024-02-21 15:21:30.411] [DEBUG] - Searching bootstrap plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.411] [DEBUG] - Found for oceanbase-ce-py_script_bootstrap-4.0.0.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.412] [DEBUG] - Searching display plugin for components …
[2024-02-21 15:21:30.412] [DEBUG] - Searching display plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:30.412] [DEBUG] - Found for oceanbase-ce-py_script_display-3.1.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.539] [INFO] Open ssh connection
[2024-02-21 15:21:30.540] [DEBUG] - host: 172.24.3.124, port: 22, user: root, password: password09!
[2024-02-21 15:21:30.671] [INFO] Load cluster param plugin
[2024-02-21 15:21:30.671] [DEBUG] - Searching param plugin for components …
[2024-02-21 15:21:30.671] [DEBUG] - Search param plugin for oceanbase-ce
[2024-02-21 15:21:30.672] [DEBUG] - Found for oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:30.672] [DEBUG] - Applying oceanbase-ce-param-4.2.0.0 for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:31.262] [INFO] Cluster status check
[2024-02-21 15:21:31.263] [DEBUG] - Searching status plugin for components …
[2024-02-21 15:21:31.263] [DEBUG] - Searching status plugin for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:31.264] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.1.1
[2024-02-21 15:21:31.264] [DEBUG] - Call oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:31.264] [DEBUG] - import status
[2024-02-21 15:21:31.265] [DEBUG] - add status ref count to 1
[2024-02-21 15:21:31.265] [DEBUG] – root@172.24.3.124 execute: cat /home/ocean/oceanbase1/run/observer.pid
[2024-02-21 15:21:31.281] [DEBUG] – exited code 1, error output:
[2024-02-21 15:21:31.281] [DEBUG] cat: /home/ocean/oceanbase1/run/observer.pid: 没有那个文件或目录
[2024-02-21 15:21:31.281] [DEBUG]
[2024-02-21 15:21:31.281] [DEBUG] - sub status ref count to 0
[2024-02-21 15:21:31.281] [DEBUG] - export status
[2024-02-21 15:21:31.394] [DEBUG] - Call oceanbase-ce-py_script_start_check-4.2.0.0 for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:31.395] [DEBUG] - import start_check
[2024-02-21 15:21:31.402] [DEBUG] - add start_check ref count to 1
[2024-02-21 15:21:31.402] [INFO] Check before start observer
[2024-02-21 15:21:31.403] [DEBUG] – root@172.24.3.124 execute: ls /data/clog/tenant_1/
[2024-02-21 15:21:31.419] [DEBUG] – exited code 0
[2024-02-21 15:21:31.419] [DEBUG] – root@172.24.3.124 execute: cat /home/ocean/oceanbase1/run/observer.pid
[2024-02-21 15:21:31.472] [DEBUG] – exited code 1, error output:
[2024-02-21 15:21:31.472] [DEBUG] cat: /home/ocean/oceanbase1/run/observer.pid: 没有那个文件或目录
[2024-02-21 15:21:31.473] [DEBUG]
[2024-02-21 15:21:31.473] [DEBUG] – server1(172.24.3.124) port check
[2024-02-21 15:21:31.473] [DEBUG] – root@172.24.3.124 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:0B41’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-02-21 15:21:31.530] [DEBUG] – exited code 0
[2024-02-21 15:21:31.530] [DEBUG] – root@172.24.3.124 execute: bash -c ‘cat /proc/net/{tcp*,udp*}’ | awk -F’ ’ ‘{print $2,$10}’ | grep ‘00000000:0B42’ | awk -F’ ’ ‘{print $2}’ | uniq
[2024-02-21 15:21:31.587] [DEBUG] – exited code 0
[2024-02-21 15:21:31.588] [DEBUG] – root@172.24.3.124 execute: ls /data/sstable/block_file
[2024-02-21 15:21:31.642] [DEBUG] – exited code 0
[2024-02-21 15:21:31.642] [DEBUG] – root@172.24.3.124 execute: cat /proc/sys/fs/aio-max-nr /proc/sys/fs/aio-nr
[2024-02-21 15:21:31.699] [DEBUG] – exited code 0
[2024-02-21 15:21:31.699] [DEBUG] – root@172.24.3.124 execute: ulimit -a
[2024-02-21 15:21:31.753] [DEBUG] – exited code 0
[2024-02-21 15:21:31.753] [WARNING] OBD-1007: (172.24.3.124) The recommended number of stack size is unlimited (Current value: 20480)
[2024-02-21 15:21:31.753] [DEBUG] – root@172.24.3.124 execute: sysctl -a
[2024-02-21 15:21:31.831] [DEBUG] – exited code 0
[2024-02-21 15:21:31.834] [WARNING] OBD-1017: (172.24.3.124) The value of the “vm.max_map_count” must be within [327600, 1310720] (Current value: 65530, Recommended value: 655360)
[2024-02-21 15:21:31.834] [WARNING] OBD-1017: (172.24.3.124) The value of the “fs.file-max” must be greater than 6573688 (Current value: 1608765, Recommended value: 6573688)
[2024-02-21 15:21:31.834] [DEBUG] – root@172.24.3.124 execute: cat /proc/meminfo
[2024-02-21 15:21:31.885] [DEBUG] – exited code 0
[2024-02-21 15:21:31.885] [DEBUG] – root@172.24.3.124 execute: df --block-size=1024
[2024-02-21 15:21:31.941] [DEBUG] – exited code 0
[2024-02-21 15:21:31.941] [DEBUG] – get disk info for path /, total: 53660876800 avail: 28271583232
[2024-02-21 15:21:31.941] [DEBUG] – get disk info for path /dev, total: 8310325248 avail: 8310325248
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /dev/shm, total: 8327802880 avail: 8327802880
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /run, total: 8327802880 avail: 8317722624
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /sys/fs/cgroup, total: 8327802880 avail: 8327802880
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /boot, total: 1063256064 avail: 886083584
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /home, total: 97788563456 avail: 93690785792
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /run/user/42, total: 1665564672 avail: 1665560576
[2024-02-21 15:21:31.942] [DEBUG] – get disk info for path /run/user/0, total: 1665564672 avail: 1665523712
[2024-02-21 15:21:31.942] [DEBUG] – disk: {’/’: {‘total’: 53660876800, ‘avail’: 28271583232, ‘need’: 0}, ‘/dev’: {‘total’: 8310325248, ‘avail’: 8310325248, ‘need’: 0}, ‘/dev/shm’: {‘total’: 8327802880, ‘avail’: 8327802880, ‘need’: 0}, ‘/run’: {‘total’: 8327802880, ‘avail’: 8317722624, ‘need’: 0}, ‘/sys/fs/cgroup’: {‘total’: 8327802880, ‘avail’: 8327802880, ‘need’: 0}, ‘/boot’: {‘total’: 1063256064, ‘avail’: 886083584, ‘need’: 0}, ‘/home’: {‘total’: 97788563456, ‘avail’: 93690785792, ‘need’: 0}, ‘/run/user/42’: {‘total’: 1665564672, ‘avail’: 1665560576, ‘need’: 0}, ‘/run/user/0’: {‘total’: 1665564672, ‘avail’: 1665523712, ‘need’: 0}}
[2024-02-21 15:21:31.942] [DEBUG] – root@172.24.3.124 execute: date +%s%N
[2024-02-21 15:21:31.994] [DEBUG] – exited code 0
[2024-02-21 15:21:31.995] [DEBUG] – 172.24.3.124 time delta -1.408935546875
[2024-02-21 15:21:32.056] [INFO] [WARN] OBD-1007: (172.24.3.124) The recommended number of stack size is unlimited (Current value: 20480)
[2024-02-21 15:21:32.056] [INFO] [WARN] OBD-1017: (172.24.3.124) The value of the “vm.max_map_count” must be within [327600, 1310720] (Current value: 65530, Recommended value: 655360)
[2024-02-21 15:21:32.056] [INFO] [WARN] OBD-1017: (172.24.3.124) The value of the “fs.file-max” must be greater than 6573688 (Current value: 1608765, Recommended value: 6573688)
[2024-02-21 15:21:32.056] [INFO]
[2024-02-21 15:21:32.056] [DEBUG] - sub start_check ref count to 0
[2024-02-21 15:21:32.056] [DEBUG] - export start_check
[2024-02-21 15:21:32.056] [DEBUG] - Call oceanbase-ce-py_script_start-4.2.0.0 for oceanbase-ce-4.2.1.1-101010012023111012.el7-e98c6ef860b5644c36f806e6fa2265255572b40a
[2024-02-21 15:21:32.056] [DEBUG] - import start
[2024-02-21 15:21:32.058] [DEBUG] - add start ref count to 1
[2024-02-21 15:21:32.058] [INFO] Start observer
[2024-02-21 15:21:32.059] [DEBUG] – root@172.24.3.124 execute: ls /data/clog/tenant_1/
[2024-02-21 15:21:32.074] [DEBUG] – exited code 0
[2024-02-21 15:21:32.074] [DEBUG] – root@172.24.3.124 execute: cat /home/ocean/oceanbase1/run/observer.pid
[2024-02-21 15:21:32.128] [DEBUG] – exited code 1, error output:
[2024-02-21 15:21:32.128] [DEBUG] cat: /home/ocean/oceanbase1/run/observer.pid: 没有那个文件或目录
[2024-02-21 15:21:32.128] [DEBUG]
[2024-02-21 15:21:32.128] [DEBUG] – server1(172.24.3.124) start command construction
[2024-02-21 15:21:32.129] [DEBUG] – starting server1(172.24.3.124) observer
[2024-02-21 15:21:32.129] [DEBUG] – root@172.24.3.124 set env LD_LIBRARY_PATH to ‘/home/ocean/oceanbase1/lib:’
[2024-02-21 15:21:32.129] [DEBUG] – root@172.24.3.124 execute: cd /home/ocean/oceanbase1; /home/ocean/oceanbase1/bin/observer -r ‘172.24.3.124:2882:2881’ -p 2881 -P 2882 -z ‘zone1’ -c 1 -d ‘/data’ -i ‘eth0’ -o __min_full_resource_pool_memory=2147483648,memory_limit=‘10G’,system_memory=‘4G’,datafile_size=‘5G’,datafile_next=‘5G’,datafile_maxsize=‘25G’,log_disk_size=‘14G’,cpu_count=16,enable_syslog_wf=False,enable_syslog_recycle=True,max_syslog_file_count=4
[2024-02-21 15:21:32.273] [DEBUG] – exited code 0
[2024-02-21 15:21:32.274] [DEBUG] – root@172.24.3.124 delete env LD_LIBRARY_PATH
[2024-02-21 15:21:32.321] [INFO] observer program health check
[2024-02-21 15:21:35.324] [DEBUG] – server1(172.24.3.124) program health check
[2024-02-21 15:21:35.325] [DEBUG] – root@172.24.3.124 execute: cat /home/ocean/oceanbase1/run/observer.pid
[2024-02-21 15:21:35.340] [DEBUG] – exited code 1, error output:
[2024-02-21 15:21:35.340] [DEBUG] cat: /home/ocean/oceanbase1/run/observer.pid: 没有那个文件或目录
[2024-02-21 15:21:35.340] [DEBUG]
[2024-02-21 15:21:35.450] [WARNING] OBD-2002: Failed to start server1(172.24.3.124) observer
[2024-02-21 15:21:35.450] [DEBUG] - sub start ref count to 0
[2024-02-21 15:21:35.450] [DEBUG] - export start
[2024-02-21 15:21:35.450] [ERROR] oceanbase-ce start failed
[2024-02-21 15:21:35.453] [INFO] See OceanBase分布式数据库-海量数据 笔笔算数 .
[2024-02-21 15:21:35.453] [INFO] Trace ID: d54a2aac-d089-11ee-b43b-001a4a1601f9
[2024-02-21 15:21:35.453] [INFO] If you want to view detailed obd logs, please run: obd display-trace d54a2aac-d089-11ee-b43b-001a4a1601f9
[2024-02-21 15:21:35.454] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0
[2024-02-21 15:21:35.454] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo
[2024-02-21 15:21:35.454] [DEBUG] - exclusive lock /root/.obd/lock/deploy_obtest5 release, count 0
[2024-02-21 15:21:35.454] [DEBUG] - unlock /root/.obd/lock/deploy_obtest5
[2024-02-21 15:21:35.454] [DEBUG] - share lock /root/.obd/lock/global release, count 0
[2024-02-21 15:21:35.454] [DEBUG] - unlock /root/.obd/lock/global

为什么要修改服务器ip呢?
ip -a 看下

公司网络环境调整 ,修改了服务器IP。旧IP已经不可用了

单机环境还是?

单机环境,集群方式启动的

这种方式参考下https://ask.oceanbase.com/t/topic/35604748/6

1 个赞

当时已经看过这解决办法了,但是不适用
1.我部署的是单机版本,没有其他备份服务器
2.目前旧IP已经无法使用,修改旧配置启动时 在SSH Connection阶段就会报错 。

有无其办法可以将旧库内的数据提取出来 ,我就可以重新部署集群了

之前修改的方式是通过什么方式修改的呢?
是通过edit-config方式将ip地址进行修改的嘛。

之前因为没有数据,是直接重新构建集群的。

ob当前不支持直接修改ip地址。
建议:可以试着修改修改服务器ip地址看看呢。

那是否有办法在不启动OB的情况下将数据库已存储数据导出

没办法。
如果是通过edit-config方式修改的ip,环境会被重装。最好的办法就是把之前ip改回来(配置文件也得还原) 然后新建个集群 创建主备租户 让数据同步 以便于再出现类似情况。
当前是生产环境还是测试呢?