shardingsphere icon indicating copy to clipboard operation
shardingsphere copied to clipboard

Malformed packet when select from information_schema.tables

Open RaigorJiang opened this issue 1 year ago • 0 comments

Bug Report

Which version of ShardingSphere did you use?

master 31fc9afcf04eb95d433ac119a722fdc82d24b203

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Expected behavior

Return correct query results (or empty results)

Actual behavior

mysql> select * from information_schema.tables;
ERROR 2027 (HY000): Malformed packet
mysql> select * from information_schema.tables;
ERROR 2008 (HY000): MySQL client ran out of memory
No connection. Trying to reconnect...
Connection id:    6
Current database: *** NONE ***

ERROR 2027 (HY000): Malformed packet
mysql>

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

  1. Start Proxy with cluster mode
mode:
 type: Cluster
 repository:
   type: ZooKeeper
   props:
     namespace: governance_ds_ss
     server-lists: localhost:2181
     retryIntervalMilliseconds: 500
     timeToLiveSeconds: 60
     maxRetries: 3
     operationTimeoutMilliseconds: 500
  1. Connect Proxy with MySQL client
  2. Execute SQL select * from information_schema.tables;

RaigorJiang avatar May 03 '24 14:05 RaigorJiang