FastGPT icon indicating copy to clipboard operation
FastGPT copied to clipboard
verified publisher icon labring

部署fastgpt OceanBase 版本失败

Open itnico opened this issue 8 months ago • 29 comments

我的docker环境： 群晖container manager，cpu：12500h，内存32g 部署postgre，milvus版本都是正常的， 但部署OceanBase 版本不正常

问题如下： 在群晖docker图形界面发现其他容器包括ob都显示绿灯，但fastgpt容器灰色。 通过docker ps命令，发现ob容器长时间处于(health: starting)，无法进入health状态，导致fastgpt容器无法启动。 通过图形界面手动启动fastgpt，可以启动并进入web界面，可以登录，但无法上传知识库文件，说明ob数据库尚未正常，报错提示见截图

docker logs ob查询日志，ob日志 root@asus:/volume2/docker/fastgpt-ob# docker logs ob find obd deploy information, skip configuring... start ob cluster ... Get local repositories ok Load cluster param plugin ok Cluster status check ok [WARN] OBD-1011: (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536) [WARN] OBD-1007: (127.0.0.1) The recommended number of stack size is unlimited (Current value: 8192) [WARN] OBD-1017: (127.0.0.1) The value of the "vm.max_map_count" must be within [327600, 1310720] (Current value: 65530, Recommended value: 655360) [WARN] OBD-1017: (127.0.0.1) The value of the "fs.file-max" must be greater than 6573688 (Current value: 3225830, Recommended value: 6573688) cluster scenario: htap Start observer ok observer program health check ok Connect to observer ok obshell start ok obshell program health check x [WARN] OBD-2012: Failed to start 127.0.0.1 obshell See https://www.oceanbase.com/product/ob-deployer/error-codes . Trace ID: f784d14c-1fea-11f0-bc0b-0242c0a8a006 If you want to view detailed obd logs, please run: obd display-trace f784d14c-1fea-11f0-bc0b-0242c0a8a006 boot success!

Image

Image

itnico avatar Apr 23 '25 03:04 itnico

能检查下这两个点吗：

  1. init.sql 文件和docker-compose在同一个文件夹中 2.Oceanbase 镜像是哪个版本

Amaranterre avatar Apr 23 '25 08:04 Amaranterre

init.sql与compose.yml在同一文件夹以下为ob代码，没改动version: '3.3' services:

vector db

ob: image: oceanbase/oceanbase-ce # docker hub # image: quay.io/oceanbase/oceanbase-ce:4.3.5.1-101000042025031818 # 镜像 container_name: ob restart: always # ports: # 生产环境建议不要暴露 # - 2881:2881 networks: - fastgpt environment: # 这里的配置只有首次运行生效。修改后，重启镜像是不会生效的。需要把持久化数据删除再重启，才有效果 - OB_SYS_PASSWORD=obsyspassword # 不同于传统数据库，OceanBase 数据库的账号包含更多字段，包括用户名、租户名和集群名。经典格式为“用户名@租户名#集群名” # 比如用mysql客户端连接时，根据本文件的默认配置，应该指定 @.” - OB_TENANT_NAME=tenantname - OB_TENANT_PASSWORD=tenantpassword # MODE分为MINI和NORMAL， 后者会最大程度使用主机资源 - MODE=NORMAL - OB_SERVER_IP=127.0.0.1 # 更多环境变量配置见oceanbase官方文档： https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002013494 volumes: - ./ob/data:/root/ob - ./ob/config:/root/.obd/cluster - ./init.sql:/root/boot/init.d/init.sql healthcheck: # obclient -h127.0.0.1 -P2881 @. -ptenantpassword -e "SELECT 1;" test: [ 'CMD-SHELL', 'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"' ] interval: 30s timeout: 10s retries: 1000 start_period: 10s发自我的 iPhone在 2025年4月23日，16:34，Shiver @.> 写道： 请问init.sql放在与docker-compose文件放在同一个文件夹了吗？ 另外如果提供一下docker-compose中对ocean-base配置的改动吗。—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.>

