Project

General

Profile

Actions

Defect #25829

closed

mysql2 0.3 gem doesn't properly close connections

Added by Pavel Rosický almost 7 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Normal
Category:
Gems support
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

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

Gemfile.patch (508 Bytes) Gemfile.patch Pavel Rosický, 2017-05-12 23:57
Actions

Also available in: Atom PDF