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

Hit a bug that the error log says I should report

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.3.22
    • N/A
    • Server

    Description

      Here is the data from the error log:

      2023-02-07  9:47:39 1263 [ERROR] InnoDB: Clustered record for sec rec not found index `cf_data_collection_object_id_v_string_idx` of table `service_desk`.`cf_data_collection`
      InnoDB: sec index record PHYSICAL RECORD: n_fields 3; compact format; info bits 0
       0: len 4; hex 807d1728; asc  } (;;
       1: len 18; hex 804f12910000000000000000000000000000; asc  O                ;;
       2: len 4; hex 00000000; asc     ;;
       
      InnoDB: clust index record PHYSICAL RECORD: n_fields 1; compact format; info bits 0
       0: len 8; hex 696e66696d756d00; asc infimum ;;
       
      TRANSACTION 421748213171280, ACTIVE 14 sec starting index read, thread declared inside InnoDB 4261
      mysql tables in use 6, locked 0
      0 lock struct(s), heap size 1136, 0 row lock(s)
      MySQL thread id 1263, OS thread handle 140267557455616, query id 16344 10.20.11.31 desk_user Sending data
      SELECT COUNT( DISTINCT `olap_incident_facts`.`incident`) AS `_ac0` FROM `olap_incident_facts`
       LEFT JOIN (SELECT `data_table`.`object_id`, `data_table`.`v_string` AS `value` FROM `cf_data_collection` AS `data_table`
       INNER JOIN `cf_fields` AS `cfs` ON data_table.field_id = cfs.id WHERE (data_table.v_string IS NOT NULL) AND (data_table.v_string != '') AND (cfs.id = 55) AND (data_table.status = 1) GROUP BY `data_table`.`object_id`,
              `data_table`.`v_string`) AS `view_olap_snowflake_55` ON `view_olap_snowflake_55`.`object_id` = `olap_incident_facts`.`incident`
       LEFT JOIN (SELECT DISTINCT `data_tab
       
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      

      Server version: MariaDB-server-10.3.22-1.el7.centos.x86_64 (it's an rpm name)

      Attachments

        Activity

          People

            Unassigned Unassigned
            richardjans Richard Jans
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.