[MDEV-30820] slow log Rows_examined out of range - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3
Component/s: Server
Labels:
- performance

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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

huge_value_rows_examined.txt
4 kB
2023-03-09 13:46

Issue Links

is duplicated by

MDEV-22860 Change EXAMINED_ROWS in I_S.PROCESSLIST from INT to BIGINT UNSIGNED

Closed

relates to

MDEV-22860 Change EXAMINED_ROWS in I_S.PROCESSLIST from INT to BIGINT UNSIGNED

Closed

MDEV-31742 incorrect examined rows in case of stored function usage

Closed

MDEV-32518 Test failure: ./mtr --no-reorder main.log_slow_debug main.subselect

Closed

Activity

Ascending order - Click to sort in descending order

Muhammad Irfan created issue - 2023-03-09 13:45

Muhammad Irfan made changes - 2023-03-09 13:45

Field	Original Value	New Value
Summary	show log Rows_examined out of range	slow log Rows_examined out of range

Muhammad Irfan made changes - 2023-03-09 13:46

Attachment

huge_value_rows_examined.txt [ 68781 ]

Julien Fritsch made changes - 2023-03-14 08:46

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.3 [ 22126 ]

Elena Stepanova made changes - 2023-03-19 20:50

Component/s		Server [ 13907 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s	10.3 [ 22126 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]
Affects Version/s		10.5 [ 23123 ]
Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]
Affects Version/s		11.0 [ 28320 ]
Assignee		Oleksandr Byelkin [ sanja ]

Elena Stepanova made changes - 2023-03-19 20:51

Status

Open [ 1 ]

Confirmed [ 10101 ]

Julien Fritsch made changes - 2023-04-27 14:45

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-06-05 07:51

Priority

Major [ 3 ]

Critical [ 2 ]

Oleksandr Byelkin made changes - 2023-07-13 08:01

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Oleksandr Byelkin made changes - 2023-07-17 08:25

Assignee	Oleksandr Byelkin [ sanja ]	Sergei Golubchik [ serg ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Oleksandr Byelkin made changes - 2023-07-19 12:53

Link

This issue relates to ~~MDEV-31742~~ [ ~~MDEV-31742~~ ]

Sergei Golubchik made changes - 2023-07-19 16:38

Assignee	Sergei Golubchik [ serg ]	Oleksandr Byelkin [ sanja ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Daniel Black made changes - 2023-09-20 06:12

Link

This issue relates to ~~MDEV-22860~~ [ ~~MDEV-22860~~ ]

Oleksandr Byelkin made changes - 2023-09-22 13:45

Fix Version/s		10.4.32 [ 29300 ]
Fix Version/s		10.5.23 [ 29012 ]
Fix Version/s		10.6.16 [ 29014 ]
Fix Version/s		10.10.7 [ 29018 ]
Fix Version/s		10.11.6 [ 29020 ]
Fix Version/s		11.0.4 [ 29021 ]
Fix Version/s		11.1.3 [ 29023 ]
Fix Version/s		11.2.2 [ 29035 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.0 [ 28320 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Julien Fritsch made changes - 2023-09-25 07:26

Fix Version/s

11.2.2 [ 29035 ]

Daniel Black made changes - 2023-09-26 00:13

Link

This issue is duplicated by ~~MDEV-22860~~ [ ~~MDEV-22860~~ ]

Marko Mäkelä made changes - 2023-10-19 05:10

Link

This issue relates to ~~MDEV-32518~~ [ ~~MDEV-32518~~ ]

Jira Automation (IT) made changes - 2024-07-04 01:12

Zendesk Related Tickets

148522

People

Assignee:: Oleksandr Byelkin

Reporter:: Muhammad Irfan

Votes:: 0 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2023-03-09 13:45

Updated:: 2024-07-07 19:37

Resolved:: 2023-09-22 13:45

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration