4

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

Then running 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.

Update:

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.

6

After a multiple hour long struggle, I could finally resolve the issue.

The culprit was a time setting (timedatectl set-local-rtc 1) for dual booting with Win10.

Due to a recent time change the clock was messed up. (The status log entries in sudo systemctl status mariadb were 1h in the future)

Setting

timedatectl set-local-rtc 0

and rebooting resolved it.

| improve this answer | |
  • Wow, thanks for sharing. Apparently I had the exact same issue. I just moved the clock a bit forward in time to resume :)) I'll move it back after it's done. – Eek May 2 '19 at 9:16
  • I don't have systemd ... so this does not work. :/ – Eric Sebasta Aug 9 at 4:07
0

Also you could change and reduce TimeoutSec=300(5 minutes) timeout from start service config file:

vi /usr/lib/systemd/system/mariadb.service
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.