Hello, I did an
and after that mysql service is no longer working. I use it with openrc service manager. When I run
it fails with the errors:
and in the log /var/lib/mysql/artixpc.err I've got:
ok no one is responding here.
are you sure the init service file is installed? i assumed it would be since it failed after update but please humor me.
Yes sir, it is installed, and it used to work even without the mariadb-openrc package installed...
btw, is this pamac? which gui package manager is that?
not a sir. but thank you.
it is indeed pamac-manager but with a dark theme applied to it. i like visuals when i do file searches and it gives easy on the eyes details of the files included in a package. I don't install with it, i use the command line for that but for searches of all kinds i appreciate it.
material-black-plum with material-black-plum-suru icons.
sudo rc-update add mariadb ???
clearly there's a system error the devs are probably working on a fix to whatever got flummoxed on the update. we are just chatting until that happens i suppose since no one else replied before me.
see this is what you wrote
but the openrc service file is mariadb-openrc
so maybe it should be rc-service mariadb start
??
Yes, I've tried with mariadb service and it gives the exact same error. And it is already added to default runlevel.
Is the key, looks like it doesn't know what a innodb is
https://bobcares.com/blog/error-plugin-innodb-registration-as-a-storage-engine-failed/
it seems my case is different from this one, in my "my.cnf" there's already no config "local-inline=0", but I tried anyway to move the logs as suggested and it didn't solved the error...
rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1
those?
Hi,
For months now, I can't run any akonadiserver based package because of that mysql/mariadb errors.
In my case, when I run
rc-service mariadb start
it gives me:
mariadb | * Datadir '/var/lib/mysql' is empty or invalid.
mariadb | * Run '/etc/init.d/mariadb setup' to create new database.
mariadb | * ERROR: mariadb failed to start
Running this
/etc/init.d/mariadb setup
gives me:
FATAL ERROR: Could not find ./share/mysql/fill_help_tables.sql
https://www.programmerall.com/article/570013961/
is that relevant to you at all as you understand it?
I can run mariadb 10.8.3-1 under latest runit-world
$ cat /etc/runit/sv/mariadb/run
#!/bin/sh
[ ! -d /run/mysqld ] && mkdir -p /run/mysqld
chown mysql:mysql /run/mysqld
exec chpst -u mysql:mysql mysqld --user=mysql 2>&1
the message related to fill_help_tables.sql seems to indicate that the command should be run in /usr as there is certainly a file at
/usr/share/mysql/fill_help_tables.sql so if . is not /usr the indicated file would not be found.
Have you paid attention to the post install/upgrade messages?
:: 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
:: 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
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.
Thanks, this solved my problem.
However, when I check mariadb status:
$ sudo rc-service mariadb status
* status: crashed
Any help is appreciated.