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

        1. createTable.sql
          2 kB
          Nirbhay Choubey
        2. sysvars.out
          361 kB
          Nirbhay Choubey

        Issue Links

          Activity

            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.