Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.16
-
None
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
-
MDEV-8447 alter table loops internally and fills up disk
- Closed
-
MDEV-12609 Allow suppression of InnoDB log messages about reserving extents
- Closed