Bug #58623 Bogus debug assertion failure in i_s_locks_row_validate()

• Submitted: 1 Dec 2010 8:01
• Modified: 11 Jan 2011 0:48
• Reporter: Marko Mäkelä
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.1 plugin, 5.5+
• OS: Any
• Assigned to: Marko Mäkelä
• CPU Architecture: Any
• Tags: debug

[1 Dec 2010 8:01] Marko Mäkelä

Description:
The fix of Bug #57802 introduced a bogus assertion failure. If buf_page_try_get() returns NULL fill_lock_data(), row->lock_data will be NULL for a record lock.

How to repeat:
1. In a debug server, run an I/O bound workload where some data pages of active record locks are forced out of the buffer pool.
2. select * from information_schema.innodb_trx;

Suggested fix:
Remove the assertion ut_ad(row->lock_data != NULL);

[1 Dec 2010 8:04] 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/125605

[1 Dec 2010 8:04] 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/125606

[22 Dec 2010 21:31] Bugs System

Pushed into mysql-trunk 5.6.1 (revid:[e-mail]-20101222212842-y0t3ibtd32wd9qaw) (version source revid:[e-mail]-20101222212842-y0t3ibtd32wd9qaw) (merge vers: 5.6.1) (pib:24)

[8 Jan 2011 15:09] Bugs System

Pushed into mysql-5.5 5.5.9 (revid:[e-mail]-20110108150508-gpanhz48z8069qot) (version source revid:[e-mail]-20110108150048-b1y9m8xe72hay0ch) (merge vers: 5.5.9) (pib:24)

[8 Jan 2011 15:12] Bugs System

Pushed into mysql-5.1 5.1.55 (revid:[e-mail]-20110108145923-0tjqdpa5w3d6tuwn) (version source revid:[e-mail]-20110108145923-0tjqdpa5w3d6tuwn) (merge vers: 5.1.55) (pib:24)