[debian-mysql] Bug#1120329: mariadb-server: debian-start check_for_crashed_tables causes journal warnings like: ERROR 1146 (42S02)

[Richard Case]

Package: mariadb-server
Version: 1:11.4.9+maria~ubu2404
Severity: normal
X-Debbugs-Cc: racitup0 at gmail.com

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