Defect #25829
closed
mysql2 0.3 gem doesn't properly close connections
0%
Description
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
Files
Updated by Go MAEDA over 7 years ago
- Tracker changed from Feature to Defect
- Subject changed from upgrade mysql2 to mysql2 gem doesn't properly close connections
- Target version set to 3.2.7
- Affected version set to 2.0.0
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.
Updated by Jean-Philippe Lang over 7 years ago
- Subject changed from mysql2 gem doesn't properly close connections to mysql2 0.3 gem doesn't properly close connections
- Status changed from New to Resolved
- Assignee set to Jean-Philippe Lang
- Resolution set to Fixed
Patch committed, thanks.
Updated by Jean-Philippe Lang over 7 years ago
- Status changed from Resolved to Closed