I have a master running with 2 slaves.
I updated the slaves to 8.0.25, the master is still at 8.0.23
Since then, one of the slaves is printing a lot of messages like this in its error log:
“[Note] [MY-012102] [InnoDB] Open file list len in shard x is y”
where y is usually 0, x is a different number from 0 to 11
the other slave seems to be working fine.
Should I rebuild the slave with xtrabackup (the db size is more than 500gb) or I can upgrade the master to .25 and this error will disappear?
–
Edit: the slave printing the errors is still replicating, 0 seconds behind Master
I guess I’ll go with the first option anyway…
1 Like
After doing a full xtrabackup+prepare and started the slave, got the data automatically upgraded from .23 to .25, started the slave, and then I have again the errors… 
Occasionally there’s also a “[MY-012100] [InnoDB] Cannot close file db/table.ibd, because modification count 152 != flush count 151”
1 Like
So I updated also the Master to 8.0.25, and now I have these “notes” also in the master’s log…
Is this a bug? I can’t find any explanation for this error on the web.
I guess this is just an excess of verbosity, which shouldn’t be logged, should it?
1 Like
I had log_error_verbosity set to 3, setting it to 2 (the default) stops the issue, but I may miss events I wanted to track.
1 Like
