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

Aborted connection NNN to db: 'DB_NAME' user: 'USER' host: 'localhost' (Unknown error)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • 5.5.45
    • N/A
    • None
    • Server version: 5.5.45-MariaDB-1~trusty-log mariadb.org binary distribution
      Distributor ID: Ubuntu
      Description: Ubuntu 14.04.3 LTS
      Release: 14.04
      Codename: trusty

    Description

      I open a connection and run a few queries against a DB on localhost. About 571-597 seconds after the connection is established, I get the error:

      Sep 25 16:08:20 HOSTNAME mysqld: 150925 16:08:20 [Warning] Aborted connection 126 to db: 'DB_NAME' user: 'USER' host: 'localhost' (Unknown error)

      There don't seem to be any variables like '%timeout%' for this much time. The next time the client tries to run a query, I get the error:
      oursql.OperationalError: (2006, 'MySQL server has gone away', None)

      I don't have a MariaDB development environment setup, but most of the relevant code appears to be in less ./sql/sql_connect.cc.

      while (thd_is_connection_alive(thd))

      { mysql_audit_release(thd); if (do_command(thd)) break; }

      end_connection(thd);

      There don't seem to be any other logs around here. There are no other processes, and no queries, running on the mysql server.

      Please let me know if I can provide any more information.

      Attachments

        Activity

          People

            Unassigned Unassigned
            yunesj Jeffrey Yunes
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.