Issue 1:
i connect apache-shardingsphere-5.0.0-alpha-shardingsphere-proxy by mysql client （8.0.25） ,when i executed some command ,a error was reported: as follows

mysql -uroot -proot -h10.0.0.1 -P 3307

root@10.1.1.1(sharding_db) 14:45>show tables;

ERROR 2027 (HY000): Malformed packet

No connection. Trying to reconnect...

Connection id: 10

Current database: sharding_db

The version of mysql client :

mysql Ver 8.0.25 for Linux on x86_64 (MySQL Community Server - GPL)

After some troubleshooting, it is suspected that the MySQL client version is not compatible with proxy。so i replaced mysql client to

/usr/local/mysql8020/bin/mysql --version

/usr/local/mysql8020/bin/mysql Ver 8.0.20 for Linux on x86_64 (MySQL Community Server - GPL)

and

/root/mysql Ver 14.14 Distrib 5.7.13, for linux-glibc2.5 (x86_64) using EditLine wrapper

shardingsphere@10.0.0.1(sharding_db) 14:52>show tables;

+---------------------+

| Tables_in_demo_ds_1 |

+---------------------+

| t_no_shard |

| t_order |

| t_order_item |

+---------------------+

The error described above did not recur 。

Here are some of my main configurations,only the datasource of the default config has been modified

server.xml

governance:

name: governance_ds

registryCenter:

type: ZooKeeper

serverLists: 10.0.0.1:2181

props:

retryIntervalMilliseconds: 500

timeToLiveSeconds: 60

maxRetries: 3

operationTimeoutMilliseconds: 500

overwrite: false

authentication:

users:

root:

password: root

sharding:

password: sharding

authorizedSchemas: sharding_db

props:

max-connections-size-per-query: 1

acceptor-size: 16 # The default value is available processors count * 2.

executor-size: 16 # Infinite by default.

proxy-frontend-flush-threshold: 128 # The default value is 128.

config-sharding.yaml

schemaName: sharding_db

dataSourceCommon:

username: shardingsphere

password: 123456

connectionTimeoutMilliseconds: 30000

idleTimeoutMilliseconds: 60000

maxLifetimeMilliseconds: 1800000

maxPoolSize: 50

minPoolSize: 1

maintenanceIntervalMilliseconds: 30000

dataSources:

ds_0:

url: jdbc:mysql://10.0.0.2:3306/demo_ds_0?serverTimezone=UTC&useSSL=false

ds_1:

url: jdbc:mysql://10.0.0.2:3306/demo_ds_1?serverTimezone=UTC&useSSL=false

rules:

!SHARDING

tables:

t_order:

actualDataNodes: ds_${0..1}.t_order_${0..1}

tableStrategy:

standard:

shardingColumn: order_id

shardingAlgorithmName: t_order_inline

keyGenerateStrategy:

column: order_id

keyGeneratorName: snowflake

t_order_item:

actualDataNodes: ds_${0..1}.t_order_item_${0..1}

tableStrategy:

standard:

shardingColumn: order_id

shardingAlgorithmName: t_order_item_inline

keyGenerateStrategy:

column: order_item_id

keyGeneratorName: snowflake

bindingTables:

t_order,t_order_item

defaultDatabaseStrategy:

standard:

shardingColumn: user_id

shardingAlgorithmName: database_inline

defaultTableStrategy:

none:

shardingAlgorithms:

database_inline:

type: INLINE

props:

algorithm-expression: ds_${user_id % 2}

t_order_inline:

type: INLINE

MySQL client connection error

Issue 2:
Bug Report

num #instances #bytes class name

1: 723701 1723060848 [C

2: 23438021 562512504 java.util.LinkedList$Node

3: 22989567 551749608 org.apache.shardingsphere.sql.parser.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment

4: 19796 24885584 [B

5: 720560 17293440 java.lang.String

6: 348547 11153504 org.apache.shardingsphere.sql.parser.sql.segment.dml.column.ColumnSegment

7: 284008 9088256 java.util.LinkedList

8: 374714 8993136 org.apache.shardingsphere.sql.parser.sql.value.identifier.IdentifierValue

9: 95366 8392208 java.lang.reflect.Method

10: 113274 7787336 [Ljava.lang.Object;

11: 246617 5918808 org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ColumnProjectionSegment

12: 170195 5446240 java.util.concurrent.ConcurrentHashMap$Node

13: 105644 4225760 java.util.LinkedHashMap$Entry

14: 34045 3716200 java.lang.Class

15: 110722 3543104 java.util.HashMap$Node

16: 35275 3271760 [Ljava.util.HashMap$Node;

17: 20645 3092088 [I

18: 89022 2848704 org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.PredicateSegment

19: 51995 2495760 org.aspectj.weaver.reflect.ShadowMatchImpl

20: 64925 2077600 org.antlr.v4.runtime.atn.ATNConfig

21: 84638 2031312 java.util.ArrayList

22: 3380 1859456 [Ljava.util.concurrent.ConcurrentHashMap$Node;

23: 51995 1663840 org.aspectj.weaver.patterns.ExposedState

24: 69247 1661928 org.apache.shardingsphere.sql.parser.sql.segment.dml.assignment.InsertValuesSegment

25: 29387 1645672 java.util.LinkedHashMap

26: 71822 1538608 [Ljava.lang.Class;

27: 31810 1526880 java.util.HashMap

28: 53692 1417528 [Z

29: 16298 1303840 java.lang.reflect.Constructor

30: 26018 1248864 com.google.common.cache.LocalCache$StrongAccessEntry

31: 25998 1247904 com.google.common.cache.LocalCache$SoftValueReference

32: 51996 1247896 [Lorg.aspectj.weaver.ast.Var;

33: 48475 1163400 org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.value.PredicateCompareRightValue

34: 23523 1129104 org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement

35: 27653 1106120 com.sun.org.apache.xerces.internal.dom.DeferredAttrImpl

36: 33396 1068672 com.alibaba.metrics.LongAdder

37: 63699 1019184 java.lang.Object

38: 40309 967416 org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.value.PredicateBracketValue

39: 40309 967416 org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.value.PredicateInRightValue

40: 40309 967416 org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.value.PredicateLeftBracketValue

41: 40309 967416 org.apache.shardingsphere.sql.parser.sql.segment.dml.predicate.value.PredicateRightBracketValue

42: 23212 928480 com.sun.org.apache.xerces.internal.dom.DeferredTextImpl

Which version of ShardingSphere did you use?

org.apache.shardingsphere

sharding-jdbc-spring-boot-starter

4.1.1

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

Expected behavior

Actual behavior

Reason analyze (If you can)

SQLParseResultCache GC不了，即使我手动调用System.gc()。cache中的软引用依然存在

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

Example codes for reproduce this issue (such as a github link).