Comment 15 for bug 1086700

Revision history for this message
Teodor Milkov (tm-del) wrote :

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.