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/02/13 07:47:03 UTC
[GitHub] [incubator-shardingsphere] lklkxcxc opened a new issue #4284: SQL
query hung
lklkxcxc opened a new issue #4284: SQL query hung
URL: https://github.com/apache/incubator-shardingsphere/issues/4284
stdout.log：`[DEBUG] 15:14:08.595 [HikariPool-1 housekeeper] com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=2, active=1, idle=1, waiting=0)
Exception in thread "ShardingSphere-Command-13" java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOfRange(Arrays.java:3664)
at java.lang.String.<init>(String.java:207)
at java.nio.HeapCharBuffer.toString(HeapCharBuffer.java:567)
at java.nio.CharBuffer.toString(CharBuffer.java:1241)
at com.mysql.jdbc.StringUtils.toString(StringUtils.java:2253)
at com.mysql.jdbc.ResultSetRow.getString(ResultSetRow.java:707)
at com.mysql.jdbc.BufferRow.getString(BufferRow.java:527)
at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5245)
at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5127)
at com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java)
at org.apache.shardingsphere.core.execute.sql.execute.result.QueryResultUtil.getValueByColumnType(QueryResultUtil.java:121)
at org.apache.shardingsphere.core.execute.sql.execute.result.QueryResultUtil.getValue(QueryResultUtil.java:51)
at org.apache.shardingsphere.core.execute.sql.execute.result.MemoryQueryResult.getResultData(MemoryQueryResult.java:79)
at org.apache.shardingsphere.core.execute.sql.execute.result.MemoryQueryResult.<init>(MemoryQueryResult.java:60)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.callback.ProxySQLExecuteCallback.createQueryResult(ProxySQLExecuteCallback.java:111)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.callback.ProxySQLExecuteCallback.executeSQL(ProxySQLExecuteCallback.java:93)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.callback.ProxySQLExecuteCallback.executeSQL(ProxySQLExecuteCallback.java:85)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.callback.ProxySQLExecuteCallback.executeSQL(ProxySQLExecuteCallback.java:54)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:68)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:57)
at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:125)
at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.parallelExecute(ShardingExecuteEngine.java:102)
at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:83)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:73)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.execute.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:82)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:93)
at org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:78)
at org.apache.shardingsphere.shardingproxy.backend.text.query.QueryBackendHandler.execute(QueryBackendHandler.java:54)
at org.apache.shardingsphere.shardingproxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:73)
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:86)
at org.apache.shardingsphere.shardingproxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:66)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)`
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] lklkxcxc commented on issue #4284: SQL
query big table return '[java.util.concurrent.ExecutionException:
java.lang.OutOfMemoryError: Java heap space]'
Posted by GitBox <gi...@apache.org>.
lklkxcxc commented on issue #4284: SQL query big table return '[java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space]'
URL: https://github.com/apache/incubator-shardingsphere/issues/4284#issuecomment-586083287
The problem was resolved that add jdbc parm “useCursorFetch=true”
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] tuohai666 closed issue #4284: SQL query
big table return '[java.util.concurrent.ExecutionException:
java.lang.OutOfMemoryError: Java heap space]'
Posted by GitBox <gi...@apache.org>.
tuohai666 closed issue #4284: SQL query big table return '[java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space]'
URL: https://github.com/apache/incubator-shardingsphere/issues/4284
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #4284: SQL
query big table return '[java.util.concurrent.ExecutionException:
java.lang.OutOfMemoryError: Java heap space]'
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #4284: SQL query big table return '[java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space]'
URL: https://github.com/apache/incubator-shardingsphere/issues/4284#issuecomment-586185925
> @kimmking Sharding -proxy will run out of memory if you use the memory
@lklkxcxc Memory resultset will out of memory if the result size larger than the jvm heap. The 5.2GB you mentioned is not equal to the size in Sharding-Proxy. To resolve this problem, you can either enlarge Xmx or using stream resultset.
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] lklkxcxc commented on issue #4284: SQL
query big table return '[java.util.concurrent.ExecutionException:
java.lang.OutOfMemoryError: Java heap space]'
Posted by GitBox <gi...@apache.org>.
lklkxcxc commented on issue #4284: SQL query big table return '[java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space]'
URL: https://github.com/apache/incubator-shardingsphere/issues/4284#issuecomment-586125043
@kimmking Sharding -proxy will run out of memory if you use the memory
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4284: SQL
query big table return '[java.util.concurrent.ExecutionException:
java.lang.OutOfMemoryError: Java heap space]'
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4284: SQL query big table return '[java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space]'
URL: https://github.com/apache/incubator-shardingsphere/issues/4284#issuecomment-586114599
Using stream query instead of memory query?
----------------------------------------------------------------
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