Bug #40133 sporadic pushbuild crash in embedded: read error in falcon_temporary.fts
Submitted: 18 Oct 2008 19:55 Modified: 26 May 2010 17:50
Reporter: Sven Sandberg Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version:6.0-rpl OS:Any
Assigned to: CPU Architecture:Any
Tags: crash, disk full, F_SHUTDOWN, falcon_temporary, pushbuild, sporadic, Tablespace, test failure

[18 Oct 2008 19:55] Sven Sandberg
Description:
This pushbuild failure happens in several tests in the main suite. xref only finds the error message in 5.1-rpl and 6.0-rpl. The bug may still exist in other trees, since 5.1-rpl and 6.0-rpl sometimes give useful error messages in the test output where other trees just give output in the "warnings" file, which xref can't find (cf. BUG#38741).

main.lock_tables_lost_commit             [ fail ]

CURRENT_TEST: main.lock_tables_lost_commit
InnoDB: The first specified data file /dev/shm/var-embedded-131/2/mysqld.1/data/ibdata1 did not exist:
InnoDB: a new database to be created!
080827 14:33:11  InnoDB: Setting file /dev/shm/var-embedded-131/2/mysqld.1/data/ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080827 14:33:11  InnoDB: Log file /dev/shm/var-embedded-131/2/mysqld.1/data/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /dev/shm/var-embedded-131/2/mysqld.1/data/ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080827 14:33:11  InnoDB: Log file /dev/shm/var-embedded-131/2/mysqld.1/data/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /dev/shm/var-embedded-131/2/mysqld.1/data/ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
[Falcon] Error: read error on page 0 of "falcon_temporary.fts": Bad file descriptor (9)
mysqltest got signal 6
read_command_buf at 0x12f0e20 = 
conn->name at 0x260b668 is an invalid pointer
conn->cur_query at (nil) is an invalid pointer
Attempting backtrace...
stack_bottom = (nil) thread_stack 0x40000
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(my_print_stacktrace+0x32)[0x650e78]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded[0x5f4d57]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded[0x5f4d83]
/lib64/libc.so.6[0x2b8d33bc8b20]
/lib64/libc.so.6(gsignal+0x35)[0x2b8d33bc8aa5]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN5Error10debugBreakEv+0xe)[0xa87e44]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN5Error5errorEPKcz+0x12f)[0xa87f75]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN2IO8readPageEP3Bdb+0xcb)[0xbbc2f5]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN5Cache9fetchPageEP3Dbbi8PageType8LockType+0x32a)[0xb74eae]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN3Dbb9fetchPageEi8PageType8LockType+0x4c)[0xb972c6]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN3Dbb8shutdownEj+0x46)[0xb97484]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN10TableSpace8shutdownEj+0x1f)[0xab6479]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN17TableSpaceManager8shutdownEj+0x29)[0xab4e03]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN8Database8shutdownEv+0x1e9)[0xb8c113]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN10Connection16shutdownDatabaseEv+0x57)[0xb8193d]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN15StorageDatabase5closeEv+0x56)[0xa96a8a]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN14StorageHandler15shutdownHandlerEv+0x98)[0xa9b060]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_ZN16StorageInterface5panicEP10handlerton17ha_panic_function+0x35)[0xa88b65]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_Z22ha_finalize_handlertonP13st_plugin_int+0x99)[0x961eb9]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded[0x6e8c14]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded[0x6e914f]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_Z15plugin_shutdownv+0x69)[0x6ebb15]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded[0x619a00]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(end_embedded_server+0x37)[0x619d5d]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(mysql_server_end+0x19)[0x60dc6f]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(_Z16free_used_memoryv+0x19c)[0x5f5f1e]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded[0x5f5f30]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(main+0xeb9)[0x602f8b]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x2b8d33bb6154]
/data0/pushbuild/pb/bzr_mysql-6.0-rpl/53/bzr_mysql-6.0-rpl-exp/libmysqld/examples/mysqltest_embedded(__gxx_personality_v0+0xb9)[0x5f2189]
terminate called after throwing an instance of 'SQLError'

 - saving '/dev/shm/var-embedded-131/2/log/main.lock_tables_lost_commit/' to '/dev/shm/var-embedded-131/log/main.lock_tables_lost_commit/'

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

How to repeat:
E.g., in main.lock_tables_lost_commit on https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=53 sapsrv1/embedded
xref: http://tinyurl.com/6s3j6n
[18 Oct 2008 20:23] Sven Sandberg
This looks similar to BUG#40114, BUG#40109, BUG#38970, and BUG#37779.
[12 May 2009 12:07] Vladislav Vaintroub
Unassigning myself. Kevin , please find a new owner.