afsilver Posted May 19, 2022 Share Posted May 19, 2022 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. [email protected]:/# 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! Quote Link to comment
Casadream_1 Posted June 23, 2022 Share Posted June 23, 2022 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? Quote Link to comment
pengrus Posted June 24, 2022 Share Posted June 24, 2022 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. Quote Link to comment
LOOPMDS Posted July 5, 2022 Share Posted July 5, 2022 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. Quote Link to comment
LOOPMDS Posted July 5, 2022 Share Posted July 5, 2022 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 Quote Link to comment
live4soccer7 Posted July 8, 2022 Share Posted July 8, 2022 (edited) @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. This worked for me: http://raafat.tawasol.net/mysql-crashes-io-error/#:~:text=This means that you have,least the last one is Edited July 8, 2022 by live4soccer7 Quote Link to comment
Capt.Insano Posted July 11, 2022 Share Posted July 11, 2022 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. Quote Link to comment
Abigel Posted July 13, 2022 Share Posted July 13, 2022 (edited) 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 July 13, 2022 by Abigel Quote Link to comment
cenzar Posted July 18, 2022 Share Posted July 18, 2022 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? Quote Link to comment
afsilver Posted August 6, 2022 Share Posted August 6, 2022 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. 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! Quote Link to comment
nerbonne Posted August 7, 2022 Share Posted August 7, 2022 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 Quote Link to comment
isvein Posted August 14, 2022 Share Posted August 14, 2022 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. Quote Link to comment
nerbonne Posted August 15, 2022 Share Posted August 15, 2022 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. Quote Link to comment
Capt.Insano Posted September 1, 2022 Share Posted September 1, 2022 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? Quote Link to comment
neepninja Posted September 2, 2022 Share Posted September 2, 2022 Hello. How can I dump my database to sql format and copy the file onto my array please? Thanks. Quote Link to comment
deadnote Posted September 2, 2022 Share Posted September 2, 2022 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 Quote Link to comment
mikester15 Posted October 4, 2022 Share Posted October 4, 2022 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! Quote Link to comment
Squid Posted October 4, 2022 Share Posted October 4, 2022 Best place for support on all LSIO containers is via their Discord. Click on the app and select Discord in the drop down Quote Link to comment
Capt.Insano Posted October 4, 2022 Share Posted October 4, 2022 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! Quote Link to comment
pika Posted October 27, 2022 Share Posted October 27, 2022 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... Quote Link to comment
Danuel Posted October 29, 2022 Share Posted October 29, 2022 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) Quote Link to comment
standbymeintothewild Posted December 29, 2022 Share Posted December 29, 2022 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. Quote Link to comment
blaine07 Posted February 5 Share Posted February 5 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? Quote Link to comment
unRaide Posted February 26 Share Posted February 26 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? Yea, seeing the same thing and wondering if any action is needed on my part? Quote Link to comment
slimshizn Posted March 8 Share Posted March 8 (edited) 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 March 8 by slimshizn Clarify 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.