[debian-mysql] Bug#995066: mariadb-server: Incorrect warning about corrupt tables on mysql start

[Alexander Kirillov]

Package: mariadb-server
Version: 1:10.5.11-1
Severity: normal
Tags: l10n patch

Dear Maintainer,

/etc/mysql/debian-start incorrectly warns about corrupt tables if there're databases and tables with non-ascii names.

Тема	WARNING: mysqlcheck has found corrupt tables
От	root
Кому	root at neva.localnet
Дата	Сегодня 13:45

ERROR 1146 (42S02) at line 1: Table '??? ????.??? ??????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.GDP' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.????????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.??????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.??????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.???????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.bugs-old' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.????? ?? ??????????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.??? ???' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.??????????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.?????? ??????????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.?????? ???????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.bugs' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.?????' doesn't exist
ERROR 1146 (42S02) at line 1: Table '??? ????.?????????' doesn't exist

 Improperly closed tables are also reported if clients are accessing
 the tables *now*. A list of current connections is below.

+-----+------+-----------+----+---------+------+----------+------------------+----------+
| Id  | User | Host      | db | Command | Time | State    | Info             | Progress |
+-----+------+-----------+----+---------+------+----------+------------------+----------+
| 441 | root | localhost |    | Query   | 0    | starting | show processlist | 0.000    |
+-----+------+-----------+----+---------+------+----------+------------------+----------+
Uptime: 6  Threads: 1  Questions: 879  Slow queries: 0  Opens: 428  Open tables: 421  Queries per second avg: 146.500

Suggested fix:

--- /usr/share/mysql/debian-start.inc.sh	2021-09-25 16:15:00.757459188 +0300
+++ /usr/share/mysql/debian-start.inc.sh	2021-09-25 16:16:05.448573230 +0300
@@ -23,7 +23,7 @@
   # If a crashed table is encountered, the "mysql" command will return with a status different from 0
   set +e
 
-  LC_ALL=C $MYSQL --skip-column-names --batch -e  '
+  $MYSQL --skip-column-names --batch -e  '
       select concat('\''select count(*) into @discard from `'\'',
                     TABLE_SCHEMA, '\''`.`'\'', TABLE_NAME, '\''`'\'')
       from information_schema.TABLES where TABLE_SCHEMA<>'\''INFORMATION_SCHEMA'\'' and TABLE_SCHEMA<>'\''PERFORMANCE_SCHEMA'\'' and ( ENGINE='\''MyISAM'\'' or ENGINE='\''Aria'\'' )' | \

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

Kernel: Linux 5.10.0-8-amd64 (SMP w/4 CPU threads)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, 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.11-1

mariadb-server recommends no packages.

mariadb-server suggests no packages.

-- no debconf information