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.sh2021-09-25 16:15:00.757459188
+0300
+++ /usr/share/mysql/debian-start.inc.sh2021-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