Bug #32697 falcon_bug_26433.test fails randomly
Submitted: 25 Nov 2007 12:55
Reporter: Ingo Strüwing
Status: Verified
Category:Tests: Engine Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: Target Version:
Tags: pbfail
Triage: D3 (Medium)

[25 Nov 2007 12:55] Ingo Strüwing
Description:
falcon.falcon_bug_26433        [ fail ]

==5164== Memcheck, a memory error detector.
==5164== Copyright (C) 2002-2007, and GNU GPL'd, by Julian Seward et al.
==5164== Using LibVEX rev 1732, a library for dynamic binary translation.
==5164== Copyright (C) 2004-2007, and GNU GPL'd, by OpenWorks LLP.
==5164== Using valgrind-3.2.3, a dynamic binary instrumentation framework.
==5164== Copyright (C) 2000-2007, and GNU GPL'd, by Julian Seward et al.
==5164== For more details, rerun with: -v
==5164== 
mysqltest: At line 82: query 'CALL p1()' failed: 1025: Error on rename of './test/t1' to
'./test/#sql2-681f-4b' (errno: -2)

The result from queries just before the failure was:
< snip >
ALTER TABLE t1 MODIFY COLUMN c varchar(500) character set latin2;
END IF;
SET v = v + 1;
END WHILE;
END//
CALL p1()//
a
a
b
b
c
c
d
d
error, probably 1025
error, probably 1025
1
1
2
2

More results from queries before failure can be found in
/dev/shm/var-falcon-101/log/falcon_bug_26433.log

Warnings from just before the error:
Warning 1265 Data truncated for column 'b' at row 20 
Warning 1265 Data truncated for column 'b' at row 21 
Warning 1265 Data truncated for column 'b' at row 22 
Warning 1265 Data truncated for column 'b' at row 23 
Warning 1265 Data truncated for column 'b' at row 24 
Warning 1265 Data truncated for column 'b' at row 25 
Warning 1265 Data truncated for column 'b' at row 26 
Warning 1265 Data truncated for column 'b' at row 27 
Warning 1265 Data truncated for column 'b' at row 28 
Warning 1265 Data truncated for column 'b' at row 29 
Warning 1265 Data truncated for column 'b' at row 30 
Warning 1265 Data truncated for column 'b' at row 31 
Warning 1265 Data truncated for column 'b' at row 32 
Warning 1265 Data truncated for column 'b' at row 33 
Warning 1265 Data truncated for column 'b' at row 34 
Warning 1265 Data truncated for column 'b' at row 35 
Warning 1265 Data truncated for column 'b' at row 36 
Warning 1265 Data truncated for column 'b' at row 37 
Warning 1265 Data truncated for column 'b' at row 38 
Warning 1265 Data truncated for column 'b' at row 39 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
1 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
2 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
3 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
4 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
5 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
6 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
7 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
8 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
9 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
10 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
11 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
12 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
13 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
14 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
15 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
16 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
17 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
18 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
19 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
20 
Warning 1265 Data truncated for column 'b' at row 20 
Warning 1265 Data truncated for column 'b' at row 21 
Warning 1265 Data truncated for column 'b' at row 22 
Warning 1265 Data truncated for column 'b' at row 23 
Warning 1265 Data truncated for column 'b' at row 24 
Warning 1265 Data truncated for column 'b' at row 25 
Warning 1265 Data truncated for column 'b' at row 26 
Warning 1265 Data truncated for column 'b' at row 27 
Warning 1265 Data truncated for column 'b' at row 28 
Warning 1265 Data truncated for column 'b' at row 29 
Warning 1265 Data truncated for column 'b' at row 30 
Warning 1265 Data truncated for column 'b' at row 31 
Warning 1265 Data truncated for column 'b' at row 32 
Warning 1265 Data truncated for column 'b' at row 33 
Warning 1265 Data truncated for column 'b' at row 34 
Warning 1265 Data truncated for column 'b' at row 35 
Warning 1265 Data truncated for column 'b' at row 36 
Warning 1265 Data truncated for column 'b' at row 37 
Warning 1265 Data truncated for column 'b' at row 38 
Warning 1265 Data truncated for column 'b' at row 39 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
1 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
2 
Warning 1366 Incorrect string value: '\x92\x92\x92\x92\x92\x92...' for column 'c' at row
3 
==5164== 
==5164== ERROR SUMMARY: 0 errors from 0 contexts (suppressed: 3 from 1)
==5164== malloc/free: in use at exit: 256 bytes in 1 blocks.
==5164== malloc/free: 469 allocs, 468 frees, 257,522 bytes allocated.
==5164== For counts of detected errors, rerun with: -v
==5164== searching for pointers to 1 not-freed blocks.
==5164== checked 1,306,360 bytes.
==5164== 
==5164== LEAK SUMMARY:
==5164==    definitely lost: 0 bytes in 0 blocks.
==5164==      possibly lost: 0 bytes in 0 blocks.
==5164==    still reachable: 256 bytes in 1 blocks.
==5164==         suppressed: 0 bytes in 0 blocks.
==5164== Reachable blocks (those to which a pointer was found) are not shown.
==5164== To see them, rerun with: --leak-check=full --show-reachable=yes

Stopping All Servers

Disabling the test case. Please re-enable after fix.

How to repeat:
See pushbuild, for example
https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-6.0-engines
log
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-engines&entry=istruewi...
See also
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[28 Nov 2007 11:24] Bugs System
Pushed into 6.0.4-alpha