mysql bug 55981

blob bug

[@more@]

http://www.mysqlperformanceblog.com/2010/11/29/data-corruption-drbd-and-story-of-bug/

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)

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

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

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

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

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

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

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