Amaranterre left a comment (labring/FastGPT#4642) 请问init.sql放在与docker-compose文件放在同一个文件夹了吗？ 另外如果提供一下docker-compose中对ocean-base配置的改动吗。

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 23 '25 09:04 itnico

可以试一下这个配置，记得删除持久化文件重新启动一遍 改动就是，将环境变量中的MODE=NORMAL改为了MODE=MINI, 同时添加了环境变量：OB_MEMORY_LIMIT=6G。

  ob:
    image: oceanbase/oceanbase-ce # docker hub
    # image: quay.io/oceanbase/oceanbase-ce:4.3.5.1-101000042025031818 # 镜像
    container_name: ob
    restart: always
    ports: # 生产环境建议不要暴露
      - 2881:2881
    networks:
      - fastgpt
    environment:
      # 这里的配置只有首次运行生效。修改后，重启镜像是不会生效的。需要把持久化数据删除再重启，才有效果
      - OB_SYS_PASSWORD=obsyspassword
      # 不同于传统数据库，OceanBase 数据库的账号包含更多字段，包括用户名、租户名和集群名。经典格式为“用户名@租户名#集群名”
      # 比如用mysql客户端连接时，根据本文件的默认配置，应该指定 “-uroot@tenantname”
      - OB_TENANT_NAME=tenantname
      - OB_TENANT_PASSWORD=tenantpassword
      # MODE分为MINI和NORMAL， 后者会最大程度使用主机资源
      - MODE=MINI
      - OB_SERVER_IP=127.0.0.1
      # 数据库占用内存，这里采用的是文档推荐配置
      - OB_MEMORY_LIMIT=6G
      # 更多环境变量配置见oceanbase官方文档： https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002013494
    volumes:
      - ./ob/data:/root/ob
      - ./ob/config:/root/.obd/cluster
      - ./init.sql:/root/boot/init.d/init.sql
    healthcheck:
    # obclient -h127.0.0.1 -P2881 -uroot@tenantname -ptenantpassword -e "SELECT 1;"
      test: ["CMD-SHELL", "obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e \"SELECT 1;\""]
      interval: 30s
      timeout: 10s
      retries: 1000
      start_period: 10s

Amaranterre avatar Apr 23 '25 09:04 Amaranterre

改动就是，将环境变量中的MODE=NORMAL改为了MODE=MINI, 同时添加了环境变量：OB_MEMORY_LIMIT=6G使用这个也不行，一样发自我的 iPhone在 2025年4月23日，17:33，Shiver @.> 写道： 可以试一下这个配置，记得删除持久化文件重新启动一遍 改动就是，将环境变量中的MODE=NORMAL改为了MODE=MINI, 同时添加了环境变量：OB_MEMORY_LIMIT=6G。 ob: image: oceanbase/oceanbase-ce # docker hub # image: quay.io/oceanbase/oceanbase-ce:4.3.5.1-101000042025031818 # 镜像 container_name: ob restart: always ports: # 生产环境建议不要暴露 - 2881:2881 networks: - fastgpt environment: # 这里的配置只有首次运行生效。修改后，重启镜像是不会生效的。需要把持久化数据删除再重启，才有效果 - OB_SYS_PASSWORD=obsyspassword # 不同于传统数据库，OceanBase 数据库的账号包含更多字段，包括用户名、租户名和集群名。经典格式为“用户名@租户名#集群名” # 比如用mysql客户端连接时，根据本文件的默认配置，应该指定 @.” - OB_TENANT_NAME=tenantname - OB_TENANT_PASSWORD=tenantpassword # MODE分为MINI和NORMAL， 后者会最大程度使用主机资源 - MODE=MINI - OB_SERVER_IP=127.0.0.1 # 数据库占用内存，这里采用的是文档推荐配置 - OB_MEMORY_LIMIT=6G # 更多环境变量配置见oceanbase官方文档： https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002013494 volumes: - ./ob/data:/root/ob - ./ob/config:/root/.obd/cluster - ./init.sql:/root/boot/init.d/init.sql healthcheck: # obclient -h127.0.0.1 -P2881 @.*** -ptenantpassword -e "SELECT 1;" test: ["CMD-SHELL", "obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;""] interval: 30s timeout: 10s retries: 1000 start_period: 10s —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

Amaranterre left a comment (labring/FastGPT#4642) 可以试一下这个配置，记得删除持久化文件重新启动一遍 改动就是，将环境变量中的MODE=NORMAL改为了MODE=MINI, 同时添加了环境变量：OB_MEMORY_LIMIT=6G。 ob: image: oceanbase/oceanbase-ce # docker hub # image: quay.io/oceanbase/oceanbase-ce:4.3.5.1-101000042025031818 # 镜像 container_name: ob restart: always ports: # 生产环境建议不要暴露 - 2881:2881 networks: - fastgpt environment: # 这里的配置只有首次运行生效。修改后，重启镜像是不会生效的。需要把持久化数据删除再重启，才有效果 - OB_SYS_PASSWORD=obsyspassword # 不同于传统数据库，OceanBase 数据库的账号包含更多字段，包括用户名、租户名和集群名。经典格式为“用户名@租户名#集群名” # 比如用mysql客户端连接时，根据本文件的默认配置，应该指定 @.” - OB_TENANT_NAME=tenantname - OB_TENANT_PASSWORD=tenantpassword # MODE分为MINI和NORMAL， 后者会最大程度使用主机资源 - MODE=MINI - OB_SERVER_IP=127.0.0.1 # 数据库占用内存，这里采用的是文档推荐配置 - OB_MEMORY_LIMIT=6G # 更多环境变量配置见oceanbase官方文档： https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002013494 volumes: - ./ob/data:/root/ob - ./ob/config:/root/.obd/cluster - ./init.sql:/root/boot/init.d/init.sql healthcheck: # obclient -h127.0.0.1 -P2881 @. -ptenantpassword -e "SELECT 1;" test: ["CMD-SHELL", "obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;""] interval: 30s timeout: 10s retries: 1000 start_period: 10s

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 23 '25 09:04 itnico

好吧，那要麻烦你协助排查一下。试一下加入环境变量 EXIT_WHILE_ERROR=false 后重新启动。

然后如果还是有错，请进入容器，执行docker log中提到的类似

obd display-trace f784d14c-1fea-11f0-bc0b-0242c0a8a006

的指令，将详细日志发给我们

Amaranterre avatar Apr 23 '25 10:04 Amaranterre

附件是ob日志和compose

2025年4月23日 18:06，Shiver @.***> 写道：

Amaranterre left a comment (labring/FastGPT#4642) 好吧，那要麻烦你协助排查一下。试一下加入环境变量 EXIT_WHILE_ERROR=false 后重新启动。

然后如果还是有错，请进入容器，执行docker log中提到的类似

obd display-trace f784d14c-1fea-11f0-bc0b-0242c0a8a006 的指令，将详细日志发给我们

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.

https://github.com/labring/FastGPT/issues/4642#issuecomment-2823775830 https://github.com/notifications/unsubscribe-auth/AY26KFQ7YLSAWC72O7UMOPD225QZVAVCNFSM6AAAAAB3VHEVKOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMRTG43TKOBTGA

Amaranterre left a comment (labring/FastGPT#4642) https://github.com/labring/FastGPT/issues/4642#issuecomment-2823775830 好吧，那要麻烦你协助排查一下。试一下加入环境变量 EXIT_WHILE_ERROR=false 后重新启动。

然后如果还是有错，请进入容器，执行docker log中提到的类似

obd display-trace f784d14c-1fea-11f0-bc0b-0242c0a8a006 的指令，将详细日志发给我们

— Reply to this email directly, view it on GitHub https://github.com/labring/FastGPT/issues/4642#issuecomment-2823775830, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY26KFQ7YLSAWC72O7UMOPD225QZVAVCNFSM6AAAAAB3VHEVKOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMRTG43TKOBTGA. You are receiving this because you authored the thread.

@.*** ~]# obd display-trace 20917bfc-2037-11f0-9dad-0242c0a8d007 [2025-04-23 11:35:59.018] [DEBUG] - cmd: ['obcluster'] [2025-04-23 11:35:59.018] [DEBUG] - opts: {'servers': None, 'components': None, 'force_delete': None, 'strict_check': None, 'without_parameter': None} [2025-04-23 11:35:59.018] [DEBUG] - mkdir /root/.obd/lock/ [2025-04-23 11:35:59.018] [DEBUG] - unknown lock mode [2025-04-23 11:35:59.019] [DEBUG] - try to get share lock /root/.obd/lock/global [2025-04-23 11:35:59.019] [DEBUG] - share lock /root/.obd/lock/global, count 1 [2025-04-23 11:35:59.019] [DEBUG] - Get Deploy by name [2025-04-23 11:35:59.019] [DEBUG] - mkdir /root/.obd/cluster/ [2025-04-23 11:35:59.019] [DEBUG] - mkdir /root/.obd/config_parser/ [2025-04-23 11:35:59.019] [DEBUG] - try to get exclusive lock /root/.obd/lock/deploy_obcluster [2025-04-23 11:35:59.019] [DEBUG] - exclusive lock /root/.obd/lock/deploy_obcluster, count 1 [2025-04-23 11:35:59.021] [DEBUG] - Deploy status judge [2025-04-23 11:35:59.022] [INFO] Get local repositories [2025-04-23 11:35:59.022] [DEBUG] - mkdir /root/.obd/repository [2025-04-23 11:35:59.022] [DEBUG] - Get local repository oceanbase-ce-4.3.5.1-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.022] [DEBUG] - Search repository oceanbase-ce version: 4.3.5.1, tag: 3a4f23adb7973d6d1d6969bcd9ae108f8c564b66, release: None, package_hash: None [2025-04-23 11:35:59.022] [DEBUG] - try to get share lock /root/.obd/lock/mirror_and_repo [2025-04-23 11:35:59.022] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo, count 1 [2025-04-23 11:35:59.022] [DEBUG] - mkdir /root/.obd/repository/oceanbase-ce [2025-04-23 11:35:59.023] [DEBUG] - Found repository oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.023] [DEBUG] - Get deploy config [2025-04-23 11:35:59.028] [INFO] Load cluster param plugin [2025-04-23 11:35:59.028] [DEBUG] - Get local repository oceanbase-ce-4.3.5.1-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.028] [DEBUG] - Searching param plugin for components ... [2025-04-23 11:35:59.028] [DEBUG] - Search param plugin for oceanbase-ce [2025-04-23 11:35:59.028] [DEBUG] - mkdir /root/.obd/plugins [2025-04-23 11:35:59.030] [DEBUG] - Found for oceanbase-ce-param-4.3.3.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.030] [DEBUG] - Applying oceanbase-ce-param-4.3.3.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.473] [INFO] Cluster status check [2025-04-23 11:35:59.473] [DEBUG] - Searching status template for components ... [2025-04-23 11:35:59.473] [DEBUG] - mkdir /root/.obd/workflows [2025-04-23 11:35:59.475] [DEBUG] - Call workflow oceanbase-ce-py_script_workflow_status-0.1 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.475] [DEBUG] - mkdir /root/.obd/mirror [2025-04-23 11:35:59.475] [DEBUG] - mkdir /root/.obd/mirror/remote [2025-04-23 11:35:59.475] [DEBUG] - mkdir /root/.obd/mirror/local [2025-04-23 11:35:59.475] [DEBUG] - mkdir /root/.obd/optimize/ [2025-04-23 11:35:59.476] [DEBUG] - mkdir /root/.obd/tool/ [2025-04-23 11:35:59.476] [DEBUG] - import status [2025-04-23 11:35:59.476] [DEBUG] - add status ref count to 1 [2025-04-23 11:35:59.476] [DEBUG] - sub status ref count to 0 [2025-04-23 11:35:59.477] [DEBUG] - export status [2025-04-23 11:35:59.477] [DEBUG] - plugin oceanbase-ce-py_script_workflow_status-0.1 result: True [2025-04-23 11:35:59.477] [DEBUG] - Found for oceanbase-ce-py_script_workflow_status-0.1 for oceanbase-ce-0.1 [2025-04-23 11:35:59.477] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo, count 2 [2025-04-23 11:35:59.478] [DEBUG] - Searching status plugin for components ... [2025-04-23 11:35:59.479] [DEBUG] - Searching status plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.479] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.479] [DEBUG] - Call plugin oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.483] [DEBUG] - import status [2025-04-23 11:35:59.483] [DEBUG] - add status ref count to 1 [2025-04-23 11:35:59.484] [DEBUG] -- local execute: cat /root/ob/observer/run/observer.pid [2025-04-23 11:35:59.487] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.487] [DEBUG] -- local execute: ls /proc/350 [2025-04-23 11:35:59.489] [DEBUG] -- exited code 2, error output: [2025-04-23 11:35:59.489] [DEBUG] ls: cannot access '/proc/350': No such file or directory [2025-04-23 11:35:59.489] [DEBUG] [2025-04-23 11:35:59.490] [DEBUG] - sub status ref count to 0 [2025-04-23 11:35:59.490] [DEBUG] - export status [2025-04-23 11:35:59.490] [DEBUG] - plugin oceanbase-ce-py_script_status-3.1.0 result: True [2025-04-23 11:35:59.490] [DEBUG] - Searching start_check template for components ... [2025-04-23 11:35:59.491] [DEBUG] - Call workflow oceanbase-ce-py_script_workflow_start_check-4.3.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.491] [DEBUG] - import start_check [2025-04-23 11:35:59.491] [DEBUG] - add start_check ref count to 1 [2025-04-23 11:35:59.492] [DEBUG] - sub start_check ref count to 0 [2025-04-23 11:35:59.492] [DEBUG] - export start_check [2025-04-23 11:35:59.492] [DEBUG] - plugin oceanbase-ce-py_script_workflow_start_check-4.3.0.0 result: True [2025-04-23 11:35:59.492] [DEBUG] - Found for oceanbase-ce-py_script_workflow_start_check-4.3.0.0 for oceanbase-ce-4.3.0.0 [2025-04-23 11:35:59.492] [DEBUG] - Searching start_check_pre plugin for components ... [2025-04-23 11:35:59.492] [DEBUG] - Searching start_check_pre plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.493] [DEBUG] - Found for oceanbase-ce-py_script_start_check_pre-4.3.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.493] [DEBUG] - Call plugin oceanbase-ce-py_script_start_check_pre-4.3.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.493] [DEBUG] - import start_check_pre [2025-04-23 11:35:59.494] [DEBUG] - add start_check_pre ref count to 1 [2025-04-23 11:35:59.495] [DEBUG] - sub start_check_pre ref count to 0 [2025-04-23 11:35:59.495] [DEBUG] - export start_check_pre [2025-04-23 11:35:59.495] [DEBUG] - plugin oceanbase-ce-py_script_start_check_pre-4.3.0.0 result: True [2025-04-23 11:35:59.495] [DEBUG] - Searching status_check plugin for components ... [2025-04-23 11:35:59.495] [DEBUG] - Searching status_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.496] [DEBUG] - Found for oceanbase-ce-py_script_status_check-4.2.1.4 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.496] [DEBUG] - Call plugin oceanbase-ce-py_script_status_check-4.2.1.4 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.496] [DEBUG] - import status_check [2025-04-23 11:35:59.497] [DEBUG] - add status_check ref count to 1 [2025-04-23 11:35:59.497] [DEBUG] -- local execute: ls /root/ob/observer/store/clog/tenant_1/ [2025-04-23 11:35:59.500] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.500] [DEBUG] -- local execute: cat /root/ob/observer/run/observer.pid [2025-04-23 11:35:59.502] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.502] [DEBUG] -- local execute: ls /proc/350 [2025-04-23 11:35:59.505] [DEBUG] -- exited code 2, error output: [2025-04-23 11:35:59.505] [DEBUG] ls: cannot access '/proc/350': No such file or directory [2025-04-23 11:35:59.505] [DEBUG] [2025-04-23 11:35:59.505] [DEBUG] - sub status_check ref count to 0 [2025-04-23 11:35:59.505] [DEBUG] - export status_check [2025-04-23 11:35:59.505] [DEBUG] - plugin oceanbase-ce-py_script_status_check-4.2.1.4 result: True [2025-04-23 11:35:59.505] [DEBUG] - Searching parameter_check plugin for components ... [2025-04-23 11:35:59.505] [DEBUG] - Searching parameter_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.506] [DEBUG] - Found for oceanbase-ce-py_script_parameter_check-4.0.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.506] [DEBUG] - Call plugin oceanbase-ce-py_script_parameter_check-4.0.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.506] [DEBUG] - import parameter_check [2025-04-23 11:35:59.508] [DEBUG] - add parameter_check ref count to 1 [2025-04-23 11:35:59.508] [DEBUG] -- local execute: ls /root/ob/observer/store/sstable/block_file [2025-04-23 11:35:59.511] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.511] [DEBUG] - sub parameter_check ref count to 0 [2025-04-23 11:35:59.511] [DEBUG] - export parameter_check [2025-04-23 11:35:59.511] [DEBUG] - plugin oceanbase-ce-py_script_parameter_check-4.0.0.0 result: True [2025-04-23 11:35:59.512] [DEBUG] - Searching system_limits_check plugin for components ... [2025-04-23 11:35:59.512] [DEBUG] - Searching system_limits_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.512] [DEBUG] - Found for oceanbase-ce-py_script_system_limits_check-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.512] [DEBUG] - Call plugin oceanbase-ce-py_script_system_limits_check-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.512] [DEBUG] - import system_limits_check [2025-04-23 11:35:59.514] [DEBUG] - add system_limits_check ref count to 1 [2025-04-23 11:35:59.514] [DEBUG] -- local execute: cat /proc/sys/fs/aio-max-nr /proc/sys/fs/aio-nr [2025-04-23 11:35:59.517] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.517] [WARNING] OBD-1011: (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536) [2025-04-23 11:35:59.517] [DEBUG] -- local execute: bash -c "ulimit -a" [2025-04-23 11:35:59.520] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.520] [WARNING] OBD-1007: (127.0.0.1) The recommended number of stack size is unlimited (Current value: 8192) [2025-04-23 11:35:59.520] [DEBUG] -- local execute: sysctl -a [2025-04-23 11:35:59.533] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.535] [WARNING] OBD-1017: (127.0.0.1) The value of the "vm.max_map_count" must be within [327600, 1310720] (Current value: 65530, Recommended value: 655360) [2025-04-23 11:35:59.535] [WARNING] OBD-1017: (127.0.0.1) The value of the "fs.file-max" must be greater than 6573688 (Current value: 3225830, Recommended value: 6573688) [2025-04-23 11:35:59.535] [DEBUG] - sub system_limits_check ref count to 0 [2025-04-23 11:35:59.535] [DEBUG] - export system_limits_check [2025-04-23 11:35:59.535] [DEBUG] - plugin oceanbase-ce-py_script_system_limits_check-3.1.0 result: True [2025-04-23 11:35:59.536] [DEBUG] - Searching resource_check plugin for components ... [2025-04-23 11:35:59.536] [DEBUG] - Searching resource_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.536] [DEBUG] - Found for oceanbase-ce-py_script_resource_check-4.0.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.536] [DEBUG] - Call plugin oceanbase-ce-py_script_resource_check-4.0.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.537] [DEBUG] - import resource_check [2025-04-23 11:35:59.539] [DEBUG] - add resource_check ref count to 1 [2025-04-23 11:35:59.539] [DEBUG] -- local execute: cat /proc/meminfo [2025-04-23 11:35:59.542] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.543] [WARNING] OBD-2000: (127.0.0.1) not enough memory. (Free: 4G, Need: 6G) [2025-04-23 11:35:59.543] [DEBUG] -- local execute: df --block-size=1024
[2025-04-23 11:35:59.546] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.546] [DEBUG] -- get disk info for path /, total: 468990296064 avail: 100063694848 [2025-04-23 11:35:59.546] [DEBUG] -- get disk info for path /dev, total: 67108864 avail: 67108864 [2025-04-23 11:35:59.546] [DEBUG] -- get disk info for path /sys/fs/cgroup, total: 16614572032 avail: 16614572032 [2025-04-23 11:35:59.547] [DEBUG] -- get disk info for path /dev/shm, total: 67108864 avail: 67108864 [2025-04-23 11:35:59.547] [DEBUG] -- get disk info for path /root/ob, total: 468990296064 avail: 100063694848 [2025-04-23 11:35:59.547] [DEBUG] -- get disk info for path /etc/hosts, total: 468990296064 avail: 100063694848 [2025-04-23 11:35:59.547] [DEBUG] -- get disk info for path /proc/acpi, total: 16614572032 avail: 16614572032 [2025-04-23 11:35:59.547] [DEBUG] -- get disk info for path /proc/scsi, total: 16614572032 avail: 16614572032 [2025-04-23 11:35:59.547] [DEBUG] -- get disk info for path /sys/firmware, total: 16614572032 avail: 16614572032 [2025-04-23 11:35:59.547] [DEBUG] -- disk: {'/': {'total': 468990296064, 'avail': 100063694848, 'need': 0}, '/dev': {'total': 67108864, 'avail': 67108864, 'need': 0}, '/sys/fs/cgroup': {'total': 16614572032, 'avail': 16614572032, 'need': 0}, '/dev/shm': {'total': 67108864, 'avail': 67108864, 'need': 0}, '/root/ob': {'total': 468990296064, 'avail': 100063694848, 'need': 0}, '/etc/hosts': {'total': 468990296064, 'avail': 100063694848, 'need': 0}, '/proc/acpi': {'total': 16614572032, 'avail': 16614572032, 'need': 0}, '/proc/scsi': {'total': 16614572032, 'avail': 16614572032, 'need': 0}, '/sys/firmware': {'total': 16614572032, 'avail': 16614572032, 'need': 0}} [2025-04-23 11:35:59.547] [DEBUG] -- local execute: date +%s%N [2025-04-23 11:35:59.549] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.550] [DEBUG] -- 127.0.0.1 time delta 0.94189453125 [2025-04-23 11:35:59.550] [DEBUG] - sub resource_check ref count to 0 [2025-04-23 11:35:59.550] [DEBUG] - export resource_check [2025-04-23 11:35:59.550] [DEBUG] - plugin oceanbase-ce-py_script_resource_check-4.0.0.0 result: True [2025-04-23 11:35:59.550] [DEBUG] - Searching environment_check plugin for components ... [2025-04-23 11:35:59.550] [DEBUG] - Searching environment_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.551] [DEBUG] - Found for oceanbase-ce-py_script_environment_check-4.2.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.551] [DEBUG] - Call plugin oceanbase-ce-py_script_environment_check-4.2.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.551] [DEBUG] - import environment_check [2025-04-23 11:35:59.553] [DEBUG] - add environment_check ref count to 1 [2025-04-23 11:35:59.554] [DEBUG] -- 127.0.0.1 port check [2025-04-23 11:35:59.554] [DEBUG] -- local execute: bash -c 'cat /proc/net/{tcp*,udp*}' | awk -F' ' '{if($4=="0A") print $2,$4,$10}' | grep ':0B41' | awk -F' ' '{print $3}' | uniq [2025-04-23 11:35:59.560] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.560] [DEBUG] -- local execute: bash -c 'cat /proc/net/{tcp*,udp*}' | awk -F' ' '{if($4=="0A") print $2,$4,$10}' | grep ':0B42' | awk -F' ' '{print $3}' | uniq [2025-04-23 11:35:59.565] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.565] [DEBUG] - sub environment_check ref count to 0 [2025-04-23 11:35:59.565] [DEBUG] - export environment_check [2025-04-23 11:35:59.565] [DEBUG] - plugin oceanbase-ce-py_script_environment_check-4.2.0.0 result: True [2025-04-23 11:35:59.565] [DEBUG] - Searching obshell_port_check plugin for components ... [2025-04-23 11:35:59.565] [DEBUG] - Searching obshell_port_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.566] [DEBUG] - Found for oceanbase-ce-py_script_obshell_port_check-4.2.1.4 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.566] [DEBUG] - Call plugin oceanbase-ce-py_script_obshell_port_check-4.2.1.4 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.566] [DEBUG] - import obshell_port_check [2025-04-23 11:35:59.567] [DEBUG] - add obshell_port_check ref count to 1 [2025-04-23 11:35:59.568] [DEBUG] -- local execute: cat /root/ob/observer/run/obshell.pid [2025-04-23 11:35:59.571] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.571] [DEBUG] -- local execute: ls /proc/833 [2025-04-23 11:35:59.573] [DEBUG] -- exited code 2, error output: [2025-04-23 11:35:59.574] [DEBUG] ls: cannot access '/proc/833': No such file or directory [2025-04-23 11:35:59.574] [DEBUG] [2025-04-23 11:35:59.574] [DEBUG] -- 127.0.0.1 port check [2025-04-23 11:35:59.574] [DEBUG] -- local execute: bash -c 'cat /proc/net/{tcp*,udp*}' | awk -F' ' '{if($4=="0A") print $2,$4,$10}' | grep ':0B46' | awk -F' ' '{print $3}' | uniq [2025-04-23 11:35:59.578] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.579] [DEBUG] - sub obshell_port_check ref count to 0 [2025-04-23 11:35:59.579] [DEBUG] - export obshell_port_check [2025-04-23 11:35:59.579] [DEBUG] - plugin oceanbase-ce-py_script_obshell_port_check-4.2.1.4 result: True [2025-04-23 11:35:59.579] [DEBUG] - Searching scenario_start_check plugin for components ... [2025-04-23 11:35:59.579] [DEBUG] - Searching scenario_start_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.580] [DEBUG] - Found for oceanbase-ce-py_script_scenario_start_check-4.3.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.580] [DEBUG] - Call plugin oceanbase-ce-py_script_scenario_start_check-4.3.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.580] [DEBUG] - import scenario_start_check [2025-04-23 11:35:59.581] [DEBUG] - add scenario_start_check ref count to 1 [2025-04-23 11:35:59.581] [DEBUG] - sub scenario_start_check ref count to 0 [2025-04-23 11:35:59.581] [DEBUG] - export scenario_start_check [2025-04-23 11:35:59.581] [DEBUG] - plugin oceanbase-ce-py_script_scenario_start_check-4.3.0.0 result: True [2025-04-23 11:35:59.581] [DEBUG] - Searching ocp_tenant_check plugin for components ... [2025-04-23 11:35:59.581] [DEBUG] - Searching ocp_tenant_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.582] [DEBUG] - Found for oceanbase-ce-py_script_ocp_tenant_check-4.0.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.582] [DEBUG] - Call plugin oceanbase-ce-py_script_ocp_tenant_check-4.0.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.582] [DEBUG] - import ocp_tenant_check [2025-04-23 11:35:59.583] [DEBUG] - add ocp_tenant_check ref count to 1 [2025-04-23 11:35:59.583] [DEBUG] - sub ocp_tenant_check ref count to 0 [2025-04-23 11:35:59.583] [DEBUG] - export ocp_tenant_check [2025-04-23 11:35:59.583] [DEBUG] - plugin oceanbase-ce-py_script_ocp_tenant_check-4.0.0.0 result: True [2025-04-23 11:35:59.584] [DEBUG] - Searching start template for components ... [2025-04-23 11:35:59.584] [DEBUG] - Call workflow oceanbase-ce-py_script_workflow_start-4.2.1.4 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.584] [DEBUG] - import start [2025-04-23 11:35:59.585] [DEBUG] - add start ref count to 1 [2025-04-23 11:35:59.585] [DEBUG] - sub start ref count to 0 [2025-04-23 11:35:59.585] [DEBUG] - export start [2025-04-23 11:35:59.585] [DEBUG] - plugin oceanbase-ce-py_script_workflow_start-4.2.1.4 result: True [2025-04-23 11:35:59.585] [DEBUG] - Found for oceanbase-ce-py_script_workflow_start-4.2.1.4 for oceanbase-ce-4.2.1.4 [2025-04-23 11:35:59.585] [DEBUG] - Searching configserver_pre plugin for components ... [2025-04-23 11:35:59.585] [DEBUG] - Searching configserver_pre plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.586] [DEBUG] - Found for oceanbase-ce-py_script_configserver_pre-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.586] [DEBUG] - Call plugin oceanbase-ce-py_script_configserver_pre-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.586] [DEBUG] - import configserver_pre [2025-04-23 11:35:59.587] [DEBUG] - add configserver_pre ref count to 1 [2025-04-23 11:35:59.587] [DEBUG] - sub configserver_pre ref count to 0 [2025-04-23 11:35:59.587] [DEBUG] - export configserver_pre [2025-04-23 11:35:59.587] [DEBUG] - plugin oceanbase-ce-py_script_configserver_pre-3.1.0 result: True [2025-04-23 11:35:59.588] [DEBUG] - Searching start_pre plugin for components ... [2025-04-23 11:35:59.588] [DEBUG] - Searching start_pre plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.588] [DEBUG] - Found for oceanbase-ce-py_script_start_pre-4.3.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.588] [DEBUG] - Call plugin oceanbase-ce-py_script_start_pre-4.3.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.588] [DEBUG] - import start_pre [2025-04-23 11:35:59.590] [DEBUG] - add start_pre ref count to 1 [2025-04-23 11:35:59.590] [INFO] cluster scenario: express_oltp [2025-04-23 11:35:59.591] [DEBUG] -- local execute: ls /root/ob/observer/store/clog/tenant_1/ [2025-04-23 11:35:59.593] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.594] [DEBUG] -- local execute: cat /root/ob/observer/run/observer.pid [2025-04-23 11:35:59.596] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.596] [DEBUG] -- local execute: ls /proc/350 [2025-04-23 11:35:59.599] [DEBUG] -- exited code 2, error output: [2025-04-23 11:35:59.599] [DEBUG] ls: cannot access '/proc/350': No such file or directory [2025-04-23 11:35:59.599] [DEBUG] [2025-04-23 11:35:59.599] [DEBUG] -- 127.0.0.1 start command construction [2025-04-23 11:35:59.599] [DEBUG] -- update enable_record_trace_log to False because of scenario [2025-04-23 11:35:59.599] [DEBUG] -- update enable_syslog_recycle to 1 because of scenario [2025-04-23 11:35:59.599] [DEBUG] -- update max_syslog_file_count to 300 because of scenario [2025-04-23 11:35:59.599] [DEBUG] - sub start_pre ref count to 0 [2025-04-23 11:35:59.600] [DEBUG] - export start_pre [2025-04-23 11:35:59.600] [DEBUG] - plugin oceanbase-ce-py_script_start_pre-4.3.0.0 result: True [2025-04-23 11:35:59.600] [DEBUG] - Searching start plugin for components ... [2025-04-23 11:35:59.600] [DEBUG] - Searching start plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.600] [DEBUG] - Found for oceanbase-ce-py_script_start-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.600] [DEBUG] - Call plugin oceanbase-ce-py_script_start-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.601] [DEBUG] - import start [2025-04-23 11:35:59.601] [DEBUG] - add start ref count to 1 [2025-04-23 11:35:59.602] [INFO] Start observer [2025-04-23 11:35:59.602] [DEBUG] -- starting 127.0.0.1 observer [2025-04-23 11:35:59.602] [DEBUG] -- @.*** export LD_LIBRARY_PATH='/root/ob/observer/lib:' [2025-04-23 11:35:59.602] [DEBUG] -- local execute: cd /root/ob/observer; /root/ob/observer/bin/observer -p 2881 -P 2882 -z 'zone1' -n 'obcluster' -c 1745401980 -d '/root/ob/observer/store' -l 'INFO' -I '127.0.0.1' -o __min_full_resource_pool_memory=2147483648,memory_limit='6G',system_memory='1G',datafile_size='5G',log_disk_size='5G',cpu_count=16,enable_syslog_wf=False,enable_syslog_recycle=True,max_syslog_file_count=4,enable_rich_error_msg=True,enable_record_trace_log=False [2025-04-23 11:35:59.784] [DEBUG] -- exited code 0 [2025-04-23 11:35:59.784] [DEBUG] -- @.*** delete env LD_LIBRARY_PATH [2025-04-23 11:35:59.784] [DEBUG] -- need_bootstrap: False [2025-04-23 11:35:59.785] [DEBUG] - sub start ref count to 0 [2025-04-23 11:35:59.785] [DEBUG] - export start [2025-04-23 11:35:59.785] [DEBUG] - plugin oceanbase-ce-py_script_start-3.1.0 result: True [2025-04-23 11:35:59.785] [DEBUG] - Searching health_check plugin for components ... [2025-04-23 11:35:59.785] [DEBUG] - Searching health_check plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.786] [DEBUG] - Found for oceanbase-ce-py_script_health_check-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:35:59.786] [DEBUG] - Call plugin oceanbase-ce-py_script_health_check-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:35:59.786] [DEBUG] - import health_check [2025-04-23 11:35:59.787] [DEBUG] - add health_check ref count to 1 [2025-04-23 11:35:59.787] [INFO] observer program health check [2025-04-23 11:36:02.789] [DEBUG] -- 127.0.0.1 program health check [2025-04-23 11:36:02.790] [DEBUG] -- local execute: cat /root/ob/observer/run/observer.pid [2025-04-23 11:36:02.792] [DEBUG] -- exited code 0 [2025-04-23 11:36:02.793] [DEBUG] -- local execute: ls /proc/86 [2025-04-23 11:36:02.795] [DEBUG] -- exited code 0 [2025-04-23 11:36:02.796] [DEBUG] -- 127.0.0.1 observer[pid: 86] started [2025-04-23 11:36:02.796] [DEBUG] - sub health_check ref count to 0 [2025-04-23 11:36:02.796] [DEBUG] - export health_check [2025-04-23 11:36:02.796] [DEBUG] - plugin oceanbase-ce-py_script_health_check-3.1.0 result: True [2025-04-23 11:36:02.796] [DEBUG] - Searching connect plugin for components ... [2025-04-23 11:36:02.797] [DEBUG] - Searching connect plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:02.798] [DEBUG] - Found for oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:02.798] [DEBUG] - Call plugin oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:02.799] [DEBUG] - import connect [2025-04-23 11:36:02.800] [DEBUG] - add connect ref count to 1 [2025-04-23 11:36:02.800] [INFO] Connect to observer [2025-04-23 11:36:02.800] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p****** [2025-04-23 11:36:05.806] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p [2025-04-23 11:36:08.810] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p****** [2025-04-23 11:36:11.814] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p [2025-04-23 11:36:14.817] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p****** [2025-04-23 11:36:17.821] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p [2025-04-23 11:36:20.842] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p****** [2025-04-23 11:36:20.845] [DEBUG] -- execute sql: select 1. args: None [2025-04-23 11:36:20.847] [DEBUG] - sub connect ref count to 0 [2025-04-23 11:36:20.847] [DEBUG] - export connect [2025-04-23 11:36:20.847] [DEBUG] - plugin oceanbase-ce-py_script_connect-3.1.0 result: True [2025-04-23 11:36:20.847] [DEBUG] - Searching bootstrap plugin for components ... [2025-04-23 11:36:20.847] [DEBUG] - Searching bootstrap plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.848] [DEBUG] - Found for oceanbase-ce-py_script_bootstrap-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.848] [DEBUG] - Call plugin oceanbase-ce-py_script_bootstrap-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.848] [DEBUG] - import bootstrap [2025-04-23 11:36:20.849] [DEBUG] - add bootstrap ref count to 1 [2025-04-23 11:36:20.849] [DEBUG] - sub bootstrap ref count to 0 [2025-04-23 11:36:20.849] [DEBUG] - export bootstrap [2025-04-23 11:36:20.849] [DEBUG] - plugin oceanbase-ce-py_script_bootstrap-3.1.0 result: True [2025-04-23 11:36:20.849] [DEBUG] - Searching user_pre plugin for components ... [2025-04-23 11:36:20.849] [DEBUG] - Searching user_pre plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.850] [DEBUG] - Found for oceanbase-ce-py_script_user_pre-4.2.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.850] [DEBUG] - Call plugin oceanbase-ce-py_script_user_pre-4.2.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.850] [DEBUG] - import user_pre [2025-04-23 11:36:20.851] [DEBUG] - add user_pre ref count to 1 [2025-04-23 11:36:20.851] [DEBUG] -- bootstrap for components: dict_keys(['oceanbase-ce']) [2025-04-23 11:36:20.851] [DEBUG] -- scale out for components: [] [2025-04-23 11:36:20.851] [DEBUG] - sub user_pre ref count to 0 [2025-04-23 11:36:20.851] [DEBUG] - export user_pre [2025-04-23 11:36:20.851] [DEBUG] - plugin oceanbase-ce-py_script_user_pre-4.2.1.0 result: True [2025-04-23 11:36:20.851] [DEBUG] - Searching create_user plugin for components ... [2025-04-23 11:36:20.852] [DEBUG] - Searching create_user plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.852] [DEBUG] - Found for oceanbase-ce-py_script_create_user-4.0.0.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.852] [DEBUG] - Call plugin oceanbase-ce-py_script_create_user-4.0.0.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.852] [DEBUG] - import create_user [2025-04-23 11:36:20.854] [DEBUG] - add create_user ref count to 1 [2025-04-23 11:36:20.854] [DEBUG] - sub create_user ref count to 0 [2025-04-23 11:36:20.854] [DEBUG] - export create_user [2025-04-23 11:36:20.854] [DEBUG] - plugin oceanbase-ce-py_script_create_user-4.0.0.0 result: True [2025-04-23 11:36:20.854] [DEBUG] - Searching obshell_start plugin for components ... [2025-04-23 11:36:20.855] [DEBUG] - Searching obshell_start plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.855] [DEBUG] - Found for oceanbase-ce-py_script_obshell_start-4.2.1.4 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.855] [DEBUG] - Call plugin oceanbase-ce-py_script_obshell_start-4.2.1.4 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.855] [DEBUG] - import obshell_start [2025-04-23 11:36:20.856] [DEBUG] - add obshell_start ref count to 1 [2025-04-23 11:36:20.856] [DEBUG] -- start_obshell: True [2025-04-23 11:36:20.856] [INFO] obshell start [2025-04-23 11:36:20.856] [DEBUG] -- local execute: cat /root/ob/observer/run/obshell.pid [2025-04-23 11:36:20.858] [DEBUG] -- exited code 0 [2025-04-23 11:36:20.859] [DEBUG] -- local execute: ls /proc/833 [2025-04-23 11:36:20.862] [DEBUG] -- exited code 0 [2025-04-23 11:36:20.862] [DEBUG] -- 127.0.0.1 obshell[pid: 833] started [2025-04-23 11:36:20.862] [INFO] obshell program health check [2025-04-23 11:36:20.862] [DEBUG] -- local execute: cat /root/ob/observer/run/obshell.pid [2025-04-23 11:36:20.866] [DEBUG] -- exited code 0 [2025-04-23 11:36:20.866] [DEBUG] -- Get 127.0.0.1 obshell[pid: 833] [2025-04-23 11:36:20.866] [DEBUG] -- local execute: ls /proc/833 [2025-04-23 11:36:20.869] [DEBUG] -- exited code 0 [2025-04-23 11:36:20.870] [DEBUG] -- 127.0.0.1 obshell[pid: 833] started [2025-04-23 11:36:20.870] [DEBUG] - sub obshell_start ref count to 0 [2025-04-23 11:36:20.870] [DEBUG] - export obshell_start [2025-04-23 11:36:20.870] [DEBUG] - plugin oceanbase-ce-py_script_obshell_start-4.2.1.4 result: True [2025-04-23 11:36:20.870] [DEBUG] - Searching obshell_bootstrap plugin for components ... [2025-04-23 11:36:20.870] [DEBUG] - Searching obshell_bootstrap plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.870] [DEBUG] - Found for oceanbase-ce-py_script_obshell_bootstrap-4.2.1.4 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.870] [DEBUG] - Call plugin oceanbase-ce-py_script_obshell_bootstrap-4.2.1.4 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.871] [DEBUG] - import obshell_bootstrap [2025-04-23 11:36:20.924] [DEBUG] - add obshell_bootstrap ref count to 1 [2025-04-23 11:36:20.925] [DEBUG] - sub obshell_bootstrap ref count to 0 [2025-04-23 11:36:20.925] [DEBUG] - export obshell_bootstrap [2025-04-23 11:36:20.925] [DEBUG] - plugin oceanbase-ce-py_script_obshell_bootstrap-4.2.1.4 result: True [2025-04-23 11:36:20.925] [DEBUG] - Searching display template for components ... [2025-04-23 11:36:20.926] [DEBUG] - Call workflow oceanbase-ce-py_script_workflow_display-0.1 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.926] [DEBUG] - import display [2025-04-23 11:36:20.927] [DEBUG] - add display ref count to 1 [2025-04-23 11:36:20.927] [DEBUG] - sub display ref count to 0 [2025-04-23 11:36:20.927] [DEBUG] - export display [2025-04-23 11:36:20.927] [DEBUG] - plugin oceanbase-ce-py_script_workflow_display-0.1 result: True [2025-04-23 11:36:20.927] [DEBUG] - Found for oceanbase-ce-py_script_workflow_display-0.1 for oceanbase-ce-0.1 [2025-04-23 11:36:20.927] [DEBUG] - Searching status plugin for components ... [2025-04-23 11:36:20.927] [DEBUG] - Searching status plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.927] [DEBUG] - Found for oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.928] [DEBUG] - Call plugin oceanbase-ce-py_script_status-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.928] [DEBUG] -- local execute: cat /root/ob/observer/run/observer.pid [2025-04-23 11:36:20.930] [DEBUG] -- exited code 0 [2025-04-23 11:36:20.931] [DEBUG] -- local execute: ls /proc/86 [2025-04-23 11:36:20.933] [DEBUG] -- exited code 0 [2025-04-23 11:36:20.934] [DEBUG] - plugin oceanbase-ce-py_script_status-3.1.0 result: True [2025-04-23 11:36:20.934] [DEBUG] - Searching status_check plugin for components ... [2025-04-23 11:36:20.934] [DEBUG] - Searching status_check plugin for general-4.3.5.1--None [2025-04-23 11:36:20.934] [DEBUG] - Found for general-py_script_status_check-0.1 for general-4.3.5.1 [2025-04-23 11:36:20.934] [DEBUG] - Call plugin general-py_script_status_check-0.1 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.935] [DEBUG] - import status_check [2025-04-23 11:36:20.935] [DEBUG] - add status_check ref count to 1 [2025-04-23 11:36:20.936] [DEBUG] - sub status_check ref count to 0 [2025-04-23 11:36:20.936] [DEBUG] - export status_check [2025-04-23 11:36:20.936] [DEBUG] - plugin general-py_script_status_check-0.1 result: True [2025-04-23 11:36:20.936] [DEBUG] - Searching connect plugin for components ... [2025-04-23 11:36:20.936] [DEBUG] - Searching connect plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.936] [DEBUG] - Found for oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.937] [DEBUG] - Call plugin oceanbase-ce-py_script_connect-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.937] [INFO] Connect to observer [2025-04-23 11:36:20.937] [DEBUG] -- connect 127.0.0.1 -P2881 -uroot -p****** [2025-04-23 11:36:20.939] [DEBUG] -- execute sql: select 1. args: None [2025-04-23 11:36:20.939] [DEBUG] - plugin oceanbase-ce-py_script_connect-3.1.0 result: True [2025-04-23 11:36:20.939] [DEBUG] - Searching display plugin for components ... [2025-04-23 11:36:20.939] [DEBUG] - Searching display plugin for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.940] [DEBUG] - Found for oceanbase-ce-py_script_display-3.1.0 for oceanbase-ce-4.3.5.1 [2025-04-23 11:36:20.940] [DEBUG] - Call plugin oceanbase-ce-py_script_display-3.1.0 for oceanbase-ce-4.3.5.1-101000042025031818.el8-3a4f23adb7973d6d1d6969bcd9ae108f8c564b66 [2025-04-23 11:36:20.940] [DEBUG] - import display [2025-04-23 11:36:20.941] [DEBUG] - add display ref count to 1 [2025-04-23 11:36:20.942] [INFO] Wait for observer init [2025-04-23 11:36:20.942] [DEBUG] -- execute sql: select * from oceanbase.__all_server. args: None [2025-04-23 11:36:20.950] [INFO] +---------------------------------------------+ [2025-04-23 11:36:20.950] [INFO] | oceanbase-ce | [2025-04-23 11:36:20.950] [INFO] +-----------+---------+------+-------+--------+ [2025-04-23 11:36:20.950] [INFO] | ip | version | port | zone | status | [2025-04-23 11:36:20.950] [INFO] +-----------+---------+------+-------+--------+ [2025-04-23 11:36:20.950] [INFO] | 127.0.0.1 | 4.3.5.1 | 2881 | zone1 | ACTIVE | [2025-04-23 11:36:20.950] [INFO] +-----------+---------+------+-------+--------+ [2025-04-23 11:36:20.950] [INFO] obclient -h127.0.0.1 -P2881 @.*** -p'' -Doceanbase -A [2025-04-23 11:36:20.951] [INFO] +---------------------------------------------+ [2025-04-23 11:36:20.951] [INFO] | oceanbase-ce | [2025-04-23 11:36:20.951] [INFO] +-----------+---------+------+-------+--------+ [2025-04-23 11:36:20.951] [INFO] | ip | version | port | zone | status | [2025-04-23 11:36:20.951] [INFO] +-----------+---------+------+-------+--------+ [2025-04-23 11:36:20.951] [INFO] | 127.0.0.1 | 4.3.5.1 | 2881 | zone1 | ACTIVE | [2025-04-23 11:36:20.951] [INFO] +-----------+---------+------+-------+--------+ [2025-04-23 11:36:20.951] [INFO] obclient -h127.0.0.1 -P2881 @. -p'***' -Doceanbase -A [2025-04-23 11:36:20.951] [INFO] [2025-04-23 11:36:20.951] [DEBUG] -- execute sql: select unix_timestamp(gmt_create) as gmt_create from oceanbase.__all_virtual_sys_variable limit 1. args: None [2025-04-23 11:36:20.958] [INFO] cluster unique id: 9dc778d0-4267-574d-882a-87e5ecb9ae47-1966210f33d-01050304 [2025-04-23 11:36:20.958] [INFO] [2025-04-23 11:36:20.958] [DEBUG] - sub display ref count to 0 [2025-04-23 11:36:20.958] [DEBUG] - export display [2025-04-23 11:36:20.958] [DEBUG] - plugin oceanbase-ce-py_script_display-3.1.0 result: True [2025-04-23 11:36:20.958] [DEBUG] - Set obcluster deploy status to running [2025-04-23 11:36:20.958] [DEBUG] - dump deploy info to /root/.obd/cluster/obcluster/.data [2025-04-23 11:36:20.961] [DEBUG] - open /root/.obd/cluster/obcluster/inner_config.yaml for w [2025-04-23 11:36:20.964] [INFO] obcluster running [2025-04-23 11:36:20.966] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 1 [2025-04-23 11:36:20.966] [DEBUG] - share lock /root/.obd/lock/mirror_and_repo release, count 0 [2025-04-23 11:36:20.966] [DEBUG] - unlock /root/.obd/lock/mirror_and_repo [2025-04-23 11:36:20.966] [DEBUG] - exclusive lock /root/.obd/lock/deploy_obcluster release, count 0 [2025-04-23 11:36:20.966] [DEBUG] - unlock /root/.obd/lock/deploy_obcluster [2025-04-23 11:36:20.966] [DEBUG] - share lock /root/.obd/lock/global release, count 0 [2025-04-23 11:36:20.966] [DEBUG] - unlock /root/.obd/lock/global [2025-04-23 11:36:20.967] [INFO] Trace ID: 20917bfc-2037-11f0-9dad-0242c0a8d007 [2025-04-23 11:36:20.967] [INFO] If you want to view detailed obd logs, please run: obd display-trace 20917bfc-2037-11f0-9dad-0242c0a8d007

