Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22229

InnoDB: error clustered record for sec rec not found

    XMLWordPrintable

Details

    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/

      Attachments

        Activity

          People

            Unassigned Unassigned
            harald Harald Hannelius
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.