[Support] Linuxserver.io - MariaDB


Recommended Posts

Thanks, just found that info also :)

 

So this is what I have done so far;

 

Copied over the two most recent xbmc DB's using MC to appdata\mariadb

 

docker exec -it mariadb /bin/bash

mysql -u root –p

Enter password

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';  and press return

GRANT ALL ON *.* TO 'xbmc';  and press return

Close out the command line tool with \q

Close out the docker with \q

 

I can now connect via my MySQL app on my mac using the xbmc user and see the two xbmc DB's I copied over.

 

Just started my Kodi on AppleTV but it's not seeing the DB so I have some more work to do to find out why.

 

I think I'm on the right path....

 

Link to comment
  • 1 month later...

I just ran the updater the other day to the latest version and now NextCloud fails saying the MySQL server has gone away. When I check the MariaDB logs it is filled and continuing to scroll this:

 

180318 16:49:32 mysqld_safe Logging to syslog.
180318 16:49:32 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:36 mysqld_safe Logging to syslog.
180318 16:49:36 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:36 mysqld_safe Logging to syslog.
180318 16:49:36 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:39 mysqld_safe Logging to syslog.
180318 16:49:39 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:42 mysqld_safe Logging to syslog.
180318 16:49:42 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:42 mysqld_safe Logging to syslog.
180318 16:49:42 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:45 mysqld_safe Logging to syslog.
180318 16:49:45 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:48 mysqld_safe Logging to syslog.
180318 16:49:48 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:51 mysqld_safe Logging to syslog.
180318 16:49:51 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:55 mysqld_safe Logging to syslog.
180318 16:49:55 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:55 mysqld_safe Logging to syslog.
180318 16:49:55 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:58 mysqld_safe Logging to syslog.
180318 16:49:58 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:50:01 mysqld_safe Logging to syslog.
180318 16:50:01 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:50:01 mysqld_safe Logging to syslog.
180318 16:50:01 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:50:04 mysqld_safe Logging to syslog.
180318 16:50:04 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:50:07 mysqld_safe Logging to syslog.
180318 16:50:07 mysqld_safe Starting mysqld daemon with databases from /config/databases

Any ideas on what may have gone wrong and how to fix?

 

Link to comment

Thanks for the tip.

 

Hmm, somehow MariaDB was missed in my backups. I tried option 2 but there was no change.

 

Can I just re-install the docker or will I need to do Nextcloud as well? If I leave my NextCloud data in place, will I lose information doing this or will I need to re-import my files once I get NextCloud working again?

Link to comment
7 hours ago, klingon00 said:

Thanks for the tip.

 

Hmm, somehow MariaDB was missed in my backups. I tried option 2 but there was no change.

 

Can I just re-install the docker or will I need to do Nextcloud as well? If I leave my NextCloud data in place, will I lose information doing this or will I need to re-import my files once I get NextCloud working again?

When I had all these problems with the MariaDB I've discovered it was a faulty SSD cache, that was corrupting the databases

 

Link to comment
17 hours ago, byographic said:

When I had all these problems with the MariaDB I've discovered it was a faulty SSD cache, that was corrupting the databases

 

That may be my problem. My appdata share is residing on the SSD cache. What was faulty about it and what did you do to resolve the issue?

Link to comment
7 hours ago, klingon00 said:

That may be my problem. My appdata share is residing on the SSD cache. What was faulty about it and what did you do to resolve the issue?

if I remember it correctly I've:

- run the mover

- stop the array

- selected "none" instead of the cache drive in the cache section

- restart the array

 

however, on this topic, there is an official explanation: https://lime-technology.com/forums/topic/46802-faq-for-unraid-v6/?tab=comments#comment-480418

Link to comment
  • 3 weeks later...

Hey, 

 

just doing some springcleaning of my box and I see it is recommended to use MariaDB from either linuxserver's or binhex's repo (according to the 'Fix common problems' plugin)

I'm currently running my kodi and owncloud database on this docker (from needo's repo), are there any procedure to safely migrate my databases over to a new docker ? 

