Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13840

MariaDB 10.2.8 is not closing connection with MySQL

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.2.8
    • N/A
    • libmariadb, Server
    • None
    • 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.

      Attachments

        Activity

          lpatrick Lori Patrick added a comment - - edited

          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!!

          lpatrick Lori Patrick added a comment - - edited 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!!
          elenst Elena Stepanova added a comment - - edited

          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.

          elenst Elena Stepanova added a comment - - edited 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.

          Closing, as it appears to be the connector issue according to the comment above.

          elenst Elena Stepanova added a comment - Closing, as it appears to be the connector issue according to the comment above.

          People

            Unassigned Unassigned
            lpatrick Lori Patrick
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.