MySQL crashes during backup and doesn't restart

0utlier

Well-Known Member
Aug 7, 2002
46
0
156
This is a strange one... This happens on only one server and only during the backups. This is about half way through the backups...
---------------------------------------------------------------------------------

Copying www logs.............
.........
.........
.........
Done
Grabbing mysql dbs...mysqldump: Can't get CREATE TABLE for table `phpbb_privmsgs` (File './ithkus_velocityforum/phpbb_privmsgs.MYD' not found (Errcode: 24))
Done
Grabbing mysql privs...DBD::mysql::st execute failed: File './mysql/user.MYD' not found (Errcode: 24) at /usr/local/cpanel/Cpanel/Mysql.pm line 669.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 670.
DBD::mysql::st execute failed: File './mysql/user.MYD' not found (Errcode: 24) at /usr/local/cpanel/Cpanel/Mysql.pm line 677.
DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() at /usr/local/cpanel/Cpanel/Mysql.pm line 678.
Done

---------------------------------------------------------------------------------
Then after the above happens MySQL is down and every backup shows this...
---------------------------------------------------------------------------------

Copying www logs.............
Done
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[email protected]' (Using password: YES)'
Grabbing mysql dbs...DBI connect('mysql:localhost','root',...) failed: Access denied for user: '[email protected]' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[email protected]' (Using password: YES)'
DBI connect('mysql:localhost','root',...) failed: Access denied for user: '[email protected]' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
Done
Grabbing mysql privs...DBI connect('mysql:localhost','root',...) failed: Access denied for user: '[email protected]' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[email protected]' (Using password: YES)'
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
ERROR 1045: Access denied for user: '[email protected]' (Using password: YES)
Done

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

Obviously, MySQL is down at this point and any site that uses MySQL is "broken". On the off chance it might fix it, I just ran mysqlcheck -r --all-databases. Anyone else seen this or have any ideas? It's getting real old having to restart MySQL every day after I get the eximstats error. Checkservd doesn't seem to catch that MySQL is down. Thank you.

Scott Goodwin
 

mickalo

Well-Known Member
Apr 16, 2002
782
5
318
N.W. Iowa
The error (24) means too many files are being open. The default setting is usually determined by the open_files_limit which is 4096 I believe.

You would need to change this in your my.cnf or startup options

Mickalo
 

0utlier

Well-Known Member
Aug 7, 2002
46
0
156
Just in case any one else runs into this problem....

Increasing open-files-limit in my.cnf did the trick it appears. Backups ran and MySQL didn't crash. Thank you.
 

1server4u

Member
Oct 17, 2003
14
0
151
UK
cPanel Access Level
Root Administrator
Increasing open-files-limit in my.cnf

Hello;

What do I add in "my.cnf" To Increase the open-files-limit as all I have in that file is root and root password?

As every Sunday when my server Backups all sites I get:"spamd failed" "apache failed" And the server runs really slow.

Thanks

Mike