Beeing used to some light MSSQL management from work but mySQL is the much of the same but quite different :) 

Link to comment

MariaDB docker says there is an update. I have updated, but it still shows update available. 

 

Pulling image: linuxserver/mariadb:latest
IMAGE ID [latest]: Pulling from linuxserver/mariadb. 
IMAGE ID [9be5c6869873]: Pulling fs layer. Downloading 100% of 41 MB. Download complete. Extracting. 
IMAGE ID [b954adc8b2ea]: Pulling fs layer. Downloading 100% of 817 B. Download complete. 
IMAGE ID [7417f525481d]: Pulling fs layer. Download complete. 
IMAGE ID [4e3280041f03]: Pulling fs layer. Download complete. 
IMAGE ID [e26640012edf]: Pulling fs layer. Downloading 100% of 163 B. Verifying Checksum. Download complete. 
IMAGE ID [43e4d6ff98e1]: Pulling fs layer. Download complete. 
IMAGE ID [3dd04afd22dd]: Pulling fs layer. Downloading 100% of 14 MB. Verifying Checksum. Download complete. 
IMAGE ID [1ed2672d3116]: Pulling fs layer. Downloading 100% of 450 B. Download complete. 
IMAGE ID [a1d0ddccc53e]: Pulling fs layer. Downloading 100% of 68 MB. Verifying Checksum. Download complete. 
IMAGE ID [242f2575c5e6]: Pulling fs layer. Downloading 100% of 4 KB. Verifying Checksum. Download complete. 
TOTAL DATA PULLED: 123 MB

Stopping container: mariadb
Successfully stopped container 'mariadb'

Removing container: mariadb
Successfully removed container 'mariadb'

Command:
root@localhost:# /usr/local/emhttp/plugins/dynamix.docker.manager/scripts/docker run -d --name='mariadb' --net='bridge' -e TZ="America/Chicago" -e HOST_OS="unRAID" -e 'PUID'='99' -e 'PGID'='100' -e 'MYSQL_ROOT_PASSWORD'='x' -p '3306:3306/tcp' -v '/mnt/cache/appdata/mariadb':'/config':'rw' 'linuxserver/mariadb'
9cde2120a29827974f3a064185370dc9954d1e779306c3b3d759a9372e55da75

The command finished successfully!

 

Link to comment
2 hours ago, Encino Stan said:

MariaDB docker says there is an update. I have updated, but it still shows update available. 

 


Pulling image: linuxserver/mariadb:latest
IMAGE ID [latest]: Pulling from linuxserver/mariadb. 
IMAGE ID [9be5c6869873]: Pulling fs layer. Downloading 100% of 41 MB. Download complete. Extracting. 
IMAGE ID [b954adc8b2ea]: Pulling fs layer. Downloading 100% of 817 B. Download complete. 
IMAGE ID [7417f525481d]: Pulling fs layer. Download complete. 
IMAGE ID [4e3280041f03]: Pulling fs layer. Download complete. 
IMAGE ID [e26640012edf]: Pulling fs layer. Downloading 100% of 163 B. Verifying Checksum. Download complete. 
IMAGE ID [43e4d6ff98e1]: Pulling fs layer. Download complete. 
IMAGE ID [3dd04afd22dd]: Pulling fs layer. Downloading 100% of 14 MB. Verifying Checksum. Download complete. 
IMAGE ID [1ed2672d3116]: Pulling fs layer. Downloading 100% of 450 B. Download complete. 
IMAGE ID [a1d0ddccc53e]: Pulling fs layer. Downloading 100% of 68 MB. Verifying Checksum. Download complete. 
IMAGE ID [242f2575c5e6]: Pulling fs layer. Downloading 100% of 4 KB. Verifying Checksum. Download complete. 
TOTAL DATA PULLED: 123 MB

Stopping container: mariadb
Successfully stopped container 'mariadb'

Removing container: mariadb
Successfully removed container 'mariadb'

