oceanbase 主备集群同步异常

【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】OceanBase_CE 4.2.0.0 (r100010032023083021-7e912e012b5f2036b79eaeecaaf59884efc184fd) (Built Aug 30 2023 21:30:14)
【问题描述】 使用docker ob laest 镜像 4.2,在一台虚拟机中部署两个单节点容器,配置主备模式失败。
【复现路径】

docker run -p 2881:2881 --name obstandalone -e MINI_MODE=1 -d oceanbase/oceanbase-ce
docker exec -it obstandalone ob-mysql sys
drop tenant test;drop resource pool test_pool; drop resource unit test_unit;
alter system log_disk_size=‘10g’;
CREATE RESOURCE UNIT unit1 MAX_CPU 1, MEMORY_SIZE = ‘2G’;
CREATE RESOURCE POOL pool1 UNIT = ‘unit1’, UNIT_NUM = 1;

CREATE TENANT IF NOT EXISTS test CHARSET=‘utf8mb4’, ZONE_LIST=(‘zone1’), PRIMARY_ZONE=‘zone1’, RESOURCE_POOL_LIST=(‘pool1’) SET ob_tcp_invited_nodes=’%’;
docker exec -it obstandalone bash
obclient -h127.1 -uroot@test -A -Doceanbase -P2881
CREATE USER rep_user IDENTIFIED BY ‘repl’;
GRANT SELECT ON oceanbase.* TO rep_user;


docker run -p 2882:2881 --name obstanby -e MINI_MODE=1 -d oceanbase/oceanbase-ce
docker exec -it obstandalone ob-mysql sys
drop tenant test;drop resource pool test_pool; drop resource unit test_unit;
alter system log_disk_size=‘10g’;
CREATE RESOURCE UNIT unit1 MAX_CPU 1, MEMORY_SIZE = ‘2G’;
CREATE RESOURCE POOL pool1 UNIT = ‘unit1’, UNIT_NUM = 1;
CREATE STANDBY TENANT IF NOT EXISTS standby_tenant LOG_RESTORE_SOURCE =“SERVICE=172.17.0.2:2881 user=rep_user@test password=repl” RESOURCE_POOL_LIST=(‘pool1’);
【问题现象及影响】
obclient [oceanbase]> SELECT TENANT_NAME, TENANT_ROLE, SYNC_SCN FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_NAME = ‘standby_tenant’;
±---------------±------------±---------+
| TENANT_NAME | TENANT_ROLE | SYNC_SCN |
±---------------±------------±---------+
| standby_tenant | NULL | NULL |
±---------------±------------±---------+
【附件】

是测试4.2基于网络的主备库吗?根据以下文档配置的?
https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000218768

是的。状态也一直是CREATING_STANDBY
obclient [oceanbase]> select TENANT_ID,TENANT_NAME,PRIMARY_ZONE,COMPATIBILITY_MODE,LOCALITY,STATUS,IN_RECYCLEBIN,LOCKED from oceanbase.DBA_OB_TENANTS where TENANT_TYPE=‘user’\G
*************************** 1. row ***************************
TENANT_ID: 1004
TENANT_NAME: standby_tenant
PRIMARY_ZONE: RANDOM
COMPATIBILITY_MODE: MYSQL
LOCALITY: FULL{1}@zone1
STATUS: CREATING_STANDBY
IN_RECYCLEBIN: NO
LOCKED: NO
1 row in set (0.001 sec)

已解决, 网络问题.

请教一下 具体的网络问题怎么解决的,遇到和你一样的问题。

印象中是 SERVICE要填宿主机物理IP,
CREATE STANDBY TENANT IF NOT EXISTS standby_tenant LOG_RESTORE_SOURCE =“SERVICE=10.186.57.68:2881 user=rep_user@test password=repl” RESOURCE_POOL_LIST=(‘pool1’);

学习啦,始终保持ing