tuohai666 commented on issue #8903: URL: https://github.com/apache/shardingsphere/issues/8903#issuecomment-769646327
It seems like the 1st SQL (2 in total) locked the rows and it lead to the 2nd SQL fire a timeout Exception. The Exception burst 50 seconds (innodb_lock_wait_timeout) after execution. Can you tell me whether fid is the key? Or how many rows will return for this SQL? What the return result looks like? And how your test codes process the 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: [email protected]
