[Support] Linuxserver.io - MariaDB


Recommended Posts

My mariadb no longer works after the last (?) update? If i run 'mysql' i get :

 

Warning: World-writable config file '/etc/my.cnf.d/custom.cnf' is ignored
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

 

Also several website depending on mariadb and my nextcloud is not working. This is bad...

 

How do i fix this? Can i go back to the previous version, and if yes, how?

Link to comment

ok, looks like the same issue others are having, i did not recognize it that fast.

Did the 'downgrade' (?) to linuxserver/mariadb:110.4.21mariabionic-ls31 and then to latest... as described.

Looks like it is functioning again.

 

Now making sure i do have backups of everything that uses mariadb... something i overlooked.

Edited by jowi
Link to comment

Im trying to set up a new instance of this container on a new unraid machine, but i cant access it at all...

This seems to tie in with the issues others are having, the version of this container from the Community Plugin (linuxserver/mariadb) does not allow me to login because it knows im not the same root as the system root "Access denied for user 'root'@'XXX' (using password: YES)" This is the expected behavior when remote access is disabled. As far as i understand it that's the "new" default...

 

Unfortunately that makes it very difficult for me to set up my new instance. How am i supposed to connect to it? I need to transfer a Table and Users from another instance, that's a pain to do without root privileges :(

 

The common fix of switching to linuxserver/mariadb:110.4.21mariabionic-ls31 and than back to linuxserver/mariadb:latest didn't work for me. If i do so i get error 10061.

 

In short:

How am i supposed to set this container up if i cant login from another machine?

 

 

EDIT:

Well rtfm would have saved me from a unnecessary post :)
All the info to fix my problem are on the linuxserver/mariadb Docker Hub + the MariaDB manual has all the commands listed. Turns out you can use the docker command line for that.

My mistake was to assume i could set up the new instance the same way i did the old...

Edited by Aderalia
rtfm
Link to comment

Unraid tells me there is an update for the mariadb docker, but i'm affraid to install it, since last time everything went wrong.

 

How do i know this update will be ok? Someone tried it? 

 

Is there a way to know to what version it will be updated? Is there a way to rollback?

 

Is there a way to exclude a docker from updates? At the moment, i can not update all, since i dont want mariadb to update, so i have to update all others manually one by one...

Edited by jowi
Link to comment
2 hours ago, jowi said:

Unraid tells me there is an update for the mariadb docker, but i'm affraid to install it, since last time everything went wrong.

 

How do i know this update will be ok? Someone tried it? 

 

Is there a way to know to what version it will be updated? Is there a way to rollback?

 

Is there a way to exclude a docker from updates? At the moment, i can not update all, since i dont want mariadb to update, so i have to update all others manually one by one...

