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

LP:498227 - MySQL crashes when InnoDB column is renamed and then added to an index, due to fast index creation bug

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      This is a pretty nasty one, because a simple "add index" statement can crash your database in a way that seems unpredictable. Bug is present in latest released MariaDB:

      MySQL 44571: InnoDB Plugin crashes on ADD INDEX
      http://bugs.mysql.com/bug.php?id=44571

      The actual crash looks like so:

      InnoDB: Error: no matching column for "renamed_column" in index "index_renamed_column"-temporary- of table "test"."test_table"!
      091218 10:40:48 InnoDB: Assertion failure in thread 139964197152528 in file dict/dict0dict.c line 1768
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
      InnoDB: about forcing recovery.
       091218 10:40:48 - mysqld got signal 6 ;
      This could be because you hit a bug.

      Attachments

        Activity

          People

            Unassigned Unassigned
            caseyforbes Casey Forbes (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.