Bug #86257 Error log: Got error 155 when reading table

• Submitted: 10 May 2017 5:53
• Modified: 10 May 2017 9:58
• Reporter: Roel Van de Paar
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S1 (Critical)
• Version: 5.7.17, 5.7.18
• OS: Any
• CPU Architecture: Any

[10 May 2017 5:53] Roel Van de Paar

Description:
mysql> SELECT hex(c1),hex(c2) FROM t1 ORDER BY c1 DESC;
ERROR 1814 (HY000): Tablespace has been discarded for table 't1'

Looks fine. However, the error log shows;

2017-05-10T05:28:08.551990Z 3 [ERROR] Got error 155 when reading table './test/t1'

How to repeat:
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 YEAR KEY,c2 INT,c3 BINARY);
ALTER TABLE t1 DISCARD TABLESPACE;
SELECT hex(c1),hex(c2) FROM t1 ORDER BY c1 DESC;

[10 May 2017 9:58] MySQL Verification Team

Hello Roel,

Thank you for the report and test case.

Thanks,
Umesh