You can manually specify a version for mariadb to stay on, and it will stay on it (that's what the 'fix' earlier in this thread involved).

However, the reason that things broke last update was because it moved to an Alpine base from Ubuntu. That won't happen again, so future updates should be fine (and may come with security benefits).

Edited by jademonkee
Link to comment
27 minutes ago, jowi said:

But i did the fix, and now there is an update... so it won't let me skip this update. I have to manually do ALL other updates, otherwise if i ' update all' this will update as well...

 

i will wait for confirmation from others that did the fix and applied this latest update.

Sorry, it seems you misunderstood: Step 1 of the fix was to set the tag to a manual version, step 2 was to specify the 'latest' tag, which will always pull down the latest version.

If you set the tag to the version you're currently on, it will stay on that version. Any Docker updates will just be to the related container files, not mariadb itself, so shouldn't break anything.

In saying that, I have the latest update and it's fine.

However, I didn't have a problem when I upgraded to the Alpine base (although it was suggested earlier in this thread that the errors happened only on larger DBs, as they took longer to shut down than was given by the "update" command. The tag swap 'fix' worked because it did a "shutdown" command before upgrading, which gave mariadb enough time to shut down gracefully before the update, so it gave the impression of it doing more than it really did).

Link to comment
1 hour ago, jademonkee said:

Sorry, it seems you misunderstood: Step 1 of the fix was to set the tag to a manual version, step 2 was to specify the 'latest' tag, which will always pull down the latest version.

What i did was set the version manually (i forgot what version exactly) update it, and then set it to 'latest', and get the lastest version. After that, it was working again. As i understand it, that was the fix: 1. update to version x manually, 2: update that to the latest.

 

So, how can i see what the version is i have actually installed? 

 

*edit* if i check version in mariadb itself it says : 10.5.12-MariaDB

Don't know if the docker version is something else? 

 

 

Edited by jowi
Link to comment
51 minutes ago, jowi said:

What i did was set the version manually (i forgot what version exactly) update it, and then set it to 'latest', and get the lastest version. After that, it was working again. As i understand it, that was the fix: 1. update to version x manually, 2: update that to the latest.

 

So, how can i see what the version is i have actually installed? 

 

*edit* if i check version in mariadb itself it says : 10.5.12-MariaDB

Don't know if the docker version is something else? 

 

 

You can see the available tags here:

https://hub.docker.com/r/linuxserver/mariadb/tags?page=1&ordering=last_updated

I don't know the difference between version-10.5.12-r0 and 10.5.12-r0-ls36 but maybe someone here can advise. If you swap to one of those versions, you'll stay on that version until you change the tag. (I think you may still get minor updates to the container, but not mariadb - someone will have to confirm).

In saying that, it seems that "latest" would be one of those two, so it's probably no problem updating this time as the latest image is still some variant of the 10.5.12 version you're on (or even the exact same version), and - again - the problems were because of the 'rebasing' of the image, not an update to mariadb itself. So yeah. It's probably pretty safe to update - but there's also no harm in waiting for a few more people in the thread to speak of their experience.

  • Like 1
Link to comment

I seem to have an issue with mariadb docker on unraid, not sure for how long, only noticed it when nextcloud stopped working.

 

Getting lots of errors in log

 

210928 18:59:08 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:08 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:09 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:09 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:09 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:09 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:10 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:10 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:11 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.

 

Moved .err files in /config/databases and an err file gets immediately created and this gets continuously repeated when I cat the err file.

 

210928 22:26:09 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2021-09-28 22:26:09 0 [Note] /usr/bin/mariadbd (mysqld 10.5.12-MariaDB-log) starting as process 31960 ...
2021-09-28 22:26:09 0 [Note] InnoDB: Uses event mutexes
2021-09-28 22:26:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-28 22:26:09 0 [Note] InnoDB: Number of pools: 1
2021-09-28 22:26:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-09-28 22:26:09 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2021-09-28 22:26:09 0 [Note] InnoDB: Using Linux native AIO
2021-09-28 22:26:09 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2021-09-28 22:26:09 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-28 22:26:09 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.21.
2021-09-28 22:26:09 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-09-28 22:26:09 0 [Note] InnoDB: Starting shutdown...
2021-09-28 22:26:09 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-09-28 22:26:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-09-28 22:26:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-28 22:26:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-09-28 22:26:09 0 [ERROR] Aborting

 

If I try to login with mysql -uroot -p I get

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

 

I am running mariadb:latest container.

 

Not sure what to try next, I'm keen to try to understand what's causing the issue.

 

Would appreciate some help.

 

Apologies if this is not the correct way to raise this issue.

 

Thanks

 

 

 

 

 

 

Link to comment
10 hours ago, trevaaaaaaa said:

I seem to have an issue with mariadb docker on unraid, not sure for how long, only noticed it when nextcloud stopped working.

 

Getting lots of errors in log

 

210928 18:59:08 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:08 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:09 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:09 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:09 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:09 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:10 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.
210928 18:59:10 mysqld_safe Starting mariadbd daemon with databases from /config/databases
210928 18:59:11 mysqld_safe Logging to '/config/databases/75c0cd19189c.err'.

 

Moved .err files in /config/databases and an err file gets immediately created and this gets continuously repeated when I cat the err file.

 

210928 22:26:09 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2021-09-28 22:26:09 0 [Note] /usr/bin/mariadbd (mysqld 10.5.12-MariaDB-log) starting as process 31960 ...
2021-09-28 22:26:09 0 [Note] InnoDB: Uses event mutexes
2021-09-28 22:26:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-28 22:26:09 0 [Note] InnoDB: Number of pools: 1
2021-09-28 22:26:09 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-09-28 22:26:09 0 [Note] mariadbd: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
2021-09-28 22:26:09 0 [Note] InnoDB: Using Linux native AIO
2021-09-28 22:26:09 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2021-09-28 22:26:09 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-28 22:26:09 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.21.
2021-09-28 22:26:09 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-09-28 22:26:09 0 [Note] InnoDB: Starting shutdown...
2021-09-28 22:26:09 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-09-28 22:26:09 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-09-28 22:26:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-28 22:26:09 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2021-09-28 22:26:09 0 [ERROR] Aborting

 

If I try to login with mysql -uroot -p I get

 

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

 

I am running mariadb:latest container.

 

Not sure what to try next, I'm keen to try to understand what's causing the issue.

 

Would appreciate some help.

 

Apologies if this is not the correct way to raise this issue.

 

Thanks

 

I've had the same error in my log since the Alpine re-base. Nothing is broken on my end, though (I'm only using it for a single instance of Nextcloud with 2 users). I'm pretty sure someone in this thread told me it's nothing to worry about, but I would like to know why it's happening.

 

