Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
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.