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

ERROR 2013 (HY000): Lost connection persists

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2.11
    • None
    • Windows 7
      Workstation / Lenovo D30

    Description

      I have several databases:

      • fire_curr: 10 tables, number of rows between 100 and 16 Mio
      • fire_curr_add: 20 tables, number of rows between 100 and 16 Mio

      and many other databases on the same MariaDB instance. When I submit an sql to fire_curr_add, for example:

      SELECT COUNT(*) FROM fire_curr_add.patient

      I get connection to the server and results. When I send the query
      to fire_curr, for example:

      SELECT COUNT(*) FROM fire_curr.patient

      I get the error:

      MariaDB: ERROR 2013 (HY000): Lost connection to MySQL server during query

      and the service stops. When I restart the service each time I want to access the database curr the serivice stops. This is not the case for nearly all other databases
      of the same instance. The instance and databases exists since 6 month and I had never such problems.

      Other affected database, tables and columns:
      I have access to database information_schema. For example, I can count the rows of table system_variables:

      SELECT COUNT(*) FROM system_variables

      But if I try the same with table columns:

      SELECT COUNT(*) FROM columns

      the connection will be lost.

      This works:

      SELECT COUNT(*) FROM tables

      Also this:

      *SELECT table_schema, table_name FROM tables

      But if I submit

      SELECT * FROM tables

      or

      SELECT table_schema, table_name, engine, table_rows 
      FROM tables 
      LIMIT 10

      the connection will be lost.

      Summary: some database disconnect the mysql-server and also some columns of tables.

      This problems was also submitted to stackoverflow.

      Attachmemts

      • WS20130124-2_20171130-2.zip: contains the compete err-file.
      • jira_01_select.gif: mysql-terminal output

      Other relevant informations:

      • 20-23.11.2017 All tables have been copied from fire_curr to fire_curr_add and processed in fire_curr_add.
      • 29.11.2017 Version 10.2.6 was upgraded to 10.2.11, but problem persists.

      Attachments

        Activity

          People

            Unassigned Unassigned
            giordano Fabio Valeri
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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