【产品名称】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>