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

InnoDB: error clustered record for sec rec not found

    XMLWordPrintable

Details

    Description

      I have an oldish version of mediawiki using database FFdb (fixforwarding.org), which apparently works, but I get lots of logs like the following:

      Aug 25 12:52:50 27 north mysqld: 2019-08-25 12:52:50 7f41a5899700 InnoDB: error clustered record for sec rec not found
      Aug 25 12:52:50 27 north mysqld: InnoDB: index `lc_lang_key` of table `FFdb`.`wiki_l10n_cache`
      Aug 25 12:52:50 27 north mysqld: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
      Aug 25 12:52:50 27 north mysqld: 0: len 2; hex 656e; asc en;;
      Aug 25 12:52:50 27 north mysqld: 1: len 17; hex 6d657373616765733a6665627275617279; asc messages:february;;
      Aug 25 12:52:50 27 north mysqld: 2: len 6; hex 000000013947; asc 9G;;
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0
      Aug 25 12:52:50 27 north mysqld: 0: len 8; hex 696e66696d756d00; asc infimum ;;
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: TRANSACTION 5290797, ACTIVE 0 sec starting index read
      Aug 25 12:52:50 27 north mysqld: mysql tables in use 1, locked 0
      Aug 25 12:52:50 27 north mysqld: MySQL thread id 29218, OS thread handle 0x7f41a5899700, query id 1223596 localhost ale Sending data
      Aug 25 12:52:50 27 north mysqld: SELECT /* LCStoreDB::get 77.75.76.172 */ lc_value FROM `wiki_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:february' LIMIT 1
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      Aug 25 12:52:50 27 north mysqld: 2019-08-25 12:52:50 7f41a5899700 InnoDB: error clustered record for sec rec not found
      Aug 25 12:52:50 27 north mysqld: InnoDB: index `lc_lang_key` of table `FFdb`.`wiki_l10n_cache`
      Aug 25 12:52:50 27 north mysqld: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
      Aug 25 12:52:50 27 north mysqld: 0: len 2; hex 656e; asc en;;
      Aug 25 12:52:50 27 north mysqld: 1: len 25; hex 6d657373616765733a74616c6b706167656c696e6b74657874; asc messages:talkpagelinktext;;
      Aug 25 12:52:50 27 north mysqld: 2: len 6; hex 0000000139c5; asc 9 ;;
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0
      Aug 25 12:52:50 27 north mysqld: 0: len 8; hex 696e66696d756d00; asc infimum ;;
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: TRANSACTION 5290797, ACTIVE 0 sec starting index read
      Aug 25 12:52:50 27 north mysqld: mysql tables in use 1, locked 0
      Aug 25 12:52:50 27 north mysqld: MySQL thread id 29218, OS thread handle 0x7f41a5899700, query id 1223599 localhost ale Sending data
      Aug 25 12:52:50 27 north mysqld: SELECT /* LCStoreDB::get 77.75.76.172 */ lc_value FROM `wiki_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:talkpagelinktext' LIMIT 1
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      Aug 25 12:52:50 27 north mysqld: 2019-08-25 12:52:50 7f41a5899700 InnoDB: error clustered record for sec rec not found
      Aug 25 12:52:50 27 north mysqld: InnoDB: index `lc_lang_key` of table `FFdb`.`wiki_l10n_cache`
      Aug 25 12:52:50 27 north mysqld: InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
      Aug 25 12:52:50 27 north mysqld: 0: len 2; hex 656e; asc en;;
      Aug 25 12:52:50 27 north mysqld: 1: len 23; hex 6d657373616765733a7265642d6c696e6b2d7469746c65; asc messages:red-link-title;;
      Aug 25 12:52:50 27 north mysqld: 2: len 6; hex 000000013a28; asc ;;
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0
      Aug 25 12:52:50 27 north mysqld: 0: len 8; hex 696e66696d756d00; asc infimum ;;
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: TRANSACTION 5290797, ACTIVE 0 sec starting index read
      Aug 25 12:52:50 27 north mysqld: mysql tables in use 1, locked 0
      Aug 25 12:52:50 27 north mysqld: MySQL thread id 29218, OS thread handle 0x7f41a5899700, query id 1223600 localhost ale Sending data
      Aug 25 12:52:50 27 north mysqld: SELECT /* LCStoreDB::get 77.75.76.172 */ lc_value FROM `wiki_l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:red-link-title' LIMIT 1
      Aug 25 12:52:50 27 north mysqld:
      Aug 25 12:52:50 27 north mysqld: InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

      Is there anything I can/should do?

      TIA
      Ale

      Attachments

        1. daemon.log
          7 kB
          Alessandro Vesely
        2. general_log
          24 kB
          Alessandro Vesely

        Activity

          People

            marko Marko Mäkelä
            Ale2019 Alessandro Vesely
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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