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 update error

Discussion in 'Database Discussions' started by vXvTails, May 1, 2010.

  1. vXvTails

    vXvTails Registered

    Joined:
    Mar 12, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Sorry for my English.
    If upgrade MySQL 5.0 > 5.1, I get an error:
    Code:
       1:MySQL-devel            ########################################### [100%]
    error: unpacking of archive failed on file /usr/lib64/mysql/plugin/ha_example.a;4bdbf297: cpio: open failed - Not a directory
       1:MySQL-server           ########################################### [100%]
    error: unpacking of archive failed: cpio: lstat failed - Not a directory
    
    CentOS 5.4 x86-64
    cPanel 11.25.0-R44718 - WHM 11.25.0 - X 3.9

    All log:
    View attachment mysql_update_log.txt
     
    #1 vXvTails, May 1, 2010
    Last edited: May 1, 2010
  2. WiredTree Joe

    WiredTree Joe Well-Known Member
    PartnerNOC

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Chicago, IL
    I am assuming you are on some sort of VPS (Virtuozzo most likely -- just a guess) and seeing errors such as this:

    Code:
    error: unpacking of archive failed on file /usr/lib64/mysql/plugin/ha_example.a;4bdbf297: cpio: open failed - Not a directory
    most likely means that your VPS cache is corrupted or missing files. If you do a

    Code:
    ls -la /usr/lib64/mysql/plugin/
    You will most likely see files with ??????? for attributes or they will be flashing in red. This is something your VPS provider needs to repair as your VPS cannot overwrite the files because there is issues with your VPS cache.

    If you are on a dedicated server, might want to fsck your drive.
     
  3. vXvTails

    vXvTails Registered

    Joined:
    Mar 12, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Code:
    $ls -la /usr/lib64/mysql/plugin/
    ls: /usr/lib64/mysql/plugin/: Это не каталог
    "Это не каталог" - "Not a directory"

    So I need to use fsck?

    Yes.
     
  4. vXvTails

    vXvTails Registered

    Joined:
    Mar 12, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I guess I need to enter a command after the upgrade. Yes?
     
  5. WiredTree Joe

    WiredTree Joe Well-Known Member
    PartnerNOC

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Chicago, IL
    Try:

    Code:
    mkdir /usr/lib64/mysql/plugin/
    then

    Code:
    /scripts/mysqlup --force 
     
  6. WiredTree Joe

    WiredTree Joe Well-Known Member
    PartnerNOC

    Joined:
    Dec 13, 2006
    Messages:
    68
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Chicago, IL
    If that works and mySQL is now running mySQL 5.1.x, you will want to run easyapache (/scripts/easyapache) and rebuild PHP so the mySQL libs in PHP are the new version as well.
     
Loading...

Share This Page