Bug #109210 FreeBSD ZFS Upgrading from 5.7 to 8.0 GA misconfigures lower_case_table_names
Submitted: 26 Nov 2022 4:52 Modified: 28 Nov 2022 13:17
Reporter: Chris Collins Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:8.0.30 OS:FreeBSD (Ports version)
Assigned to: CPU Architecture:x86

[26 Nov 2022 4:52] Chris Collins
Existing installation is running on case sensitive filesystem ZFS on FreeBSD 12.

Existing installation has lower_case_table_names=0 auto configured (not specified in config file).

When doing an in place upgrade I read documentation, followed prerequisite checks, and ran the tool to check existing databases, all tables were marked as OK.

On starting 8.0.30 it reports some errors for tables that have incorrect caps with the following wording.

[ERROR] [MY-013521] [Server] Table name 'table name' containing upper case characters is not allowed with lower_case_table_names = 1.

The upgrade then fails because of the misconfiguration.

But as reported this is running on UNIX on a case sensitive file system with existing installation set to 0.

How to repeat:
Attempt to start mysql 8.0 again on FreeBSD 12 with ZFS.

Suggested fix:
To automatically lower_case_table_names = 0 on ZFS.
[28 Nov 2022 13:17] MySQL Verification Team
Hi Mr. Collins,

Thank you for your bug report.

However, if you look at the list of the supported platforms, you will notice that we do not support FreeBSD.

That means, that you are responsible for the entire administration, including the correct setting of the configuration variables.