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

alter table loops internally and fills up disk

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Duplicate
        • Affects Version/s: 10.0.16
        • Fix Version/s: N/A
        • Component/s: Data Definition - Alter Table
        • 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)

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8386 MARIADB creates very big tmp file > 351Gb. Started happening after Version 10.0.16-15

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Frank Schröder,

                  What exactly do you mean by importing the table? (There are several actions that can be called this way, so specifics is important).
                  Can you provide the table that you are importing, in whatever form you have it?
                  You set 'affects version' to Galera, is it what you are really using?
                  Please also provide your cnf file(s).
                  Thanks.

                  Show
                  elenst Elena Stepanova added a comment - Frank Schröder , What exactly do you mean by importing the table? (There are several actions that can be called this way, so specifics is important). Can you provide the table that you are importing, in whatever form you have it? You set 'affects version' to Galera, is it what you are really using? Please also provide your cnf file(s). Thanks.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment - - edited

                  Thank you.
                  Once again, I can reproduce it on openSUSE (on their binaries), but not on another system, so it must be closely related to, or a duplicate of, MDEV-8386.

                  Show
                  elenst Elena Stepanova added a comment - - edited Thank you. Once again, I can reproduce it on openSUSE (on their binaries), but not on another system, so it must be closely related to, or a duplicate of, MDEV-8386 .
                  Hide
                  Permalink
                  jplindst Jan Lindström added a comment -

                  Closing as duplicate.

                  Show
                  jplindst Jan Lindström added a comment - Closing as duplicate.

                    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: