Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
Description
Problem
|
================
|
The innodb will crash when master thread wants to evict an unused object.
|
The backtrace:
|
ut_ad(dict_index_is_clust(index))
|
row_merge_drop_indexes
|
dict_table_remove_from_cache_low
|
dict_make_room_in_cache ()
|
srv_master_evict_from_table_cache ()
|
srv_master_do_idle_tasks ()
|
srv_master_thread (arg=0x0)
|
start_thread (arg=0x2b21c8200700)
|
clone ()
|
|
Solution
|
================
|
The wrong position of judgement logic code about variable 'drop_aborted' in function
|
dict_table_close() may be the root cause.
|
We simply move this piece of codes prior to the decrement of
|
table->n_ref_count, thus aborted index will be discard when this table
|
is being closed.
|
https://github.com/alibaba/AliSQL/commit/58ebcbd5c8998a43e985223e665e5da331f5651c
Attachments
Issue Links
- duplicates
-
MDEV-13051 MySQL#86607 InnoDB crash after failed ADD INDEX and table_definition_cache eviction
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Epic Link | MDEV-11372 [ 59082 ] |
Link |
This issue duplicates |
issue.field.resolutiondate | 2019-04-30 06:43:37.0 | 2019-04-30 06:43:37.064 |
Component/s | Storage Engine - InnoDB [ 10129 ] | |
Component/s | Storage Engine - XtraDB [ 10135 ] | |
Fix Version/s | 10.3.3 [ 22644 ] | |
Fix Version/s | 10.2.10 [ 22615 ] | |
Fix Version/s | 10.1.29 [ 22636 ] | |
Fix Version/s | 10.0.33 [ 22552 ] | |
Assignee | Marko Mäkelä [ marko ] | |
Resolution | Duplicate [ 3 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 93557 ] | MariaDB v4 [ 133897 ] |
This appears to be a duplicate of
MDEV-13051.The Description looks exactly the same as in MySQL Bug #86607, which is what I fixed in
MDEV-13051together with the original reporter jianwei zhao.