[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=0x7f36bc17e000 nid=0x4c92 runnable [0x7f36465c1000] 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 NIVIRTRESSHR 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** ` org.apache.shardingsphere sharding-jdbc-core 4.0.0-RC1 ` 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: us...@infra.apache.org With regards, Apache Git Services
[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=0x7f36bc17e000 nid=0x4c92 runnable [0x7f36465c1000] 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 NIVIRTRESSHR 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** ` org.apache.shardingsphere sharding-jdbc-core 4.0.0-RC1 ` 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: us...@infra.apache.org With regards, Apache Git Services
