Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Urgent help needed - MySql upgrade failed during WHM Update

Discussion in 'General Discussion' started by Chriz1977, Jun 8, 2007.

  1. Chriz1977

    Chriz1977 Well-Known Member

    Joined:
    Sep 18, 2006
    Messages:
    191
    Likes Received:
    0
    Trophy Points:
    166
    Hi

    I was updating cpanel to version 11 and all was going well untill i got this message :

    MySQL Setup Script Version 7.0
    Loaded cPPkgs::MySQL ok!
    This is the cPPkgs::MySQL 4.1.22 installer for Linux.
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-shared-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-devel-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-embedded-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-client-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-bench-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-server-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    Fetching http://httpupdate.cpanel.net/mysqlinstall/4.1.22-0/centos/4.4/MySQL-shared-4.1.22-0.glibc23.i386.rpm (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages index using db3 - Cannot allocate memory (12)
    error: cannot open Packages database in /var/lib/rpm
    rpmdb: Lock table is out of available locker entries
    error: db4 error(22) from db->close: Invalid argument
    error: cannot open Packages database in /var/lib/rpm
    This script updates all the mysql privilege tables to be usable by
    MySQL 4.0 and above.

    Now SQL wont work. Can i run /scripts/mysqlup and then try the update of whm again or will that make things worse?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Chriz1977, Jun 8, 2007
  2. brendanrtg

    brendanrtg Well-Known Member

    Joined:
    Oct 4, 2006
    Messages:
    311
    Likes Received:
    0
    Trophy Points:
    166
    Appears you have a memory problem. Is this on a VPS?

    The new CP 11 I heard requires more memory than 10 and as of now, it seems to create quite a few rlimit and memory problems on VPS.

    Maybe you can try /scripts/mysqlup --force and see if you have the same memory problem.

    If it persists, then you might want to contact your host and up the memory for your VPS.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 brendanrtg, Jun 8, 2007
  3. Chriz1977

    Chriz1977 Well-Known Member

    Joined:
    Sep 18, 2006
    Messages:
    191
    Likes Received:
    0
    Trophy Points:
    166
    Thats weird as i have 2 dedicated servers both with the same amount of memory and the other one is ok.

    Can i roll cpanel back to version 10 or is that even more trouble?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Chriz1977, Jun 8, 2007
  4. brendanrtg

    brendanrtg Well-Known Member

    Joined:
    Oct 4, 2006
    Messages:
    311
    Likes Received:
    0
    Trophy Points:
    166
    We went from 10 to 11 and a few problem arises which we cannot fix. We could not afford the downtime because our users were screaming, so we went back to 10 by updating it to STABLE, which is presently still at 10.

    Perform a STABLE upgrade and then do a upcp --force to ensure that its updated. You can also update system soft to be sure.

    HOWEVER, you mentioned you have DEDICATED SERVERS, so I am not sure if the problem is with the NODE because the problem you raised happens only on VPS. You might want to contact cpanel if yours is a dedicated.

    Cpanel is encouraging users to submit a support ticket if they have problems with 11.

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 brendanrtg, Jun 8, 2007
(You must log in or sign up to post here.)
Loading...
Similar Threads - Urgent help needed
  1. segun_nira

    Urgent need to Recover mistakenly deleted files

    segun_nira, Jul 24, 2017, in forum: E-mail Discussion
    Replies:
    7
    Views:
    781
    24x7server
    Jul 25, 2017
  2. cPanelBenny

    Urgent DCV Updates

    cPanelBenny, Jul 10, 2017, in forum: cPanel Announcements
    Replies:
    3
    Views:
    4,995
    linux4me2
    Jul 20, 2017
  3. phil99

    SOLVED Help with CSF custom regex

    phil99, Jun 10, 2018, in forum: Security
    Replies:
    10
    Views:
    105
    cPanelLauren
    Jun 11, 2018
  4. Spork Schivago

    Need help Setting up more than one DMARC record.

    Spork Schivago, Apr 29, 2018, in forum: Bind/DNS/Nameserver
    Replies:
    8
    Views:
    144
    Spork Schivago
    May 4, 2018
  5. xyourxhighnessx

    Need help with CSV/file manager.

    xyourxhighnessx, Apr 20, 2018, in forum: General Discussion
    Replies:
    4
    Views:
    113
    cPanelLauren
    Apr 20, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice