[MDEV-24685] SHOW ENGINE INNODB STATUS reports I/O thread 0 state: (null) ((null)) Created: 2021-01-26  Updated: 2022-12-16  Resolved: 2021-01-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5.0
Fix Version/s: 10.5.9

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: regression-10.5

Issue Links:
Problem/Incident
is caused by MDEV-16264 Implement a common work queue for Inn... Closed

 Description   

The output of SHOW ENGINE INNODB STATUS includes a useless-looking section like the following:

--------
FILE I/O
--------
I/O thread 0 state: (null) ((null))
I/O thread 1 state: (null) ((null))
I/O thread 2 state: (null) ((null))
I/O thread 3 state: (null) ((null))
I/O thread 4 state: (null) ((null))
I/O thread 5 state: (null) ((null))
I/O thread 6 state: (null) ((null))
I/O thread 7 state: (null) ((null))
I/O thread 8 state: (null) ((null))
I/O thread 9 state: (null) ((null))

This output comes from the following code in srv_printf_innodb_monitor():

	fputs("--------\n"
	      "FILE I/O\n"
	      "--------\n", file);
	os_aio_print(file);

The reason why the output is useless appears to be that the calls to srv_reset_io_thread_op_info() and srv_set_io_thread_op_info() were removed in MDEV-16264.

I would suggest that we remove the above code as well as all references to srv_io_thread_op_info and srv_io_thread_function.


Generated at Thu Feb 08 09:31:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.