Vote #78467
完了mysql2 0.3 gem doesn't properly close connections
0%
説明
Hi,
I found that mysql2 (0.3.21) doesn't properly closing connections.
Our mysql's error logs are full of these warnings
11797 [Warning] Aborted connection 12561 to db: 'test' user: 'test' host: '127.0.0.1' (Got an error reading communication packets) 11798 [Warning] Aborted connection 12561 to db: 'test' user: 'test' host: '127.0.0.1' (Got an error reading communication packets) 11799 [Warning] Aborted connection 12561 to db: 'test' user: 'test' host: '127.0.0.1' (Got an error reading communication packets) ...
it is already fixed, but the change wasn't backported to the 0.3.x branch
https://github.com/brianmario/mysql2/issues/606
I can confirm the issue is gone after upgrading to the current version 0.4.6.
This version is still compatible with Ruby 1.9+ and it passes redmine tests. I also run our specs and it looks like everything is ok.
Notable changes:
* mysql 8 support * prepared statements support * connection.close/shutdown fix * many bugfixes
Full changelog:
https://github.com/brianmario/mysql2/releases
journals
Setting target version to 3.2.7.
I have been observing a significant increase in the number of connections on my environment for years, maybe caused by this issue.
Thank you for detecting and inspecting this issue.
--------------------------------------------------------------------------------
Patch committed, thanks.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------