{"id":1821,"date":"2017-10-16T09:22:08","date_gmt":"2017-10-16T13:22:08","guid":{"rendered":"https:\/\/easy-admin.ca\/?p=1821"},"modified":"2017-10-25T18:32:36","modified_gmt":"2017-10-25T22:32:36","slug":"virtualmin-backup-failed-mysql-crashed","status":"publish","type":"post","link":"https:\/\/easy-admin.ca\/index.php\/2017\/10\/16\/virtualmin-backup-failed-mysql-crashed\/","title":{"rendered":"VirtualMIN Backup Failed – MySQL “MariaDB” crash"},"content":{"rendered":"

Good day!<\/strong><\/em> I ran into a problem when backing up all my virtualMIN websites. When the backup failed something stange happened to MySQL “MariaDB<\/strong>” database server. When backup fail, MariaDB<\/strong> crash!<\/p>\n

To fix this issue I added a command to run after backup:<\/p>\n

systemctl stop <\/strong>mariadb ; systemctl start <\/strong>mariaDB<\/p>\n

Located in > <\/strong>VirtualMIN > Scheduled Backups ><\/strong><\/p>\n

\"\"<\/p>\n

This will prevent mariaDB to crash after a failed virtualMIN backup!<\/p>\n

Notes:<\/strong> Check the size of your \/tmp and increase it!<\/p>\n

If you are having “Out of resources <\/strong><\/span>Errcode : 24 message”<\/strong><\/span><\/p>\n

The <\/strong>mysql error:<\/strong>\u00a0 Out of resources when opening file… (Errcode: 24)\u00a0\u00a0 indicates that the number of files that msyql is permitted to open has been exceeded.<\/p>\n

This limit is controlled by the variable open_files_limit<\/strong>. \u00a0 You can read this in phpMyAdmin (or the MySQL command line utility) with the statement:<\/p>\n

\n
SHOW<\/a> VARIABLES LIKE<\/a> 'open%'<\/pre>\n<\/div>\n
To set this variable to a higher number, edit the \/etc\/my.cnf file and add the lines:<\/p>\n
[mysqld]\r\nopen_files_limit = 5000<\/pre>\n
Then be sure to restart mysql with:\u00a0\u00a0 sudo \/etc\/init.d\/mysql restart<\/p>\n
Remember to use the server administrative account and sudo when you edit the file.\u00a0 The choice of editor is up to you.<\/p>\n
Now, showing the variable should show the number you choose.<\/p>\n
Note that 5000 shown above is an example. A good rule of thumb is to take the current number of files and add 1000 to it. If this doesn’t help, add some more.\u00a0 This number affects the amount of memory that MySQL uses, so setting it to a very high number is not a good idea.<\/p>\n
You may also verified your \/etc\/my.cfg configurations:<\/strong><\/p>\n
[mysqld]
\ndatadir = \/var\/lib\/mysql
\nsocket = \/var\/lib\/mysql\/mysql.sock<\/p>\n
local-infile=0
\nsymbolic-links=0
\ninnodb_file_per_table = 1
\nthread_concurrency = 8
\nquery_cache_size = 64M
\nthread_cache_size = 8
\nmyisam_sort_buffer_size = 256M
\nread_rnd_buffer_size = 32M
\nread_buffer_size = 4M
\nsort_buffer_size = 4M
\ntable_open_cache = 512
\nmax_allowed_packet = 7M
\nkey_buffer_size = 512M
\nopen_files_limit = 10000<\/span>
\nmax_connections = 32768
\ninnodb_buffer_pool_size = 40M<\/p>\n
[mysqld_safe]
\nlog-error=\/var\/log\/mariadb\/mariadb.log
\npid-file=\/var\/run\/mariadb\/mariadb.pid<\/p>\n
!includedir \/etc\/my.cnf.d<\/p>\n
After modifications you must restart MySQL server<\/strong><\/p>\n
# systemctl restart mariadb<\/p>\n","protected":false},"excerpt":{"rendered":"
Good day! I ran into a problem when backing up all my virtualMIN websites. When the backup failed something stange happened to MySQL “MariaDB” database server. When backup fail, MariaDB crash! To fix this issue I added a command to run after backup: systemctl stop mariadb ; systemctl start mariaDB Located in > VirtualMIN > … Continue reading VirtualMIN Backup Failed – MySQL “MariaDB” crash<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1821","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts\/1821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/comments?post=1821"}],"version-history":[{"count":0,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/posts\/1821\/revisions"}],"wp:attachment":[{"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/media?parent=1821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/categories?post=1821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easy-admin.ca\/index.php\/wp-json\/wp\/v2\/tags?post=1821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}