I am running MariaDB (v 10.3.13) on Arch Linux (Manjaro). It worked normally for the last months but now there are some issues. When I try to reboot the computer, it gets stuck at
A stop job is running for MariaDB 10.3.13 database server
The time it should take gets increased every minute till it finally times out (after approx 20 min).
Stopping MariaDB manually also gets stuck when I try to restart/stop it with
sudo systemctl stop/restart mariadb
sudo systemctl status mariadb shows
/usr/bin/mysqld (initiated by: unknown): Normal shutdown Event Scheduler: Purging the queue. 0 events InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool InnoDB: Buffer pool(s) dump completed at 190402 20:31:01 InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
with every minute another line with
InnoDB: Waiting for page_cleaner to finish flushing of buffer pool being added.
Is there a way to reset MariaDB? Or a way to get more information what the problem is?
PS: I installed some updates through the Package Manager lately, after which I noticed the issue for the first time.
When I uninstall, reboot and reinstall MariaDB, I can stop/restart MariaDB without issues and shutdown goes without issues. But after booting again, I am back to the above described problems.