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: | |
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
[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.