[GitHub] [shardingsphere] tuichenchuxin commented on pull request #23114: Fix show encrypt columns occasional exception

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

tuichenchuxin commented on PR #23114:
URL: https://github.com/apache/shardingsphere/pull/23114#issuecomment-1366508525

   @TeslaCN 
   When H2 processes the `show columns` statement, it will be converted into a `select` statement. During the process, H2 will be compiled twice. If the metaId is changed during the compilation process, an exception will occur. Hrikari's houseKeeper thread will create a connection in order to maintain the minimum number of connections, and the metaId will change when the connection is created. Modifying `minimumIdle = 0` can prevent houseKeeper from actively creating connections, thereby preventing this exception from happening.
   
   For why h2 recompile has error if metaId changed. I have submit a issue. https://github.com/h2database/h2database/issues/3698


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