maria-discuss team mailing list archive

[Jogchum Reitsma <jogchum.reitsma@xxxxxxxxx>]

Hi,

I am on OpenSuse Tumbleweed, rolling distro.

Since some snapshots of Tumbleweed my mariadb does not start at system 
start. I don't use the mariadb databases a lot, so I didn't notice it 
immediately. Hence I'm  unsure when the problem occurred first time.

When trying to start it manually, I got the message

[ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was 
created with MariaDB 10.5.8.

Searching that message, I saw a post on 
https://bbs.archlinux.org/viewtopic.php?id=259364

Like me, he had a non-default location for the databases configured in 
/etc/my.cnf.

The solution that worked for him was to change that to another location 
in my.cnf, starting the database (which now succeeded), and copy the 
existing databases to that new location.

So I decided to mimic that: commented out the existing database 
location, entered an new one, and started the database server (as root) with

systemctl start mariadb

After a while, the new location is created (owned by mysql:root) and 
populated:

l mysql_recover
totaal 111048
drwx------   6 mysql   root        243  2 okt 21:33 ./
drwxr-xr-x 225 jogchum users     16384  2 okt 21:26 ../
-rw-rw----   1 mysql   mysql    417792  2 okt 21:27 aria_log.00000001
-rw-rw----   1 mysql   mysql        52  2 okt 21:27 aria_log_control
-rw-rw----   1 mysql   mysql       942  2 okt 21:27 ib_buffer_pool
-rw-rw----   1 mysql   mysql  12582912  2 okt 21:27 ibdata1
-rw-rw----   1 mysql   mysql 100663296  2 okt 21:27 ib_logfile0
drwx------   2 mysql   mysql      4096  2 okt 21:27 mysql/
-rw-rw----   1 root    root         14  2 okt 21:27 mysql_upgrade_info
drwx------   2 mysql   mysql        28  2 okt 21:27 performance_schema/
drwx------   2 mysql   mysql      8192  2 okt 21:27 sys/
drwx------   2 mysql   mysql        28  2 okt 21:27 test/

But unlike the posting at bbs.archlinux.org just mentioned, the server 
crashed again, now with the following messages in journalctl:

#################################################################################

journalctl -xeu mariadb.service

 A start job for unit mariadb.service has finished with a failure.

 The job identifier is 2782226 and the job result is failed.
okt 02 21:20:47 linux-mkay systemd[1]: Starting MariaDB database server...
 Subject: A start job for unit mariadb.service has begun execution
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

 A start job for unit mariadb.service has begun execution.

 The job identifier is 2790830.
okt 02 21:20:47 linux-mkay mysql-systemd-helper[44977]: 2022-10-02 
21:20:47 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as 
process 44977 ...
okt 02 21:20:48 linux-mkay systemd[1]: mariadb.service: Main process 
exited, code=exited, status=1/FAILURE
 Subject: Unit process exited
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

 An ExecStart= process belonging to unit mariadb.service has exited.

 The process' exit code is 'exited' and its exit status is 1.
okt 02 21:20:48 linux-mkay systemd[1]: mariadb.service: Failed with 
result 'exit-code'.
 Subject: Unit failed
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

 The unit mariadb.service has entered the 'failed' state with result 
'exit-code'.
okt 02 21:20:48 linux-mkay systemd[1]: Failed to start MariaDB database 
server.
 Subject: A start job for unit mariadb.service has failed
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

 A start job for unit mariadb.service has finished with a failure.

 The job identifier is 2790830 and the job result is failed.
okt 02 21:26:55 linux-mkay systemd[1]: Starting MariaDB database server...
 Subject: A start job for unit mariadb.service has begun execution
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

 A start job for unit mariadb.service has begun execution.

 The job identifier is 2792404.
okt 02 21:26:55 linux-mkay mysql-systemd-helper[45372]: Creating MySQL 
privilege database...
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Two 
all-privilege accounts were created.
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: One is 
root@localhost, it has no password, but you need to
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: be system 'root' 
user to connect. Use, for example, sudo mysql
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: The second is 
mysql@localhost, it has no password either, but
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: you need to be 
the system 'mysql' user to connect.
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: After connecting 
you can set the password, if you would need to be
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: able to connect 
as any of these users with a password and without sudo
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: See the MariaDB 
Knowledgebase at https://mariadb.com/kb
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Please report 
any problems at https://mariadb.org/jira
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: The latest 
information about MariaDB is available at https://mariadb.org/.
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: Consider joining 
MariaDB's strong and vibrant community:
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45384]: 
https://mariadb.org/get-involved/
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: 2022-10-02 
21:27:17 0 [Note] /usr/sbin/mysqld (server 10.8.3-MariaDB) starting as 
process 45468 ...
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: 2022-10-02 
21:27:17 0 [Warning] Can't create test file 
/home/jogchum/mysql_recover/linux-mkay.lower-test
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: [103B blob data]
okt 02 21:27:17 linux-mkay mysql-systemd-helper[45468]: 2022-10-02 
21:27:17 0 [ERROR] Aborting
okt 02 21:27:17 linux-mkay systemd[1]: mariadb.service: Main process 
exited, code=exited, status=1/FAILURE
 Subject: Unit process exited
 Defined-By: systemd
 Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel

############################################################################################

Anyone an idea why /home/jogchum/mysql_recover/linux-mkay.lower-test 
can't be created and how to solve that?

Thanks in advance!

regards, Jogchum