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

mysql.spider_tables corrupted by CREATE TABLE statement

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.7
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Ubuntu Linux 12.04

      Description

      mysql.spider_tables can be consistently corrupted as follows:

      CREATE TABLE s ENGINE=SPIDER CONNECTION 'host "10.0.0.5", user "x", password "x"';
      Lost connection to MySQL server during query

      When subsequently creating a valid table, mysql.spider_tables is corrupted

      CREATE TABLE s(id INT NOT NULL AUTO_INCREMENT, code VARCHAR(10), PRIMARY KEY(id)) ENGINE=SPIDER CONNECTION 'host "10.0.0.5", user "x", password "x"';
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      Connection id:    3
      Current database: test
      ERROR 145 (HY000): Table './mysql/spider_tables' is marked as crashed and should be repaired

      I have managed to corrupt mysql.spider_tables in numerous other ways with the CREATE TABLE statement as well - this is just one easily repeatable example.

        Attachments

          Activity

            People

            Assignee:
            Kentoku Kentoku Shiba
            Reporter:
            greenman Ian Gilfillan
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration