mysql bug 55981

blob bug

[@more@]

http://www.mysqlperformanceblog.com/2010/11/29/data-corruption-drbd-and-story-of-bug/
http://bugs.mysql.com/bug.php?id=55981

root@test 06:52:04>CREATE TABLE t4(c1 int,c2 int,c3 MEDIUMBLOB,PRIMARY KEY(c1)) engine=innodb;
Query OK, 0 rows affected (0.01 sec)

root@test 06:52:05>insert into t4 values(1, 2, REPEAT('b', 54903));
Query OK, 1 row affected (0.04 sec)

root@test 06:52:12>start transaction;
Query OK, 0 rows affected (0.00 sec)

root@test 06:52:18>update t4 set c1 = 3;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0

root@test 06:52:24>rollback;
Query OK, 0 rows affected (0.01 sec)

root@test 06:52:30>start transaction;
Query OK, 0 rows affected (0.00 sec)

root@test 06:52:37>update t4 set c1 = 3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

root@test 06:52:41>rollback;
ERROR 2013 (HY000): Lost connection to MySQL server during query
悲剧了

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7591490/viewspace-1042379/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7591490/viewspace-1042379/