version: '3.3' services:

vector db

ob: image: oceanbase/oceanbase-ce # docker hub # image: quay.io/oceanbase/oceanbase-ce:4.3.5.1-101000042025031818 # 镜像 container_name: ob restart: always # ports: # 生产环境建议不要暴露 # - 2881:2881 networks: - fastgpt environment: # 这里的配置只有首次运行生效。修改后，重启镜像是不会生效的。需要把持久化数据删除再重启，才有效果 - OB_SYS_PASSWORD=obsyspassword # 不同于传统数据库，OceanBase 数据库的账号包含更多字段，包括用户名、租户名和集群名。经典格式为“用户名@租户名#集群名” # 比如用mysql客户端连接时，根据本文件的默认配置，应该指定 @.” - OB_TENANT_NAME=tenantname - OB_TENANT_PASSWORD=tenantpassword # MODE分为MINI和NORMAL， 后者会最大程度使用主机资源 - MODE=MINI - EXIT_WHILE_ERROR=false - OB_MEMORY_LIMIT=6G - OB_SERVER_IP=127.0.0.1 # 更多环境变量配置见oceanbase官方文档： https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000002013494 volumes: - ./ob/data:/root/ob - ./ob/config:/root/.obd/cluster - ./init.sql:/root/boot/init.d/init.sql healthcheck: # obclient -h127.0.0.1 -P2881 @. -ptenantpassword -e "SELECT 1;" test: [ 'CMD-SHELL', 'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"' ] interval: 30s timeout: 10s retries: 1000 start_period: 10s

