Bug #34453 Can't change size of file (Errcode: 1224)
Submitted: 11 Feb 2008 10:13 Modified: 12 Nov 2009 20:54
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:mysql-5.1.23-rc-winx64 OS:Windows (64-bit XP)
Assigned to: Jon Olav Hauglid CPU Architecture:Any

[11 Feb 2008 10:13] Shane Bester
Description:
the testsuite fails on the trigger test on windows.  Here is the failure:

mysql> drop temporary table if exists t2;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> create table t1 (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> create temporary table t2 (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> create trigger t1_bi before insert on t1 for each row insert into t2 values (0);
Query OK, 0 rows affected (0.02 sec)

mysql> create trigger t1_bd before delete on t1 for each row delete from t2;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (0);
Query OK, 1 row affected (0.00 sec)

mysql> insert into t1 values (0);
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+------+
| s1   |
+------+
|    0 |
|    0 |
+------+
2 rows in set (0.08 sec)

mysql> select * from t2;
+------+
| s1   |
+------+
|    0 |
|    0 |
+------+
2 rows in set (0.00 sec)

mysql> delete from t1;
ERROR 14 (HY000): Can't change size of file (Errcode: 1224)
mysql>

How to repeat:
drop table if exists t1;
drop temporary table if exists t2;
create table t1 (s1 int);
create temporary table t2 (s1 int);
create trigger t1_bi before insert on t1 for each row insert into t2 values (0);
create trigger t1_bd before delete on t1 for each row delete from t2;
insert into t1 values (0);
insert into t1 values (0);
select * from t1;
select * from t2;
delete from t1;
[11 Feb 2008 21:19] MySQL Verification Team
Thank you for the bug report.

mysql> delete from t1;
ERROR 14 (HY000): Can't change size of file (Errcode: 1224)
mysql> show variables like "%version%";
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.1.24-rc-nt-log    |
| version_comment         | Source distribution |
| version_compile_machine | ia32                |
| version_compile_os      | Win32               |
+-------------------------+---------------------+
5 rows in set (0.06 sec)

mysql>
[13 Feb 2008 22:19] Omer Barnir
triage: setting to P3 because this is a simple case that people can run into
[8 Oct 2008 10:48] Konstantin Osipov
Can't repeat against the latest 6.0. Still a test case won't harm.
[10 Apr 2009 10:11] rancpine cui
can't appear on RedHat Linux, mysql 5.1.32

mysql> drop table if exists t1;
Query OK, 0 rows affected (0.00 sec)

mysql> drop temporary table if exists t2;
Query OK, 0 rows affected (0.00 sec)

mysql> create table t1 (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> create temporary table t2 (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> create trigger t1_bi before insert on t1 for each row insert into t2 values (0);
Query OK, 0 rows affected (0.00 sec)

mysql> create trigger t1_bd before delete on t1 for each row delete from t2;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 values (0);
Query OK, 1 row affected (0.00 sec)

mysql> insert into t1 values (0);
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+------+
| s1   |
+------+
|    0 | 
|    0 | 
+------+
2 rows in set (0.00 sec)

mysql> select * from t2;
+------+
| s1   |
+------+
|    0 | 
|    0 | 
+------+
2 rows in set (0.00 sec)

mysql> delete from t1;
Query OK, 2 rows affected (0.00 sec)

mysql> select version();
+------------+
| version()  |
+------------+
| 5.1.32-log | 
+------------+
1 row in set (0.00 sec)
[2 Jun 2009 9:20] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/75446

2791 Jon Olav Hauglid	2009-06-02
      Bug #34453 Can't change size of file (Errcode: 1224)
      
      Unable to reproduce error on current version of mysql azalea.
      Test case based on the bug report added to trigger.test.
[16 Jun 2009 13:15] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/76389

2800 Jon Olav Hauglid	2009-06-16
      Bug #34453 Can't change size of file (Errcode: 1224)
      
      Unable to reproduce error on current version of mysql azalea.
      Test case based on the bug report added to trigger.test.
[18 Jun 2009 6:48] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090617073019-azsawauatv99124t) (version source revid:jon.hauglid@sun.com-20090616122749-uenmqbo4mxr4mel2) (merge vers: 5.4.4-alpha) (pib:11)
[18 Jun 2009 14:56] Paul DuBois
Test case change only. No changelog entry needed.
[12 Oct 2009 11:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/86552

2909 Jon Olav Hauglid	2009-10-12
      Bug #34453 Can't change size of file (Errcode: 1224)
           
      Unable to reproduce error on current version of the 5.5.0
      codebase. Test case based on the bug report added to trigger.test.
      
      Backport of revno: 2617.52.11.
[12 Oct 2009 11:01] Jon Olav Hauglid
Pushed to mysql-next-mr-runtime (version 5.5.0).
[3 Nov 2009 7:17] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091102151658-j9o4wgro47m5v84d) (version source revid:alik@sun.com-20091023064702-2f8jdmny61bdl94u) (merge vers: 6.0.14-alpha) (pib:13)
[3 Nov 2009 15:39] Paul DuBois
Test case change only. No changelog entry needed.
[12 Nov 2009 8:20] Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091110093229-0bh5hix780cyeicl) (version source revid:mikael@mysql.com-20091103113702-p61dlwc6ml6fxg18) (merge vers: 5.5.0-beta) (pib:13)
[12 Nov 2009 20:54] Paul DuBois
Changes to test case only. No changelog entry needed.