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

slow log Rows_examined out of range

Details

    Description

      There is an issue for logging query on slow log table.
      Since we set log_output=FILE and the data type for 'rows_examined' column on CVS table slow_log is INT, when this value exceeds the maximum allowed value for INT , an error is logged into error log.

      ([ERROR] Unable to write to mysql.slow_log)

      Because the INSERT into the slow_log table fails due to the maximum value being exceeded. This is the output when we change the log_output to file:

      # Thread_id: 380229  Schema: andre_k  QC_hit: No# Query_time: 0.028396  Lock_time: 0.001841  Rows_sent: 2  Rows_examined: 10958383778436017378# Rows_affected: 0  Bytes_sent: 124# Tmp_tables: 2  Tmp_disk_tables: 0  Tmp_table_sizes: 380968# Full_scan: Yes  Full_join: No  Tmp_table: Yes  Tmp_table_on_disk: No# Filesort: Yes  Filesort_on_disk: No  Merge_passes: 0  Priority_queue: Yes
      		 
      # SET timestamp=1677147120;
      		 
      # SELECT  get_id(CAST(aes_decrypt(tab1.NAME_F,'V41iNM0n4') AS char),'KM_ID_PL') as get_string,    (CASE WHEN (SELECT ID FROM tab2 where tab2.TAB1_ID = tab1.ID LIMIT 1) IS NULL THEN 0 ELSE 1 END) AS IS_ATTFROM    tab1ORDER BY 2 DESCLIMIT 2;

      use case huge_value_rows_examined.txt is attached.

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-22860 Change EXAMINED_ROWS in I_S.PROCESSLIST from INT to BIGINT UNSIGNED

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-22860 Change EXAMINED_ROWS in I_S.PROCESSLIST from INT to BIGINT UNSIGNED

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31742 incorrect examined rows in case of stored function usage

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32518 Test failure: ./mtr --no-reorder main.log_slow_debug main.subselect

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

            People

              sanja Oleksandr Byelkin
              muhammad.irfan Muhammad Irfan
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.