Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.16
-
None
-
None
-
Ubuntu 20, mariadb 10.6.16, fully NVME pcie 4.0, high end server, hundreds databases with hundreds tables
Description
Hi,
we have version 10.6 more than year. Yesterday we updated to 10.6.16 (before 10.6.12), we hoped it will solve our problem, but it doesn't.
ur mariadb error log is filled repeatelly with problems with pending operations, pending fsync.
Don't know what's problem. I know, its 'NOTE", not 'WARNING'/'ERROR', but...
Example of 3 types of "error":
A) pending fsync:
[Note] InnoDB: Cannot close file ./XXX/YYY.ibd because of pending fsync
B) pending operations:
[Note] InnoDB: Cannot close file ./XXX/YYY.ibd because of 4 pending operations
C) both:
[Note] InnoDB: Cannot close file ./XXX/YYY.ibd because of 8 pending operations and pending fsync
Every time its another database or table, not same. We have about 100 lines per day logged with this.
We are thinking to upgrade 10.6 to 10.11, but not sure, if this can helps, because 10.6 is still maintained for long time, so...
If it will necessary, I can provide more informations, ask me if something else is needed.
MariaDB 10.1 and 10.3 without problem.
We have high end server and fully nvme pcie 4.0 drivers.
We have hundreds of databases and every database have hundreds of tables.
We aren't facing any problems with real performance.
Ubuntu 20, kernel 5.4.0-156-generic
2x CPU Intel(R) Xeon(R) Gold 5218R CPU @ 2.10GHz (Total 40 cores, 80 threads)
innodb_buffer_pool_size=200G
innodb_io_capacity=2000
innodb_io_capacity_max=4000
Total server RAM is 756G
Thank you.
Attachments
Issue Links
- relates to
-
MDEV-33656 MariaDB unresponsive and in error log file --Thread 139894688810752 has waited at srv0srv.cc line 1554
- Open