obd部署单机434运行一段时间服务消失

br-1502e2c51048: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.28.0.1 netmask 255.255.0.0 broadcast 172.28.255.255
ether 02:42:b4:7a:1d:85 txqueuelen 0 (Ethernet)
RX packets 9296121 bytes 1033534547 (1.0 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 8463251 bytes 1143052806 (1.1 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-200e40b74abc: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.25.0.1 netmask 255.255.0.0 broadcast 172.25.255.255
ether 02:42:bb:6d:e1:b4 txqueuelen 0 (Ethernet)
RX packets 6447844 bytes 404062466 (404.0 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 5940704 bytes 575678513 (575.6 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-558fd1ed5122: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.22.0.1 netmask 255.255.0.0 broadcast 172.22.255.255
ether 02:42:68:9c:9d:21 txqueuelen 0 (Ethernet)
RX packets 14872665 bytes 924149450 (924.1 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 12847935 bytes 1010116950 (1.0 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-60c5d893c1e2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.20.0.1 netmask 255.255.0.0 broadcast 172.20.255.255
ether 02:42:39:a3:14:57 txqueuelen 0 (Ethernet)
RX packets 6931059 bytes 3739045591 (3.7 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 9104243 bytes 691545604 (691.5 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-8e3188bf3731: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.27.0.1 netmask 255.255.0.0 broadcast 172.27.255.255
ether 02:42:5f:61:5e:ce txqueuelen 0 (Ethernet)
RX packets 14131782 bytes 876552446 (876.5 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 12110535 bytes 952850259 (952.8 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-9ed284d11dfd: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.21.0.1 netmask 255.255.0.0 broadcast 172.21.255.255
ether 02:42:35:af:60:dc txqueuelen 0 (Ethernet)
RX packets 10800792 bytes 1366146795 (1.3 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 17029300 bytes 1898767294 (1.8 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-afed950abd22: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.24.0.1 netmask 255.255.0.0 broadcast 172.24.255.255
ether 02:42:dc:70:49:8e txqueuelen 0 (Ethernet)
RX packets 50498453 bytes 111162040350 (111.1 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 43698707 bytes 4229720765 (4.2 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-d5ddb4e87638: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.19.0.1 netmask 255.255.0.0 broadcast 172.19.255.255
ether 02:42:b0:96:de:54 txqueuelen 0 (Ethernet)
RX packets 15859311 bytes 1910337373 (1.9 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 18867940 bytes 1951552035 (1.9 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-f8be4ab07ee8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.18.0.1 netmask 255.255.0.0 broadcast 172.18.255.255
ether 02:42:e4:d9:76:80 txqueuelen 0 (Ethernet)
RX packets 342771 bytes 2262699518 (2.2 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 277169 bytes 631460776 (631.4 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

br-f8cb923f175e: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.26.0.1 netmask 255.255.0.0 broadcast 172.26.255.255
ether 02:42:7a:c6:1f:9c txqueuelen 0 (Ethernet)
RX packets 17279747 bytes 1050589854 (1.0 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 15240788 bytes 1169926855 (1.1 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

docker0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 172.17.0.1 netmask 255.255.0.0 broadcast 172.17.255.255
ether 02:42:13:d6:68:18 txqueuelen 0 (Ethernet)
RX packets 17467131 bytes 1629174526 (1.6 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 26015951 bytes 2662898321 (2.6 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

ens18: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
inet 192.168.224.169 netmask 255.255.255.0 broadcast 192.168.224.255
inet6 fe80::be24:11ff:fe3f:e8bc prefixlen 64 scopeid 0x20
ether bc:24:11:3f:e8:bc txqueuelen 1000 (Ethernet)
RX packets 159788347 bytes 36548675163 (36.5 GB)
RX errors 0 dropped 654482 overruns 0 frame 0
TX packets 116770355 bytes 169991418759 (169.9 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536
inet 127.0.0.1 netmask 255.0.0.0
loop txqueuelen 1000 (Local Loopback)
RX packets 410211 bytes 170235073 (170.2 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 410211 bytes 170235073 (170.2 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

tailscale0: flags=4305<UP,POINTOPOINT,RUNNING,NOARP,MULTICAST> mtu 1280
inet 100.64.0.1 netmask 255.255.255.255 destination 100.64.0.1
unspec 00-00-00-00-00-00-00-00-00-00-00-00-00-00-00-00 txqueuelen 500 (UNSPEC)
RX packets 85744358 bytes 12220097679 (12.2 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 87577068 bytes 44330887880 (44.3 GB)
TX errors 0 dropped 7113 overruns 0 carrier 0 collisions 0

veth06d73ca: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 0a:31:85:4f:db:07 txqueuelen 0 (Ethernet)
RX packets 4155341 bytes 2227017161 (2.2 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 4518332 bytes 1981706146 (1.9 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth0af4b09: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether c2:03:6e:1d:35:55 txqueuelen 0 (Ethernet)
RX packets 6931059 bytes 3836080417 (3.8 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 9104243 bytes 691545604 (691.5 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth1bdc4c6: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether d2:41:ab:71:54:80 txqueuelen 0 (Ethernet)
RX packets 342771 bytes 2267498312 (2.2 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 277169 bytes 631460776 (631.4 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth22aa4c7: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether f6:bf:02:28:02:a7 txqueuelen 0 (Ethernet)
RX packets 12898208 bytes 953764172 (953.7 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 11000039 bytes 828597188 (828.5 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth273c71e: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether ea:52:4b:ac:80:4b txqueuelen 0 (Ethernet)
RX packets 1763300 bytes 268255523 (268.2 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 963392 bytes 384348990 (384.3 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth2aec0e8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 32:32:87:02:5c:c8 txqueuelen 0 (Ethernet)
RX packets 14029696 bytes 1066381952 (1.0 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 12026185 bytes 945851588 (945.8 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth2e6e1e0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 7e:af:a1:7f:6e:7b txqueuelen 0 (Ethernet)
RX packets 6447844 bytes 494332282 (494.3 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 5940704 bytes 575678513 (575.6 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth3a811d9: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 6e:c3:51:0b:ca:74 txqueuelen 0 (Ethernet)
RX packets 1527877 bytes 543355523 (543.3 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 2860583 bytes 556717996 (556.7 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth692a00c: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 1a:84:b4:d9:90:bf txqueuelen 0 (Ethernet)
RX packets 20706684 bytes 109268902903 (109.2 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 21962086 bytes 2008326432 (2.0 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth6e99d37: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 32:ee:6e:28:96:59 txqueuelen 0 (Ethernet)
RX packets 5112968 bytes 486263860 (486.2 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 2676442 bytes 367087754 (367.0 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth748833b: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether e6:04:33:29:aa:0b txqueuelen 0 (Ethernet)
RX packets 9296105 bytes 1163678428 (1.1 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 8463238 bytes 1143046633 (1.1 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth7ccb072: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 02:67:2a:35:e3:75 txqueuelen 0 (Ethernet)
RX packets 17279747 bytes 1292506312 (1.2 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 15240788 bytes 1169926855 (1.1 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

veth8edad42: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 2a:9f:56:5b:66:10 txqueuelen 0 (Ethernet)
RX packets 7258532 bytes 735661904 (735.6 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 5643909 bytes 609420548 (609.4 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

vetha4a940f: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 42:bf:58:04:08:7d txqueuelen 0 (Ethernet)
RX packets 15859311 bytes 2132367727 (2.1 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 18867940 bytes 1951552035 (1.9 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

vethb88add2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 2a:9d:94:84:a7:d1 txqueuelen 0 (Ethernet)
RX packets 16 bytes 1813 (1.8 KB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 14 bytes 6215 (6.2 KB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

vethb8b78ad: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 06:2a:f7:d8:7c:5f txqueuelen 0 (Ethernet)
RX packets 14749331 bytes 1122393758 (1.1 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 12744845 bytes 1001430374 (1.0 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

vethccf3b09: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 5a:07:12:ca:d9:17 txqueuelen 0 (Ethernet)
RX packets 4531598 bytes 426297589 (426.2 MB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 2425886 bytes 418177662 (418.1 MB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

vethce3de57: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether 26:ba:40:62:03:2b txqueuelen 0 (Ethernet)
RX packets 15263269 bytes 3368713196 (3.3 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 20596015 bytes 3865978816 (3.8 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

vethd96b5ed: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
ether b2:c9:87:f2:ae:ce txqueuelen 0 (Ethernet)
RX packets 17463805 bytes 1873392241 (1.8 GB)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 26013506 bytes 2662669284 (2.6 GB)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

1 个赞

集群铲掉使用obd demo部署或者obd web白屏化部署试试。

1 个赞

obd web白屏化部署,一样出现同样的问题,部署成功,部署后一阵是正常的,后面就出现停用了

1 个赞

observer日志发一份完整的看看,~/oceanbase/log/

1 个赞

log.zip (35.9 MB)

1 个赞

防火墙关闭了么

1 个赞

sudo ufw status
Status: inactive
关了的,要是有开,我也不能在本地连接到内网服务器的部署的oceanbase了,就是不知道为啥过段时间他会自动停用,是配置问题?我使用的是最小安装模式

1 个赞


r日志显示获取sys租户的参数失败。

1 个赞

看下这个呢
sudo ethtool ens18
cat /sys/class/net/ens18/speed

1 个赞




不知道怎么导出,设置都是默认的,又是部署后能连接,过段时间就无法连接了
log.zip (35.5 MB)
log_obshell.zip (115.3 KB)

1 个赞

看一下楼上镜水老师的回复,获取一下
sudo ethtool ens18
cat /sys/class/net/ens18/speed

1 个赞

sudo ethtool ens18
[sudo] password for um:
Settings for ens18:
Supported ports: [ ]
Supported link modes: Not reported
Supported pause frame use: No
Supports auto-negotiation: No
Supported FEC modes: Not reported
Advertised link modes: Not reported
Advertised pause frame use: No
Advertised auto-negotiation: No
Advertised FEC modes: Not reported
Speed: Unknown!
Duplex: Unknown! (255)
Port: Other
PHYAD: 0
Transceiver: internal
Auto-negotiation: off
Link detected: yes
cat /sys/class/net/ens18/speed
-1

1 个赞

麻烦用obdiag诊断工具收集一些信息看看。obd部署的话会自带obdiag工具:
obd obdiag gather scene run --scene=observer.cluster_down

1 个赞

obd obdiag gather scene run myoceanbase --scene=observer.cluster_down 导出了空的文件夹

1 个赞

obd obdiag gather scene run myoceanbase --scene=observer.cluster_down
Get local repositories and plugins ok
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
[WARN] Use centos 7 remote mirror repository for ubuntu 20.04
The tool oceanbase-diagnostic-tool is already installed the latest version 2.5.0
Open ssh connection ok
gather_scenes_run start …
[ERROR] connect OB: 192.168.224.163:2881 with user root@sys failed, error:(2003, “Can’t connect to MySQL server on ‘192.168.224.163’ ([Errno 111] Connection refused)”)
[ERROR] connect OB: 192.168.224.163:2881 with user root@sys failed, error:(2003, “Can’t connect to MySQL server on ‘192.168.224.163’ ([Errno 111] Connection refused)”)
[WARN] args --store_dir [/home/um/apps/base/oceanbase/myoceanbase/oceanbase/gather_scene_20241120151317] incorrect: No such directory, Now create it
[ERROR] Failed to find yaml task path: /home/um/.obdiag/gather/tasks/
[ERROR] Invalid Task :observer.cluster_down. Please check the task is exist.
Gather scene results stored in this directory: /home/um/apps/base/oceanbase/myoceanbase/oceanbase/gather_scene_20241120151317/obdiag_gather_pack_20241120151320
Trace ID: ec3986b6-a70e-11ef-b16b-bc2411950816
If you want to view detailed obdiag logs, please run: /home/um/oceanbase-diagnostic-tool/obdiag display-trace ec3986b6-a70e-11ef-b16b-bc2411950816

[WARN]
Gather all result stored in this directory: /home/um/apps/base/oceanbase/myoceanbase/oceanbase/gather_scene_20241120151317

Trace ID: ea2ac074-a70e-11ef-9e77-bc2411950816
If you want to view detailed obd logs, please run: obd display-trace ea2ac074-a70e-11ef-9e77-bc2411950816

1 个赞

obdiag 版本较低吧 可以先升级一下最新版的

1 个赞

单节点 6G内存不稳定的话,推荐配置是什么

1 个赞

6G是最小规格配置 不适合应用生产环境
推荐可参考该文档https://www.oceanbase.com/docs/community-observer-cn-10000000001879714

1 个赞

这个oceanbase-all-in-one-4.3.4_20241108.el7.x86_64社区版就没有能稳定运行的吗,要不然就卡在 Initialize oceanbase-ce 重试几次就行,要不然就运行一段时间 oceanbase自己挂掉,配置都按文章可选设置了,还试了好几个服务器,都一样,还找不出问题,试过docker部署和 使用 systemd 部署 OceanBase 数据库都不行,搞不明白,是系统问题还是什么问题

1 个赞

找不出原因,可能是触发了什么被系统干掉了,已换4.2.5长期支持版,支持utf8mb4_unicode_ci,稳定运行一天了,没有OLAP的场景就不推荐最新版