大佬,请问下,我创建obbinlog后状态一直为convert_running: No,怎么回事,我的observer版本是oceanbase-ce. 4.2.5.7 obproxy-ce .4.3.5.0 obbinlog-ce.4.3.5
binlog_instance.log (149.1 KB)
libobcdc.log (2.7 MB)
,创建语句
CREATE BINLOG FOR TENANT obcluster.jwwl TO USER root PASSWORD xxxx WITH CLUSTER URL http://10.209.66.49:8080/services?Action=ObRootServiceInfo&ObCluster=obcluster, REPLICATE NUM 2;
看日志信息是libobcdc 在拉 tenant jwwl(tenant_id=1002)的 sys LS(ls_id=1)data dict 时,按时间戳找起始 LSN 失败 你把同时间的observer.log日志发一下
ob上查一下这个信息
SHOW PARAMETERS LIKE ‘%rpc%authentication%’;
SHOW PARAMETERS LIKE ‘ssl_client_authentication’;
obclient(root@jwwl)[oceanbase]> SHOW PARAMETERS LIKE ‘%rpc%authentication%’;
±------±---------±-------------±---------±---------------------------------±----------±------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault |
±------±---------±-------------±---------±---------------------------------±----------±------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone1 | observer | 10.209.66.49 | 2882 | rpc_server_authentication_method | NULL | ALL | specifies rpc server authentication method. ALL: support all authentication methods. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | ALL | 1 |
| zone1 | observer | 10.209.66.49 | 2882 | rpc_client_authentication_method | NULL | NONE | specifies rpc client authentication method. NONE: without authentication. SSL_NO_ENCRYPT: authentication by SSL handshake but not encrypt the communication channel. SSL_IO: authentication by SSL handshake and encrypt the communication channel | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | NONE | 1 |
±------±---------±-------------±---------±---------------------------------±----------±------±--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
2 rows in set (0.013 sec)
obclient(root@jwwl)[oceanbase]> SHOW PARAMETERS LIKE ‘ssl_client_authentication’;
±------±---------±-------------±---------±--------------------------±----------±------±-----------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone | svr_type | svr_ip | svr_port | name | data_type | value | info | section | scope | source | edit_level | default_value | isdefault |
±------±---------±-------------±---------±--------------------------±----------±------±-----------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
| zone1 | observer | 10.209.66.49 | 2882 | ssl_client_authentication | NULL | True | enable server SSL support. Takes effect after ca/cert/key file is configured correctly. | OBSERVER | CLUSTER | DEFAULT | DYNAMIC_EFFECTIVE | False | 0 |
±------±---------±-------------±---------±--------------------------±----------±------±-----------------------------------------------------------------------------------------±---------±--------±--------±------------------±--------------±----------+
1 row in set (0.013 sec)
observer.log (32.8 MB)
应该给你配置的RPC 鉴权有关系
在 sys 租户执行:
ALTER SYSTEM SET ssl_client_authentication = False;
SHOW PARAMETERS LIKE 'ssl_invited_nodes';
-- 若 value 是 ALL,改成 NONE,避免仍强制 SSL
ALTER SYSTEM SET ssl_invited_nodes = 'NONE';
改完重建/重启 obbinlog 看看是否还有问题
