Bug #42825 Falcon Exception: read error on page 1 of "": Bad file descriptor (9) on CHECK
Submitted: 13 Feb 11:45
Reporter: Philip Stoev
Status: Analyzing
Category:Server: Falcon Severity:S1 (Critical)
Version:6.0-falcon-team OS:Any
Assigned to: Target Version:

[13 Feb 11: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 12:03] Philip Stoev
Unfortunately recovering again from the original tablespace did not cause the problem to
appear once more.