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

    XMLWordPrintable

    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

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: