【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】
社区版 4.1.0.0
【问题描述】
在VM中创建centos7虚拟机，然后使用docker方式成功部署了OB（使用如下命令成功进入数据库docker exec -it obstandalone ob-mysql root）。在centos7终端使用reboot命令重启操作系统，然后重启OB容器：docker start xxxx，日志中出现：failed to start 127.0.0.1 obagent
【复现路径】
第一次成功启动步骤如下（官网步骤）：
1、# 部署 mini 的独立实例
docker run -p 2881:2881 --name obstandalone -e MINI_MODE=1 -d oceanbase/oceanbase-ce
2、查看日志：docker logs obstandalone | tail -10
错误出现步骤，如下：
1、centos终端执行重启命令 reboot
2、docker start container_id
3、查看日志出现：failed to start 127.0.0.1 obagent
4、详细日志
[2023-07-26 06:39:36.517] [DEBUG] – execute sql: select * from oceanbase.__all_server. args: None
[2023-07-26 06:39:36.518] [DEBUG] – OBD-5000: select * from oceanbase.__all_server execute failed
[2023-07-26 06:39:36.519] [ERROR] Traceback (most recent call last):
[2023-07-26 06:39:36.519] [ERROR] File “core.py”, line 1564, in start_cluster
[2023-07-26 06:39:36.519] [ERROR] File “core.py”, line 1685, in _start_cluster
[2023-07-26 06:39:36.519] [ERROR] File “core.py”, line 182, in call_plugin
[2023-07-26 06:39:36.519] [ERROR] File “_plugin.py”, line 314, in call
[2023-07-26 06:39:36.519] [ERROR] File “_plugin.py”, line 281, in _new_func
[2023-07-26 06:39:36.519] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/display.py”, line 37, in display
[2023-07-26 06:39:36.519] [ERROR] servers = cursor.fetchall(‘select * from oceanbase.__all_server’, raise_exception=True, exc_level=‘verbose’)
[2023-07-26 06:39:36.519] [ERROR] File “_stdio.py”, line 864, in func_wrapper
[2023-07-26 06:39:36.519] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 108, in fetchall
[2023-07-26 06:39:36.519] [ERROR] return self.execute(sql, args=args, execute_func=‘fetchall’, raise_exception=raise_exception, exc_level=exc_level, stdio=stdio)
[2023-07-26 06:39:36.519] [ERROR] File “_stdio.py”, line 864, in func_wrapper
[2023-07-26 06:39:36.519] [ERROR] File “/root/.obd/plugins/oceanbase-ce/3.1.0/connect.py”, line 91, in execute
[2023-07-26 06:39:36.519] [ERROR] self.cursor.execute(sql, args)
[2023-07-26 06:39:36.519] [ERROR] File “/usr/obd/lib/site-packages/pymysql/cursors.py”, line 148, in execute
[2023-07-26 06:39:36.519] [ERROR] result = self._query(query)
[2023-07-26 06:39:36.519] [ERROR] File “/usr/obd/lib/site-packages/pymysql/cursors.py”, line 310, in _query
[2023-07-26 06:39:36.519] [ERROR] conn.query(q)
[2023-07-26 06:39:36.519] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 548, in query
[2023-07-26 06:39:36.519] [ERROR] self._affected_rows = self._read_query_result(unbuffered=unbuffered)
[2023-07-26 06:39:36.519] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 775, in _read_query_result
[2023-07-26 06:39:36.519] [ERROR] result.read()
[2023-07-26 06:39:36.519] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 1156, in read
[2023-07-26 06:39:36.519] [ERROR] first_packet = self.connection._read_packet()
[2023-07-26 06:39:36.519] [ERROR] File “/usr/obd/lib/site-packages/pymysql/connections.py”, line 725, in _read_packet
[2023-07-26 06:39:36.519] [ERROR] packet.raise_for_error()
[2023-07-26 06:39:36.520] [ERROR] File “/usr/obd/lib/site-packages/pymysql/protocol.py”, line 221, in raise_for_error
[2023-07-26 06:39:36.520] [ERROR] err.raise_mysql_exception(self._data)
[2023-07-26 06:39:36.520] [ERROR] File “/usr/obd/lib/site-packages/pymysql/err.py”, line 143, in raise_mysql_exception
[2023-07-26 06:39:36.520] [ERROR] raise errorclass(errno, errval)
[2023-07-26 06:39:36.520] [ERROR] pymysql.err.ProgrammingError: (1146, “Table ‘oceanbase.__all_server’ doesn’t exist”)
[2023-07-26 06:39:36.520] [ERROR]
[2023-07-26 06:39:39.523] [DEBUG] – execute sql: select * from oceanbase.__all_server. args: None
[2023-07-26 06:39:39.533] [INFO] ±--------------------------------------------+
[2023-07-26 06:39:39.533] [INFO] | observer |
[2023-07-26 06:39:39.533] [INFO] ±----------±--------±-----±------±-------+
[2023-07-26 06:39:39.533] [INFO] | ip | version | port | zone | status |
[2023-07-26 06:39:39.533] [INFO] ±----------±--------±-----±------±-------+
[2023-07-26 06:39:39.534] [INFO] | 127.0.0.1 | 4.1.0.0 | 2881 | zone1 | ACTIVE |
[2023-07-26 06:39:39.534] [INFO] ±----------±--------±-----±------±-------+
[2023-07-26 06:39:39.534] [INFO] obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A
[2023-07-26 06:39:39.534] [INFO] [ERROR] failed to start 127.0.0.1 obagent.
[2023-07-26 06:39:39.534] [INFO] [ERROR] obagent start failed
【问题现象及影响】
重启OceanBase容器出现错误：Table ‘oceanbase.__all_server’ doesn’t exist
【附件】
请各位大神出手相助！
