Bug #53256 in a stress test, assert dict/dict0dict.c:815 table2 == NULL

• Submitted: 28 Apr 2010 15:47
• Modified: 14 Dec 2010 19:24
• Reporter: Mikhail Izioumtchenko
• Status: Closed
• Category: MySQL Server: InnoDB Plugin storage engine
• Severity: S2 (Serious)
• Version: mysql-5.1-innodb
• OS: Any
• Assigned to: Marko Mäkelä
• CPU Architecture: Any

[28 Apr 2010 15:47] Mikhail Izioumtchenko

Description:
assert dict/dict0dict.c:815  table2 == NULL in a stress test

How to repeat:
standard stress test

[29 Apr 2010 22:20] Mikhail Izioumtchenko

I think this assert is wrong when reached from row_merge_drop_temp_indexes()
because it would imply there is at most one temp index to drop,
per any table.
Indeed with a q&d workaround to avoid hitting the assert
I was able to recover the dataset and the resulting data passed 
CHECK TABLE.

[5 May 2010 11:24] 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/107495

[5 May 2010 11:24] 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/107496

[5 May 2010 11:25] Marko Mäkelä

Michael, does the patch fix it?

[5 May 2010 11:50] 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/107511

[5 May 2010 16: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/107558

[10 May 2010 15:40] Mikhail Izioumtchenko

the patch certainly fixes the bug. Marko, could you merge it to mysql-trunk-innodb

[31 May 2010 8:29] Bugs System

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

[15 Jun 2010 8:11] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100615080459-smuswd9ooeywcxuc) (version source revid:[e-mail]-20100511104500-c6kzd0bg5s42p8e9) (merge vers: 5.1.47) (pib:16)

[15 Jun 2010 8:27] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20100615080558-cw01bzdqr1bdmmec) (version source revid:[e-mail]-20100511104500-c6kzd0bg5s42p8e9) (pib:16)

[17 Jun 2010 6:14] Bugs System

Pushed into 5.5.5-m3 (revid:[e-mail]-20100615145247-8bj0vmuqlotbqsn9) (version source revid:[e-mail]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:16)

[17 Jun 2010 6:18] Bugs System

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

[1 Jul 2010 20:22] Ryan Mack

What is the q&d workaround of which you speak?

Thanks, Ryan

[1 Jul 2010 20:38] Mikhail Izioumtchenko

the q&d workaround was removing the assert in question.

[27 Jul 2010 20:22] John Russell

Internally generated bug, closing without adding to change log.

[14 Oct 2010 8:29] 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]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 8:43] 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]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)

[14 Oct 2010 8:58] 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]-20100513074652-0cvlhgkesgbb2bfh) (merge vers: 5.5.5-m3) (pib:21)