Bug #94769 Do not check read_only for updates to dictionary charset and collations table
Submitted: 25 Mar 2019 13:21 Modified: 7 May 2019 18:13
Reporter: Ståle Deraas Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.0.1 OS:Any
Assigned to: CPU Architecture:Any

[25 Mar 2019 13:21] Ståle Deraas
If you have a the read_only option set on a replication slave, an upgarde will emit the following warning:

[Warning] [MY-010005] [Server] Skip re-populating collations and character sets tables in read-only mode.

Looking https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_read_only this should be allowed. We should also evaluate if these tables should be updated, even if 'super_read_only' is specified.

How to repeat:

Set 'read_only' sysvar to 'ON' and upgrade the server.
[7 May 2019 18:13] Paul DuBois
Posted by developer:
Fixed in 8.0.17.

If the read_only system variable was enabled, its value improperly
was applied against updates to the character set and collation data
dictionary tables.