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

MariaDB 10.1 + Spider => crash server

    XMLWordPrintable

Details

    Description

      Tables spider lost raper ? (I guess)

      then =>

      # mysql
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 4
      Server version: 10.1.11-MariaDB-1~jessie marispider_tablesadb.org binary distribution
       
      Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> SELECT table_schema,
          -> sum( data_length ) as "data",
          -> sum( index_length ) as "index",
          -> sum( data_free ) as "data_free" ,
          -> count(1) as "tables",
          -> sum(TABLE_ROWS) as "rows",
          -> DEFAULT_CHARACTER_SET_NAME,
          -> DEFAULT_COLLATION_NAME
          -> FROM information_schema.TABLES a
          -> INNER JOIN information_schema.SCHEMATA b ON a.table_schema = b.SCHEMA_NAME
          -> GROUP BY table_schema;
      ERROR 2013 (HY000): Lost connection to MySQL server during query
      MariaDB [(none)]> show databases;
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")
      ERROR: Can't connect to the server

      i reconnect :

      DROP TABLE backend.sbtest;

      I try previous query and it worked fine this time.

      table was created as fallow :

      CREATE TABLE `sbtest` (
        `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
        `k` int(10) unsigned NOT NULL DEFAULT '0',
        `c` char(120) NOT NULL DEFAULT '',
        `pad` char(60) NOT NULL DEFAULT '',
        PRIMARY KEY (`id`),
        KEY `k` (`k`)
      ) ENGINE=SPIDER DEFAULT CHARSET=latin1 COMMENT='wrapper "mysql", table "sbtest"'
      /*!50100 PARTITION BY KEY (`id`)
      (PARTITION pt1 COMMENT = 'srv "backend1"' ENGINE = SPIDER,
       PARTITION pt2 COMMENT = 'srv "backend2"' ENGINE = SPIDER) */

      backend1 = backend2 (same params, just different databases)

      after reboot mysql, it seem that backend2 don't answer anymore and worked fine for backend1.

      PS : all of these backend are locate on same MySQL server.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Aurelien_LEQUOY Aurélien LEQUOY
            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.