Help MYSQL is dead and refuses to restart

[Snowman30]

I have a problem with MySQL refusing to restart:

root@colin [/var/tmp]# /scripts/restartsrv mysql
Waiting for mysql to restart..............finished.



/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
root@colin [/var/tmp]#
[/quote]

Im running mysql 5.0.27 on WHM 11.1.0 cPanel 11.4.19-R14378
CENTOS Enterprise 3.8 i686 - WHM X v3.1.0

Ive tried /scripts/upcp --force
/scripts/mysqlup --force

nothing works

heres the error log for mysql:

070705 14:19:11 mysqld started
070705 14:19:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070705 14:19:11 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 4078283224.
InnoDB: Doing recovery: scanned up to log sequence number 0 4078283224
InnoDB: Page directory corruption: supremum not pointed to
070705 14:19:11 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex;InnoDB: End of page dump
070705 14:19:11 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 0,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page directory corruption: supremum not pointed to
070705 14:19:11 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex ;InnoDB: End of page dump
070705 14:19:12 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 0,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
070705 14:19:12InnoDB: Error: trying to access a stray pointer 0x36c3fff8
InnoDB: buf pool start is at 0xb6c30000, end at 0xb7430000
InnoDB: Probable reason is database corruption or memory
InnoDB: corruption. If this happens in an InnoDB database recovery, see
InnoDB: http://dev.mysql.com/doc/refman/5.0/...-recovery.html
InnoDB: how to force recovery.
070705 14:19:12InnoDB: Assertion failure in thread 3076464768 in file ../include/buf0buf.ic line 259
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/...-recovery.html
InnoDB: about forcing recovery.
mysqld got signal 11;

key_buffer_size=0
read_buffer_size=131072
max_used_connections=0
max_connections=500
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1087996 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xbfffd44c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8165050
0x8340868
0x82d1441
0x82dc193
0x828ff5c
0x8291916
0x82809c7
0x827ef07
0x8219515
0x820eb88
0x816650d
0x8166c61
0x12679a
0x80e6541

070705 14:19:12 mysqld ended

ive also tried to lodge a cpanel ticket and their system is bugging out with an error\

can anyone assist?

[rpmws]

I have a problem with MySQL refusing to restart:

root@colin [/var/tmp]# /scripts/restartsrv mysql
Waiting for mysql to restart..............finished.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
root@colin [/var/tmp]#
Im running mysql 5.0.27 on WHM 11.1.0 cPanel 11.4.19-R14378
CENTOS Enterprise 3.8 i686 - WHM X v3.1.0

Ive tried /scripts/upcp --force
/scripts/mysqlup --force

nothing works

heres the error log for mysql:



ive also tried to lodge a cpanel ticket and their system is bugging out with an error\

can anyone assist?

just for the hell of it do this:
/scripts/restartsrv mysql

if that fails ..
rm /etc/my.cnf
/scripts/mysqlup --force
then
/scripts/restartsrv mysql


what ya get?

[Snowman30]

same error, already tried that

[rpmws]

same error, already tried that

you removed the my.cnf file?

do you have a link in /tmp ?
mysql.sock -> ../../var/lib/mysql/mysql.sock=

I guess you could try touching a mysql.sock file in /var/lib/mysql/mysql.sock or delete it if one is there. ??

I have seen this before and this is what I managed to do to get it working.

[rpmws]

yes my.cnf file was removed and a orced mysqlup has been done

ive tried it with and without a link to mysql.sock in tmp and i have tried toucing mysql.sock in /var/lib/mysql

no joy same errors:

so it complains if can't find the sock? or it shows the errors you posted? I am wondering if you could get it to run if you move all your databases out just for now from the /var/lib/mysql/ folder .. keep them safe. see if will run. I suppose it could be a perms issue?

[Snowman30]

yes my.cnf file was removed and a orced mysqlup has been done

ive tried it with and without a link to mysql.sock in tmp and i have tried toucing mysql.sock in /var/lib/mysql

no joy same errors:

[rpmws]

yes my.cnf file was removed and a orced mysqlup has been done

ive tried it with and without a link to mysql.sock in tmp and i have tried toucing mysql.sock in /var/lib/mysql

no joy same errors:

my sock file by the way is owned by mysql ..check perms

srwxrwxrwx 1 mysql mysql 0 Jul 5 01:17 mysql.sock=

[rpmws]

yes my.cnf file was removed and a orced mysqlup has been done

ive tried it with and without a link to mysql.sock in tmp and i have tried toucing mysql.sock in /var/lib/mysql

no joy same errors:

i didn't read all those errors before. you have some crashed db's i suppose and the sock never gets created cause it knows it can't run yet.

did you see this?
http://dev.mysql.com/doc/refman/5.0/...-recovery.html

[Snowman30]

i didn't read all those errors before. you have some crashed db's i suppose and the sock never gets created cause it knows it can't run yet.

did you see this?
http://dev.mysql.com/doc/refman/5.0/...-recovery.html

ive reviewed the mysql docs and sadly they are completely useless when mysql and mysqladmin refuse to start

[Snowman30]

InnoDB seems to have been the problem so i have added skip-innodb to my.cnf and ive got it back online