Endless loop after innodb_adaptive_hash_index is turned off
Bug #1157007 reported by
林晓斌
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Invalid
|
Undecided
|
Unassigned | ||
5.1 |
Won't Fix
|
High
|
Unassigned | ||
5.5 |
Triaged
|
High
|
Unassigned | ||
5.6 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
When set innodb_
After set innodb_
Repeat :
set innodb_
innodb_
source
http://
suggest fix:
set block->
summary: |
- endless loop after turning of innodb_adaptive_hash_index + Endless loop after innodb_adaptive_hash_index is turned off |
To post a comment you must log in.
I am able to confirm the issue and it seems to be stuck in one of drop_page_ hash_index.
those retry loops in btr_search_
Along with suggested fix, it may also be better to check if
btr_search_enabled is true in btr_free_root before dropping the
page hash index.
Note, both the size of buffer pool and number of partitions
matter for reproduction. For larger buffer pools, you need to
load it significantly more.
I have got the backtraces as well which I will attach in the next
comment.