Ubuntu
mysql-5.7 package

  1. Bug #1785693
  2. Comment #3

Comment 3 for bug 1785693

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

From your log I see:
  Setting up mysql-server-5.7 (5.7.23-0ubuntu0.18.04.1) ...
  locale: Cannot set LC_CTYPE to default locale: No such file or directory
  locale: Cannot set LC_MESSAGES to default locale: No such file or directory
  locale: Cannot set LC_ALL to default locale: No such file or directory
  Error occurred: Cannot select database.
  mysql_upgrade failed with exit status 1

And in the mysql error log related to that:
  2018-08-06T18:45:33.244519Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

I've seen a few cases were this was related to overlayfs [1], but most others like [2] are certain variations on deleted or permission-changed DB files.

It seems to me that the DB config was modified breaking the service start, that in turn will break the package upgrade/install.

[1]: https://serverfault.com/questions/870568/fatal-error-cant-open-and-lock-privilege-tables-table-storage-engine-for-use
[2]: https://stackoverflow.com/questions/9083408/fatal-error-cant-open-and-lock-privilege-tables-table-mysql-host-doesnt-ex