Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-557

LP #999147: A crash that leaves behind an InnoDB temporary table with temporary indexes results in an unbootable server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 10-05-2013 05:58:03

      No concrete test case yet, but it needs a temporary table that has at least one index and a server crash that leaves such table behind.

      Subsequent server reboots will try to remove such table and fail:

      120514 6:43:57 InnoDB: Assertion failure in thread 47327229830816 in file dict0dict.c line 868
      InnoDB: Failing assertion: table2 == NULL
      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.5/en/forcing-innodb-recovery.html
      InnoDB: about forcing recovery.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist