We are seing something very similar here with 5.5.29-rel29.4:
InnoDB: error in sec index entry update in
InnoDB: index "expire" of table "drupal"."cache_views"
InnoDB: tuple DATA TUPLE: 2 fields;
0: len 4; hex 80000000; asc ;;
1: len 13; hex 76696577735f646174613a656e; asc views_data:en;;
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 32
0: len 4; hex 80000000; asc ;;
1: len 30; hex 756e7061636b5f6f7074696f6e733a656265646361623631656562316138; asc unpack_options:ebedcab61eeb1a8; (total 50 bytes);
TRANSACTION 2AA58139, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
18 lock struct(s), heap size 1024, 50 row lock(s), undo log entries 40
MySQL thread id 249170, OS thread handle 0xb64ffb70, query id 58302445 localhost qpbonbou updating
DELETE FROM cache_views
InnoDB: Submit a detailed bug report to http://bugs.mysql.com
InnoDB: Warning: hash index ref_count (10) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "drupal/cache_field"
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_tablespace().
index: "expire" table: "drupal/cache_views"
InnoDB: Warning: hash index ref_count (3) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "drupal/cache"
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "drupal/cache_bootstrap"
...
Query (aa67380): SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('entity_info:en')
Unfortunatelly, I've no scriptable way to reproduce it, but with this somewhat heavy Drupal site, it crashes 3-4 times daily.
We are seing something very similar here with 5.5.29-rel29.4:
InnoDB: error in sec index entry update in ."cache_ views" 174613a656e; asc views_data:en;;
InnoDB: index "expire" of table "drupal"
InnoDB: tuple DATA TUPLE: 2 fields;
0: len 4; hex 80000000; asc ;;
1: len 13; hex 76696577735f646
InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 32 f7074696f6e733a 656265646361623 631656562316138 ; asc unpack_ options: ebedcab61eeb1a8 ; (total 50 bytes);
0: len 4; hex 80000000; asc ;;
1: len 30; hex 756e7061636b5f6
TRANSACTION 2AA58139, ACTIVE 0 sec updating or deleting
mysql tables in use 1, locked 1
18 lock struct(s), heap size 1024, 50 row lock(s), undo log entries 40
MySQL thread id 249170, OS thread handle 0xb64ffb70, query id 58302445 localhost qpbonbou updating
DELETE FROM cache_views
InnoDB: Submit a detailed bug report to http:// bugs.mysql. com tablespace( ). cache_field" tablespace( ). cache_views" tablespace( ). tablespace( ). cache_bootstrap "
InnoDB: Warning: hash index ref_count (10) is not zero after fil_discard_
index: "PRIMARY" table: "drupal/
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_
index: "expire" table: "drupal/
InnoDB: Warning: hash index ref_count (3) is not zero after fil_discard_
index: "PRIMARY" table: "drupal/cache"
InnoDB: Warning: hash index ref_count (1) is not zero after fil_discard_
index: "PRIMARY" table: "drupal/
...
Query (aa67380): SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN ('entity_info:en')
Unfortunatelly, I've no scriptable way to reproduce it, but with this somewhat heavy Drupal site, it crashes 3-4 times daily.