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

InnoDB Clustered record for sec rec not found index

    XMLWordPrintable

Details

    Description

      2023-03-02 10:55:12 51 [ERROR] InnoDB: Clustered record for sec rec not found index `problem_1` of table `zabbix`.`problem`
      InnoDB: sec index record PHYSICAL RECORD: n_fields 4; compact format; info bits 0
      0: len 4; hex 80000000; asc ;;
      1: len 4; hex 80000000; asc ;;
      2: len 8; hex 000000000000c1fe; asc ;;
      3: len 8; hex 0000000002c21dec; asc ;;

      InnoDB: clust index record PHYSICAL RECORD: n_fields 16; compact format; info bits 0
      0: len 8; hex 0000000002bb364c; asc 6L;;
      1: len 6; hex 000000000000; asc ;;
      2: len 7; hex 80000000000000; asc ;;
      3: len 4; hex 80000000; asc ;;
      4: len 4; hex 80000000; asc ;;
      5: len 8; hex 00000000000091b1; asc ;;
      6: len 4; hex e224294f; asc $)O;;
      7: len 4; hex ab62e736; asc b 6;;
      8: SQL NULL;
      9: len 4; hex 80000000; asc ;;
      10: len 4; hex 80000000; asc ;;
      11: SQL NULL;
      12: SQL NULL;
      13: len 29; hex 496e74657266616365204661302f313628293a204c696e6b20646f776e; asc Interface Fa0/16(): Link down;;
      14: len 4; hex 80000000; asc ;;
      15: len 4; hex 80000003; asc ;;

      TRANSACTION 421956045321576, ACTIVE 0 sec starting index read
      mysql tables in use 1, locked 0
      0 lock struct(s), heap size 1128, 0 row lock(s)
      MySQL thread id 51, OS thread handle 140471920727808, query id 418169 localhost zabbix Sending data
      select eventid,objectid from problem where source=0 and object=0 and objectid in (18368,18373,18376,18377,18378,18379,18382,49653,49662,49669,49670) and r_eventid is null

      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

      Attachments

        Activity

          People

            Unassigned Unassigned
            xiaohua.zhang@minthgroup.com zhangxiaohua
            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.