MySQL 8.0.21 error log is cluttered with [Note] [MY-012102] [InnoDB] Open file list len in shard X is Y

Gergan Zhekov

3/19/23, 2:39 PM

Since we have upgraded our MySQL server to 8.0.21 from 5.7, our error log is cluttered with the following message (if it is even an error message?), which takes a lot of space in our log and it is being spammed consistently:

2021-11-19T14:33:45.754254Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 17 is 0
2021-11-19T14:33:45.754589Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 18 is 0
2021-11-19T14:33:45.754923Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 19 is 0
2021-11-19T14:33:45.755256Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 20 is 0
2021-11-19T14:33:45.755592Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 21 is 0
2021-11-19T14:33:45.755927Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 22 is 0
2021-11-19T14:33:45.756262Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 23 is 0
2021-11-19T14:33:45.756597Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 24 is 0
2021-11-19T14:33:45.756932Z 0 [Note] [MY-012102] [InnoDB] Open file list len in shard 25 is 0

The database is otherwise functioning fine and everything is working as intended.

I understand that I can reduce the log verbosity to "2" from "3", but that way some important events may be missed.

Does anyone know what might cause this, and how it can be fixed?

0 + 0

mysql

database

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: MySQL 8.0.21 error log is cluttered with [Note] [MY-012102] [InnoDB] Open file list len in shard X is Y

TH: บันทึกข้อผิดพลาด MySQL 8.0.21 รกด้วย [Note] [MY-012102] [InnoDB] เปิดรายการไฟล์ len ในชาร์ด X คือ Y

RO: Jurnalul de erori MySQL 8.0.21 este aglomerat cu [Notă] [MY-012102] [InnoDB] Deschideți lista de fișiere len în fragmentul X este Y

RU: Журнал ошибок MySQL 8.0.21 загроможден [Примечание] [MY-012102] [InnoDB] Список открытых файлов len в осколке X равен Y

VI: Nhật ký lỗi MySQL 8.0.21 lộn xộn với [Lưu ý] [MY-012102] [InnoDB] Mở danh sách tệp len trong phân đoạn X là Y

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.