210927 12:23:15 mysqld_safe Logging to '/config/databases/e42e52e45c78.err'.
210927 12:23:16 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

Link to comment
7 hours ago, jademonkee said:

I've had the same error in my log since the Alpine re-base. Nothing is broken on my end, though (I'm only using it for a single instance of Nextcloud with 2 users). I'm pretty sure someone in this thread told me it's nothing to worry about, but I would like to know why it's happening.

 

210927 12:23:15 mysqld_safe Logging to '/config/databases/e42e52e45c78.err'.
210927 12:23:16 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

I'm only using it for a single instance of nextcloud aswell with a couple of users. I can't login to nextcloud at all, I just get

 

"Internal Server Error The server encountered an internal error and was unable to complete your request. Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report. More details can be found in the server log."

 

I don't see any errors in nextcloud log though, I only get errors in mariadb...not sure if these errors are causing my nextcloud issue.

 

Was thinking of trying an older mariadb container as I'm sure nextcloud worked a few weeks ago.

Link to comment

Also tried the fix

 

Also getting

Quote

211001 15:31:55 mysqld_safe Logging to syslog.
211001 15:31:55 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:31:56 mysqld_safe Logging to syslog.
211001 15:31:56 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:31:58 mysqld_safe Logging to syslog.
211001 15:31:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:31:59 mysqld_safe Logging to syslog.
211001 15:31:59 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:00 mysqld_safe Logging to syslog.
211001 15:32:00 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:02 mysqld_safe Logging to syslog.
211001 15:32:02 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:03 mysqld_safe Logging to syslog.
211001 15:32:03 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:04 mysqld_safe Logging to syslog.
211001 15:32:04 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:06 mysqld_safe Logging to syslog.
211001 15:32:06 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:07 mysqld_safe Logging to syslog.
211001 15:32:07 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:08 mysqld_safe Logging to syslog.
211001 15:32:08 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:10 mysqld_safe Logging to syslog.
211001 15:32:10 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:11 mysqld_safe Logging to syslog.
211001 15:32:11 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:12 mysqld_safe Logging to syslog.
211001 15:32:12 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:14 mysqld_safe Logging to syslog.
211001 15:32:14 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:15 mysqld_safe Logging to syslog.
211001 15:32:15 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:16 mysqld_safe Logging to syslog.
211001 15:32:16 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:17 mysqld_safe Logging to syslog.
211001 15:32:17 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:19 mysqld_safe Logging to syslog.
211001 15:32:19 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:20 mysqld_safe Logging to syslog.
211001 15:32:20 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:21 mysqld_safe Logging to syslog.
211001 15:32:21 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:23 mysqld_safe Logging to syslog.
211001 15:32:23 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:24 mysqld_safe Logging to syslog.
211001 15:32:24 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:25 mysqld_safe Logging to syslog.
211001 15:32:25 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:26 mysqld_safe Logging to syslog.
211001 15:32:26 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:28 mysqld_safe Logging to syslog.
211001 15:32:28 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:29 mysqld_safe Logging to syslog.
211001 15:32:29 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:30 mysqld_safe Logging to syslog.
211001 15:32:30 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:32 mysqld_safe Logging to syslog.
211001 15:32:32 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:33 mysqld_safe Logging to syslog.
211001 15:32:33 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:34 mysqld_safe Logging to syslog.
211001 15:32:34 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:35 mysqld_safe Logging to syslog.
211001 15:32:35 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:37 mysqld_safe Logging to syslog.
211001 15:32:37 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:38 mysqld_safe Logging to syslog.
211001 15:32:38 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:39 mysqld_safe Logging to syslog.
211001 15:32:39 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:41 mysqld_safe Logging to syslog.
211001 15:32:41 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:42 mysqld_safe Logging to syslog.
211001 15:32:42 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:43 mysqld_safe Logging to syslog.
211001 15:32:43 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:45 mysqld_safe Logging to syslog.
211001 15:32:45 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:46 mysqld_safe Logging to syslog.
211001 15:32:46 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:47 mysqld_safe Logging to syslog.
211001 15:32:47 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:48 mysqld_safe Logging to syslog.
211001 15:32:48 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:50 mysqld_safe Logging to syslog.
211001 15:32:50 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:51 mysqld_safe Logging to syslog.
211001 15:32:51 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:52 mysqld_safe Logging to syslog.
211001 15:32:52 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:54 mysqld_safe Logging to syslog.
211001 15:32:54 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:55 mysqld_safe Logging to syslog.
211001 15:32:55 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:56 mysqld_safe Logging to syslog.
211001 15:32:56 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:58 mysqld_safe Logging to syslog.
211001 15:32:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:32:59 mysqld_safe Logging to syslog.
211001 15:32:59 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:00 mysqld_safe Logging to syslog.
211001 15:33:00 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:02 mysqld_safe Logging to syslog.
211001 15:33:02 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:03 mysqld_safe Logging to syslog.
211001 15:33:03 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:04 mysqld_safe Logging to syslog.
211001 15:33:04 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:06 mysqld_safe Logging to syslog.
211001 15:33:06 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:07 mysqld_safe Logging to syslog.
211001 15:33:07 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:08 mysqld_safe Logging to syslog.
211001 15:33:08 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:09 mysqld_safe Logging to syslog.
211001 15:33:10 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:11 mysqld_safe Logging to syslog.
211001 15:33:11 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:12 mysqld_safe Logging to syslog.
211001 15:33:12 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:13 mysqld_safe Logging to syslog.
211001 15:33:13 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:15 mysqld_safe Logging to syslog.
211001 15:33:15 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:16 mysqld_safe Logging to syslog.
211001 15:33:16 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:17 mysqld_safe Logging to syslog.
211001 15:33:17 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:19 mysqld_safe Logging to syslog.
211001 15:33:19 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:20 mysqld_safe Logging to syslog.
211001 15:33:20 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:21 mysqld_safe Logging to syslog.
211001 15:33:21 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:23 mysqld_safe Logging to syslog.
211001 15:33:23 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:24 mysqld_safe Logging to syslog.
211001 15:33:24 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:25 mysqld_safe Logging to syslog.
211001 15:33:25 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:26 mysqld_safe Logging to syslog.
211001 15:33:26 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:28 mysqld_safe Logging to syslog.
211001 15:33:28 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:29 mysqld_safe Logging to syslog.
211001 15:33:29 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:30 mysqld_safe Logging to syslog.
211001 15:33:30 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:32 mysqld_safe Logging to syslog.
211001 15:33:32 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:33 mysqld_safe Logging to syslog.
211001 15:33:33 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:34 mysqld_safe Logging to syslog.
211001 15:33:34 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:36 mysqld_safe Logging to syslog.
211001 15:33:36 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:37 mysqld_safe Logging to syslog.
211001 15:33:37 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:38 mysqld_safe Logging to syslog.
211001 15:33:38 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:39 mysqld_safe Logging to syslog.
211001 15:33:39 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:41 mysqld_safe Logging to syslog.
211001 15:33:41 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:42 mysqld_safe Logging to syslog.
211001 15:33:42 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:43 mysqld_safe Logging to syslog.
211001 15:33:43 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:45 mysqld_safe Logging to syslog.
211001 15:33:45 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:46 mysqld_safe Logging to syslog.
211001 15:33:46 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:47 mysqld_safe Logging to syslog.
211001 15:33:47 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:49 mysqld_safe Logging to syslog.
211001 15:33:49 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:50 mysqld_safe Logging to syslog.
211001 15:33:50 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:51 mysqld_safe Logging to syslog.
211001 15:33:51 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:52 mysqld_safe Logging to syslog.
211001 15:33:52 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:54 mysqld_safe Logging to syslog.
211001 15:33:54 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:55 mysqld_safe Logging to syslog.
211001 15:33:55 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:56 mysqld_safe Logging to syslog.
211001 15:33:56 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:58 mysqld_safe Logging to syslog.
211001 15:33:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:33:59 mysqld_safe Logging to syslog.
211001 15:33:59 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:00 mysqld_safe Logging to syslog.
211001 15:34:00 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:01 mysqld_safe Logging to syslog.
211001 15:34:01 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:03 mysqld_safe Logging to syslog.
211001 15:34:03 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:04 mysqld_safe Logging to syslog.
211001 15:34:04 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:06 mysqld_safe Logging to syslog.
211001 15:34:06 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:07 mysqld_safe Logging to syslog.
211001 15:34:07 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:08 mysqld_safe Logging to syslog.
211001 15:34:08 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:09 mysqld_safe Logging to syslog.
211001 15:34:09 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:11 mysqld_safe Logging to syslog.
211001 15:34:11 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:12 mysqld_safe Logging to syslog.
211001 15:34:12 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:13 mysqld_safe Logging to syslog.
211001 15:34:13 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:15 mysqld_safe Logging to syslog.
211001 15:34:15 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:16 mysqld_safe Logging to syslog.
211001 15:34:16 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:17 mysqld_safe Logging to syslog.
211001 15:34:17 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:19 mysqld_safe Logging to syslog.
211001 15:34:19 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:20 mysqld_safe Logging to syslog.
211001 15:34:20 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:21 mysqld_safe Logging to syslog.
211001 15:34:21 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:23 mysqld_safe Logging to syslog.
211001 15:34:23 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:24 mysqld_safe Logging to syslog.
211001 15:34:24 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:25 mysqld_safe Logging to syslog.
211001 15:34:25 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:26 mysqld_safe Logging to syslog.
211001 15:34:26 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:28 mysqld_safe Logging to syslog.
211001 15:34:28 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:29 mysqld_safe Logging to syslog.
211001 15:34:29 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:30 mysqld_safe Logging to syslog.
211001 15:34:30 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:32 mysqld_safe Logging to syslog.
211001 15:34:32 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:33 mysqld_safe Logging to syslog.
211001 15:34:33 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:34 mysqld_safe Logging to syslog.
211001 15:34:34 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:35 mysqld_safe Logging to syslog.
211001 15:34:36 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:37 mysqld_safe Logging to syslog.
211001 15:34:37 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:38 mysqld_safe Logging to syslog.
211001 15:34:38 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:39 mysqld_safe Logging to syslog.
211001 15:34:39 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:41 mysqld_safe Logging to syslog.
211001 15:34:41 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:42 mysqld_safe Logging to syslog.
211001 15:34:42 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:43 mysqld_safe Logging to syslog.
211001 15:34:43 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:45 mysqld_safe Logging to syslog.
211001 15:34:45 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:46 mysqld_safe Logging to syslog.
211001 15:34:46 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:47 mysqld_safe Logging to syslog.
211001 15:34:47 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:48 mysqld_safe Logging to syslog.
211001 15:34:48 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:50 mysqld_safe Logging to syslog.
211001 15:34:50 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:51 mysqld_safe Logging to syslog.
211001 15:34:51 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:52 mysqld_safe Logging to syslog.
211001 15:34:52 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:54 mysqld_safe Logging to syslog.
211001 15:34:54 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:55 mysqld_safe Logging to syslog.
211001 15:34:55 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:56 mysqld_safe Logging to syslog.
211001 15:34:56 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:58 mysqld_safe Logging to syslog.
211001 15:34:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:34:59 mysqld_safe Logging to syslog.
211001 15:34:59 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:00 mysqld_safe Logging to syslog.
211001 15:35:00 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:02 mysqld_safe Logging to syslog.
211001 15:35:02 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:03 mysqld_safe Logging to syslog.
211001 15:35:03 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:04 mysqld_safe Logging to syslog.
211001 15:35:04 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:05 mysqld_safe Logging to syslog.
211001 15:35:05 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:07 mysqld_safe Logging to syslog.
211001 15:35:07 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:08 mysqld_safe Logging to syslog.
211001 15:35:08 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:09 mysqld_safe Logging to syslog.
211001 15:35:09 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:11 mysqld_safe Logging to syslog.
211001 15:35:11 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:12 mysqld_safe Logging to syslog.
211001 15:35:12 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:13 mysqld_safe Logging to syslog.
211001 15:35:13 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:15 mysqld_safe Logging to syslog.
211001 15:35:15 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:16 mysqld_safe Logging to syslog.
211001 15:35:16 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:17 mysqld_safe Logging to syslog.
211001 15:35:17 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:18 mysqld_safe Logging to syslog.
211001 15:35:18 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:20 mysqld_safe Logging to syslog.
211001 15:35:20 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:21 mysqld_safe Logging to syslog.
211001 15:35:21 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:22 mysqld_safe Logging to syslog.
211001 15:35:22 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:23 mysqld_safe Logging to syslog.
211001 15:35:23 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:25 mysqld_safe Logging to syslog.
211001 15:35:25 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:26 mysqld_safe Logging to syslog.
211001 15:35:26 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:27 mysqld_safe Logging to syslog.
211001 15:35:27 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:29 mysqld_safe Logging to syslog.
211001 15:35:29 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:30 mysqld_safe Logging to syslog.
211001 15:35:30 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:31 mysqld_safe Logging to syslog.
211001 15:35:31 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:32 mysqld_safe Logging to syslog.
211001 15:35:32 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:34 mysqld_safe Logging to syslog.
211001 15:35:34 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:35 mysqld_safe Logging to syslog.
211001 15:35:35 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:36 mysqld_safe Logging to syslog.
211001 15:35:36 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:38 mysqld_safe Logging to syslog.
211001 15:35:38 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:39 mysqld_safe Logging to syslog.
211001 15:35:39 mysqld_safe Starting mysqld daemon with databases from /config/databases
211001 15:35:4

 

