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

[ERROR] InnoDB: Clustered record for sec rec not found index

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 10.4.20
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:

      Description

      2021-11-05 10:07:51 131 [ERROR] InnoDB: Clustered record for sec rec not found index `items_1` of table `zabbix`.`items`
      InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
      0: len 8; hex 0000000000002f6d; asc /m;;
      1: len 30; hex 646f636b65722e6d6f6e69746f725b757365642e6d656d2c736f6e64612d; asc docker.monitor[used.mem,sonda-; (total 41 bytes);
      2: len 8; hex 000000000005f5be; asc ;;

      InnoDB: clust index record PHYSICAL RECORD: n_fields 62; compact format; info bits 0
      0: len 8; hex 000000000005f4bf; asc ;;
      1: len 6; hex 000000000000; asc ;;
      2: len 7; hex 80000000000000; asc ;;
      3: len 4; hex 80000012; asc ;;
      4: len 0; hex ; asc ;;
      5: len 0; hex ; asc ;;
      6: len 8; hex 0000000000002f99; asc / ;;
      7: len 20; hex 436f66726520666f7261207375626e6574203332; asc Cofre fora subnet 32;;
      8: len 9; hex 7375626e65745f3332; asc subnet_32;;
      9: len 1; hex 30; asc 0;;
      10: len 2; hex 3764; asc 7d;;
      11: len 4; hex 33363564; asc 365d;;
      12: len 4; hex 80000001; asc ;;
      13: len 4; hex 80000003; asc ;;
      14: len 0; hex ; asc ;;
      15: len 0; hex ; asc ;;
      16: len 0; hex ; asc ;;
      17: len 4; hex 80000000; asc ;;
      18: len 0; hex ; asc ;;
      19: len 0; hex ; asc ;;
      20: len 0; hex ; asc ;;
      21: len 0; hex ; asc ;;
      22: SQL NULL;
      23: SQL NULL;
      24: len 0; hex ; asc ;;
      25: len 0; hex ; asc ;;
      26: len 4; hex 80000000; asc ;;
      27: len 0; hex ; asc ;;
      28: len 0; hex ; asc ;;
      29: len 0; hex ; asc ;;
      30: len 0; hex ; asc ;;
      31: len 4; hex 80000000; asc ;;
      32: SQL NULL;
      33: len 0; hex ; asc ;;
      34: len 0; hex ; asc ;;
      35: len 4; hex 80000000; asc ;;
      36: len 3; hex 333064; asc 30d;;
      37: len 4; hex 80000000; asc ;;
      38: len 4; hex 80000000; asc ;;
      39: len 0; hex ; asc ;;
      40: len 4; hex 80000000; asc ;;
      41: len 0; hex ; asc ;;
      42: len 8; hex 000000000005f4b7; asc ;;
      43: len 2; hex 3373; asc 3s;;
      44: len 0; hex ; asc ;;
      45: len 0; hex ; asc ;;
      46: len 0; hex ; asc ;;
      47: len 3; hex 323030; asc 200;;
      48: len 4; hex 80000001; asc ;;
      49: len 4; hex 80000000; asc ;;
      50: len 0; hex ; asc ;;
      51: len 0; hex ; asc ;;
      52: len 4; hex 80000000; asc ;;
      53: len 4; hex 80000000; asc ;;
      54: len 4; hex 80000000; asc ;;
      55: len 0; hex ; asc ;;
      56: len 0; hex ; asc ;;
      57: len 0; hex ; asc ;;
      58: len 4; hex 80000000; asc ;;
      59: len 4; hex 80000000; asc ;;
      60: len 4; hex 80000000; asc ;;
      61: SQL DEFAULT;

      TRANSACTION 421703784035608, ACTIVE 3 sec fetching rows
      mysql tables in use 3, locked 0
      0 lock struct(s), heap size 1128, 0 row lock(s)
      MySQL thread id 131, OS thread handle 140220371769088, query id 65567758 zabbix-infra02.sep.local 10.170.20.36 zabbix Sending data
      select t.itemid,t.lastlogsize,t.mtime from item_rtdata t,items i,hosts h where t.itemid=i.itemid and i.hostid=h.hostid and h.proxy_hostid=12216 order by t.itemid

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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              ivertongs iverton guterres Schmidt
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.