| Bug #17764 | trigger crashes myisam table | ||
|---|---|---|---|
| Submitted: | 28 Feb 2006 11:43 | Modified: | 31 Mar 2006 9:22 |
| Reporter: | Nizamettin OZPOLAT | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S2 (Serious) |
| Version: | 5.0.18 | OS: | Linux (SuSE Linux 9.0 (i586) - Kernel 2) |
| Assigned to: | Dmitri Lenev | Target Version: | |
| Tags: | corruption, myisam | ||
[28 Feb 2006 16:38]
Jorge del Conde
Thanks for your bug report.
I was able to reproduce this under WinXP w/5.0.18
-> (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3
ERROR 1194 (HY000): Table 't2' is marked as crashed and should be repaired
mysql>
[18 Mar 2006 19:36]
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/3959
[28 Mar 2006 12:50]
Konstantin Osipov
Thoroughly discussed with Monty and Dmitri and decided to take another approach to the problem: disable bulk insert completely in prelocked mode.
[29 Mar 2006 9:14]
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/4262
[29 Mar 2006 12:49]
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/4266
[29 Mar 2006 20:11]
Konstantin Osipov
Pushed into 5.0.20, merged into 5.1.8
[31 Mar 2006 9:22]
Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Additional info:
Documented bugfix in 5.0.20 and 5.1.8 changelogs. Closed.
[7 Apr 2006 17:35]
Konstantin Osipov
Bug#16074 has been marked as a duplicate of this bug.
[17 Apr 2006 23:21]
Dmitri Lenev
Bug #17704 has been marked as yet another duplicate of this bug.
[19 Apr 2006 15:21]
Dmitri Lenev
Bug #16021 is another duplicate of this bug.
[19 Apr 2006 17:14]
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/5151
Description: As can be examined at the example when myisam tables name is used in stored procedure mysqlserver give error "Table 't2' is marked as crashed and should be repaired". sp1 called by the trigger after insert on t2. When I change table type to innodb every thing is OK. sp1 sums b grouped by a on table t2 and assigns it to table t1 if t1.a=t2.a How to repeat: CREATE TABLE `t1` ( `a` int(11) default NULL, `b` int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; insert into t1 (a,b) values(1,2),(2,3),(1,2),(2,3),(1,2); CREATE TABLE `t2` ( `a` int(11) default NULL, `c` int(11) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; drop procedure if exists sp1; create procedure sp1(in v2 INTEGER) NOT DETERMINISTIC SQL SECURITY DEFINER COMMENT '' BEGIN DECLARE total INTEGER; select sum(c) into total from t2 where a = v2 group by a; update t1 set t1.b = total where t1.a = v2; END; --drop trigger tr1; CREATE TRIGGER tr1 AFTER INSERT ON t2 FOR EACH ROW call sp1(NEW.a); --ALTER TABLE t2 TYPE=inndb, COMMENT=''; insert into t2 (a,c) values (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3), (1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3),(1,2),(2,3);