Command:
root@localhost:# /usr/local/emhttp/plugins/dynamix.docker.manager/scripts/docker run -d --name='mariadb' --net='bridge' -e TZ="America/Chicago" -e HOST_OS="unRAID" -e 'PUID'='99' -e 'PGID'='100' -e 'MYSQL_ROOT_PASSWORD'='x' -p '3306:3306/tcp' -v '/mnt/cache/appdata/mariadb':'/config':'rw' 'linuxserver/mariadb'
9cde2120a29827974f3a064185370dc9954d1e779306c3b3d759a9372e55da75

The command finished successfully!

 

 

 

that sounds like an unraid problem to me 

Link to comment
On 19.03.2018 at 12:35 PM, byographic said:

When I had all these problems with the MariaDB I've discovered it was a faulty SSD cache, that was corrupting the databases

On 20.03.2018 at 5:59 AM, klingon00 said:

That may be my problem. My appdata share is residing on the SSD cache. What was faulty about it and what did you do to resolve the issue?

I have the same problem. How can I understand that my cache SSDs are faulty?

 

And what should I do considering I don't backup. It seems, if this problem is associated with the db files, there is no point in deleting the mariadb docker and install again. 

Link to comment

I have seen some other posts in this thread with the below problem:

180318 16:49:39 mysqld_safe Starting mysqld daemon with databases from /config/databases
180318 16:49:42 mysqld_safe Logging to syslog.

It is said that this problem is related to an unclean shutdown from which I normally avoid. May I ask how often do users of this container face with this problem? If an "unclean" shutdown corrupts the mariadb so easily, perhaps it is better to use mariadb in a VM at a production setting.

 

Opinions please. Thank you.

Edited by sse450
Link to comment

Hi All, I want to make sure I'm doing this correctly.

 

New MariaDB install that i want to use for Nextcloud for now, and possibly more in the future.

 

I have HeidiSQL on my Windows box that I can manage the DBs with. 

I was going to create a separate user that is NOT root as I understand this is the right way to do things?

e.g. create a "nextcloud" user and a "nextcloud" database.

 

My question is what privileges does that user need and how do I grant them just to that one database?

 

Thanks.

Link to comment
  • 3 weeks later...

Everytime CA Backup stopping and starting dockers affects nextcloud I google "unraid hulk smash" to get back here to fix it.

 

I may never remember how to get a shell prompt in my docker and then do # mysqld --tc-heuristic-recover commit

I may never forget:  "hulk smash"   

 

Thanks chaosratt.

 

On 12/1/2017 at 9:45 PM, chaosratt said:

I just wanted to chime in here on a fix for the the container seeming to not start properly.

 

There's no need to do a full appdata rollback usually.

 

Log into the container: docker exec -ti mariadb /bin/bash

 

run mysqld from the commandline and you'll get a full dump of what's wrong. It's likely *not* a corrupt database, but rather a transaction stuck in a partially completed state

Your choice is to "hulk smash" the partial transaction through, or revert it like it never happened. Both have potential consequences.

 

mysqld --tc-heuristic-recover commit

or

mysqld --tc-heuristic-recover rollback

 

Also, you have backups, right?

 

  • Upvote 1
Link to comment
On 4/27/2018 at 12:45 PM, dimes007 said:

Everytime CA Backup stopping and starting dockers affects nextcloud

You can set CA Backup to not stop certain applications (Advanced Settings) before backing them up.  Whether or not this affects the app in question depends.  In my case, since there's no access to my db when the backup runs, I don't have any problems with leaving it running.

Link to comment
  • 2 weeks later...

Hi,

 

Will lsio be upgrading this container to 10.2 or maybe adding a new one for 10.2? There are some window functions I'm using in a project that I'd like to run on my unRAID server and would rather use an lsio docker but could roll my own if needed

 

https://mariadb.com/kb/en/library/window-functions/

Link to comment

I get odd files in my database folder. DLL files and ~ files. I can remove them, but they always come back. MariaDB doesn't need these files to work, so I am not sure what they are or where they come from. I am only using Kodi with MariaDB. Does anyone else get these files?

files.JPG

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.