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 Failing

Discussion in 'Database Discussions' started by david.cocos, Jan 28, 2015.

  1. david.cocos

    david.cocos Member

    Joined:
    May 19, 2014
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I am receiving the same message as johnsap, and as a plus, mysql is failing at the same time with the message that innodb has ran out of locks. I was wondering if you have found any solution to the problem or the cause of it, or any more information in general.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    I've moved this post into it's own thread. Could you let us know the specific InnoDB error message that you see?

    Thank you.
     
  3. david.cocos

    david.cocos Member

    Joined:
    May 19, 2014
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I have written about my problem before in this post. The added thing would be that I have discovered that the cron error that is sent by email appears at the same time as the db fails, which would lead me to think that it it caused by it, or at least has to do with it.
    Any help would be very appreciated and thank you!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    As mentioned in the other thread, you may need to consult with a database specialist or a qualified system administrator if you are unable to determine why MySQL is crashing. I don't see anything cPanel-related that would lead to this problem.

    Thank you.
     
  5. david.cocos

    david.cocos Member

    Joined:
    May 19, 2014
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I kind of determined that mysql is crashing because of that cron, I think it can't be a coincidence that it fails exactly when that cron does, at the same time, and the exact number of times. My initial question was what solution did you provide to the person in the post that I initially posted to, or any other information regarding the problem in cause.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The user did not reference a ticket number, so it's not clear if they decided to submit a support ticket. Feel free to open a support ticket if you want us to take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  7. david.cocos

    david.cocos Member

    Joined:
    May 19, 2014
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Can you tell me what that cron actually does, how it works, etc...
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Yes, per our documentation:

    Thank you.
     
Loading...

Share This Page