obproxy执行SQL问题-手动部署单机模拟三节点

【产品名称】oceanbase

【产品版本】3.1.1

【问题描述】登录单节点可以正常执行SQL,使用obproxy登录,无法执行SQL。执行过程如下:

[admin@duizhang log]$ mysql -h127.1 -uroot@sys -P2881 -poracle_4U -c -A oceanbase mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3221608268 Server version: 5.7.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:33:14) Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. root@127.1 : oceanbase 03:27:34> select 1 ; ±–+ | 1 | ±–+ | 1 | ±–+ 1 row in set (0.00 sec) root@127.1 : oceanbase 03:27:36> exit Bye [admin@duizhang log]$ mysql -h 192.168.211.54 -uroot@proxysys -P 2883 -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 Server version: 5.6.25 Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement. root@proxysys@192.168.211.54 : (none) 03:27:42> select 1; ERROR 2027 (HY000): Malformed packet ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2013 (HY000): Lost connection to MySQL server during query root@proxysys@192.168.211.54 : (none) 03:27:43>

mysql -h127.1 -uroot@sys#集群名 -P2883 -poracle_4U -c -A oceanbase
验证obproxy的话,用这个连接串试一下呢。
1 个赞

root@proxysys只是用来管理obproxy,支持的命令有限。如


show proxyconfig;


show processlistn


等等。


不能用来跑常用的mysql命令。

1 个赞

666