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

alter table loops internally and fills up disk

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.0.16
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      10.0.16-MariaDB-log openSUSE package
      SLES 12

      Description

      In a fresh MariaDB when I import a small 9MB InnoDB Table and enter OPTIMIZE LOCAL TABLE the server hangs/loops and fills the disk 100% with one huge #sql...ibd file. The mysqld has then to be stopped with kill -9...
      As written in the documentation the server performs an ALTER TABLE engine=InnoDB, so there is the same effect when I enter the ALTER directly, also on ALTER TABLE ADD KEY and so on. No difference if there are already keys on the table or not. If the table contains less than ~10000 rows, it works fine.
      Workarounds:
      1) change the engine to MyIsam and then back to InnoDB
      2) set old_alter_table=ON (preferred)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              oldschool Frank Schröder
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: