[MDEV-13840] MariaDB 10.2.8 is not closing connection with MySQL Created: 2017-09-18 Updated: 2017-09-19 Resolved: 2017-09-19 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | libmariadb, Server |
| Affects Version/s: | 10.2.8 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Lori Patrick | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS 7.2 |
||
| Description |
|
We upgraded from MariaDB 5.5.34 to MariaDB 10.2.8 over the weekend. After the upgrade, we are seeing applications that use MySQL C++ Static Connector 1.0.6 fail to disconnect properly after a failed insert attempt. The client side thinks the application has closed, but the server still have the thread open, and a netstat shows it still open on the client side. Is this a known issue? Is there a work around other than upgrading to MariaDB C++ connector? We had previously testing 10.1.18 and not seen this issue. |
| Comments |
| Comment by Lori Patrick [ 2017-09-19 ] |
|
We actually found upgrading the generic library resolves the problem. Once we updated to 1.1.9 - the problem is resolved. We also back tested and confirmed, the issue existed on 5.5.34. This ticket can be closed. Thanks!! |
| Comment by Elena Stepanova [ 2017-09-19 ] |
|
Could you please provide a code snippet from the application which establishes the connection, attempts insert, fails and disconnects? Where did 1.0.6 come from? MySQL website only offers 1.0.5. Does the server error log say anything? Please also attach your server cnf file(s). — Upd: sorry didn't see your comment above while writing this one. |
| Comment by Elena Stepanova [ 2017-09-19 ] |
|
Closing, as it appears to be the connector issue according to the comment above. |