[GitHub] [shardingsphere] tuohai666 commented on issue #6324: ShardingSphere-Proxy will be blocked when query big blob data

[GitBox <gi...@apache.org>]

tuohai666 commented on issue #6324:
URL: https://github.com/apache/shardingsphere/issues/6324#issuecomment-658211334


   @Simbafa Thanks for your analysis and all the test.
   The root cause of this problem is due to unreached notify to proxy.
   
   Codes in MySQLCommandExecuteEngine:
   ```
   1     context.flush();
   2     backendConnection.getResourceSynchronizer().doAwait();
   ```
   Proxy might be starting to **begin** notify() after the 1st line ended before wait(). The notify will be back before or after the 2nd line.
   If after the 2nd line, everything goes well. Otherwise, the thread will never be awakened by notify.
   I have submitted a pr to resolve this problem by adding a timer to wait.
   


----------------------------------------------------------------
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