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.

setupdbmap eats all server memory

Discussion in 'Database Discussions' started by RACKSET, Jun 6, 2012.

  1. RACKSET

    RACKSET Active Member

    Joined:
    Apr 28, 2006
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    localhost
    /usr/local/cpanel/bin/setupdbmap eats all server memory and causes server overload on each run with upcp.
    -- CentOS 6.2 KVM Guest.
    This only effects one server, as we have other servers the same config (actually clone) without any issue. I think the script should itself check it's memory usage to prevent this. Any advise to resolve this?

    Also have to mention I have not any report of db/mysql issues from users, seems all works ok.
     
  2. MilesWeb

    MilesWeb Well-Known Member
    PartnerNOC

    Joined:
    May 23, 2012
    Messages:
    174
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    @RACKSET How many databases on your server ? I have had executed it on many of the shared servers, but never had such issue. Check mysql error logs file under /var/lib/mysql. See if any database is corrupt.
     
  3. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    It would be very helpful to take a look at the server that is encountering the problem. If you could open a ticket using the link in my signature, we would be happy to help you out.

    Thanks!
     
  4. RACKSET

    RACKSET Active Member

    Joined:
    Apr 28, 2006
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    localhost
    I found the cause of this, the script runs mysql query "SELECT User, Db FROM db WHERE user REGEXP '\\_' " and this caused mysql to eat all memory. I also was able to reproduce this issue from mysql console with running the same query. So it's not an issue on setupdbmap script, but why mysql is not able to handle this query? That's the story.

    Mysql process status shows this thread in "Sending data". There is about 3000 db's on the server and all db's as I know work correctly. Any advise to improve "mysql db" appreciated.
     
  5. RACKSET

    RACKSET Active Member

    Joined:
    Apr 28, 2006
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    localhost
    Anyone can help to resolve mysql issue please?
     
  6. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,466
    Likes Received:
    196
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Have you opened a ticket on this? That would be your best way forward I believe.
     

Share This Page