[MDEV-14931] Upon failure to access tablespace InnoDB quickly issues 100 error messages and dies - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.1
Fix Version/s: 10.1
Component/s: Storage Engine - InnoDB
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.

Attachments

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-01-11 23:40

Updated:: 2018-01-11 23:40

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.