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 2022/04/04 01:52:40 UTC

[GitHub] [shardingsphere] liujintaogit opened a new issue, #16581: Streaming result set com.mysql.jdbc.RowDataDynamic@4a5d8aab is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries

liujintaogit opened a new issue, #16581:
URL: https://github.com/apache/shardingsphere/issues/16581

   ## Question
   apache-shardingsphere-5.0.0-shardingsphere-proxy-bin 
   alter
   [INFO ] 2022-04-04 09:45:36.533 [Connection-3-ThreadExecutor] o.a.s.p.b.t.a.m.e.i.AbstractSelectInformationExecutor$DefaultSelectInformationExecutor - Actual SQL: ds_0 ::: SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA
   [ERROR] 2022-04-04 09:45:36.534 [Connection-3-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
   java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@4a5d8aab is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries.
           at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:869)
           at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:865)
           at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3217)
           at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2453)
           at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
           at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
           at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
           at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)
           at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
           at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
           at org.apache.shardingsphere.proxy.backend.text.admin.mysql.executor.information.AbstractSelectInformationExecutor$DefaultSelectInformationExecutor.getSourceData(AbstractSelectInformationExecutor.java:174)
           at org.apache.shardingsphere.proxy.backend.text.admin.mysql.executor.information.AbstractSelectInformationExecutor.execute(AbstractSelectInformationExecutor.java:69)
           at org.apache.shardingsphere.proxy.backend.text.admin.DatabaseAdminQueryBackendHandler.execute(DatabaseAdminQueryBackendHandler.java:55)
           at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:61)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:99)
           at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:72)
           at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
           at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
           at java.lang.Thread.run(Unknown Source)
   
   **For English only**, other languages will not accept.
   
   Before asking a question, make sure you have:
   
   - Googled your question.
   - Searched open and closed [GitHub issues](https://github.com/apache/shardingsphere/issues).
   - Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
   
   Please pay attention on issues you submitted, because we maybe need more details. 
   If no response anymore and we cannot reproduce it on current information, we will **close it**.
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #16581: Streaming result set com.mysql.jdbc.RowDataDynamic@4a5d8aab is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #16581: Streaming result set com.mysql.jdbc.RowDataDynamic@4a5d8aab is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries
URL: https://github.com/apache/shardingsphere/issues/16581


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #16581: Streaming result set com.mysql.jdbc.RowDataDynamic@4a5d8aab is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16581:
URL: https://github.com/apache/shardingsphere/issues/16581#issuecomment-1089764141

   Hi @liujintaogit, can you try latest 5.1.1 version?


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu commented on issue #16581: Streaming result set com.mysql.jdbc.RowDataDynamic@4a5d8aab is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #16581:
URL: https://github.com/apache/shardingsphere/issues/16581#issuecomment-1159483844

   Closed because of no feedback for long time.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org