lp://staging/~stewart/drizzle/update-innobase-1.0.10

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

2197. By Karen Langford on 2010-11-10

Merge Revision revid:<email address hidden> from MySQL InnoDB

Original revid:<email address hidden>

Original Authors: <email address hidden>
Original commit message:
Fix bug #55039 Failing assertion: space_id > 0 in fil0fil.c.

2196. By Sunny Bains on 2010-11-10

Merge Revision revid:<email address hidden> from MySQL InnoDB

Original revid:<email address hidden>

Original Authors: Sunny Bains <email address hidden>
Original commit message:
Fix bug#54583. This change reverses rsvn:1350 by getting rid of a bogus assertion
and clarifies the invariant in dict_table_get_on_id().

In Mar 2007 Marko observed a crash during recovery, the crash resulted from
an UNDO operation on a system table. His solution was to acquire an X lock on
the data dictionary, this in hindsight was an overkill. It is unclear what
caused the crash, current hypothesis is that it was a memory corruption.

The X lock results in performance issues by when undoing changes due to
rollback during normal operation on regular tables.

Why the change is safe:
======================
The InnoDB code has changed since the original X lock change was made. In the
new code we always lock the data dictionary in X mode during startup when
UNDOing operations on the system tables (this is a given). This ensures that
the crash Marko observed cannot happen as long as all transactions that update
the system tables follow the standard rules by setting the appropriate DICT_OP
flag when writing the log records when they make the changes.

If transactions violate the above mentioned rule then during recovery (at
startup) the rollback code (see trx0roll.c) will not acquire the X lock
and we will see the crash again. This will however be a different bug.

2195. By Inaam Rana <email address hidden> on 2010-11-10

Merge Revision revid:<email address hidden> from MySQL InnoDB

Original revid:<email address hidden>

Original Authors: Inaam Rana <email address hidden>
Original commit message:
Add ChangeLog for bug#39168

2194. By Marko Mäkelä <email address hidden> on 2010-11-10

Merge Revision revid:<email address hidden> from MySQL InnoDB

Original revid:<email address hidden>

Original Authors: Marko Mäkelä <email address hidden>
Original commit message:
Add ChangeLog entry for Bug#54679

2193. By jimmy on 2010-11-10

Merge Revision revid:<email address hidden> from MySQL InnoDB

Original revid:<email address hidden>

Original Authors: Jimmy Yang <email address hidden>
Original commit message:
Port fix for "bug #54044 Create temporary tables and using innodb crashes"
to 5.1 plugin codeline.

rb://378, approved by Marko

2192. By jimmy on 2010-11-10

Merge Revision revid:<email address hidden> from MySQL InnoDB

Original revid:<email address hidden>

Original Authors: Jimmy Yang <email address hidden>
Original commit message:
Fix bug #54044, Create temporary tables and using innodb crashes. Screen
out NULL type columns, and return without creating the table.

rb://378 approved by Marko

2191. By Stewart Smith on 2010-11-10

merge bug fix for CREATE TABLE with column of type NULL

2190. By Stewart Smith on 2010-11-10

merge innobase 1.0.9 build fixes

2189. By Stewart Smith on 2010-11-10

fix patch for Fix Bug#54686: 'field->col->mtype == type' assertion error at row/row0sel.c

2188. By Stewart Smith on 2010-11-10

add innodb test case that was missing