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.

[case 64049] Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i386

Discussion in 'General Discussion' started by mtbwacko, Jan 29, 2013.

  1. mtbwacko

    mtbwacko Well-Known Member

    Joined:
    Nov 30, 2004
    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    6
    My automatic update for one of my servers failed last night for the first time in years. Does anyone know how to remedy this? Thanks.

    [20130128.230346] Testing RPM transaction
    [20130128.230348] error: Failed dependencies:
    [20130128.230348] MySQL conflicts with mysql-5.0.77-4.el5_4.2.i386
    [20130128.230348] W Exit Code: 254
    [20130128.230348] ***** FATAL: Test install failed: error: Failed dependencies:
    [20130128.230348] MySQL conflicts with mysql-5.0.77-4.el5_4.2.i386
    [20130128.230348] The Administrator will be notified to review this output when this script completes
    [20130128.230348] E Error testing if the RPMs will install: Died at /usr/local/cpanel/scripts/updatenow.static line 12517.
    [20130128.230348] E Detected events which require user notification during updatenow. Will send iContact the log
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    Re: Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i38

    From the output it appears you are using the MySQL RPM provided by RHEL/CentOS 5. Do you recall how you disabled the cPanel MySQL RPM? It appears this is not properly detected resulting in the aborted upgrade.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Re: Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i38

    Hello :)

    Could you also submit a support ticket so we can take a closer look?

    Submit A Ticket

    Please provide us with the ticket number so we can update this thread.

    Thank you.
     
  4. mtbwacko

    mtbwacko Well-Known Member

    Joined:
    Nov 30, 2004
    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    6
    Re: Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i38

    Kenneth, thanks for the reply. I've never disabled the cPanel MySQL RPM and this is the first time an update failure has occurred for a server that's been online for years using automatic cPanel updates. I guess I'll submit a support ticket on this. Thanks!

     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Re: Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i38

    Could you let us know the ticket number when you open the ticket so we can update this thread with the outcome?

    Thanks.
     
  6. mtbwacko

    mtbwacko Well-Known Member

    Joined:
    Nov 30, 2004
    Messages:
    54
    Likes Received:
    0
    Trophy Points:
    6
    Re: Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i38

    Yes, the cPanel ticket number is 3690013.

    Thanks,
    Greg
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Re: Overnight Update Failed MySQL conflicts with mysql-5.0.77-4.el5_4.2.i38

    The ticket indicates this is the result of a rogue MySQL RPM installed on the system:

    Code:
    # rpm -qa|grep mysql-5
    mysql-5.0.77-4.el5_4.2
    
    You will notice this does not match the other installed MySQL RPMs:

    Code:
    MySQL-server-5.5.28-2.cp.1132
    MySQL-devel-5.5.28-2.cp.1132
    MySQL-client-5.5.28-2.cp.1132
    MySQL-test-5.5.28-2.cp.1132
    MySQL-shared-5.5.28-2.cp.1132
    Removing the mysql-5.0.77-4.el5_4.2 RPM will allow the update to proceed.

    Thank you.
     
  8. pantherqs

    pantherqs Member

    Joined:
    Aug 21, 2004
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Same problem here, should I just rpm -e mysql-5.0.77-4.el5_4.2 then reinstall? Will the database be wiped?
     
  9. JohnR

    JohnR Member

    Joined:
    Dec 12, 2002
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    I have the same problem.

    [20130313.091648] error: Failed dependencies:
    [20130313.091648] MySQL conflicts with mysql-5.0.95-1.el5_7.1.i386
    [20130313.091648] W Exit Code: 254
    [20130313.091648] ***** FATAL: Test install failed: error: Failed dependencies:
    [20130313.091648] MySQL conflicts with mysql-5.0.95-1.el5_7.1.i386
    [20130313.091648] The Administrator will be notified to review this output when this script completes
    [20130313.091648] ***** FATAL: Error testing if the RPMs will install: Died at /usr/local/cpanel/scripts/updatenow.static line 12521.

    This is on a server with only three accounts and I get notified of any logins as I should be the only one logging in. Not sure how a "rogue" version would get installed.

    What is the best way to get around this without loosing data or causing downtime?
     
  10. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    745
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
  11. linehooks

    linehooks Registered

    Joined:
    Mar 14, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I have the same problem :( will removing the RPM delete my databases?

    It there a way of remedying this without much downtime please?

    Help?!

     
  12. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    745
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Howdy,

    If you use the rpm command

    Code:
    rpm -e --nodeps --allmatches --justdb <RPMNAME>
    
    It will only remove entry of the RPM from the RPM database. No binaries or files will be touched.

    Thanks!
     
  13. linehooks

    linehooks Registered

    Joined:
    Mar 14, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thank you kindly Sir. worked a charm!
     
Loading...

Share This Page