Tucubanito07 Posted September 2, 2021 Share Posted September 2, 2021 So what I am seeing is to change the tag to :latest and update it that way and make sure Nextcloud is stopped. Quote Link to comment
jowi Posted September 3, 2021 Share Posted September 3, 2021 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? Quote Link to comment
jowi Posted September 3, 2021 Share Posted September 3, 2021 (edited) 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 September 3, 2021 by jowi Quote Link to comment
jowi Posted September 9, 2021 Share Posted September 9, 2021 It has been working good for the last few days. But i'm worried about the next time unraid wants to update mariadb... is there any news if this will continue to be a problem? Or should we export the db etc and install a new, different mariadb docker? 1 Quote Link to comment
Aderalia Posted September 13, 2021 Share Posted September 13, 2021 (edited) 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 September 13, 2021 by Aderalia rtfm Quote Link to comment
Boyturtle Posted September 14, 2021 Share Posted September 14, 2021 On 8/26/2021 at 1:36 AM, goosetrousers said: I did this, everything worked again. Then I updated to linuxserver/mariadb:latest and everything continued to work, but with an Alpine base. Saved me from migrating, I guess I'll sit on my backups and see how this plays out. This seems to be working for me too. Cheers Quote Link to comment
hamish_18 Posted September 16, 2021 Share Posted September 16, 2021 Thanks for this! Fixed me up as well. Quote Link to comment
jowi Posted September 23, 2021 Share Posted September 23, 2021 (edited) 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 September 23, 2021 by jowi Quote Link to comment
jademonkee Posted September 23, 2021 Share Posted September 23, 2021 (edited) 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 September 23, 2021 by jademonkee Quote Link to comment
jowi Posted September 23, 2021 Share Posted September 23, 2021 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. Quote Link to comment
jademonkee Posted September 23, 2021 Share Posted September 23, 2021 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). Quote Link to comment
jowi Posted September 23, 2021 Share Posted September 23, 2021 (edited) 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 September 23, 2021 by jowi Quote Link to comment
jademonkee Posted September 23, 2021 Share Posted September 23, 2021 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. 1 Quote Link to comment
trevaaaaaaa Posted September 28, 2021 Share Posted September 28, 2021 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 Quote Link to comment
JonathanM Posted September 28, 2021 Share Posted September 28, 2021 1 hour ago, siddonj said: My Mariadb Docker reboots everyday at 03:02. Why? Do you have it set to backup with CA Backup? Quote Link to comment
jademonkee Posted September 29, 2021 Share Posted September 29, 2021 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 Quote Link to comment
trevaaaaaaa Posted September 29, 2021 Share Posted September 29, 2021 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. Quote Link to comment
jowi Posted September 30, 2021 Share Posted September 30, 2021 Anyone yet that can confirm that updating a previously 'fixed' mariadb (manually fixed to v10.5.12) can be succesfully updated to the latest version? Quote Link to comment
jowi Posted October 1, 2021 Share Posted October 1, 2021 How can i find out what exact version is installed anyway? If i know, i could do the update, and if it fails, revert back to my previous (current) version. Quote Link to comment
eds Posted October 1, 2021 Share Posted October 1, 2021 (edited) 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 October 1, 2021 by eds added additional command Quote Link to comment
j0nnymoe Posted October 1, 2021 Share Posted October 1, 2021 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. Quote Link to comment
jowi Posted October 2, 2021 Share Posted October 2, 2021 I have now asked 4 times in the last few weeks if ANYONE has issues after applying the fix a few weeks ago, and applying recent updates. Sadly, no response at all? Really? Quote Link to comment
trevaaaaaaa Posted October 2, 2021 Share Posted October 2, 2021 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. Quote Link to comment
jademonkee Posted October 4, 2021 Share Posted October 4, 2021 On 10/2/2021 at 10:35 AM, jowi said: I have now asked 4 times in the last few weeks if ANYONE has issues after applying the fix a few weeks ago, and applying recent updates. Sadly, no response at all? Really? I responded, and shall again: I have had no issues. Quote Link to comment
jowi Posted October 4, 2021 Share Posted October 4, 2021 (edited) 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 October 4, 2021 by jowi 1 Quote Link to comment
Recommended Posts
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.