Docker-mariadb unraid

LSIO Discussion Container Support
1

Hello all, i am new to this so appreciate any help you can give me…

i have the lscr.io/linuxserver/mariadb docker running on my unraid server. while it seems to be doing its job, my mariadb container appdata folder is growing huge. i have a ton of .err files in there some over a gig.

the have the warning:

2024-03-09 8:56:14 3 [Warning] Aborted connection 3 to db: ‘unconnected’ user: ‘unauthenticated’ host: ‘localhost’ (This connection closed normally without authentication)
2024-03-09 8:56:14 4 [Warning] Access denied for user ‘root’@‘localhost’ (using password: YES)
2024-03-09 8:56:58 6 [Warning] IP address ‘172.17.0.1’ could not be resolved: Name does not resolve
2024-03-09 8:56:58 5 [Warning] IP address ‘172.17.0.1’ could not be resolved: Name does not resolve
2024-03-09 8:56:58 7 [Warning] IP address ‘172.17.0.1’ could not be resolved: Name does not resolve

then they are FILLED with the errors over and over:

2024-03-05 14:09:17 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column ‘hist_type’ at position 9 to have type enum(‘SINGLE_PREC_HB’,‘DOUBLE_PREC_HB’,‘JSON_HB’), found type enum(‘SINGLE_PREC_HB’,‘DOUBLE_PREC_HB’).
2024-03-05 14:09:17 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column ‘histogram’ at position 10 to have type longblob, found type varbinary(255).

are you aware of a way to fix this? if not can you point me in the direction, thank you!

2

Unfortunately, we support the container, not the application inside the container. You’re welcome to join our discord and seek best-effort help in #other-support. You would need to share what is using the database to get much help though. With that said, if you’re having a bunch of errors, I would just restore a backup from before the errors began.

3

thank you for the response. i am new to this so what is the difference between the container and the application? thank you!

4

to put it simply, the container is a box, the application is a thing inside the box. if the box breaks, we’ll fix it. if the thing breaks you ask the people who make the thing for help