itnico avatar Apr 23 '25 12:04 itnico

能麻烦你在提供下容器内的 /root/.obd/log/obd 日志文件吗。体积比较大可以用附件的方式提供

Amaranterre avatar Apr 24 '25 02:04 Amaranterre

你看下是不是这个

2025年4月24日 10:58，Shiver @.***> 写道：

Amaranterre left a comment (labring/FastGPT#4642) https://github.com/labring/FastGPT/issues/4642#issuecomment-2826150207 能麻烦你在提供下容器内的 /root/.obd/log/obd 日志文件吗。体积比较大可以用附件的方式提供

— Reply to this email directly, view it on GitHub https://github.com/labring/FastGPT/issues/4642#issuecomment-2826150207, or unsubscribe https://github.com/notifications/unsubscribe-auth/AY26KFUMWHDEOWSCOCFCKTL23BHPDAVCNFSM6AAAAAB3VHEVKOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMRWGE2TAMRQG4. You are receiving this because you authored the thread.

itnico avatar Apr 24 '25 03:04 itnico

请问你是用在邮件附上的附件吗？我在github这里的issue页面好像看不到，能在github 这里回复吗

然后从容器导出日志的步骤大致是： docker ps 找到 ob 的 容器id（container id,大概是f7b1e2aaaef7这种形式) 然后执行

