Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
-
None
Description
I have gigabytes of syslog filled with this;
Apr 13 07:02:06 penti mysqld[18227]: 2020-04-13 07:02:06 7fffd95a4700 InnoDB: error clustered record for sec rec not found
Apr 13 07:02:06 penti mysqld[18227]: InnoDB: index `exptime` of table `fe83wiki`.`objectcache`
Apr 13 07:02:06 penti mysqld[18227]: InnoDB: sec index record PHYSICAL RECORD: n_fields 2; compact format; info bits 0
Apr 13 07:02:06 penti mysqld[18227]: 0: len 8; hex 8000125f46646f73; asc _Fdos;;
Apr 13 07:02:06 penti mysqld[18227]: 1: len 30; hex 6665383377696b693a7063616368653a6964686173683a313639362d3021; asc fe83wiki:pcache:idhash:1696-0!; (total 39 bytes);
Apr 13 07:02:06 penti mysqld[18227]: InnoDB: clust index record PHYSICAL RECORD: n_fields 5; compact format; info bits 0
Apr 13 07:02:06 penti mysqld[18227]: 0: len 30; hex 6665383377696b693a7063616368653a6964686173683a313639352d3021; asc fe83wiki:pcache:idhash:1695-0!; (total 39 bytes);
Apr 13 07:02:06 penti mysqld[18227]: 1: len 6; hex 000017c750ec; asc P ;;
Apr 13 07:02:06 penti mysqld[18227]: 2: len 7; hex f700003db30110; asc = ;;
Apr 13 07:02:06 penti mysqld[18227]: 3: len 30; hex a5576d6edb3810ed6f9f8215506017a8637d388e23a7018a346ddc4d6223; asc Wmn 8 o P` c}8 # 4m Mb#; (total 1388 bytes);
Apr 13 07:02:06 penti mysqld[18227]: 4: len 8; hex 8000125f46720bd3; asc _Fr ;;
Apr 13 07:02:06 penti mysqld[18227]: TRANSACTION 429396372, ACTIVE 0 sec fetching rows
Apr 13 07:02:06 penti mysqld[18227]: mysql tables in use 1, locked 0
Apr 13 07:02:06 penti mysqld[18227]: MySQL thread id 327619, OS thread handle 0x7fffd95a4700, query id 262128533 localhost fe83wiki Sending data
Apr 13 07:02:06 penti mysqld[18227]: SELECT /* SqlBagOStuff::deleteObjectsExpiringBefore */ keyname,exptime FROM `objectcache` WHERE (exptime < '20200413035828') AND (exptime >= '2020-04-11 18:55:48') ORDER BY
exptime LIMIT 100
Apr 13 07:02:06 penti mysqld[18227]: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/