Your message dated Wed, 26 Nov 2025 21:19:39 -0800
with message-id
<caou6tabnu5sza6hram85s3bf3z-jjmm8kyxe9sgd5r7dh0q...@mail.gmail.com>
and subject line Re: [debian-mysql] Bug#1120329: Problem identified & fix
confirmed
has caused the Debian Bug report #1120329,
regarding mariadb-server: debian-start check_for_crashed_tables causes journal
warnings like: ERROR 1146 (42S02)
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.)
--
1120329: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1120329
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: mariadb-server
Version: 1:11.4.9+maria~ubu2404
Severity: normal
X-Debbugs-Cc: [email protected]
Dear Maintainer,
I'm getting a number of these errors printed in the systemd journal when i
restart mariadb:
```
Nov 07 17:56:05 p2 /etc/mysql/debian-start[8427]: --------------
Nov 07 17:56:05 p2 /etc/mysql/debian-start[8427]: select count(*) into @discard
from _cdfd7a1251c20c3e.tabError Log
Nov 07 17:56:05 p2 /etc/mysql/debian-start[8427]: --------------
Nov 07 17:56:05 p2 /etc/mysql/debian-start[8427]:
Nov 07 17:56:05 p2 /etc/mysql/debian-start[8427]: ERROR 1146 (42S02) at line 1:
Table '_cdfd7a1251c20c3e.tabError' doesn't exist
```
It appears to be cause by the `check_for_crashed_tables` shell call in
`debian-start`
I have found that function in `/usr/share/mariadb/debian-start.inc.sh`:
```shell
echo '
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")
' | \
LC_ALL=C $MARIADB --skip-column-names --batch | \
xargs --no-run-if-empty -i $MARIADB --skip-column-names --silent --batch
--force -e "{}" &> "${tempfile}"
```
It looks to me like the `table.table_name` is not properly surrounded by
quotes, so when a table name with spaces occurs, the command is failing.
However looking at the shell script you have gone to quite a bit of trouble to
add the correct quotes in the `SELECT CONCAT(` statement.
-- System Information:
Debian Release: trixie/sid
APT prefers noble-updates
APT policy: (500, 'noble-updates'), (500, 'noble-security'), (500, 'noble'),
(100, 'noble-backports')
Architecture: amd64 (x86_64)
Kernel: Linux 6.14.0-1016-aws (SMP w/2 CPU threads)
Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE
Locale: LANG=C.UTF-8, LC_CTYPE=C.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 adduser 3.137ubuntu1
ii debconf [debconf-2.0] 1.5.86ubuntu1
ii galera-4 [galera-4] 26.4.24-ubu2404
ii gawk 1:5.2.1-2build3
ii iproute2 6.1.0-1ubuntu6.2
ii libc6 2.39-0ubuntu8.6
ii libdbi-perl 1.643-4build3
ii libgcc-s1 14.2.0-4ubuntu2~24.04
ii libpam0g 1.5.3-5ubuntu5.5
ii libssl3t64 3.0.13-0ubuntu3.6
ii libstdc++6 14.2.0-4ubuntu2~24.04
ii lsof 4.95.0-1build3
ii mariadb-client 1:11.4.9+maria~ubu2404
ii mariadb-common 1:11.4.9+maria~ubu2404
ii mariadb-server-core 1:11.4.9+maria~ubu2404
ii passwd 1:4.13+dfsg1-4ubuntu3.2
ii perl 5.38.2-3.2ubuntu0.2
ii procps 2:4.0.4-4ubuntu3.2
ii psmisc 23.7-1build1
ii rsync 3.2.7-1ubuntu1.2
ii socat 1.8.0.0-4build3
ii zlib1g 1:1.3.dfsg-3.1ubuntu2.1
Versions of packages mariadb-server recommends:
ii libhtml-template-perl 2.97-2
ii mariadb-server-compat 1:11.4.9+maria~ubu2404
ii pv 1.8.5-2build1
Versions of packages mariadb-server suggests:
pn mailx <none>
pn mariadb-test <none>
ii netcat-openbsd 1.226-1ubuntu2
-- Configuration Files:
/etc/mysql/mariadb.conf.d/50-server.cnf changed [not included]
-- debconf information excluded
--- End Message ---
--- Begin Message ---
Version: 1:11.8.3-1, 1:11.4.5-1
This was fixed via
https://salsa.debian.org/mariadb-team/mariadb-server/-/commit/8b900bf44546f490f125a556c8fc3c50ab2a7a56
that shipped already in previous release.
--- End Message ---
