zljgit commented on issue #2997:
URL: https://github.com/apache/shardingsphere/issues/2997#issuecomment-666879014
> **jstack**
>
> `"DubboServerHandler-172.16.42.151:9503-thread-483" #734 daemon prio=5
os_prio=0 tid=0x00007f36bc17e000 nid=0x4c92 runnable [0x00007f36465c1000]
java.lang.Thread.State: RUNNABLE at
org.apache.commons.collections4.map.AbstractHashedMap.getEntry(AbstractHashedMap.java:461)
at
org.apache.commons.collections4.map.AbstractReferenceMap.getEntry(AbstractReferenceMap.java:427)
at
org.apache.commons.collections4.map.AbstractReferenceMap.get(AbstractReferenceMap.java:244)
at
org.apache.shardingsphere.core.parse.cache.ParsingResultCache.getSQLStatement(ParsingResultCache.java:53)
at
org.apache.shardingsphere.core.parse.SQLParsingEngine.getSQLStatementFromCache(SQLParsingEngine.java:69)
at
org.apache.shardingsphere.core.parse.SQLParsingEngine.parse(SQLParsingEngine.java:56)
at
org.apache.shardingsphere.core.route.router.sharding.ParsingSQLRouter.parse(ParsingSQLRouter.java:78)
at
org.apache.shardingsphere.core.route.PreparedStatementRoutingEngine.route(PreparedStatementRoutingEngine.java:64
) at
org.apache.shardingsphere.core.PreparedQueryShardingEngine.route(PreparedQueryShardingEngine.java:60)
at
org.apache.shardingsphere.core.BaseShardingEngine.shard(BaseShardingEngine.java:64)
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.shard(ShardingPreparedStatement.java:224)
at
org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.executeQuery(ShardingPreparedStatement.java:109)
at
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:692)
........... at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) at
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:776)
......... `
>
> **top threads**
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 19602 root 20 0 8773700 2.766g 23436 R 94.1 17.8 8:29.27 java
> 19617 root 20 0 8773700 2.766g 23436 R 88.2 17.8 18:27.23 java
> 19606 root 20 0 8773700 2.766g 23436 R 47.1 17.8 12:36.25 java
> 19611 root 20 0 8773700 2.766g 23436 R 41.2 17.8 7:58.80 java
> 19608 root 20 0 8773700 2.766g 23436 R 29.4 17.8 24:20.39 java
> 19612 root 20 0 8773700 2.766g 23436 R 29.4 17.8 31:49.70 java
> 19601 root 20 0 8773700 2.766g 23436 R 23.5 17.8 0:00.82 java
>
> **version**
> `<dependency> <groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-core</artifactId> <version>4.0.0-RC1</version>
</dependency>`
>
> please help me ,thanks all .
看上去是 SQLParseResultCache
private final Map<String, SQLStatement> cache = new
ReferenceMap<>(AbstractReferenceMap.ReferenceStrength.SOFT,
AbstractReferenceMap.ReferenceStrength.SOFT, 65535, 1);
导致死循环
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
