The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql + Perl failed overnight

Discussion in 'General Discussion' started by TonyBenn, Dec 17, 2008.

Thread Status:
Not open for further replies.
  1. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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...
     
  2. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
  3. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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?!!
     
  4. thomhol

    thomhol Registered

    Joined:
    Jan 22, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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


     
  5. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
  6. thomhol

    thomhol Registered

    Joined:
    Jan 22, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I got this error after mysql restart but I don't know what I should do :eek:

    http://208.98.6.60/error.txt

    I opened a ticket but still I did not get help :(
     
  7. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  8. blargman

    blargman Well-Known Member

    Joined:
    Sep 11, 2007
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    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
     
  9. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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...
     
  10. thomhol

    thomhol Registered

    Joined:
    Jan 22, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    yes I am using mysql 4.1. This helped me, my mysql is up at last. thank you for help!


     
    #10 thomhol, Dec 17, 2008
    Last edited: Dec 17, 2008
  11. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
  12. TonyBenn

    TonyBenn Member

    Joined:
    Jan 14, 2007
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  13. earcos

    earcos Registered

    Joined:
    Oct 26, 2003
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    exactly the same problem here, been trying all day to fix it withouth success. Innodb are corrupted and cPanel support is very unhelpful.
     
  14. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    What's the ticket number on your ticket?
     
  15. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    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.
     
  16. blargman

    blargman Well-Known Member

    Joined:
    Sep 11, 2007
    Messages:
    99
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  17. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Please open a ticket @ https://tickets.cpanel.net/submit/

    Our techs have a guide for fixing this issue now. As soon as its cleaned up and verified we will be able to post it
     
  18. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
Loading...
Thread Status:
Not open for further replies.

Share This Page