MySQL Bugs: #72986: Add debug check for tablespace match in the adaptive hash index

Bug #72986	Add debug check for tablespace match in the adaptive hash index
Submitted:	12 Jun 2014 10:09	Modified:	12 Jun 2014 12:15
Reporter:	Marko Mäkelä	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.7.5	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The InnoDB adaptive hash index is lacking debug assertions for checking that the tablespace ID in the buffer blocks matches index->space.

How to repeat:
Read the code.

Suggested fix:
Add assertions like this:

	ut_ad(block->page.id.space() == index->space);

Move the bpage->id.reset() call from buf_LRU_block_remove_hashed() to buf_LRU_block_free_hashed_page(), so that the space_id will be valid when dropping the adaptive hash index when a page is being evicted.

Fixed as of the upcoming 5.7.5 release, and here's the changelog entry:

Added debug assertions to the adaptive hash index code to check that the
tablespace ID in buffer blocks match the index space. 

Thank you for the bug report.