HeroHong opened a new issue #12331:
URL: https://github.com/apache/shardingsphere/issues/12331
## 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?
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>4.1.1</version>
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
### Expected behavior
### Actual behavior
### Reason analyze (If you can)
SQLParseResultCache GC不了，技术我手动调用System.gc()。cache中的软引用依然存在
<img width="1120" alt="wecom-temp-130d4c4bea4878d4babcbd4400a15f4b"
src="https://user-images.githubusercontent.com/11569710/132796828-6aeb1388-1e69-4da8-9583-26455274d39c.png";>
### 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).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
![https://user-images.githubusercontent.com/11569710/132796828-6aeb1388-1e69-4da8-9583-26455274d39c.png"](https://user-images.githubusercontent.com/11569710/132796828-6aeb1388-1e69-4da8-9583-26455274d39c.png"){kind=link}