Page 1 of 1

[SOLVED] Backups fails on mysql

Posted: Sun Apr 16, 2017 10:28 pm
by aximus
The automatic backups are failing, and keeps trying to create a new backup, causing high server load. I see this in the log:

-- DB --
2017-04-17 00:22:17 admin_foo (mysql)
2017-04-17 00:22:18 admin_bar (mysql)
sh: 0: getcwd() failed: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
sh: 0: getcwd() failed: No such file or directory
exim: can't get the current working directory: No such file or directory
Error: dump admin_bar failed

(anonymised using 'foo' and 'bar')

I googled the problem and found some answers pointing to viewtopic.php?f=40&t=9694#p34401. But I don't understand how that is supposed to help.

Help is much appreciated.

Re: Backups fails on mysql

Posted: Tue Apr 18, 2017 7:30 am
by skurudo
This is the environment variables which help with paths to executable files

Re: Backups fails on mysql

Posted: Sat Apr 22, 2017 7:11 am
by aximus
Solved the problem:

The mysql backup failed for `admin_bar`. In order to fix it, I logged in to phpmyadmin and noticed something was wrong in the `admin_bar` database. After repairing all tables (and in my case, dropping one weird table), all was good.

Re: [SOLVED] Backups fails on mysql

Posted: Mon Apr 24, 2017 9:22 am
by skurudo
Nice catch, aximus
Thanks for your report.