Bug #53578 assert on invalid page access, in fil_io()

• Submitted: 11 May 2010 17:28
• Modified: 14 Oct 2010 15:17
• Reporter: Mikhail Izioumtchenko
• Status: Closed
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S2 (Serious)
• Version: 1.0,1.1
• OS: Any
• Assigned to: Marko Mäkelä
• CPU Architecture: Any

[11 May 2010 17:28] Mikhail Izioumtchenko

Description:
after a server crash, InnoDB eventually asserts in fil_io() complaining about accessing a page outside of the known limits of the tablespace.

How to repeat:
very hard to reproduce and extremely unlikely to happen in a customer
environment, but it does happen in my stress and recovery testing.

[24 May 2010 11:04] Jimmy Yang

Ok to push.

[24 May 2010 11:05] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109035

[24 May 2010 11:05] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109036

[24 May 2010 11:44] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109043

[24 May 2010 11:45] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109045

[24 May 2010 11:45] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109046

[24 May 2010 15:45] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/109079

[31 May 2010 8:29] Bugs System

Pushed into 5.1.48 (revid:[e-mail]-20100531082307-9x08gg1g7zybx2jy) (version source revid:[e-mail]-20100531082307-9x08gg1g7zybx2jy) (merge vers: 5.1.48) (pib:16)

[17 Jun 2010 6:13] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100615145247-8bj0vmuqlotbqsn9) (version source revid:[e-mail]-20100524110439-fazi70rlmt07tzd9) (merge vers: 5.1.48) (pib:16)

[17 Jun 2010 6:17] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100615150216-cubqoyn1fj9b6a2p) (version source revid:[e-mail]-20100524110439-fazi70rlmt07tzd9) (pib:16)

[21 Jun 2010 8:49] Marko Mäkelä

There is a slight bug in the bug fix: Bug #54658 "InnoDB: Warning: allocated tablespace %lu, old maximum was 0"

[27 Jul 2010 20:23] John Russell

Internally generated bug, closing without adding to change log.

[14 Oct 2010 8:31] Bugs System

Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:[e-mail]-20101014082627-jrmy9xbfbtrebw3c) (version source revid:[e-mail]-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 8:47] Bugs System

Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:[e-mail]-20101014083757-5qo48b86d69zjvzj) (version source revid:[e-mail]-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 9:01] Bugs System

Pushed into mysql-5.1-telco-6.2 5.1.51-ndb-6.2.19 (revid:[e-mail]-20101014084420-y54ecj85j5we27oa) (version source revid:[e-mail]-20100531152341-x2d4hma644icamh1) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 15:17] Jon Stephens

Setting back to Closed state. See previous comments.