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

mysql.spider_tables corrupted by CREATE TABLE statement

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.7
    • None
    • None
    • 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

            Kentoku Kentoku Shiba (Inactive)
            greenman Ian Gilfillan
            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.