Keywords: WordPress - Google Cloud Platform - Technical issue - Other
bnsupport ID: a3a9e28b-0ad4-8906-9092-42f70ddb9786
On the morning of 8/12/19 we found our website was down with an error message on the page saying Cannot establish database connection. After digging into the logs I found in the mysql error log this message
Different lower_case_table_names settings for server ('0') and data dictionary ('1').
No settings were changed, no plugins installed or updated, the VM didn't auto update any packages via package manager. The ctl.sh script for mysql already had an option for --lower_case_case_variable_names=1 by default. Mysql will not start because of this error. I've tried everything I could find online, but I couldn't find any article that referenced the error with 0 for the server and 1 for the data dictionary, most had the opposite, 1 for the server and 0 for data dictionary.
The closest answer I could find was on the mysql forums with people saying this was a breaking change when updating from version 5.x to 8. Did the VM get auto-updated to mysql 8?