Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
第一次远程连接，执行 show database 为空，第二次连接后正常（后面连接其他节点也正常）
# 第一次远程连接
obclient -h172.16.16.10 -P3306 -uroot@sys -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221523616
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [(none)]> \s
--------------
Current database:
Current user: root@172.16.16.7
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Protocol version: 10
Connection: 172.16.16.10 via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 3306
Protocol: Compressed
Active --------------
# 显示结果为空
obclient [(none)]> show databases;
Query OK, 0 rows affected (0.000 sec)
obclient [(none)]> \q
Bye
# 再次连接
$ obclient -h172.16.16.10 -P3306 -uroot@sys -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221524124
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
# 这次显示正常
obclient [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
+--------------------+
7 rows in set (0.008 sec)
obclient [(none)]>
obclient [(none)]> Bye
# 连接其他节点也正常了
$ obclient -h172.16.16.53 -P3306 -uroot@sys -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3222011924
Server version: OceanBase_CE 4.0.0.0 (r100000272022110114-6af7f9ae79cd0ecbafd4b1b88e2886ccdba0c3be) (Built Nov 1 2022 14:57:18)
Copyright (c) 2000, 2018, OB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
obclient [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
+--------------------+
7 rows in set (0.017 sec)
obclient [(none)]> Bye