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@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
