[MDEV-14931] Upon failure to access tablespace InnoDB quickly issues 100 error messages and dies Created: 2018-01-11  Updated: 2018-01-11

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.1
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 0
Labels: None


 Description    

Version: '10.1.31-MariaDB-debug'  socket: '/home/travis/logs/current1_1/mysql.sock'  port: 19300  Source distribution
 
2018-01-10 20:13:31 7ff78831bb00 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Trying to access tablespace [space=8: page=1581] but the tablespace does not exist or is just being dropped.
 
2018-01-10 20:14:07 140700603623168 [ERROR] InnoDB: Unable to read tablespace 8 page no 1581 into the buffer pool after 100 attempts. The most probable cause of this error may be that the table has been corrupted. You can try to fix this problem by using innodb_force_recovery. Please see http://dev.mysql.com/doc/refman/5.6/en/ for more details. Aborting...
 
2018-01-10 20:14:07 7ff7697fa700  InnoDB: Assertion failure in thread 140700603623168 in file ha_innodb.cc line 22004
 
InnoDB: We intentionally generate a memory trap.

As discussed, maybe there is a better way to handle this – less messages in the error log, more delay between attempts, etc.
Generated at Thu Feb 08 08:17:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.