Database error for the past 4 days

savanna96

Member
Feb 13, 2013
7
0
1
cPanel Access Level
Root Administrator
Hey on my host that I am a root admin of but don't own but have full access MYSQL keeps disconnecting every couple hours and every night when I sleep it has the error I keep resetting the MYSQL but I need to know what I need to fix to stop this from happening because it's going to drive clients away. What test can I run to attempt to fix this error

Thanks,
Savanna
 

savanna96

Member
Feb 13, 2013
7
0
1
cPanel Access Level
Root Administrator
Can'r access error log

when I try to check the log on both User "Root" and my root account I get Permission Denied so I can't even check what is wrong and I opened another topic got 1 reply all day so I haven't been able to fix it
 

JaredR.

Well-Known Member
Feb 25, 2010
1,834
27
143
Houston, TX
cPanel Access Level
Root Administrator
Re: Can'r access error log

Which log are you trying to access? Apache, cPanel, or something else?

How, exactly, are you trying to access it? Are you logging into the shell as root?
 

savanna96

Member
Feb 13, 2013
7
0
1
cPanel Access Level
Root Administrator
I'm trying to access the /var/lib/mysql/hostname.err and yes as Root because I'm trying to get the error fixed as I have to keep resetting the SQL Part every couple of hours
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Hello :)

Could you let us know the specific command you are attempting to use? For example, have you tried using "cat" or "tail -f" before the log file name? Are you logged in via SSH?

Thank you.
 

savanna96

Member
Feb 13, 2013
7
0
1
cPanel Access Level
Root Administrator
I was just doing /var/lib/mysql/hostname.err but I just did tail -f and this is all I got


130215 20:31:09 InnoDB: Completed initialization of buffer pool
130215 20:31:09 InnoDB: highest supported file format is Barracuda.
130215 20:31:09 InnoDB: Waiting for the background threads to start
130215 20:31:10 InnoDB: 1.1.8 started; log sequence number 306804440
130215 20:31:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130215 20:31:10 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130215 20:31:10 [Note] Server socket created on IP: '0.0.0.0'.
130215 20:31:10 [Note] Event Scheduler: Loaded 0 events
130215 20:31:10 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.28-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
 

savanna96

Member
Feb 13, 2013
7
0
1
cPanel Access Level
Root Administrator
Ok the Database just failed which I needed to get the correct error log:

130216 1:34:02 [ERROR] /usr/sbin/mysqld: Can't open file: './whmsonic/sch.frm' (errno: 24)
130216 1:34:15 [ERROR] /usr/sbin/mysqld: Can't open file: './cphulkd/auths.frm' (errno: 24)
130216 1:34:15 [ERROR] /usr/sbin/mysqld: Can't open file: './cphulkd/auths.frm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.fr m' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.f rm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures .frm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.fr m' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.f rm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.fr m' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures .frm' (errno: 24)