# InnoDB: error clustered record for sec rec not found

**URL:** <https://forums.percona.com/t/innodb-error-clustered-record-for-sec-rec-not-found/1971>\
**Category:** Other MySQL® Questions\
**Created:** [January 21, 2013, 8:04am UTC](https://forums.percona.com/t/innodb-error-clustered-record-for-sec-rec-not-found/1971 "2013-01-21T08:04:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![chlor](https://avatars.discourse-cdn.com/v4/letter/c/d2c977/32.png) [@chlor](https://forums.percona.com/u/chlor)\
**Post date:** [January 21, 2013, 8:04am UTC](https://forums.percona.com/t/innodb-error-clustered-record-for-sec-rec-not-found/1971/1 "2013-01-21T08:04:45Z")

</div>

Hi

I got a lot of the following error in syslog. The database is still running but these messages looks rather bad.

I might to post this error on [bugs.mysql.com](http://bugs.mysql.com) but as Im running percona-server 5.5.28-rel29.2-360.squeeze Im not really sure.

Hardware and system is 16 cores 64GB RAM amd64.

Jan 20 12:23:01 rontgen mysqld: 130120 12:23:01 InnoDB: error clustered record for sec rec not found  
Jan 20 12:23:01 rontgen mysqld: InnoDB: index `cache_id` of table `someDatabase`.`tx_extbase_cache_object`  
Jan 20 12:23:01 rontgen mysqld: InnoDB: sec index record PHYSICAL RECORD: n\_fields 2; compact format; info bits 0  
Jan 20 12:23:01 rontgen mysqld: 0: len 30; hex 54785f457874626173655f56616c69646174696f6e5f56616c696461746f ; asc Tx\_Extbase\_Validation\_Validato; (total 39 bytes);  
Jan 20 12:23:01 rontgen mysqld: 1: len 4; hex 000014aa; asc ;;  
Jan 20 12:23:01 rontgen mysqld:  
Jan 20 12:23:01 rontgen mysqld: InnoDB: clust index record PHYSICAL RECORD: n\_fields 8; compact format; info bits 0  
Jan 20 12:23:01 rontgen mysqld: 0: len 4; hex 000014a9; asc ;;  
Jan 20 12:23:01 rontgen mysqld: 1: len 6; hex 0000929ca119; asc ;;  
Jan 20 12:23:01 rontgen mysqld: 2: len 7; hex fe000003b30110; asc ;;  
Jan 20 12:23:01 rontgen mysqld: 3: len 26; hex 54785f457874626173655f50726f70657274795f4d6170706572; asc Tx\_Extbase\_Property\_Mapper;;  
Jan 20 12:23:01 rontgen mysqld: 4: len 4; hex 50fbd35a; asc P Z;;  
Jan 20 12:23:01 rontgen mysqld: 5: len 30; hex 4f3a33373a2254785f457874626173655f4f626a6563745f436f6e746169 ; asc O:37:"Tx\_Extbase\_Object\_Contai; (total 563 bytes);  
Jan 20 12:23:01 rontgen mysqld: 6: SQL NULL;  
Jan 20 12:23:01 rontgen mysqld: 7: len 4; hex 00000e10; asc ;;  
Jan 20 12:23:01 rontgen mysqld:  
Jan 20 12:23:01 rontgen mysqld: TRANSACTION 929D20C3, ACTIVE 0 sec starting index read  
Jan 20 12:23:01 rontgen mysqld: mysql tables in use 1, locked 0  
Jan 20 12:23:01 rontgen mysqld: MySQL thread id 176813, OS thread handle 0x7f6b20d78700, query id 264139443 [papin.example.com](http://papin.example.com) 192.168.4.54 someDatabase Sending data  
Jan 20 12:23:01 rontgen mysqld: SELECT COUNT(\*) FROM tx\_extbase\_cache\_object WHERE identifier = ‘Tx\_Extbase\_Validation\_ValidatorResolver’ AND (crdate + lifetime \>= 1358680981 OR lifetime = 0)  
Jan 20 12:23:01 rontgen mysqld:  
Jan 20 12:23:01 rontgen mysqld: InnoDB: Submit a detailed bug report to hppt://bugs.mysql.com

On the same server there have been a lot of errors like:

Jan 20 21:45:10 rontgen mysqld: InnoDB: Warning: hash index  
ref\_count (1) is not zero after fil\_discard\_tablespace().

Any help much appreciated.

best regards  
Hans