You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/01/09 16:06:58 UTC
[GitHub] [incubator-shardingsphere] erstens opened a new issue #2997: cpu
load 100% when using sqlstatement cache
erstens opened a new issue #2997: cpu load 100% when using sqlstatement cache
URL: https://github.com/apache/incubator-shardingsphere/issues/2997
**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 .
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services