MySQL Bugs: #109563: show engine innodb status:Innodb_data_pending

Bug #109563	show engine innodb status:Innodb_data_pending_fsyncs Is Constantly Rising
Submitted:	10 Jan 2023 5:25	Modified:	10 Jan 2023 13:07
Reporter:	ianhol young	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	8.0.31	OS:	Ubuntu (20.04.4)
Assigned to:		CPU Architecture:	x86

Description:
show engine innodb status\G
....
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (read thread)
I/O thread 9 state: waiting for completed aio requests (read thread)
I/O thread 10 state: waiting for completed aio requests (write thread)
I/O thread 11 state: waiting for completed aio requests (write thread)
I/O thread 12 state: waiting for completed aio requests (write thread)
I/O thread 13 state: waiting for completed aio requests (write thread)
I/O thread 14 state: waiting for completed aio requests (write thread)
I/O thread 15 state: waiting for completed aio requests (write thread)
I/O thread 16 state: waiting for completed aio requests (write thread)
I/O thread 17 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:
Pending flushes (fsync) log: 0; buffer pool: 18446744073709551614
1307 OS file reads, 70021 OS file writes, 40002 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 71.52 writes/s, 71.52 fsyncs/s
....

Pending flushes (fsync) buffer pool numerical anomaly

I tried to execute the following command but still did not recover
flush status;
flush engine logs;

How to repeat:
Is Constantly Rising

https://bugs.mysql.com/bug.php?id=99363
https://support.oracle.com/knowledge/Oracle%20Database%20Products/2725705_1.html

Hi Mr. young,

Thank you for your bug report.

Your report is very interesting, but this is a forum for reports which contain fully repeatable test cases. Those test cases should contain a set of SQL statements that always lead to the situation that you describe .....

We can not repeat your report, but when you supply us with the necessary test case, we shall try to repeat it and if we are successful, we shall change the status of this bug report.

Can't repeat.