Skip to content
View in the app

A better way to browse. Learn more.

Unraid

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

[Support] Linuxserver.io - MariaDB

Featured Replies

i had a severe crash on my unraid server 3 days ago, docker service kept locking up, and i had to delete docker image and start over.
now everything is back except mariadb.
log from docker:

[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.
220519 18:55:56 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'.
220519 18:55:56 mysqld_safe Starting mariadbd daemon with databases from /config/databases
220519 18:55:58 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'.
220519 18:55:58 mysqld_safe Starting mariadbd daemon with databases from /config/databases
220519 18:56:00 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'.
220519 18:56:00 mysqld_safe Starting mariadbd daemon with databases from /config/databases
220519 18:56:02 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'.
220519 18:56:02 mysqld_safe Starting mariadbd daemon with databases from /config/databases
220519 18:56:05 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'.
220519 18:56:05 mysqld_safe Starting mariadbd daemon with databases from /config/databases
220519 18:56:07 mysqld_safe Logging to '/config/databases/e8ae576d472a.err'.
220519 18:56:07 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Caught SIGTERM signal!
cat: /var/run/mysqld/mysqld.pid: No such file or directory
[cont-finish.d] executing container finish scripts...
[cont-finish.d] done.
[s6-finish] waiting for services.
[s6-finish] sending all processes the TERM signal.
[s6-finish] sending all processes the KILL signal and exiting.

 

text from e8ae576d472a.err:

 

220519 18:43:20 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2022-05-19 18:43:20 0 [Note] /usr/bin/mariadbd (mysqld 10.5.15-MariaDB-log) starting as process 518 ...
2022-05-19 18:43:21 0 [Note] InnoDB: Uses event mutexes
2022-05-19 18:43:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-19 18:43:21 0 [Note] InnoDB: Number of pools: 1
2022-05-19 18:43:21 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-05-19 18:43:21 0 [Note] InnoDB: Using Linux native AIO
2022-05-19 18:43:21 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-05-19 18:43:21 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-19 18:43:22 0 [Note] InnoDB: Transaction 50443189 was in the XA prepared state.
2022-05-19 18:43:22 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2022-05-19 18:43:22 0 [Note] InnoDB: Trx id counter is 50443190
2022-05-19 18:43:22 0 [Note] InnoDB: 128 rollback segments are active.
2022-05-19 18:43:22 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2022-05-19 18:43:22 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2022-05-19 18:43:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-19 18:43:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-19 18:43:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-05-19 18:43:22 0 [Note] InnoDB: 10.5.15 started; log sequence number 11641422179; transaction id 50443191
2022-05-19 18:43:22 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2022-05-19 18:43:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-19 18:43:22 0 [Note] InnoDB: Starting recovery for XA transactions...
2022-05-19 18:43:22 0 [Note] InnoDB: Transaction 50443189 in prepared state after recovery
2022-05-19 18:43:22 0 [Note] InnoDB: Transaction contains changes to 1 rows
2022-05-19 18:43:22 0 [Note] InnoDB: 1 transactions in prepared state after recovery
2022-05-19 18:43:22 0 [Note] Found 1 prepared transaction(s) in InnoDB
2022-05-19 18:43:22 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was ma>
2022-05-19 18:43:22 0 [ERROR] Aborting
220519 18:43:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

tried "mysqld --user=root --tc-heuristic-recover" with rollback and commit. in the docker console.

 

root@e8ae576d472a:/# mysqld --user=root --tc-heuristic-recover rollback
2022-05-19 19:01:16 0 [Note] mysqld (mysqld 10.5.15-MariaDB-log) starting as process 1375 ...
2022-05-19 19:01:16 0 [Note] InnoDB: Uses event mutexes
2022-05-19 19:01:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-19 19:01:16 0 [Note] InnoDB: Number of pools: 1
2022-05-19 19:01:16 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-05-19 19:01:16 0 [Note] InnoDB: Using Linux native AIO
2022-05-19 19:01:16 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-05-19 19:01:16 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-19 19:01:17 0 [Note] InnoDB: 128 rollback segments are active.
2022-05-19 19:01:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-19 19:01:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-19 19:01:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-05-19 19:01:17 0 [Note] InnoDB: 10.5.15 started; log sequence number 35064; transaction id 8
2022-05-19 19:01:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-19 19:01:17 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2022-05-19 19:01:17 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
2022-05-19 19:01:17 0 [Note] Heuristic crash recovery mode
2022-05-19 19:01:17 0 [Note] Please restart mysqld without --tc-heuristic-recover
2022-05-19 19:01:17 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2022-05-19 19:01:17 0 [Note] InnoDB: Buffer pool(s) load completed at 220519 19:01:17
2022-05-19 19:01:17 0 [ERROR] Can't init tc log
2022-05-19 19:01:17 0 [ERROR] Aborting

 

But i do not know how to proceed from here.

any help is grately appriciated!

  • 1 month later...
  • Replies 623
  • Views 232.5k
  • Created
  • Last Reply

Top Posters In This Topic

Most Popular Posts

  • goosetrousers
    goosetrousers

    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 back

  • @exico here is my workaround,   try using this Repository: linuxserver/mariadb:110.4.21mariabionic-ls31

  • Update:   I re-installed the mariadb docker without password and then I managed to login with root account (no password) - then manually changed the password  mysql -u root -p mysql>

Posted Images

Hello everyone,

 

I've been sweating for several days and I see that the messages here are going to the same side as me.

I use MariaDb without errors, my services (bookstack, lychee and Authelia) without problems.

 

No logs showing errors, no spamming to cause mariadb to quit.

I restart mariadb and everything works again but just for a while.

When I want to connect with admin I see that there have been too many connection requests that mariadb wanted to protect itself.

 

I changed the max_connections = xxxxx parameter in the custom.cnf file and with the command: show variables like "max_connections"; I can see that increasing. My question is, how do I find out who is causing this ? (no newspaper correctly tells me about the problem). So once 10,000 tests have been carried out, I will come back to a mariadb which will protect itself once again.

 

I killed each service to leave either one or the other.

I went around the 3 services one by one, and each time mariadb protects itself.

How to make it accept repeated connections (by whom I don't know) for 500 years?

22 hours ago, Casadream_1 said:

Hello everyone,

 

I've been sweating for several days and I see that the messages here are going to the same side as me.

I use MariaDb without errors, my services (bookstack, lychee and Authelia) without problems.

 

No logs showing errors, no spamming to cause mariadb to quit.

I restart mariadb and everything works again but just for a while.

When I want to connect with admin I see that there have been too many connection requests that mariadb wanted to protect itself.

 

I changed the max_connections = xxxxx parameter in the custom.cnf file and with the command: show variables like "max_connections"; I can see that increasing. My question is, how do I find out who is causing this ? (no newspaper correctly tells me about the problem). So once 10,000 tests have been carried out, I will come back to a mariadb which will protect itself once again.

 

I killed each service to leave either one or the other.

I went around the 3 services one by one, and each time mariadb protects itself.

How to make it accept repeated connections (by whom I don't know) for 500 years?

 

What applications have access, just those three? 

 

What are their permissions inside the database? 

 

Log in as root and then please post the output of:

 

SELECT user,host FROM mysql.user;

 

And then:

 

SHOW GRANTS FOR <username>@<host>;

 

Do this for each user.

 

Do you have any logs?  From MariaDB or the applications? 

 

Please attach them to your reply if so.

  • 2 weeks later...

using latest version of "linuxserver/mariadb" for my Zabbix.


   Zabbix Server "zabbix/zabbix-server-mysql:latest" failed to updgrade Database

 

When i try to upgrade Zabbix to 6.2 from 6.0.5 docker i get below error in Zabbix Server log


from "Zabbix Server" Log:
---------------------

7:20220705:141509.188 completed 48% of database upgrade
7:20220705:141509.189 [Z3005] query failed: [1419] You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) [create trigger hosts_insert after insert on hosts
for each row
insert into changelog (object,objectid,operation,clock)
values (1,new.hostid,1,unix_timestamp())]
7:20220705:141509.189 database upgrade failed
7:20220705:141509.191 database could be upgraded to use primary keys in history tables.

--------------------------------------------


im no db expert. so if anybody knows hoiw to fix this.  never seen this problem before.  i updated from 5.x to 6.0.5 with no trouble.

1 hour ago, LOOPMDS said:

using latest version of "linuxserver/mariadb" for my Zabbix.


   Zabbix Server "zabbix/zabbix-server-mysql:latest" failed to updgrade Database

 

When i try to upgrade Zabbix to 6.2 from 6.0.5 docker i get below error in Zabbix Server log


from "Zabbix Server" Log:
---------------------

7:20220705:141509.188 completed 48% of database upgrade
7:20220705:141509.189 [Z3005] query failed: [1419] You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) [create trigger hosts_insert after insert on hosts
for each row
insert into changelog (object,objectid,operation,clock)
values (1,new.hostid,1,unix_timestamp())]
7:20220705:141509.189 database upgrade failed
7:20220705:141509.191 database could be upgraded to use primary keys in history tables.

--------------------------------------------


im no db expert. so if anybody knows hoiw to fix this.  never seen this problem before.  i updated from 5.x to 6.0.5 with no trouble.

 

i fixed it by doing :  

mysql -u root -p

and 

SET GLOBAL log_bin_trust_function_creators = 1;

verify it works, then

and then adding below in the "custom.cnf" 

log_bin_trust_function_creators = 1

 

@afsilver I am getting a similar issue as well. I had a recovery and everything is back online except mariadb. Did you ever find a resolution? I'm no noobie, but I haven't been able to resolve this one yet and it would be great to get my dbs back online.

 

image.thumb.png.bd1b57de4735954d7608d2c3a88b0ed9.png

 

This worked for me: http://raafat.tawasol.net/mysql-crashes-io-error/#:~:text=This means that you have,least the last one is

Edited by live4soccer7

Came here to ask a similar question to others. I have not had any issues with my MariaDB install that I know of but I happened to check the log and noticed the following about a .err file:

 

-------------------------------------
          _         ()
         | |  ___   _    __
         | | / __| | |  /  \
         | | \__ \ | | | () |
         |_| |___/ |_|  \__/


Brought to you by linuxserver.io
-------------------------------------

To support LSIO projects visit:
https://www.linuxserver.io/donate/
-------------------------------------
GID/UID
-------------------------------------

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

[custom-init] no custom files found exiting...
[ls.io-init] done.
220711 15:54:26 mysqld_safe Logging to '/config/databases/26dcfea28ad2.err'.
220711 15:54:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

The .err file contains the following:

 

220711 15:54:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2022-07-11 15:54:26 0 [Note] /usr/bin/mariadbd (mysqld 10.5.16-MariaDB-log) starting as process 315 ...
2022-07-11 15:54:26 0 [Note] InnoDB: Uses event mutexes
2022-07-11 15:54:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-07-11 15:54:26 0 [Note] InnoDB: Number of pools: 1
2022-07-11 15:54:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-07-11 15:54:26 0 [Note] InnoDB: Using Linux native AIO
2022-07-11 15:54:26 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-07-11 15:54:26 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-11 15:54:26 0 [Note] InnoDB: 128 rollback segments are active.
2022-07-11 15:54:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-07-11 15:54:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-07-11 15:54:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-07-11 15:54:26 0 [Note] InnoDB: 10.5.16 started; log sequence number 261866318704; transaction id 208867832
2022-07-11 15:54:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-11 15:54:26 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2022-07-11 15:54:27 0 [Note] Server socket created on IP: '::'.
2022-07-11 15:54:27 0 [Note] Reading of all Master_info entries succeeded
2022-07-11 15:54:27 0 [Note] Added new Master_info '' to hash table
2022-07-11 15:54:27 0 [Note] /usr/bin/mariadbd: ready for connections.
Version: '10.5.16-MariaDB-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
2022-07-11 15:54:27 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 15:54:27
2022-07-11 15:54:30 4 [Warning] IP address '172.17.0.1' could not be resolved: Name does not resolve
2022-07-11 15:54:33 6 [Warning] IP address '192.168.1.100' could not be resolved: Name does not resolve

 

I can not see any errors there that are concerning, am I missing something or is it normal that MariaDB logs to a .err file even if there are no issues?

 

Thanks for any advice.

 

 

Hi,

after updating my container I am getting this error "no space left"
But I have enough space on the disks and cache, like 100GB for each disk

Can somebody pls help me?

Edited by Abigel

Hello, randomly out of the blue I was no longer able to log in to mariadb with root via adminer. I tried with phpmyadmin and via the terminal and also no luck. I also tried to edit the root password on the edit page of the docker container but no luck. Here is the exact error: 

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

It would appear normal connections still work. I'm running 2 instances of photoprism and they are running with no issues and connecting to mariadb. I found online there is a way to skip grant tables, flush privileges, and create a new login but I couldn't find a way to do it for lscr.io/linuxserver/mariadb. Is there anyway I can fix this?

  • 3 weeks later...
On 7/8/2022 at 6:37 AM, live4soccer7 said:

@afsilver I am getting a similar issue as well. I had a recovery and everything is back online except mariadb. Did you ever find a resolution? I'm no noobie, but I haven't been able to resolve this one yet and it would be great to get my dbs back online.

 

image.thumb.png.bd1b57de4735954d7608d2c3a88b0ed9.png

 

This worked for me: http://raafat.tawasol.net/mysql-crashes-io-error/#:~:text=This means that you have,least the last one is

I gave up, and deleted the whole db and rebuilt it.

Added users manually and scanned files in nextcloud folder to add the userfiles.

 

Had a new btrfs fail on the cache drive and lost the db again, this time i had a local and external backup!

On 6/7/2021 at 9:12 PM, JustAnotherGuy1324 said:

 

 

- now change root password and insert hostname for root

1. mysql> FLUSH PRIVILEGES;
2. mysql> ALTER USER 'root'@'INSERT_HOST' IDENTIFIED BY 'your_secret';
2. mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'your_secret';          <- my setup
3. mysql> FLUSH PRIVILEGES;

 

 

 

I get this error, any ideas?  

 

MariaDB [(none)]> FLUSH PRIVILEGES;
ERROR 1146 (42S02): Table 'mysql.db' doesn't exist
 

How can I reset my root password that I dont remember?
I tried to add "mysqld_safe --skip-grant-tables" to the post arguments and follow a guide I found, but if I add this to this container it wont even start.

On 8/14/2022 at 1:35 PM, isvein said:

How can I reset my root password that I dont remember?
I tried to add "mysqld_safe --skip-grant-tables" to the post arguments and follow a guide I found, but if I add this to this container it wont even start.

I ended up making a mysql dump using the login/password for nextcloud (this is what was using the database), then deleting the mariadb instance, installing a new copy, and then importing the mysql dump.

  • 3 weeks later...
On 7/11/2022 at 4:09 PM, Capt.Insano said:

Came here to ask a similar question to others. I have not had any issues with my MariaDB install that I know of but I happened to check the log and noticed the following about a .err file:

 

-------------------------------------
          _         ()
         | |  ___   _    __
         | | / __| | |  /  \
         | | \__ \ | | | () |
         |_| |___/ |_|  \__/


Brought to you by linuxserver.io
-------------------------------------

To support LSIO projects visit:
https://www.linuxserver.io/donate/
-------------------------------------
GID/UID
-------------------------------------

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

[custom-init] no custom files found exiting...
[ls.io-init] done.
220711 15:54:26 mysqld_safe Logging to '/config/databases/26dcfea28ad2.err'.
220711 15:54:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

The .err file contains the following:

 

220711 15:54:26 mysqld_safe Starting mariadbd daemon with databases from /config/databases
2022-07-11 15:54:26 0 [Note] /usr/bin/mariadbd (mysqld 10.5.16-MariaDB-log) starting as process 315 ...
2022-07-11 15:54:26 0 [Note] InnoDB: Uses event mutexes
2022-07-11 15:54:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-07-11 15:54:26 0 [Note] InnoDB: Number of pools: 1
2022-07-11 15:54:26 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-07-11 15:54:26 0 [Note] InnoDB: Using Linux native AIO
2022-07-11 15:54:26 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728
2022-07-11 15:54:26 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-11 15:54:26 0 [Note] InnoDB: 128 rollback segments are active.
2022-07-11 15:54:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-07-11 15:54:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-07-11 15:54:26 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-07-11 15:54:26 0 [Note] InnoDB: 10.5.16 started; log sequence number 261866318704; transaction id 208867832
2022-07-11 15:54:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-11 15:54:26 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2022-07-11 15:54:27 0 [Note] Server socket created on IP: '::'.
2022-07-11 15:54:27 0 [Note] Reading of all Master_info entries succeeded
2022-07-11 15:54:27 0 [Note] Added new Master_info '' to hash table
2022-07-11 15:54:27 0 [Note] /usr/bin/mariadbd: ready for connections.
Version: '10.5.16-MariaDB-log'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
2022-07-11 15:54:27 0 [Note] InnoDB: Buffer pool(s) load completed at 220711 15:54:27
2022-07-11 15:54:30 4 [Warning] IP address '172.17.0.1' could not be resolved: Name does not resolve
2022-07-11 15:54:33 6 [Warning] IP address '192.168.1.100' could not be resolved: Name does not resolve

 

I can not see any errors there that are concerning, am I missing something or is it normal that MariaDB logs to a .err file even if there are no issues?

 

Thanks for any advice.

 

 

 

Sorry to post again but I am chasing a possible issue with Nextcloud and trying to make sure the issues is not mariadb related.

 

Is it normal that mariadb logs to a .err file even if running normally?

 

 

Hello. How can I dump my database to sql format and copy the file onto my array please? 

 

Thanks. 

HI

I looked into the mariadb/log/mysql folder and I see a lot of mariadb-bin.xxxxxx files. Each file size is around 100Mo

Can I delete them ?

Why I have all these files ? Is there a way to read the logs ?

Thanks

  • 1 month later...
On 9/1/2022 at 2:01 PM, Capt.Insano said:

 

Sorry to post again but I am chasing a possible issue with Nextcloud and trying to make sure the issues is not mariadb related.

 

Is it normal that mariadb logs to a .err file even if running normally?

 

 

I'm having this issue as well. Would love support if possible!

Best place for support on all LSIO containers is via their Discord.  Click on the app and select Discord in the drop down

16 hours ago, mikester15 said:

I'm having this issue as well. Would love support if possible!

 

I ended up moving to the "MariaDB Official" containers, I migrated using HeidiSQL and am now using a seperate container for each database and it has so far been rock solid. I was previously having lock-ups with Nextcloud. This has now gone away!

  • 4 weeks later...
On 9/2/2022 at 4:41 PM, deadnote said:

HI

I looked into the mariadb/log/mysql folder and I see a lot of mariadb-bin.xxxxxx files. Each file size is around 100Mo

Can I delete them ?

Why I have all these files ? Is there a way to read the logs ?

Thanks

did you figure this out? these logs (how do i read them?) occupy my whole cache drive (only for today there are 252 = 24,5GB)...

yesterday i had to manually delete some files so i could enter mariaDB console to dump the logs older than a day...

hi,

i have same problem

 

221029 17:41:58 mysqld_safe Logging to '/config/databases/1091f11024d1.err'.
221029 17:41:58 mysqld_safe Starting mariadbd daemon with databases from /config/databases

 

and i noticed that i cant access database anymore

 

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

 

  • 1 month later...
On 9/2/2022 at 8:20 AM, neepninja said:

Hello. How can I dump my database to sql format and copy the file onto my array please? 

 

Thanks. 

Yes, this is what mysqldump can do

simple example
 

docker exec mariadb /usr/bin/mysqldump --user=root --password=******** {{dbname}} > /mnt/user/data/mariadb_backup/dump.sql

This post over shows how to set up a backup that goes daily or whenever you decide that the script is run. I use a similar script for all my databases.

  • 1 month later...

Is this container not kept updated with docker? I see this in logs; i have tried to run it but can't seem to figure out the proper way to handle this?

 

Any help?

 

406264173_ScreenShot2023-02-05at9_06_11AM.thumb.png.6cb9b52d09ac017e842a7afcbd9959f6.png

  • 3 weeks later...
On 2/5/2023 at 7:06 AM, blaine07 said:

Is this container not kept updated with docker? I see this in logs; i have tried to run it but can't seem to figure out the proper way to handle this?

 

Any help?

 

406264173_ScreenShot2023-02-05at9_06_11AM.thumb.png.6cb9b52d09ac017e842a7afcbd9959f6.png

 

Yea, seeing the same thing and wondering if any action is needed on my part?

  • 2 weeks later...
On 2/25/2023 at 11:31 PM, unRaide said:

 

Yea, seeing the same thing and wondering if any action is needed on my part?

Yes


Stop all of your containers using mysql, then open a mariadb console, then enter the following, followed by your password.
 

Quote

mysql_upgrade -u root -p

 

Edited by slimshizn
Clarify

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...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.