MySQL Bugs: #57896: Incorrect check of schema version in LQH

Bug #57896	Incorrect check of schema version in LQH
Submitted:	1 Nov 2010 14:19	Modified:	5 Nov 2010 22:31
Reporter:	Jonas Oreland	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-6.3	OS:	Any
Assigned to:	Jonas Oreland	CPU Architecture:	Any

Description:
LQH's check of major schema version is incorrect, and does not take into account
no of bits passed in LQHKEYREQ in only 16.

Can lead to error 1227 when doing key operations

How to repeat:
run create/drop 65537 times on 1 table,
then try to insert into it

Suggested fix:
.

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/122448

3331 jonas oreland	2010-11-01
      ndb - bug#57896 - LQHKEYREQ only contains 16-bit schema version

Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.39 (revid:jonas@mysql.com-20101101154450-c1sbv0n5lyfig041) (version source revid:jonas@mysql.com-20101101154450-c1sbv0n5lyfig041) (merge vers: 5.1.51-ndb-6.3.39) (pib:21)

Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.20 (revid:jonas@mysql.com-20101101161110-luebipotbx2zhel5) (version source revid:jonas@mysql.com-20101101161110-luebipotbx2zhel5) (merge vers: 5.1.51-ndb-7.0.20) (pib:21)

bug#57897 could also cause this

Pushed to 6.3.39, 7.0.20 and 7.1.9

Documented fix in the NDB-6.3.39, 7.0.20, and 7.1.9 changelogs as follows:

        The LQHKEYREQ request message used by the local query handler
        when checking the major schema version of a table, being only 16
        bits wide, could cause this check to fail with an Invalid schema
        version error (error code 1227). This issue was made to occur in
        tests by creating, dropping, and re-creating the same table
        65537 times, then trying to insert into the table.

Closed.