Bug #42825 Falcon Exception: read error on page 1 of "": Bad file descriptor (9) on CHECK
Submitted: 13 Feb 2009 10:45 Modified: 1 Jan 2011 17:33
Reporter: Philip Stoev Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S1 (Critical)
Version:6.0-falcon-team OS:Any
Assigned to: CPU Architecture:Any

[13 Feb 2009 10:45] Philip Stoev 
Description:
When executing CHECK TABLE on a tablespace after recovery, Falcon crashed as follows:

# 14:54:36 Exception: read error on page 1 of "": Bad file descriptor (9)
# 14:54:36 terminate called after throwing an instance of 'SQLError'
# 14:54:36 090210 14:54:36 - mysqld got signal 6 ;

# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(IO::readPage(Bdb*)+0x153) [0x9ff90f]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(Cache::fetchPage(Dbb*, int, PageType, LockType)+0x3d9) [0x9b407d]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(Dbb::fetchPage(int, PageType, LockType)+0x4c) [0x9d9330]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(PageInventoryPage::validate(Dbb*, Validation*)+0x7a) [0xa1a578]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(Dbb::validate(int)+0x5d) [0x9d8a17]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(TableSpaceManager::validate(int)+0x57) [0x99906f]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(Database::validate(int)+0xb3) [0x9d1bed]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(Connection::validate(int)+0x2c) [0x9c2f22]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(StorageConnection::validate(int)+0x45) [0x9745c3]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(StorageInterface::check(THD*, st_ha_check_opt*)+0x65) [0x96a561]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(handler::ha_check(THD*, st_ha_check_opt*)+0xe3) [0x816e39]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld [0x84075d]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(mysql_check_table(THD*, TABLE_LIST*, st_ha_check_opt*)+0xb2) [0x8415ae]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(mysql_execute_command(THD*)+0x2b9d) [0x6d4a7b]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x273) [0x6da9d1]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0xa54) [0x6db5bc]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(do_command(THD*)+0x22b) [0x6dcae5]
# 14:54:36 /build/bzr/6.0-falcon-team/mysql-test/../sql/mysqld(handle_one_connection+0x11a) [0x6caab5]

How to repeat:
The tablespace will be uploaded shortly
[13 Feb 2009 11:03] Philip Stoev 
Unfortunately recovering again from the original tablespace did not cause the problem to appear once more.
[1 Jan 2011 17:33] Valeriy Kravchuk 
We do not work on Falcon storage engine any more.