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

MARIADB creates very big tmp file > 351Gb. Started happening after Version 10.0.16-15

Details

    Description

      ALTER enters into an infinite loop on reserving extents until system runs out of disk mysqld aborts.

      #!/bin/bash
      		 
       
      		 
      mysql="mysql -uroot -S /var/run/mysql/mysql.sock "
      		 
       
      		 
      $mysql test < ./createTable.sql
      		 
       
      		 
      #for i in $( seq 22 1 122 ); do
      		 
      for i in $( seq 22 1 2722 ); do
      		 
        echo $i
      		 
        $mysql test -e "INSERT INTO \`mdl_course_modules\` VALUES ($i,4,5,5,24,NULL,1141569781,'',0,0,1,0,'',0,'locked',1,1,0,0,0,0,NULL,0,0,0,0,0,0);"
      		 
      done
      		 
       
      		 
      $mysql test -e "ALTER TABLE test.mdl_course_modules ADD stefantest LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER showdescription;"
      		 

      sles12-x86-64:/var/lib/mysql/test # ls -ahl
      		 
      total 9.0G
      		 
      -rw-rw---- 1 mysql mysql  6.2K Jun  2 12:52 #sql-ba5_b99.frm
      		 
      -rw-rw---- 1 mysql mysql  9.0G Jun  2 13:08 #sql-ib18-3361842814.ibd
      		 
      drwx------ 1 mysql root    168 Jun  2 12:52 .
      		 
      drwx------ 1 mysql root    248 Jun  2 13:08 ..
      		 
      -rw-rw---- 1 mysql mysql  6.2K Jun  2 12:46 mdl_course_modules.frm
      		 
      -rw-rw---- 1 mysql mysql 1008K Jun  2 12:52 mdl_course_modules.ibd

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8447 alter table loops internally and fills up disk

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12609 Allow suppression of InnoDB log messages about reserving extents

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            nirbhay_c Nirbhay Choubey (Inactive) created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Description ALTER enters into an infinite loop on reserving extents until system runs out of disk.

            {code}
            #!/bin/bash

            mysql="mysql -uroot -S /var/run/mysql/mysql.sock "

            $mysql test < ./createTable.sql

            #for i in $( seq 22 1 122 ); do
            for i in $( seq 22 1 2722 ); do
              echo $i
              $mysql test -e "INSERT INTO \`mdl_course_modules\` VALUES ($i,4,5,5,24,NULL,1141569781,'',0,0,1,0,'',0,'locked',1,1,0,0,0,0,NULL,0,0,0,0,0,0);"
            done

            $mysql test -e "ALTER TABLE test.mdl_course_modules ADD stefantest LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER showdescription;"
            {code}

            sles12-x86-64:/var/lib/mysql/test # ls -ahl
            total 9.0G
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:52 #sql-ba5_b99.frm
            -rw-rw---- 1 mysql mysql 9.0G Jun 2 13:08 #sql-ib18-3361842814.ibd
            drwx------ 1 mysql root 168 Jun 2 12:52 .
            drwx------ 1 mysql root 248 Jun 2 13:08 ..
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:46 mdl_course_modules.frm
            -rw-rw---- 1 mysql mysql 1008K Jun 2 12:52 mdl_course_modules.ibd             		ALTER enters into an infinite loop on reserving extents until system runs out of disk.

            {code}
            #!/bin/bash

            mysql="mysql -uroot -S /var/run/mysql/mysql.sock "

            $mysql test < ./createTable.sql

            #for i in $( seq 22 1 122 ); do
            for i in $( seq 22 1 2722 ); do
              echo $i
              $mysql test -e "INSERT INTO \`mdl_course_modules\` VALUES ($i,4,5,5,24,NULL,1141569781,'',0,0,1,0,'',0,'locked',1,1,0,0,0,0,NULL,0,0,0,0,0,0);"
            done

            $mysql test -e "ALTER TABLE test.mdl_course_modules ADD stefantest LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER showdescription;"
            {code}
            {noformat}
            sles12-x86-64:/var/lib/mysql/test # ls -ahl
            total 9.0G
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:52 #sql-ba5_b99.frm
            -rw-rw---- 1 mysql mysql 9.0G Jun 2 13:08 #sql-ib18-3361842814.ibd
            drwx------ 1 mysql root 168 Jun 2 12:52 .
            drwx------ 1 mysql root 248 Jun 2 13:08 ..
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:46 mdl_course_modules.frm
            -rw-rw---- 1 mysql mysql 1008K Jun 2 12:52 mdl_course_modules.ibd
            {noformat}
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Attachment sysvars.out [ 38513 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Description ALTER enters into an infinite loop on reserving extents until system runs out of disk.

            {code}
            #!/bin/bash

            mysql="mysql -uroot -S /var/run/mysql/mysql.sock "

            $mysql test < ./createTable.sql

            #for i in $( seq 22 1 122 ); do
            for i in $( seq 22 1 2722 ); do
              echo $i
              $mysql test -e "INSERT INTO \`mdl_course_modules\` VALUES ($i,4,5,5,24,NULL,1141569781,'',0,0,1,0,'',0,'locked',1,1,0,0,0,0,NULL,0,0,0,0,0,0);"
            done

            $mysql test -e "ALTER TABLE test.mdl_course_modules ADD stefantest LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER showdescription;"
            {code}
            {noformat}
            sles12-x86-64:/var/lib/mysql/test # ls -ahl
            total 9.0G
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:52 #sql-ba5_b99.frm
            -rw-rw---- 1 mysql mysql 9.0G Jun 2 13:08 #sql-ib18-3361842814.ibd
            drwx------ 1 mysql root 168 Jun 2 12:52 .
            drwx------ 1 mysql root 248 Jun 2 13:08 ..
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:46 mdl_course_modules.frm
            -rw-rw---- 1 mysql mysql 1008K Jun 2 12:52 mdl_course_modules.ibd
            {noformat}             		ALTER enters into an infinite loop on reserving extents until -system runs out of disk- mysqld aborts.

            {code}
            #!/bin/bash

            mysql="mysql -uroot -S /var/run/mysql/mysql.sock "

            $mysql test < ./createTable.sql

            #for i in $( seq 22 1 122 ); do
            for i in $( seq 22 1 2722 ); do
              echo $i
              $mysql test -e "INSERT INTO \`mdl_course_modules\` VALUES ($i,4,5,5,24,NULL,1141569781,'',0,0,1,0,'',0,'locked',1,1,0,0,0,0,NULL,0,0,0,0,0,0);"
            done

            $mysql test -e "ALTER TABLE test.mdl_course_modules ADD stefantest LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci AFTER showdescription;"
            {code}
            {noformat}
            sles12-x86-64:/var/lib/mysql/test # ls -ahl
            total 9.0G
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:52 #sql-ba5_b99.frm
            -rw-rw---- 1 mysql mysql 9.0G Jun 2 13:08 #sql-ib18-3361842814.ibd
            drwx------ 1 mysql root 168 Jun 2 12:52 .
            drwx------ 1 mysql root 248 Jun 2 13:08 ..
            -rw-rw---- 1 mysql mysql 6.2K Jun 2 12:46 mdl_course_modules.frm
            -rw-rw---- 1 mysql mysql 1008K Jun 2 12:52 mdl_course_modules.ibd
            {noformat}
            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.0 [ 16000 ]
            Assignee Jan Lindström [ jplindst ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            elenst Elena Stepanova made changes -
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.0.17 [ 18300 ]
            Fix Version/s 10.0 [ 16000 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 70338 ] MariaDB v4 [ 149311 ]

            People

              jplindst Jan Lindström (Inactive)
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.