Skip to main content ↑ ↓
Topic: MySQL/Mariadb stopped working after recent updates (Read 1487 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Re: MySQL/Mariadb stopped working after recent updates

Reply #15 –
Quote from: nous – on
Have you paid attention to the post install/upgrade messages?
Code: [Select]
:: You need to initialize the MariaDB data directory prior to starting
   the service. This can be done with mariadb-install-db command, e.g.:
   mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Code: [Select]
:: MariaDB was updated to a new feature release. To update the data run:
   mariadb-upgrade -u root -p && restart service

Yes, for sure. As I said, mysql was working normally for weeks, then this error began

Re: MySQL/Mariadb stopped working after recent updates

Reply #16 –
Oh, my bad, I thought I was responding to @anoki. See https://bbs.archlinux.org/viewtopic.php?id=276839

[EDIT] Just upgraded a system and the post-update message says this exact thing. Users should ruin mariadb-upgrade BEFORE restarting the service or rebooting. Never skip reading the upgrade messages.
 

Re: MySQL/Mariadb stopped working after recent updates

Reply #17 –
Quote from: nous – on
Have you paid attention to the post install/upgrade messages?
Code: [Select]
:: You need to initialize the MariaDB data directory prior to starting
   the service. This can be done with mariadb-install-db command, e.g.:
   mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
Code: [Select]
:: MariaDB was updated to a new feature release. To update the data run:
   mariadb-upgrade -u root -p && restart service
Thanks, this solved my problem.

However, when I check mariadb status:
Code: [Select]
$ sudo rc-service mariadb status
 * status: crashed
Any help is appreciated.