Cannot connect using phpmyadmin, nextcloud, lychee or anything else that uses the mariadb.  Is this thing forked?

 

Ran the following from the docker:

Quote

# mysqld status
2021-10-01 15:43:56 0 [Note] mysqld (mysqld 10.4.21-MariaDB-1:10.4.21+maria~bionic-log) starting as process 9578 ...
2021-10-01 15:43:56 0 [ERROR] mysqld: Can't lock aria control file '/config/databases/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
2021-10-01 15:43:59 0 [Note] InnoDB: Using Linux native AIO
2021-10-01 15:43:59 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-10-01 15:43:59 0 [Note] InnoDB: Uses event mutexes
2021-10-01 15:43:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-10-01 15:43:59 0 [Note] InnoDB: Number of pools: 1
2021-10-01 15:43:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-10-01 15:43:59 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-10-01 15:43:59 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2021-10-01 15:43:59 0 [Note] InnoDB: Completed initialization of buffer pool
2021-10-01 15:43:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-10-01 15:43:59 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.5.12.
2021-10-01 15:43:59 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-10-01 15:44:00 0 [Note] InnoDB: Starting shutdown...
2021-10-01 15:44:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-10-01 15:44:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-10-01 15:44:00 0 [Note] Plugin 'FEEDBACK' is disabled.
mysqld: Too many arguments (first extra is 'status').
2021-10-01 15:44:00 0 [ERROR] Aborting

 

Edited by eds
added additional command
Link to comment

Just to make it clear, if anyone is having issues with the update to the latest version of mariadb. It's due to your database corrupting as your previous container wasn't shutdown cleanly (Something using during an update / automatic updates killing the container early). To recover your database, do the following with -all- containers that use mariadb off:

 

Try the `linuxserver/mariadb:version-110.4.21mariabionic` tag, let everything start up, check the logs to make sure it's all clean, then do `docker exec nextclouddb s6-svc -d /var/run/s6/services/mariadb/` (assuming your container is called nexclouddb, otherwise adjust that appropriately). Wait ~30 seconds and then stop the container and update to latest.

 

If this doesn't work, you will need to restore a working backup.

Link to comment
16 hours ago, j0nnymoe said:

Just to make it clear, if anyone is having issues with the update to the latest version of mariadb. It's due to your database corrupting as your previous container wasn't shutdown cleanly (Something using during an update / automatic updates killing the container early). To recover your database, do the following with -all- containers that use mariadb off:

 

Try the `linuxserver/mariadb:version-110.4.21mariabionic` tag, let everything start up, check the logs to make sure it's all clean, then do `docker exec nextclouddb s6-svc -d /var/run/s6/services/mariadb/` (assuming your container is called nexclouddb, otherwise adjust that appropriately). Wait ~30 seconds and then stop the container and update to latest.

 

If this doesn't work, you will need to restore a working backup.

I was going to try this but I don't have a mariadb directory in /var/run/s6/services/ of my nextcloud container.

Link to comment

Yes, and thanks again, but i wanted to follow your advice and wait for some more confirmations. 

 

But it doesn't look anyone else will respond. I decided to do it anyway. I've backupped the db data just to be sure, and did the update, all looks well.

Edited by jowi
  • Like 1
Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.