MySQL Bugs: #39396: Maria: ha_maria.cc:2415: assertion in ha_maria::store

Bug #39396	Maria: ha_maria.cc:2415: assertion in ha_maria::store_lock()
Submitted:	11 Sep 2008 13:54	Modified:	7 Mar 2010 18:20
Reporter:	Guilhem Bichot	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Maria storage engine	Severity:	S3 (Non-critical)
Version:	6.0-bzr	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Happens with
./mtr --mem --mysqld=--default-storage-engine=maria multi_update  

How to repeat:
see description

I can't repeat this with the mysql-6.0-maria tree, so I have to assume this bug has either been fixed in mysql-maria or it was fixed as part of the mysql-maria -> mysql-6.0-maria merge.

It should be fixed in MySQL-6.0 when we merge the MySQL-6.0-maria tree into 6.0, which is sheduled to happen very soon.

Found a way to repeat it; It's a timing issue when table locks fails in MySQL

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

2747 Michael Widenius	2008-10-23
      Fix for Bug#39396 Maria: ha_maria.cc:2415: assertion in ha_maria::store_lock()
      - Problem was wrong cleanup of mysql_lock_tables() in MySQL 6.0
      Fixed bug in my_vsnprintf in handling of %lld and %llu
      Removed warnings about usage of depricated mysqld options in mysql-test-run

The problem was a bug in how aborting of locks was handled in mysql_lock_tables() that was introduced during a recent "code cleanup".
The bug affects any storage engine; The reason it failed in Maria was because Maria has more asserts than a normal storage engine to ensure that it's called properly.
Now pushed into MySQL-6.0-maria. Will be fixed in 6.0 as soon as MySQL-6.0-maria is merged to MySQL-6.0.

Pushed into 6.0.8-alpha  (revid:monty@mysql.com-20081023162952-ugd9u9vcecvfi5fa) (version source revid:monty@mysql.com-20081023162952-ugd9u9vcecvfi5fa) (pib:5)

Internal only. No documentation needed.

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

3026 Konstantin Osipov	2009-12-10
      Backport a part of Monty's fix for Bug#39396, rev. 2736.2.11 
      "ha_maria.cc:2415: assertion in ha_maria::store_lock()".
     @ sql/lock.cc
        Fixed wrong cleanup of mysql_lock_tables()
        - We must call read_lock_data() BEFORE we set 
        lock_count to 0. Added DBUG statements.

Pushed into 6.0.14-alpha (revid:alik@sun.com-20100216101445-2ofzkh48aq2e0e8o) (version source revid:kostja@sun.com-20091211154405-c9yhiewr9o5d20rq) (merge vers: 6.0.14-alpha) (pib:16)

Pushed into mysql-next-mr (revid:alik@sun.com-20100216101208-33qkfwdr0tep3pf2) (version source revid:kostja@sun.com-20091210133803-i4wux7npwaa6n3do) (pib:16)

Pushed into 5.5.3-m3 (revid:alik@sun.com-20100306103849-hha31z2enhh7jwt3) (version source revid:vvaintroub@mysql.com-20100216221947-luyhph0txl2c5tc8) (merge vers: 5.5.99-m3) (pib:16)

No documentation needed.