Bug #40109 sporadic falcon assert in main.bootstrap on vm-win2003-64-b/embedded in 6.0-rpl
Submitted: 17 Oct 2008 15:22 Modified: 11 Nov 2008 17:43
Reporter: Sven Sandberg Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version:6.0-rpl OS:Any (vm-win2003-64b embedded)
Assigned to: CPU Architecture:Any
Tags: 6.0-rpl-green, bootstrap, embedded, F_PAGE IO, pushbuild, sporadic, test failure, windows

[17 Oct 2008 15:22] Sven Sandberg
Description:
Pushbuild failure, always in bootstrap on vm-win2003-64b/embedded in 6.0-rpl:

main.bootstrap                           [ fail ]

CURRENT_TEST: main.bootstrap
mysqltest: At line 32: command "$MYSQLD_BOOTSTRAP_CMD  < $MYSQLTEST_VARDIR/tmp/bootstrap_error.sql >> $MYSQLTEST_VARDIR/tmp/bootstrap.log 2>&1" succeeded - should have failed with errno 1...

The result from queries just before the failure was:
drop table if exists t1;
drop table t1;
mysqltest got exception 0x80000003
read_command_buf at 00000001401DA910=--exec $MYSQLD_BOOTSTRAP_CMD  < $MYSQLTEST_VARDIR/tmp/bootstrap_error.sql >> $MYSQLTEST_VARDIR/tmp/bootstrap.log 2>&1
conn->name at 00000000005DFC30=
conn->cur_query at 0000000000000000=
Attempting backtrace...
0000000078EF3320    ntdll.dll!DbgBreakPoint()
0000000180309529    LIBMYSQLD.dll!mysql_fetch_fields()
00000001803A6CD0    LIBMYSQLD.dll!mysql_num_rows()
0000000180375839    LIBMYSQLD.dll!mysql_ssl_set()
000000018030EA1D    LIBMYSQLD.dll!mysql_fetch_fields()
00000001803072D9    LIBMYSQLD.dll!mysql_fetch_fields()
00000001802F4483    LIBMYSQLD.dll!mysql_fetch_fields()
000000018028C628    LIBMYSQLD.dll!mysql_fetch_fields()
0000000180237ED6    LIBMYSQLD.dll!mysql_fetch_fields()
00000001800C7152    LIBMYSQLD.dll!mysql_stmt_affected_rows()
000000018005A84B    LIBMYSQLD.dll!mysql_debug()
000000018005B3D5    LIBMYSQLD.dll!mysql_debug()
00000001800349AA    LIBMYSQLD.dll!unpack_filename()
000000018001A6C2    LIBMYSQLD.dll!mysql_server_end()
0000000140003499    mysqltest_embedded.exe!free_used_memory()[mysqltest.cc:1130]
000000014000367C    mysqltest_embedded.exe!die()[mysqltest.cc:1201]
000000014000D16A    mysqltest_embedded.exe!do_exec()[mysqltest.cc:2637]
00000001400114C1    mysqltest_embedded.exe!main()[mysqltest.cc:7696]
000000014004C155    mysqltest_embedded.exe!__tmainCRTStartup()[crt0.c:327]
0000000077D5966C    kernel32.dll!BaseProcessStart()
[Falcon] Error: page 0/0 wrong page type, expected 1 got 0

mysqltest failed with unexpected return code 3

 - saving 'e:/var-embedded-102/log/main.bootstrap/' to 'e:/var-embedded-102/log/main.bootstrap/'

Retrying test, attempt(2/3)...

cygpath -m C:/cygwin/home/pushbuild/pb1/pb/bzr_mysql-6.0-rpl/80/mysql-6.0.8-alpha-pb80/libmysqld/examples/release/mysqltest_embedded.exe
cygpath -m e:/var-embedded-102/log/current_test

How to repeat:
E.g. here: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=80 vm-win2003-64-b/embedded
xref: http://tinyurl.com/62soz7
[17 Oct 2008 15:58] Sven Sandberg
See also BUG#40114
[11 Nov 2008 17:43] Kevin Lewis
Marking as a duplicate of Bug#39458 which is "Can't Repeat"

This bug seems to be complaining about
Test output match (LIKE):
    %Falcon% Error: page % wrong page type, expected
This pushbuild failure occurred regularly up until 2008-10-03 07:39:00
but has not occurred since.
 
Bug#39458 is now 'Can't Repeat' according to this comment;
[7 Oct 20:27] Ann Harrison
After the changes to the Cache::flush method were reverted, 
this problem no longer occurs.