docker exec -it [container id]  cat /root/.obd/log/obd >  ~/obd.log

( ~/obd.log 是你想要把日志导出的地址，根据自己情况选择）

Amaranterre avatar Apr 24 '25 03:04 Amaranterre

obd.log

看是不是这个？

itnico avatar Apr 24 '25 03:04 itnico

确定启动时删除了持久化文件，文件夹只有config，init.sql和docker-compose三个文件吗

itnico @.***>于2025年4月24日 周四11:41写道：

itnico left a comment (labring/FastGPT#4642) https://github.com/labring/FastGPT/issues/4642#issuecomment-2826252988

obd.log https://github.com/user-attachments/files/19883925/obd.log

看是不是这个？

— Reply to this email directly, view it on GitHub https://github.com/labring/FastGPT/issues/4642#issuecomment-2826252988, or unsubscribe https://github.com/notifications/unsubscribe-auth/A7LRVO363A6SL3V4ROXO2CL23BMONAVCNFSM6AAAAAB3VHEVKOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMRWGI2TEOJYHA . You are receiving this because you commented.Message ID: @.***>

Amaranterre avatar Apr 24 '25 04:04 Amaranterre

之前有旧数据，aiproxy，mongo，我刚把旧数据全删了，容器全删了，就那三个文件和几个空目录（群晖得先建好目录，要不会提示找不到），重头构建，结果一样，卡着过不去。发自我的 iPhone在 2025年4月24日，12:57，Shiver @.***> 写道： Amaranterre left a comment (labring/FastGPT#4642) 确定启动时删除了持久化文件，文件夹只有config，init.sql和docker-compose三个文件吗


itnico ***@***.***>于2025年4月24日 周四11:41写道：

> *itnico* left a comment (labring/FastGPT#4642)
> <https://github.com/labring/FastGPT/issues/4642#issuecomment-2826252988>
>
> obd.log <https://github.com/user-attachments/files/19883925/obd.log>
>
> 看是不是这个？
>
> —
> Reply to this email directly, view it on GitHub
> <https://github.com/labring/FastGPT/issues/4642#issuecomment-2826252988>,
> or unsubscribe
> <https://github.com/notifications/unsubscribe-auth/A7LRVO363A6SL3V4ROXO2CL23BMONAVCNFSM6AAAAAB3VHEVKOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDQMRWGI2TEOJYHA>
> .
> You are receiving this because you commented.Message ID:
> ***@***.***>
>

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 24 '25 05:04 itnico

能进入容器执行下这些吗： 先：

docker exec -it ob bash

然后执行

obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"

看下什么结果。

记得删持久化文件，然后日志也麻烦提供一下。 另外这个启动时间会比较长，可能要多等一下

Amaranterre avatar Apr 24 '25 06:04 Amaranterre

@.*** ~]# obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;" +------+ | 1 | +------+ | 1 | +------+

以上是执行结果

obd display-trace 2efba6fa-204a-11f0-b6de-0242c0a8d006 执行这个没有任何输出

发自我的 iPhone

在 2025年4月24日，14:23，Shiver @.***> 写道：

obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"

itnico avatar Apr 24 '25 07:04 itnico

那应该就正常了呀，现在还是不能启动吗

Amaranterre avatar Apr 24 '25 07:04 Amaranterre

跟之前一样，fastgpt不能启动，因为它在等ob进入hearth，而ob一直在hearth：starting发自我的 iPhone在 2025年4月24日，15:06，Shiver @.***> 写道： Amaranterre left a comment (labring/FastGPT#4642) 那应该就正常了呀，现在还是不能启动吗

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 24 '25 07:04 itnico

执行这一句试一下看下输出：

docker inspect ob | grep healthcheck -A 1

应该是docker-compose 而不是镜像的问题

Amaranterre avatar Apr 24 '25 08:04 Amaranterre

因机器突然故障，待修好后再搞发自我的 iPhone在 2025年4月24日，16:39，Shiver @.***> 写道： Amaranterre left a comment (labring/FastGPT#4642) 执行这一句试一下： docker inspect ob | grep healthcheck -A 1

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 24 '25 15:04 itnico

再测的时候麻烦更改一下docker-compose.yml中的healthcheck项的配置试试，将：

    healthcheck:
      # obclient -h127.0.0.1 -P2881 ***@***.*** -ptenantpassword -e "SELECT 1;"
      test:
        [
          'CMD-SHELL',
          'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"'
        ]
      interval: 30s
      timeout: 10s
      retries: 1000
      start_period: 10s

改为：

    healthcheck:
      test: ["CMD-SHELL", "obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e \"SELECT 1;\" || exit 1"]
      interval: 30s
      timeout: 10s
      retries: 1000
      # start_period: 10s

Amaranterre avatar Apr 25 '25 06:04 Amaranterre

执行完这个没有返回任何东西 发自我的 iPhone

在 2025年4月24日，16:39，Shiver @.***> 写道：

docker inspect ob | grep healthcheck -A 1

itnico avatar Apr 26 '25 14:04 itnico

效果一样，你可以检查一下看跟aiproxy是否有冲突，因为无意中意外关机，因为aiproxy是设置的unless-stoped，重启后aiproxy容器没有启动，这时候发现fastgpt容器启动了。发自我的 iPhone在 2025年4月25日，14:52，Shiver @.> 写道： Amaranterre left a comment (labring/FastGPT#4642) 再测的时候麻烦更改一下docker-compose.yml中的healthcheck项的配置试试，将： healthcheck: # obclient -h127.0.0.1 -P2881 @. -ptenantpassword -e "SELECT 1;" test: [ 'CMD-SHELL', 'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"' ] interval: 30s timeout: 10s retries: 1000 start_period: 10s

改为： healthcheck: test: ["CMD-SHELL", "obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;" || exit 1"] interval: 30s timeout: 10s retries: 1000 # start_period: 10s

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 26 '25 14:04 itnico

效果一样，你可以检查一下看跟aiproxy是否有冲突，因为无意中意外关机，因为aiproxy是设置的unless-stoped，重启后aiproxy容器没有启动，这时候发现fastgpt容器启动了。发自我的 iPhone在 2025年4月25日，14:52，Shiver @.> 写道： Amaranterre left a comment (labring/FastGPT#4642) 再测的时候麻烦更改一下docker-compose.yml中的healthcheck项的配置试试，将： healthcheck: # obclient -h127.0.0.1 -P2881 @. -ptenantpassword -e "SELECT 1;" test: [ 'CMD-SHELL', 'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"' ] interval: 30s timeout: 10s retries: 1000 start_period: 10s

改为： healthcheck: test: ["CMD-SHELL", "obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;" || exit 1"] interval: 30s timeout: 10s retries: 1000 # start_period: 10s

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

找不到头绪啊，我这边复现不出来有点麻烦，只能一步一步看日志了（ 你执行一下

docker inspect ob

看看呢。我目前感觉应该是容器启动出问题了。

Amaranterre avatar Apr 27 '25 02:04 Amaranterre

@.:/volume2/docker/fastgpt-ob# docker inspect ob [ { "Id": "58df8d0abd9a0f2ea5ef22a92af9d7937caf62e9eff2fb75e473a1d7229db647", "Created": "2025-04-27T11:14:55.629402161Z", "Path": "bash", "Args": [ "-c", "/usr/sbin/sshd && /root/boot/start.sh" ], "State": { "Status": "running", "Running": true, "Paused": false, "Restarting": false, "OOMKilled": false, "Dead": false, "Pid": 834, "ExitCode": 0, "Error": "", "StartedAt": "2025-04-27T11:14:57.012049369Z", "FinishedAt": "0001-01-01T00:00:00Z", "Health": { "Status": "starting", "FailingStreak": 30, "Log": [ { "Start": "2025-04-27T19:27:58.26647777+08:00", "End": "2025-04-27T19:27:58.300858086+08:00", "ExitCode": 1, "Output": "Enter password: ERROR 2005 (HY000): Unknown OceanBase server host '-P2881' (-2)\n" }, { "Start": "2025-04-27T19:28:28.313695131+08:00", "End": "2025-04-27T19:28:28.348374471+08:00", "ExitCode": 1, "Output": "Enter password: ERROR 2005 (HY000): Unknown OceanBase server host '-P2881' (-2)\n" }, { "Start": "2025-04-27T19:28:58.361022022+08:00", "End": "2025-04-27T19:28:58.39283569+08:00", "ExitCode": 1, "Output": "Enter password: ERROR 2005 (HY000): Unknown OceanBase server host '-P2881' (-2)\n" }, { "Start": "2025-04-27T19:29:28.40495199+08:00", "End": "2025-04-27T19:29:28.438596498+08:00", "ExitCode": 1, "Output": "Enter password: ERROR 2005 (HY000): Unknown OceanBase server host '-P2881' (-2)\n" }, { "Start": "2025-04-27T19:29:58.456746442+08:00", "End": "2025-04-27T19:29:58.475922589+08:00", "ExitCode": 1, "Output": "Enter password: ERROR 2005 (HY000): Unknown OceanBase server host '-P2881' (-2)\n" } ] } }, "Image": "sha256:e564520360af8d69547c702ef73741fa7268c73cb1521f19f1aa4c5c7335b308", "ResolvConfPath": @./containers/58df8d0abd9a0f2ea5ef22a92af9d7937caf62e9eff2fb75e473a1d7229db647/resolv.conf", "HostnamePath": @./containers/58df8d0abd9a0f2ea5ef22a92af9d7937caf62e9eff2fb75e473a1d7229db647/hostname", "HostsPath": @./containers/58df8d0abd9a0f2ea5ef22a92af9d7937caf62e9eff2fb75e473a1d7229db647/hosts", "LogPath": @.***/containers/58df8d0abd9a0f2ea5ef22a92af9d7937caf62e9eff2fb75e473a1d7229db647/log.db", "Name": "/ob", "RestartCount": 0, "Driver": "btrfs", "Platform": "linux", "MountLabel": "", "ProcessLabel": "", "AppArmorProfile": "docker-default", "ExecIDs": null, "HostConfig": { "Binds": [ "/volume2/docker/fastgpt-ob/ob/data:/root/ob:rw", "/volume2/docker/fastgpt-ob/ob/config:/root/.obd/cluster:rw", "/volume2/docker/fastgpt-ob/init.sql:/root/boot/init.d/init.sql:rw" ], "ContainerIDFile": "", "LogConfig": { "Type": "db", "Config": {} }, "NetworkMode": "fastgpt-ob_fastgpt", "PortBindings": {}, "RestartPolicy": { "Name": "always", "MaximumRetryCount": 0 }, "AutoRemove": false, "VolumeDriver": "", "VolumesFrom": null, "ConsoleSize": [ 0, 0 ], "CapAdd": null, "CapDrop": null, "CgroupnsMode": "host", "Dns": null, "DnsOptions": null, "DnsSearch": null, "ExtraHosts": [], "GroupAdd": null, "IpcMode": "private", "Cgroup": "", "Links": null, "OomScoreAdj": 0, "PidMode": "", "Privileged": false, "PublishAllPorts": false, "ReadonlyRootfs": false, "SecurityOpt": null, "UTSMode": "", "UsernsMode": "", "ShmSize": 67108864, "Runtime": "runc", "Isolation": "", "CpuShares": 0, "Memory": 0, "NanoCpus": 0, "CgroupParent": "", "BlkioWeight": 0, "BlkioWeightDevice": null, "BlkioDeviceReadBps": null, "BlkioDeviceWriteBps": null, "BlkioDeviceReadIOps": null, "BlkioDeviceWriteIOps": null, "CpuPeriod": 0, "CpuQuota": 0, "CpuRealtimePeriod": 0, "CpuRealtimeRuntime": 0, "CpusetCpus": "", "CpusetMems": "", "Devices": null, "DeviceCgroupRules": null, "DeviceRequests": null, "MemoryReservation": 0, "MemorySwap": 0, "MemorySwappiness": null, "OomKillDisable": false, "PidsLimit": null, "Ulimits": null, "CpuCount": 0, "CpuPercent": 0, "IOMaximumIOps": 0, "IOMaximumBandwidth": 0, "MaskedPaths": [ "/proc/asound", "/proc/acpi", "/proc/kcore", "/proc/keys", "/proc/latency_stats", "/proc/timer_list", "/proc/timer_stats", "/proc/sched_debug", "/proc/scsi", "/sys/firmware" ], "ReadonlyPaths": [ "/proc/bus", "/proc/fs", "/proc/irq", "/proc/sys", "/proc/sysrq-trigger" ] }, "GraphDriver": { "Data": null, "Name": "btrfs" }, "Mounts": [ { "Type": "bind", "Source": "/volume2/docker/fastgpt-ob/ob/data", "Destination": "/root/ob", "Mode": "rw", "RW": true, "Propagation": "rprivate" }, { "Type": "bind", "Source": "/volume2/docker/fastgpt-ob/ob/config", "Destination": "/root/.obd/cluster", "Mode": "rw", "RW": true, "Propagation": "rprivate" }, { "Type": "bind", "Source": "/volume2/docker/fastgpt-ob/init.sql", "Destination": "/root/boot/init.d/init.sql", "Mode": "rw", "RW": true, "Propagation": "rprivate" } ], "Config": { "Hostname": "58df8d0abd9a", "Domainname": "", "User": "", "AttachStdin": false, "AttachStdout": true, "AttachStderr": true, "Tty": false, "OpenStdin": false, "StdinOnce": false, "Env": [ "OB_TENANT_PASSWORD=tenantpassword", "MODE=NORMAL", "OB_SERVER_IP=127.0.0.1", "OB_SYS_PASSWORD=obsyspassword", "OB_TENANT_NAME=tenantname", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" ], "Cmd": null, "Healthcheck": { "Test": [ "CMD-SHELL", "obclient -h -P2881 -uroot@ -p -e "SELECT 1;"" ], "Interval": 30000000000, "Timeout": 10000000000, "StartPeriod": 10000000000, "Retries": 1000 }, "Image": "oceanbase/oceanbase-ce", "Volumes": null, "WorkingDir": "/root", "Entrypoint": [ "bash", "-c", "/usr/sbin/sshd && /root/boot/start.sh" ], "OnBuild": null, "Labels": { "com.docker.compose.config-hash": "9f0db26563116ac38eacfbd6894b0511b41715ddf946f3c17deab8b5d4d2ea01", "com.docker.compose.container-number": "1", "com.docker.compose.depends_on": "", "com.docker.compose.image": "sha256:e564520360af8d69547c702ef73741fa7268c73cb1521f19f1aa4c5c7335b308", "com.docker.compose.oneoff": "False", "com.docker.compose.project": "fastgpt-ob", "com.docker.compose.project.config_files": "/volume2/docker/fastgpt-ob/compose.yml", "com.docker.compose.project.working_dir": "/volume2/docker/fastgpt-ob", "com.docker.compose.service": "ob", "com.docker.compose.version": "2.20.1", "maintainer": "OpenAnolis Cloud Native SIG", "org.opencontainers.image.created": "2023-03-24 10:49:55+0800", "org.opencontainers.image.licenses": "Mulan PSL v2", "org.opencontainers.image.title": "Anolis OS Base Image", "org.opencontainers.image.vendor": "Anolis OS" } }, "NetworkSettings": { "Bridge": "", "SandboxID": "e42550df61cfccbed31dd1ebf46ec48444ec3c0b76e8ae8b4648eef87d10b293", "HairpinMode": false, "LinkLocalIPv6Address": "", "LinkLocalIPv6PrefixLen": 0, "Ports": {}, "SandboxKey": "/var/run/docker/netns/e42550df61cf", "SecondaryIPAddresses": null, "SecondaryIPv6Addresses": null, "EndpointID": "", "Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "IPAddress": "", "IPPrefixLen": 0, "IPv6Gateway": "", "MacAddress": "", "Networks": { "fastgpt-ob_fastgpt": { "IPAMConfig": null, "Links": null, "Aliases": [ "ob", "ob", "58df8d0abd9a" ], "NetworkID": "d7bbfbec9174f8b2ab8af0d103cc3e7635768729aa196225f7a7ca94f1448507", "EndpointID": "e4efd8f0278ffebe502909b3f078fb9ba8043ee5096a091290595243ff3968d8", "Gateway": "172.21.0.1", "IPAddress": "172.21.0.5", "IPPrefixLen": 16, "IPv6Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "MacAddress": "02:42:ac:15:00:05", "DriverOpts": null } } } } ]

itnico avatar Apr 27 '25 03:04 itnico

我好像明白了，你把

    healthcheck:
      test:
         [
           'CMD-SHELL',
           'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"'
         ]

中的环境变量都替换成实际的值试试。 比如默认情况下，替换成：

    healthcheck:
      test:
         [
           'CMD-SHELL',
           'obclient -h127.0.0.1 -P2881 -uroot@tenantname -ptenantpassword -e "SELECT 1;"'
         ]

Amaranterre avatar Apr 27 '25 03:04 Amaranterre

可以了，谢谢在 2025年4月27日，11:42，Shiver @.***> 写道： Amaranterre left a comment (labring/FastGPT#4642) 我好像明白了，你把 healthcheck: test: [ 'CMD-SHELL', 'obclient -h$OB_SERVER_IP -P2881 -uroot@$OB_TENANT_NAME -p$OB_TENANT_PASSWORD -e "SELECT 1;"' ]

中的环境变量都替换成实际的值试试。 比如默认情况下，替换成： healthcheck: test: [ 'CMD-SHELL', 'obclient -h127.0.0.1 -P2881 @.*** -ptenantpassword -e "SELECT 1;"' ]

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 27 '25 04:04 itnico

不谢，你可以把配置改成：

    healthcheck:
      test:
         [
           'CMD-SHELL',
           'obclient -h$${OB_SERVER_IP} -P2881 -uroot@$${OB_TENANT_NAME} -p$${OB_TENANT_PASSWORD} -e "SELECT 1;"'
         ]
      interval: 30s
      timeout: 10s
      retries: 1000

试试吗。这个写法应该也会通过

Amaranterre avatar Apr 27 '25 06:04 Amaranterre

start_period: 10s不要了是吗？发自我的 iPhone在 2025年4月27日，14:03，Shiver @.***> 写道： Amaranterre left a comment (labring/FastGPT#4642) 不谢，你可以把配置改成： healthcheck: test: [ 'CMD-SHELL', 'obclient -h$${OB_SERVER_IP} -P2881 -uroot@$${OB_TENANT_NAME} -p$${OB_TENANT_PASSWORD} -e "SELECT 1;"' ] interval: 30s timeout: 10s retries: 1000

试试吗。这个写法应该也会通过

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 27 '25 07:04 itnico

要不要应该都可以，关键是把 $OB_SERVER_IP 换成了 $${OB_SERVER_IP}，这样的配置更加健壮。注意要删除以前的持久化文件。 进一步分析可以看我为了修复这个问题提的PR: https://github.com/labring/FastGPT/pull/4676

Amaranterre avatar Apr 27 '25 07:04 Amaranterre

可以了发自我的 iPhone在 2025年4月27日，15:41，Shiver @.***> 写道： Amaranterre left a comment (labring/FastGPT#4642) 要不要应该都可以，关键是把 $OB_SERVER_IP 换成了 $${OB_SERVER_IP}，这样会更加健壮。 进一步分析可以看我为了修复这个问题提的PR: #4676

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you authored the thread.Message ID: @.***>

itnico avatar Apr 27 '25 07:04 itnico

已合并，感谢支持

c121914yu avatar Apr 27 '25 09:04 c121914yu