Your message dated Sat, 19 Feb 2022 17:11:41 -0800
with message-id
<caou6tabkycpjs1uishhj-+rcqrjrzyane0wvklzvovsozfo...@mail.gmail.com>
and subject line Re: [debian-mysql] Bug#995066: mariadb-server: Incorrect
warning about corrupt tables on mysql start
has caused the Debian Bug report #995066,
regarding mariadb-server: Incorrect warning about corrupt tables on mysql start
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
995066: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=995066
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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
Кому [email protected]
Дата Сегодня 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
--- End Message ---
--- Begin Message ---
Hello Alexander!
It seems that this issue has no actionable items on how to improve the
user experience for everybody. Thus I am closing this issue as there
are no actions to take about it.
If you later come up with improvements to the MariaDB packaging in
Debian, please consider contributing by submitting a Merge Request.
https://salsa.debian.org/mariadb-team/mariadb-server/-/wikis/Contributing-to-MariaDB-packaging-in-Debian
Thanks!
--- End Message ---
