Mysql + Perl failed overnight

Status
Not open for further replies.

TonyBenn

Member
Jan 14, 2007
10
0
151
I'm assuming this has something to do with the upgrade to cPanel 11.24.4-R32443 - WHM 11.24.2. I'm on freebsd 6.2

Mysql is not starting, and I got this email too:

>>>>>>>>
[checkperlmodules] The perl module Text::CSV could not be installed.

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't locate Text/CSV.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/BSDPAN /usr/local/lib/perl5/site_perl/5.8.8/mach /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.8/mach /usr/local/lib/perl5/5.8.8 .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============
%Config::Config is read-only
<<<<<<<<<<

I tried to get mysql running again, including mysqlup. The perl warning came up again:

/scripts/mysqlup --force

...
If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
Method: Perl Expect
%Config::Config is read-only
....

Help!! I'm going to try and reinstall perl now...
 

TonyBenn

Member
Jan 14, 2007
10
0
151
Update: Perl upgrade worked, but Apache and Mysql were b0rked.

Cpanel staff were very helpful. My advice to anyone with a mysql.sock issue: check the log files in /var/lib/mysql. Mysql is pretty unhelpful at the CLI when it fails to start.

Mysql innodb files were corrupted (will see how much data was lost) and Apache was failing to load (php/mysql client library problem?).

How did I manage to get so many problems at once?!!
 

thomhol

Registered
Jan 22, 2008
3
0
51
re

same problem for me - centos 5.2, mysql 4.1.22 - i can't restart mysql after cpanel update

i would be glad if anyone could help in this issue asap


I'm assuming this has something to do with the upgrade to cPanel 11.24.4-R32443 - WHM 11.24.2. I'm on freebsd 6.2

Mysql is not starting, and I got this email too:

>>>>>>>>
[checkperlmodules] The perl module Text::CSV could not be installed.

This module is required by cPanel, and the system may not function correctly until it is installed, and functional. Below is the results of the auto-install attempt:

Test Run
==============
Can't locate Text/CSV.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.8/BSDPAN /usr/local/lib/perl5/site_perl/5.8.8/mach /usr/local/lib/perl5/site_perl/5.8.8 /usr/local/lib/perl5/site_perl /usr/local/lib/perl5/5.8.8/mach /usr/local/lib/perl5/5.8.8 .) at - line 1.
BEGIN failed--compilation aborted at - line 1.


Installer Run
==============
%Config::Config is read-only
<<<<<<<<<<

I tried to get mysql running again, including mysqlup. The perl warning came up again:

/scripts/mysqlup --force

...
If you get an 'Access denied' error, you should run this script again and
give the MySQL root user password as an argument with the --password= option
Method: Perl Expect
%Config::Config is read-only
....

Help!! I'm going to try and reinstall perl now...
 

TonyBenn

Member
Jan 14, 2007
10
0
151
looks very similar to my error (innodb corrupt).

You can disable innodb in your my.conf and restart mysql without it. Some of your db's may rely on it though, in which case you'll have to do some recovery, pref. with a dba.
 

blargman

Well-Known Member
Verifed Vendor
Sep 11, 2007
99
0
56
innodb_recovery_mode=4 in my.cnf

dump all db's
stop mysql
mv ib* files in /var/lib/mysql out of the way.
restart mysql

reimport db's.

You have MySQL 4.1? We're seeing this as a systemic problem with 4.1 and CPanel Release
 

TonyBenn

Member
Jan 14, 2007
10
0
151
thanks for the advice blargman, will try that, but there's another problem, not sure if anyone else is suffering from it.

The mysql libraries are not working. Apache failed to load, and when I rebuilt it using easyapache I got an error like this, which means that php can't use mysql:

-- Begin opt 'Mysql' --
-- Begin dryrun test 'mysql compilation test' --
/usr/local/lib/mysql/libmysqlclient.so: undefined reference to
`gethostbyname_r'
Can't exec "/cpmysql": No such file or directory at
/var/cpanel/perl/easy/Cpanel/Easy/Utils/MySQL.pm line 102.
Use of uninitialized value in string eq at
/var/cpanel/perl/easy/Cpanel/Easy/Utils/MySQL.pm line 108.
dryrun test 'mysql compilation test' did not return true

!! Dry run failed for 'Cpanel::Easy::PHP5::Mysql' skipping option !!

-- Begin opt 'Mysql of the system' --
-- Begin dryrun test 'mysql compilation test' --
dryrun test 'mysql compilation test' did not return true

!! Dry run failed for 'Cpanel::Easy::PHP5::MysqlOfSystem' skipping option
!!

Found this:
http://www.webhostingtalk.com/showthread.php?t=611686

I'm now reinstalling the mysql client AND rebuilding apache.... for about the 5th time today...
 

thomhol

Registered
Jan 22, 2008
3
0
51
yes I am using mysql 4.1. This helped me, my mysql is up at last. thank you for help!


innodb_recovery_mode=4 in my.cnf

dump all db's
stop mysql
mv ib* files in /var/lib/mysql out of the way.
restart mysql

reimport db's.

You have MySQL 4.1? We're seeing this as a systemic problem with 4.1 and CPanel Release
 
Last edited:

TonyBenn

Member
Jan 14, 2007
10
0
151
I just switched to innodb recovery mode (the command for mysql 4.1 is "innodb_force_recovery = 4") and the db refused to start.

All I got in the .err log was this, exactly the same, over and over again:

081217 16:15:11 InnoDB: Error: trying to access tablespace 538976288 page no. 538976288,
InnoDB: but the tablespace does not exist or is just being dropped.

Anyone know what else I can try to recover the tables?
 

earcos

Registered
Oct 26, 2003
1
0
151
exactly the same problem here, been trying all day to fix it withouth success. Innodb are corrupted and cPanel support is very unhelpful.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,481
35
208
cPanel Access Level
DataCenter Provider
Please post your kernel and mysql version here.

Our support is behind due to the release. We are very sorry if it is taking more then 30 minutes to get to your request.
 

blargman

Well-Known Member
Verifed Vendor
Sep 11, 2007
99
0
56
Nick/David

Do you know any other methods for recovery besides dumping? I'm dealing with 2 that won't even start with innodb enabled at the moment. sigh.
 
Status
Not open for further replies.