[debian-mysql] Bug#1015189: mariadb-server: stopping mariadb.service never finishes

[Paul Gevers]

Package: mariadb-server
Version: 1:10.6.8-1
Severity: important

Dear maintainer,

For a while now, I can't properly shut down my laptop, because MariaDb
doesn't finish gracefully.

I just ran a manual $(systemctl stop mariadb.service) to see if I
could spot what's going wrong but there is no output and I killed it
after 7 minutes.

Please let me know if there is more to test or try or if you need more
info from my system.

Paul

paul at mulciber ~ $ sudo systemctl stop mariadb.service 

^C
paul at mulciber ~ $ sudo systemctl status mariadb.service 
● mariadb.service - MariaDB 10.6.8 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: deactivating (stop-sigterm) since Sun 2022-07-17 13:52:47 CEST; 7min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
   Main PID: 1043 (mariadbd)
     Status: "Waiting to flush the buffer pool"
      Tasks: 6 (limit: 4255)
     Memory: 33.8M
        CPU: 1min 9.598s
     CGroup: /system.slice/mariadb.service
             └─1043 /usr/sbin/mariadbd

jul 14 16:16:58 mulciber mariadbd[1043]: Version: '10.6.8-MariaDB-1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian buildd-unstable
jul 14 16:16:58 mulciber mariadbd[1043]: 2022-07-14 16:16:58 0 [Note] InnoDB: Buffer pool(s) load completed at 220714 16:16:58
jul 14 16:16:58 mulciber systemd[1]: Started MariaDB 10.6.8 database server.
jul 14 16:16:58 mulciber /etc/mysql/debian-start[1245]: Upgrading MySQL tables if necessary.
jul 17 13:52:47 mulciber systemd[1]: Stopping MariaDB 10.6.8 database server...
jul 17 13:52:47 mulciber mariadbd[1043]: 2022-07-17 13:52:47 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
jul 17 13:52:47 mulciber mariadbd[1043]: 2022-07-17 13:52:47 0 [Note] InnoDB: FTS optimize thread exiting.
jul 17 13:52:47 mulciber mariadbd[1043]: 2022-07-17 13:52:47 0 [Note] InnoDB: Starting shutdown...
jul 17 13:52:47 mulciber mariadbd[1043]: 2022-07-17 13:52:47 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
jul 17 13:52:47 mulciber mariadbd[1043]: 2022-07-17 13:52:47 0 [Note] InnoDB: Buffer pool(s) dump completed at 220717 13:52:47



-- System Information:
Debian Release: bookworm/sid
  APT prefers testing
  APT policy: (990, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 5.18.0-2-amd64 (SMP w/8 CPU threads; PREEMPT)
Kernel taint flags: TAINT_WARN
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en
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.6  1:10.6.8-1

mariadb-server recommends no packages.

mariadb-server suggests no packages.

-- no debconf information