[debian-mysql] Bug#996389: mariadb-server: FATAL ERROR: Upgrade failed

[Alexander Kirillov]

Package: mariadb-server
Version: 1:10.5.12-0+deb11u1
Severity: normal
Tags: l10n patch

Dear Maintainer,

Automatic upgrade of MySQL tables fails if there're databases and/or tables with non-ASCII names. See also #995066.

# cat /var/log/syslog
...
Oct 10 10:14:52 neva systemd[1]: Started MariaDB 10.5.12 database server.
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171797]: Upgrading MySQL tables if necessary.
...
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: Phase 2/7: Installing used storage engines... Skipped
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: Phase 3/7: Fixing views
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: Running 'mysqlcheck' with connection arguments: --socket='/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' 
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: Processing databases
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: information_schema
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: mysql
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: mysql.user                                         OK
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: performance_schema
...
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: wordpress-www
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: ??? ????
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: /usr/bin/mysqlcheck: Got error: 1049: Unknown database '??? ????' when selecting the database
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171800]: FATAL ERROR: Upgrade failed
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171834]: Checking for insecure root accounts.
Oct 10 10:14:52 neva /etc/mysql/debian-start[4171841]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Oct 10 10:14:57 neva /etc/mysql/debian-start[4173463]: WARNING: mysqlcheck has found corrupt tables
Oct 10 10:14:57 neva /etc/mysql/debian-start[4173463]: ERROR 1146 (42S02) at line 1: Table '??? ????.??? ??????' doesn't exist
Oct 10 10:14:57 neva /etc/mysql/debian-start[4173463]: ERROR 1146 (42S02) at line 1: Table '??? ????.GDP' doesn't exist

-- System Information:
Debian Release: 11.1
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 5.10.0-9-amd64 (SMP w/4 CPU threads)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_WARN, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-server depends on:
ii  mariadb-server-10.5  1:10.5.12-0+deb11u1

mariadb-server recommends no packages.

mariadb-server suggests no packages.

-- no debconf information
-------------- next part --------------
--- /usr/share/mysql/debian-start.inc.sh	2021-09-25 16:15:00.757459188 +0300
+++ /usr/share/mysql/debian-start.inc.sh	2021-10-13 17:52:27.289695579 +0300
@@ -58,7 +58,7 @@
 
   # Filter all "duplicate column", "duplicate key" and "unknown column"
   # errors as the script is designed to be idempotent.
-  LC_ALL=C $MYUPGRADE \
+  $MYUPGRADE \
     2>&1 \
     | egrep -v '^(1|@had|ERROR (1051|1054|1060|1061|1146|1347|1348))' \
     | logger -p daemon.warn -i -t$0