Bug #36310 InnoDB plugin crash

• Submitted: 24 Apr 2008 6:11
• Modified: 18 Jun 2010 23:05
• Reporter: Venu Anuganti
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S2 (Serious)
• Version: innodb_plugin-1.0.0
• OS: Any
• Assigned to: Vasil Dimov
• CPU Architecture: Any
• Tags: InnoDB plugin, MySQL 5.1

[24 Apr 2008 6:11] Venu Anuganti

Description:
InnoDB seems to crash when one starts the 5.1.24 server with one of the un-supported InnoDB options and querying on the Information Schema plugins.

How to repeat:
1. Build the 5.1.24 server with InnoDB plugin (either with --with-innodb or --with-plugin-innodb or start and load all InnoDB plugins and stop the server)
2. Restart server by adding innodb_flush_method=fdatasync
3. Query Information_schema.locks

For more information on steps, check:
http://venublog.com/2008/04/23/simple-way-to-crash-innodb-plugin-10/

Suggested fix:
It looks like InnoDB needs to have dependency on the main plugin when it is loading the information schema plugins or at least it should have validation checks up on querying the information schema tables for the main plugin. I will file a bug report on this

[24 Apr 2008 14:17] Vasil Dimov

Hi,

I am coining a solution for this right now...

I_S plugins should refuse to start if the "main" innodb storage engine plugin is not loaded.

[29 Apr 2008 15:30] Vasil Dimov

Patch for this is ready - I_S plugins should not start if the main InnoDB storage engine is not started.

I found http://bugs.mysql.com/36399 while working on this.

[29 Apr 2008 15:39] Vasil Dimov

Patch committed. Will be present in the next plugin version.

[29 Apr 2008 15:42] Venu Anuganti

Thanks for the immediate attention on the bug, we appreciate that.

[21 May 2008 20:05] Calvin Sun

The fix is in 1.0.1 release.

[5 May 2010 15:18] Bugs System

Pushed into 5.1.47 (revid:[e-mail]-20100505145753-ivlt4hclbrjy8eye) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[6 May 2010 14:58] Paul DuBois

Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.

[28 May 2010 6:02] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100524190136-egaq7e8zgkwb9aqi) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (pib:16)

[28 May 2010 6:31] Bugs System

Pushed into 6.0.14-alpha (revid:[e-mail]-20100524190941-nuudpx60if25wsvx) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[28 May 2010 6:59] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100524185725-c8k5q7v60i5nix3t) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[29 May 2010 15:20] Paul DuBois

Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.

[17 Jun 2010 12:06] Bugs System

Pushed into 5.1.47-ndb-7.0.16 (revid:[e-mail]-20100617114014-bva0dy24yyd67697) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 12:52] Bugs System

Pushed into 5.1.47-ndb-6.2.19 (revid:[e-mail]-20100617115448-idrbic6gbki37h1c) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)

[17 Jun 2010 13:34] Bugs System

Pushed into 5.1.47-ndb-6.3.35 (revid:[e-mail]-20100617114611-61aqbb52j752y116) (version source revid:[e-mail]-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)