[Support] Linuxserver.io - MariaDB


Recommended Posts

How do I migrate to the alpine image:

******************************************************
******************************************************
* *
* *
* This image will soon be rebased *
* from ubuntu to alpine. *
* Please be aware, this may cause issues *
* It is strongly recommended to make backups *
* of your config and databases before *
* updating your image to the alpine base. *
* *
* *
******************************************************
******************************************************

 

  • Like 1
Link to comment
2 hours ago, 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 worked for me as well.

Link to comment

I updated this morning and have this in the logs:

Quote

User uid: 99
User gid: 100
-------------------------------------

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 30-config: executing...
[cont-init.d] 30-config: exited 0.
[cont-init.d] 40-initialise-db: executing...
[cont-init.d] 40-initialise-db: exited 0.
[cont-init.d] 90-custom-folders: executing...
[cont-init.d] 90-custom-folders: exited 0.
[cont-init.d] 99-custom-files: executing...
[custom-init] no custom files found exiting...
[cont-init.d] 99-custom-files: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
210826 10:05:52 mysqld_safe Logging to '/config/databases/98571c4a56a9.err'.
210826 10:05:52 mysqld_safe Starting mariadbd daemon with databases from /config/databases

It's not adding any extra lines (like, they're not repeating), and Swag + NextCloud are working fine (the only things that use it - and I don't even remeber if they both do, or just NC... heh)). Is that safe mode anything to worry about? Or is it all good?

Link to comment
8 hours ago, 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 worked for me too. 

 

7 minutes ago, jademonkee said:

I updated this morning and have this in the logs:

It's not adding any extra lines (like, they're not repeating), and Swag + NextCloud are working fine (the only things that use it - and I don't even remeber if they both do, or just NC... heh)). Is that safe mode anything to worry about? Or is it all good?

 

After the "fix" I have the same logs:

 

[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 30-config: executing...
[cont-init.d] 30-config: exited 0.
[cont-init.d] 40-initialise-db: executing...
[cont-init.d] 40-initialise-db: exited 0.
[cont-init.d] 90-custom-folders: executing...
[cont-init.d] 90-custom-folders: exited 0.
[cont-init.d] 99-custom-files: executing...
[custom-init] no custom files found exiting...
[cont-init.d] 99-custom-files: exited 0.
[cont-init.d] done.
[services.d] starting services
[services.d] done.
210826 10:27:08 mysqld_safe Logging to '/config/databases/1e9a6a6ee3d8.err'.
210826 10:27:08 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

Link to comment
17 hours ago, ich777 said:

How do I migrate to the alpine image:

******************************************************
******************************************************
* *
* *
* This image will soon be rebased *
* from ubuntu to alpine. *
* Please be aware, this may cause issues *
* It is strongly recommended to make backups *
* of your config and databases before *
* updating your image to the alpine base. *
* *
* *
******************************************************
******************************************************

 

Upgrading to `:latest` will put you on alpine.

Link to comment
On 8/23/2021 at 5:55 PM, Tucubanito07 said:

When ever the tag gets update to ALPINE = LATEST, what will happen to the application if we update it then? Will it corrupt the database or would we have to do something before we update to make sure it does not corrupt the databases or mess up anything when updating? Also, why are you guys going to Alpine? What's the benefits?

Less so benefits for unraid users (x86_64) but better for our armhf / aarch64 users as mariadb don't release up to date versions for those platforms on ubuntu base.

  • Like 1
Link to comment
45 minutes ago, j0nnymoe said:

Upgrading to `:latest` will put you on alpine.

Only asking because I got the same issue while upgrading to latest as @sonic6.

 

A downgrade to: 'linuxserver/mariadb:110.4.21mariabionic-ls31' and upgrade after the downgrade solved the issue, everything is now up and running on alpine.

Link to comment
7 hours ago, j0nnymoe said:

Less so benefits for unraid users (x86_64) but better for our armhf / aarch64 users as mariadb don't release up to date versions for those platforms on ubuntu base.

When we update the container to the latest? Will it break anything on the database? If you know. Any recommendations on updating it so it does not mess up any of the databases we have already working. 

Link to comment

This "fix", is needed because the container gets forcefully shut down, before mariadb has successfully shutdown, this is usually isn't a problem, as mariadb is nice, and usually manages to recover from a dirty shutdown.  The docker update plugin uses 10s as the default time before killing a container, which does not suffice. 

  • Thanks 2
Link to comment
16 hours ago, nekromantik said:

not really a fix if nextcloud breaks 

 

16 hours ago, Froberg said:

"Fix" worked for me, at least I can access the db through phpmyadmin again. Nextcloud is still b0rked though. Have to get some rest, but specifically the fix that worked in my case: 

 

And then switching to :latest. 

 

16 hours ago, nekromantik said:

not really a fix if nextcloud breaks 

 

This fix worked for me. 

Nextcloud is back up and running without issue.

 

Link to comment

If you are getting the following error in the logs 

 

"Unknown/unsupported storage engine: InnoDB"

 

Then doing this resolved may resolve your issue.  It resolved mine.  I updated mariadb and then nextcloud.

 

For the future.  Before upgrading mariadb, stop the next cloud docker container, then stop mariadb container.  Then apply updates.  

 

Basically I opened a console on the mariadb docker.  

 

ran the following commands

 

> cd /config/databases

> rm ib_logfile0

> rm ib_logfile1 (note: You may get "rm : Cannot remove 'ib_logfile1': No such file or directory) on this command

 

Then stop both the containers and restart both the containers

This seemed to have resolved my issue.

 

Credit where it's due: https://serverfault.com/questions/379714/unknown-unsupported-storage-engine-innodb-mysql-ubuntu

 

Link to comment
On 8/25/2021 at 8:36 PM, 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.

+1. same exact issue for me and this worked too. Thanks!

Link to comment
On 8/26/2021 at 8: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 worked for me as well. both mariadb service and nextcloud up and running again. thanks !!

Link to comment

i was on vacation and sadly this mariadb docker auto upgraded (due to CA) and since the change to alpine (and maria 10.5) now my kodi instances randomly become unhappy with the db

 

launching kodi results in it crashing because it cant get data from the db (it connects just errors on things), sample:

 

2021-09-01 09:58:50.454 T:24263    INFO <general>: Starting Kodi (19.1 (19.1.0) Git:20210508-85e05228b4). Platform: Android ARM 64-bit
...
2021-09-01 09:58:50.504 T:24263    INFO <general>: Contents of special://profile/advancedsettings.xml are...
                                                   <advancedsettings>
                                                     <loglevel>0</loglevel>
                                                     <videodatabase>
                                                       <type>mysql</type>
                                                       <host>192.168.0.11</host>
                                                       <port>3306</port>
...
2021-09-01 09:58:53.110 T:24291    INFO <general>: MYSQL: Connected to version 10.5.12-MariaDB-log
2021-09-01 09:58:53.115 T:24291    INFO <general>: Running database version MyMusic82
2021-09-01 09:58:53.121 T:24291    INFO <general>: Running database version MyVideos119
...
2021-09-01 09:58:53.555 T:24263    INFO <general>: JSONRPC v12.3.0: Successfully initialized
2021-09-01 09:58:53.574 T:24292   ERROR <general>: SQL: [MyVideos119] An unknown error occurred
                                                   Query: SELECT * FROM streamdetails WHERE idFile = 16300

2021-09-01 09:58:53.655 T:24292   ERROR <general>: GetStreamDetails(16300) failed
...
2021-09-01 09:58:53.836 T:24291   ERROR <general>: GetArtForItem(1125) failed
2021-09-01 09:58:53.836 T:24291   ERROR <general>: SQL: Missing result set!
2021-09-01 09:58:53.836 T:24291   ERROR <general>: GetArtForItem(181) failed
2021-09-01 09:58:53.841 T:24291   ERROR <general>: SQL: [MyVideos119] Commands were executed in an improper order
                                                   Query: SELECT * FROM streamdetails WHERE idFile = 733

 

looking around, i found few different things saying that it may just be mariadb 10.5 itself
found this, https://discourse.coreelec.org/t/the-state-of-mariadb-in-the-context-of-coreelec/13025

 

 

restarted docker, tried from another box and still no go:

 

2021-09-01 12:12:49.885 T:24465    INFO <general>: MYSQL: Connected to version 10.5.12-MariaDB-log
2021-09-01 12:12:49.891 T:24465   ERROR <general>: SQL: [MyMusic82] An unknown error occurred
                                                   Query: SELECT idVersion FROM version
                                                   
                                                   
2021-09-01 12:12:50.005 T:24465   ERROR <general>: Process error processing job 

 

tried to downgrade mariadb docker to older tag (110.4.21mariabionic-ls31) but then on docker start up it just shows it crashing/starting:

210901 11:49:22 mysqld_safe Logging to syslog.
210901 11:49:22 mysqld_safe Starting mysqld daemon with databases from /config/databases
210901 11:49:23 mysqld_safe Logging to syslog.
210901 11:49:23 mysqld_safe Starting mysqld daemon with databases from /config/databases
210901 11:49:24 mysqld_safe Logging to syslog.
210901 11:49:24 mysqld_safe Starting mysqld daemon with databases from /config/databases
210901 11:49:25 mysqld_safe Logging to syslog.

 

looking at why...

# /usr/sbin/mysqld --basedir=/usr --datadir=/config/databases --plugin-dir=/usr/lib/mysql/plugin --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld
2021-09-01 12:38:58 0 [Note] /usr/sbin/mysqld (mysqld 10.4.21-MariaDB-1:10.4.21+maria~bionic-log) starting as process 7030 ...
2021-09-01 12:38:58 0 [ERROR] mysqld: Can't lock aria control file '/config/databases/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds
^C^C^C^C^C
2021-09-01 12:39:29 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/config/databases/aria_log_control'
2021-09-01 12:39:29 0 [ERROR] Plugin 'Aria' init function returned error.
2021-09-01 12:39:29 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2021-09-01 12:39:29 0 [Note] InnoDB: Using Linux native AIO
2021-09-01 12:39:29 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-09-01 12:39:29 0 [Note] InnoDB: Uses event mutexes
2021-09-01 12:39:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-01 12:39:29 0 [Note] InnoDB: Number of pools: 1
2021-09-01 12:39:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-01 12:39:29 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
2021-09-01 12:39:29 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2021-09-01 12:39:29 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-01 12:39:29 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-09-01 12:39:29 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.5.12.
2021-09-01 12:39:29 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2021-09-01 12:39:29 0 [Note] InnoDB: Starting shutdown...
2021-09-01 12:39:30 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-09-01 12:39:30 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-09-01 12:39:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-01 12:39:30 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2021-09-01 12:39:30 0 [ERROR] Failed to initialize plugins.
2021-09-01 12:39:30 0 [ERROR] Aborting

 

I got it working on old tag finally.

 

As I had ran "mysql_upgrade -u root -p" when it was on alpine/10.5 to try and get it to fix the problem that the upgrade caused:

https://forum.kodi.tv/showthread.php?tid=364255&pid=3057634

 

So downgraded back to older tag but then in the database folder I had to nuke: aria_log.* / ib_logfile0 / mysql_upgrade_info

 

Now things work like they did before just fine..

 

Edited by zoggy
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.