DB Suddenly no longer working

[mtthidoteu]

Hello! So I have had NGINX Reverse Proxy Manager working flawlessly for weeks/months. However, recently the admin page has been not working and my container has been unhealthy. Upon looking at the logs, it seems that the Database is no longer accessible. The hosts thankfully continue to run. Upon looking at the Database container, it seems to no longer be getting any IP and is looping with the following message;

[i] pre-init.d - processing /scripts/pre-init.d/01_secret-init.sh

[i] mysqld already present, skipping creation

[i] MySQL directory already present, skipping creation

2021-07-09 12:36:57 0 [Note] /usr/bin/mysqld (mysqld 10.4.15-MariaDB) starting as process 1 ...

Cannot find checkpoint record at LSN (1,0x2cdf8c)

2021-07-09 12:36:57 0 [ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files

2021-07-09 12:36:57 0 [ERROR] Plugin 'Aria' init function returned error.

2021-07-09 12:36:57 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

2021-07-09 12:36:57 0 [Note] Plugin 'InnoDB' is disabled.

2021-07-09 12:36:57 0 [Note] Plugin 'FEEDBACK' is disabled.

2021-07-09 12:36:57 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded

2021-07-09 12:36:57 0 [ERROR] Failed to initialize plugins.

It is looping over and over. I have not "touched" the container and this issue has suddenly started. Any ideas? Thank you

[TheSamDickey]

All my websites went down after updating all my containers. My database is also not accessible.

Here is the repeating error showing up in my database:

[cont-init.d] executing container initialization scripts...
[cont-init.d] 01_perms.sh: executing...
Changing ownership of /data/logs to 0:0
[cont-init.d] 01_perms.sh: exited 0.
[cont-init.d] 01_s6-secret-init.sh: executing...
[cont-init.d] 01_s6-secret-init.sh: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
Generating dummy SSL certificate...
Generating a RSA private key
........................+++++
...+++++
writing new private key to '/data/nginx/dummykey.pem'
-----
Complete
❯ Enabling IPV6 in hosts: /etc/nginx/conf.d
❯ /etc/nginx/conf.d/default.conf
❯ /etc/nginx/conf.d/include/assets.conf
❯ /etc/nginx/conf.d/include/block-exploits.conf
❯ /etc/nginx/conf.d/include/force-ssl.conf
❯ /etc/nginx/conf.d/include/ip_ranges.conf
❯ /etc/nginx/conf.d/include/letsencrypt-acme-challenge.conf
❯ /etc/nginx/conf.d/include/proxy.conf
WARNING: NODE_ENV value of 'production' did not match any deployment config file names.
WARNING: See https://github.com/lorenwest/node-config/wiki/Strict-Mode
❯ /etc/nginx/conf.d/include/ssl-ciphers.conf
❯ /etc/nginx/conf.d/include/resolvers.conf
❯ /etc/nginx/conf.d/production.conf
❯ Enabling IPV6 in hosts: /data/nginx
[9/15/2021] [5:21:44 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:21:50 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:21:56 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:22:02 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:22:08 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:22:14 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:22:14 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:22:20 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db
[9/15/2021] [5:22:20 PM] [Global ] › ✖ error getaddrinfo ENOTFOUND db

I've tried installing fresh and creating a fresh volume, but it doesn't write any files at all. I'm not sure what the issue is.

[gsteenss]

switching the db image to mariadb:latest fixed this issue for me.

[KhizerShareef]

switching the db image to mariadb:latest fixed this issue for me.

for me I removed the "latest" from

image: 'jc21/mariadb-aria:latest'

to

image: 'jc21/mariadb-aria'

helped. I was logged in as root but it was still wasn't allowing to change the user and I kept getting this error

ERROR 1018 (HY000): Can't read dir of './npm/' (errno: 13 "Permission denied")

I am guessing the new image has some issues? I hope someone gets back to me about this because I don't want to stay on a older version and get attacked for some vulnerability.