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

MySQL/Mariadb stopped working after recent updates

Hello, I did an
Quote
pacman -Syu
and after that mysql service is no longer working. I use it with openrc service manager. When I run
Quote
rc-service mysql start
it fails with the errors:

Quote
sudo rc-service mysql start
Starting MariaDB.220710 09:26:18 mysqld_safe Logging to '/var/lib/mysql/artixpc.err'.
220710 09:26:18 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
./etc/init.d/mysql: line 263: kill: (6944) - No such process
/etc/init.d/mysql: line 276: log_failure_msg: command not found

and in the log /var/lib/mysql/artixpc.err I've got:

Quote
220710 09:26:18 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
2022-07-10  9:26:18 0 [Note] /usr/bin/mariadbd (server 10.8.3-MariaDB) starting as process 7049 ...
2022-07-10  9:26:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-07-10  9:26:18 0 [Note] InnoDB: Number of transaction pools: 1
2022-07-10  9:26:18 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-07-10  9:26:18 0 [Note] InnoDB: Using Linux native AIO
2022-07-10  9:26:18 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2022-07-10  9:26:18 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-10  9:26:18 0 [Note] InnoDB: File system buffers for log disabled (block size=4096 bytes)
2022-07-10  9:26:18 0 [ERROR] InnoDB: Missing FILE_CHECKPOINT(9211053) at 9211053
2022-07-10  9:26:18 0 [ERROR] InnoDB: Log scan aborted at LSN 9211053
2022-07-10  9:26:18 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-07-10  9:26:18 0 [Note] InnoDB: Starting shutdown...
2022-07-10  9:26:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-07-10  9:26:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-07-10  9:26:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-07-10  9:26:19 0 [ERROR] Aborting
220710 09:26:19 mysqld_safe mysqld from pid file /var/lib/mysql/artixpc.pid ended

Re: MySQL/Mariadb stopped working after recent updates

Reply #1 –
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.
Cat Herders of Linux
 

Re: MySQL/Mariadb stopped working after recent updates

Reply #2 –
Quote from: cat herders of linux – on
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?

Re: MySQL/Mariadb stopped working after recent updates

Reply #3 –
Quote from: 0xf4b10 – on
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.
Cat Herders of Linux

Re: MySQL/Mariadb stopped working after recent updates

Reply #4 –
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
Quote
rc-service mysql start

but the openrc service file is mariadb-openrc

so maybe it should be rc-service mariadb start

??

Cat Herders of Linux

Re: MySQL/Mariadb stopped working after recent updates

Reply #5 –
Quote from: cat herders of linux – on
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.

Re: MySQL/Mariadb stopped working after recent updates

Reply #6 –
Quote
2022-07-10  9:26:19 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-07-10  9:26:19 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-07-10  9:26:19 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Is the key, looks like it doesn't know what a innodb is

Re: MySQL/Mariadb stopped working after recent updates

Reply #9 –
Quote from: 0xf4b10 – on
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...

Code: [Select]
rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1

those?
Cat Herders of Linux

Re: MySQL/Mariadb stopped working after recent updates

Reply #11 –
Hi,

For months now, I can't run any akonadiserver based package because of that mysql/mariadb errors.

In my case, when I run
Code: [Select]
rc-service mariadb start
it gives me:

Code: [Select]
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
Code: [Select]
/etc/init.d/mariadb setup
gives me:
Code: [Select]
FATAL ERROR: Could not find ./share/mysql/fill_help_tables.sql

Re: MySQL/Mariadb stopped working after recent updates

Reply #12 –
Quote from: anoki – on
Hi,

For months now, I can't run any akonadiserver based package because of that mysql/mariadb errors.

In my case, when I run
Code: [Select]
rc-service mariadb start
it gives me:

Code: [Select]
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
Code: [Select]
/etc/init.d/mariadb setup
gives me:
Code: [Select]
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?
Cat Herders of Linux

Re: MySQL/Mariadb stopped working after recent updates

Reply #13 –
I can run mariadb 10.8.3-1 under latest runit-world
Code: [Select]
$ 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.

Re: MySQL/Mariadb stopped working after recent updates

Reply #14 –
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