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
• Status: Closed
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.0.1
• OS: Any
• CPU Architecture: Any

[25 Mar 2019 13:21] Ståle Deraas

Description:
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.