Results 1 to 12 of 12

Thread: Server lockups - dbindex / updateuserdomains

  1. #1
    Member
    Join Date
    Feb 2003
    Posts
    311

    Default Server lockups - dbindex / updateuserdomains

    My server is locking up just about every hour since this morning (runs out of RAM, CPU shoots up). When I was able to capture a top, I noticed a huge amount of theses processes:

    /scripts/updateuserdomains
    /usr/local/cpanel/bin/dbindex

    How do I fix this?

  2. #2
    Registered User
    Join Date
    May 2008
    Location
    chandigarh, India
    Posts
    1

    Default Re: Server lockups - dbindex / updateuserdomains

    Hi,

    I am facing same issue. Any fix for this?

    Thanks

  3. #3
    Member
    Join Date
    Feb 2003
    Posts
    311

    Default Re: Server lockups - dbindex / updateuserdomains

    Well, here's what I did... not sure if its a good fix or not, but so far I've been up for two hours which is longer than at any point since 5am.

    crontab -e
    remove the line for /usr/local/cpanel/bin/dbindex

    Then changed my update config to stable version of cPanel (from current) and ran /scripts/upcp --force

    Like I said, I'm keeping my fingers crossed but things haven't been going nuts since. I would like to know what dbindex does because it only seems to be on this server (I have others that aren't set to autoupdate cPanel that don't have it). So I'm guessing its something new they added in current?

  4. #4
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: Server lockups - dbindex / updateuserdomains

    Please make sure your version of dbindex was successfully updated. If you are running 11.28 RELEASE, you can use the following command to ensure you have the latest one.

    Code:
    wget -O /usr/local/cpanel/bin/dbindex http://httpupdate.cpanel.net/cpanelsync/RELEASE/bin/dbindex
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

  5. #5
    Member
    Join Date
    Feb 2003
    Posts
    311

    Default Re: Server lockups - dbindex / updateuserdomains

    Quote Originally Posted by cpanelnick View Post
    Please make sure your version of dbindex was successfully updated. If you are running 11.28 RELEASE, you can use the following command to ensure you have the latest one.

    Code:
    wget -O /usr/local/cpanel/bin/dbindex http://httpupdate.cpanel.net/cpanelsync/RELEASE/bin/dbindex

    Nick,

    I'm running Stable 11.26.20 now. What is dbindex? Should the cron for it be put back in?

  6. #6
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: Server lockups - dbindex / updateuserdomains

    Quote Originally Posted by compunet2 View Post
    Nick,

    I'm running Stable 11.26.20 now. What is dbindex? Should the cron for it be put back in?
    dbindex is part of db-mapping. If you switched back to STABLE you do not need it.
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

  7. #7
    Member
    Join Date
    Nov 2010
    Posts
    52

    Default Re: Server lockups - dbindex / updateuserdomains

    We experienced this on 5 servers this morning and had to downgrade all of them. I contacted CPanel and here's what they recommended to fix it for the time being until the next update is released with the fix:

    mv /usr/local/cpanel/bin/dbindex /usr/local/cpanel/bin/dbindex.disabled


    Or simply do crontab -e and delete the cronjob for dbindex.

    It's a definite bug and it's crashing a lot of servers. Caused one helluva Friday morning for us.

  8. #8
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: Server lockups - dbindex / updateuserdomains

    Quote Originally Posted by RCraft View Post
    We experienced this on 5 servers this morning and had to downgrade all of them. I contacted CPanel and here's what they recommended to fix it for the time being until the next update is released with the fix:

    mv /usr/local/cpanel/bin/dbindex /usr/local/cpanel/bin/dbindex.disabled
    This happens when:

    1) dbindex DOES NOT get updated to 11.28.33 version
    2) updateuserdomains DOES get updated to 11.28.33 version
    3) you have missing entries in /etc/dbowners.

    The command I posted above to manually update dbindex to the 11.28.33 version and will resolve the problem without the need to disable it.
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

  9. #9
    Member
    Join Date
    Nov 2010
    Posts
    52

    Default Re: Server lockups - dbindex / updateuserdomains

    Quote Originally Posted by cpanelnick View Post
    This happens when dbindex DOES NOT get updated and updateuserdomains DOES. The command I posted above to manually update dbindex will resolve the problem without the need to disable it.
    Well, your information conflicts with the answers I received in ticket # 1019930. They even sent me an additional update a little while ago telling me to move that directory.

  10. #10
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: Server lockups - dbindex / updateuserdomains

    Quote Originally Posted by RCraft View Post
    Well, your information conflicts with the answers I received in ticket # 1019930. They even sent me an additional update a little while ago telling me to move that directory.
    RCraft,

    I do apologize, however the information I posted above is the most current. While we were investigating this problem, we were asking people to disable it. The root cause has now been determined, and this is no longer the case.

    Thanks
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

  11. #11
    Member
    Join Date
    Nov 2010
    Posts
    52

    Default Re: Server lockups - dbindex / updateuserdomains

    Quote Originally Posted by cpanelnick View Post
    RCraft,

    I do apologize, however the information I posted above is the most current. While we were investigating this problem, we were asking people to disable it. The root cause has now been determined, and this is no longer the case.

    Thanks
    Thanks. I'm just going to wait for 11.28 to go to stable.

  12. #12
    cPanel Staff cpanelnick's Avatar
    Join Date
    Feb 2003
    Location
    Houston, TX
    Posts
    4,770

    Default Re: Server lockups - dbindex / updateuserdomains

    11.28.35 (available now) will address this problem.
    -Nick
    cPanel Inc.

    Need support? Submit a request here. Complimentary support is available to all license holders regardless of where you purchased your license.
    Need a complimentary support account? Create one here.

Similar Threads

  1. HELP updateuserdomains
    By NNNils in forum cPanel & WHM Discussions
    Replies: 14
    Last Post: 04-02-2006, 06:27 PM
  2. /scripts/updateuserdomains error on every server I check
    By jsnape in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 11-04-2005, 12:28 PM
  3. /scripts/updateuserdomains help
    By shann in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 09-24-2005, 06:24 PM
  4. scripts? updateuserdomains?
    By daneisfly in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 05-18-2004, 09:03 PM
  5. Mysql4 and server lockups
    By Redmak in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 08-21-2002, 01:41 AM