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.

Issue with tailwatchd failing after upgrading MySQL

Discussion in 'General Discussion' started by JonSimmonds, Jan 11, 2011.

  1. JonSimmonds

    JonSimmonds Registered

    Joined:
    Apr 24, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Leeds, UK
    Hi

    I have done some searching for other threads, found 2 good ones (http://forums.cpanel.net/f34/tailwatchd-failed-my-mail-120141.html & http://forums.cpanel.net/f5/tailwatchd-failing-161813.html) but none of the advice offered seams to have helped in my situation.

    I have had these issues since I upgraded apache from 2.0 to 2.2 and mysql from 5.0.91 - 5.1.51) - upgraded using the script to upgrade mysql in the whm web interface and apache via easy apache. (Php was also upgraded from 5.3.x to 5.3.4 (forgot what subversion))

    I am getting the following emails sent from cron jobs which have obviously gone wrong

    Code:
    Cron <root@myhost> /usr/bin/test -x /usr/local/cpanel/bin/tail-check && /usr/local/cpanel/bin/tail-check
    
    Notification => myemail@email.com via EMAIL [level => 1]
    Notification => mypager@email.com via PAGER [level => 1]
    
    
    
    tailwatchd on myhost.domain.com failed
    
    tailwatchd failed @ Tue Jan 11 17:35:01 2011. A restart was attempted automagically.
    Service Check Method: [check command] tailwatchd is not running
    
    
    
    Cron <root@myhost> /usr/bin/test -x /scripts/update_db_cache && /scripts/update_db_cache
    
    Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
    at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
    Compilation failed in require at /scripts/update_db_cache line 23.
    BEGIN failed--compilation aborted at /scripts/update_db_cache line 23.
    
    Have forced a upcp to no joy, any suggestions?
     
  2. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    What is your version of cPanel&WHM?

    To confirm, was a forced MySQL update ("mysqlup") also performed, (per my earlier reply in one of the related forum threads)?
    To gather more information, please let us know the output from the following commands:
    Code:
    # stat /usr/lib64/libmysqlclient.so* /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so
    # rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort
    Please try the following command to ensure the "DBD::mysql" Perl module is installed:
    Code:
    # /scripts/perlinstaller DBD::mysql
    If the above command does not help, please try it with the force option:
    Code:
    # /scripts/perlinstaller --force DBD::mysql
    To test for successful resolution, please run the following command to see if any errors are reported:
    Code:
    # /scripts/update_db_cache
     
  3. JonSimmonds

    JonSimmonds Registered

    Joined:
    Apr 24, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Leeds, UK
    Hi

    WHM version is 11.28.64

    in response to your questions
    Code:
    root@myhost [/home/myuser]# /scripts/mysqlup --force --verbose
    Updates for âmysqlâMYSQLUPâneverâ
    
    root@myhost [/home/myuser]]# /scripts/restartsrv_tailwatchd
    root@myhost [/home/myuser]]#
    
    Not sure why the â's are there in the response from mysqlup (for some reason putty has "is set to â€" as its title in windows) , no error messages from the restartsrv_tailwatchd
    Code:
    root@myhost [/home/myuser]# stat /usr/lib64/libmysqlclient.so* /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so
      File: `/usr/lib64/libmysqlclient.so' -> `libmysqlclient.so.16.0.0'
      Size: 24              Blocks: 0          IO Block: 4096   symbolic link
    Device: 801h/2049d      Inode: 278588      Links: 1
    Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
    Access: 2011-01-10 23:21:05.000000000 +0000
    Modify: 2011-01-09 12:42:57.000000000 +0000
    Change: 2011-01-09 12:42:57.000000000 +0000
      File: `/usr/lib64/libmysqlclient.so.15' -> `libmysqlclient.so.16'
      Size: 20              Blocks: 0          IO Block: 4096   symbolic link
    Device: 801h/2049d      Inode: 278723      Links: 1
    Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
    Access: 2011-01-12 22:07:17.000000000 +0000
    Modify: 2011-01-09 12:44:16.000000000 +0000
    Change: 2011-01-09 12:44:16.000000000 +0000
      File: `/usr/lib64/libmysqlclient.so.16' -> `libmysqlclient.so.16.0.0'
      Size: 24              Blocks: 0          IO Block: 4096   symbolic link
    Device: 801h/2049d      Inode: 278559      Links: 1
    Access: (0777/lrwxrwxrwx)  Uid: (    0/    root)   Gid: (    0/    root)
    Access: 2011-01-12 22:07:17.000000000 +0000
    Modify: 2011-01-09 12:42:57.000000000 +0000
    Change: 2011-01-09 12:42:57.000000000 +0000
      File: `/usr/lib64/libmysqlclient.so.16.0.0'
      Size: 5391845         Blocks: 10560      IO Block: 4096   regular file
    Device: 801h/2049d      Inode: 1540135     Links: 1
    Access: (0755/-rwxr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
    Access: 2011-01-12 22:07:17.000000000 +0000
    Modify: 2010-09-28 21:11:22.000000000 +0100
    Change: 2011-01-10 04:03:46.000000000 +0000
      File: `/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so'
      Size: 234338          Blocks: 472        IO Block: 4096   regular file
    Device: 801h/2049d      Inode: 69877       Links: 1
    Access: (0555/-r-xr-xr-x)  Uid: (    0/    root)   Gid: (    0/    root)
    Access: 2011-01-12 22:07:17.000000000 +0000
    Modify: 2011-01-05 22:17:18.000000000 +0000
    Change: 2011-01-05 22:17:18.000000000 +0000
    root@myhost [/home/myuser]#
    
    root@myhost [/home/myuser]# rpm -qa --qf "%{name}-%{version}-%{release}.%{arch}\n" | grep -i mysql | sort
    MySQL-bench-5.0.91-0.glibc23.x86_64
    MySQL-client-5.1.51-0.glibc23.x86_64
    MySQL-devel-5.1.51-0.glibc23.x86_64
    MySQL-server-5.1.51-0.glibc23.x86_64
    MySQL-shared-5.1.51-0.glibc23.x86_64
    MySQL-test-5.1.51-0.glibc23.x86_64
    root@myhost [/home/myuser]#
    

    Code:
    
    IO::Uncompress::Gunzip is up to date (2.033).
    Compress::Zlib is up to date (2.033).
    IO::Zlib is up to date (1.10).
    Archive::Tar is up to date (1.76).
    Archive::Zip is up to date (1.30).
    Net::Cmd is up to date (2.29).
    Net::FTP is up to date (2.77).
    Term::ReadKey is up to date (2.30).
    Term::ReadLine::Perl is up to date (1.0303).
    YAML is up to date (0.72).
    Parse::CPAN::Meta is up to date (1.40).
    Text::Glob is up to date (0.08).
    CPAN is up to date (1.9402).
    File::Which is up to date (1.09).
    DBD::mysql is up to date (4.018).
    perlmod--Install done
    root@myhost [/home/myuser]#
    
    the perl installer produced alot of output, I assume the output above is sufficent to show what version of DBD::mysql there is

    Code:
    root@myhost [/home/myuser]# /scripts/update_db_cache
    Can't load '/usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBD/mysql/mysql.so) at /usr/local/lib/perl5/5.8.8/x86_64-linux/XSLoader.pm line 70.
     at /usr/local/lib/perl5/site_perl/5.8.8/x86_64-linux/DBD/mysql.pm line 14
    Compilation failed in require at /scripts/update_db_cache line 23.
    BEGIN failed--compilation aborted at /scripts/update_db_cache line 23.
    root@myhost [/home/myuser]#
    

    Thanks for taking the time to help, hope we can get this fixed!
     
  4. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The message from mysqlup appears to be caused by the MySQL update preference being set to "never" in /etc/cpupdate.conf as configured via WebHost Manager: WHM: Main >> Server Configuration >> Update Preferences (Update Config)

    If the preference is changed to "inherit" that should allow mysqlup to proceed further; here is an example of what the updated entry would look like in /etc/cpupdate.conf:
    Code:
    # grep "^MYSQLUP=" /etc/cpupdate.conf
    MYSQLUP=inherit
    The old MySQL-bench RPM can be removed after the upgrade to MySQL 5.1:
    Code:
    # yum remove MySQL-bench
    We have internal case 38666 that is active for examining why the MySQL-bench RPM may be left installed when upgrading MySQL from version 5.0 to 5.1; however, I believe this symptom is not be directly related to original issue being discussed.

    If a forced MySQL update/reinstall does not alleviate the issue, I recommend submitting a support request so that we may assist with further, in-depth investigation; direct access will be needed to accurately diagnose and inspect the surrounding circumstances.

    Please let me know your support ticket ID number when available.
     
  5. JonSimmonds

    JonSimmonds Registered

    Joined:
    Apr 24, 2005
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Leeds, UK
    Hi, setting mysql updates to inherit, then running the mysqlup script would appear to have fixed the problem. For reference in the WHM webinterface neither never or inherit was selected for the packages to upgrade.

    Thank you for your help
     
  6. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    7
    Trophy Points:
    38
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Thank you for the follow-up and confirmation of resolution. :)

    If anyone else may experience similar difficulty, I would be curious to see the output of the following command before adjusting the MySQL update preference:
    Code:
    # cat /etc/cpupdate.conf
     
  7. 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
    Case 38666 was resolved in version 11.31.1.2. See if this is on your update tier yet by visiting Downloads - cPanel Inc.
     
  8. sehh

    sehh Well-Known Member

    Joined:
    Feb 11, 2006
    Messages:
    579
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Europe
    Guys, sorry to open a new thread. I'm having the same problem as described above.

    running /scripts/update_db_cache returns:

    Code:
    Can't load '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so) at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/XSLoader.pm line 71.
     at /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/DBD/mysql.pm line 15.
    Compilation failed in require at /scripts/update_db_cache line 26.
    BEGIN failed--compilation aborted at /scripts/update_db_cache line 26.
    
    Same for apache's modules that use mysql.so.

    I tried mysqlup --force but that didn't help. I also tried perinstaller --force DBD::mysql but that didn't do anything as well.

    Any help would be appreciated.

    Thank you.
     
Loading...

Share This Page