Bug #42835 falcon_bug_22165.test fails sporadically
Submitted: 13 Feb 2009 15:17 Modified: 13 Feb 2009 15:30
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0-TRUNK OS:Any
Assigned to: Vladislav Vaintroub CPU Architecture:Any
Tags: F_PAGE IO, pushbuild, sporadic, test failure

[13 Feb 2009 15:17] Alexander Nozdrin 
Description:
Symptoms:
---------------------------------
falcon.falcon_bug_22165                  [ fail ]
        Test ended at 2009-02-13 11:36:35

CURRENT_TEST: falcon.falcon_bug_22165
mysqltest: At line 65: query 'reap' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
CREATE PROCEDURE p1 ()
begin
declare v int default 0;
declare continue handler for sqlexception
begin
declare continue handler for sqlexception begin end;
ALTER TABLE t1 MODIFY COLUMN c timestamp;
end;
SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
while v < 10 do
START TRANSACTION;
INSERT INTO t1 (a, b) VALUES (v, 'a');
UPDATE t1 SET c = current_timestamp WHERE a = v;
IF (v < 5)  
THEN COMMIT;
ELSE ROLLBACK; 
END IF;
SET v = v + 1;
end while;
end//
-----------------------------

According to Wlad, this is most likely different issue
than Bug#35255 (which is already fixed).

How to repeat:
XRef: http://tinyurl.com/bhsrvq
[13 Feb 2009 15:30] Alexander Nozdrin 
That was a mistake -- Bug#35255 was not pushed.