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

Wheezy runs out of disk space / shm

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • N/A
    • N/A
    • Tests, MTR
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-wheezy-amd64/builds/10095/steps/mtr/logs/stdio

      innodb.innodb-enlarge-blob '32k,innodb'  w1 [ fail ]
              Test ended at 2017-08-28 19:09:25
       
      CURRENT_TEST: innodb.innodb-enlarge-blob
      mysqltest: At line 23: query 'UPDATE t1 SET a=CONCAT(a, RAND(), a)' failed: 1114: The table 't1' is full
       
      The result from queries just before the failure was:
      CREATE TABLE t1 (a LONGTEXT) ENGINE=INNODB DEFAULT CHARSET=UTF8 ROW_FORMAT=DYNAMIC;
      SHOW WARNINGS;
      Level	Code	Message
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B');
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      INSERT INTO t1 SELECT CONCAT('A', SPACE(4087), 'B') FROM t1;
      UPDATE t1 SET a=CONCAT(a, RAND(), a);
      UPDATE t1 SET a=CONCAT(a, RAND(), a);
      UPDATE t1 SET a=CONCAT(a, RAND(), a);
      

      As discussed earlier, wheezy has been running out of space quite often recently. Probably other VMs will follow. The outcome of that discussion was that we should try to increase the memory for our kvm runs.

      Attachments

        Activity

          People

            dbart Daniel Bartholomew
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.