linghengqian commented on issue #32765: URL: https://github.com/apache/shardingsphere/issues/32765#issuecomment-2356372742
- I introduced how to use Alibaba Druid's `StatViewServlet`, `WebStatFilter`, and custom `Filter` to monitor the logical data source and real data source of ShardingSphere JDBC at https://github.com/apache/shardingsphere/discussions/12258#discussioncomment-10427297 and https://www.yuque.com/linghengqian/meve2v/zoy35sivtf6nzp90 . - In the relevant example, I used some virtual threads to execute the inevitable `insert` SQL with the `H2database` database instance managed by `Alibaba Druid` at a frequency of once per second, and I was completely unable to reproduce your problem. All connections pooled by `Druid` can continue to be used. - I have noticed at least 3 `Alibaba Druid` bugs, and these bugs have existed for at least 8 years. But these bugs are actually irrelevant to your description. 1. According to https://github.com/alibaba/druid/pull/6128, alibaba/druid should not set the default value of `testWhileIdle` to true. 2. According to https://github.com/alibaba/druid/issues/5158, alibaba/druid mistakenly hard-coded `/druid/login.html`. 3. According to https://github.com/alibaba/druid/pull/6132, when Spring AOP is configured to use `CGLib` proxy, `alibaba/druid`'s Spring Boot Starter does not actively create the Spring Bean of `DefaultAdvisorAutoProxyCreator`. - The master branch of shardingsphere contains unit tests for transactions on mysql managed by hikaricp, which cannot be reproduced from hotspot jdk or graalvm native image. - @HuLaLaGa I now suspect that there is a bug in the mysql jdbc driver you are using. Or there is a bug in the mysql server. I think it's necessary for you to provide a git containing unit tests, where the database should be initialized via testcontainers-java and junit5 . -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
