Results 1 to 11 of 11
  1. #1
    Join Date
    Apr 2004
    Location
    USA
    Posts
    445

    Mysql and crons keep failing

    WHM 10.8.0 cPanel 10.9.0-R57
    CentOS 3.8 i686 - WHM X v3.1.0

    I don't know if these are related problems, but it started happening right after a kernal update a couple of weeks ago.

    Mysql will stay up for a day or so, give or take a few hours, then fail, and the ONLY way I can get it up again is to reboot the server. Not a good thing.

    Crons stay up for only a few hours, then fail, but I can restart them to get them running again. At least I don't have to reboot the server to start crons again.

    How do I troubleshoot this?

    Idiot instructions, please.
    ►►►Come join us at A Fun FRIENDLY Christian Forum◄◄◄

  2. #2
    Join Date
    Sep 2006
    Location
    Michigan
    Posts
    64

    Server information

    Do you have any detail on the server load leading up to the hang?

    'sar -u', or 'sar -q' output..

    Are there any detail in /var/log/messages around the time of the hang?

    What kernel version are you running? 'uname -a' should show you this info..

    Nick

  3. #3
    Join Date
    Apr 2004
    Location
    USA
    Posts
    445
    sar -u and sar -q both said command not found

    Kernel version:

    2.4.21-47.0.1.ELsmp #1 SMP Thu Oct 19 11:33:45 EDT 2006 i686 i686 i386 GNU/Linux
    ►►►Come join us at A Fun FRIENDLY Christian Forum◄◄◄

  4. #4
    Join Date
    Apr 2004
    Location
    USA
    Posts
    445
    /var/log/messages doesn't show much. It just shows the last minute or two. It has several lines that looks like this, which I don't know how to interpret:

    sshd(pam_unix)[13583]: authentication failure; logname=
    uid=0 euid=0 tty=NODEVssh ruser= rhost=75.126.74.166-static.reverse.softlayer.co
    m user=root
    Nov 24 18:18:24 server6 sshd(pam_unix)[13584]: authentication failure; logname=
    uid=0 euid=0 tty=NODEVssh ruser= rhost=75.126.74.166-static.reverse.softlayer.co
    m user=root


    Do I need to look at it while mysql is failed?
    ►►►Come join us at A Fun FRIENDLY Christian Forum◄◄◄

  5. #5
    Dude
    run this
    /scripts/upcp --force
    /scripts/fixeverything

  6. #6
    Join Date
    Apr 2004
    Location
    USA
    Posts
    445
    Quote Originally Posted by Server-Specialist
    Dude
    run this
    /scripts/upcp --force
    /scripts/fixeverything
    Cpanel update only fixed it for a couple of days.

    But I forgot about /scripts/fixeverything so I just ran that one. I'll look in my notes and see if there are other fixit commands I've forgotten.
    ►►►Come join us at A Fun FRIENDLY Christian Forum◄◄◄

  7. #7
    Join Date
    Apr 2004
    Location
    USA
    Posts
    445
    Forgot to mention, I'm a dudette, not a dude
    ►►►Come join us at A Fun FRIENDLY Christian Forum◄◄◄

  8. #8
    Join Date
    Apr 2005
    Location
    Jacksonville, FL
    Posts
    977
    You're probably just running out of RAM. If you don't have one already, make yourself a swapfile that's at least equivalent to the amount of RAM in your machine.

    One thing you can do to ensure you don't have to manually reboot is to set MySQL to be monitored. You can do this in WHM under Services.

    Now selling BigVPS's!
    Jacksonville Colocation and dedicated servers by colo4jax
    We are *not* a reseller. We own our servers, switches, routers and racks.

  9. #9
    Join Date
    Apr 2004
    Location
    USA
    Posts
    445
    I guess there's a swap file, this is in WHM >> Main >> Server Status >> Service Status
    Swap Used 4.21 %

    I can't find where to monitor mysql, exactly where do I look?
    ►►►Come join us at A Fun FRIENDLY Christian Forum◄◄◄

  10. #10

  11. #11
    Join Date
    Oct 2005
    Location
    US
    Posts
    308
    You can monitor mysql at:

    >> WHM >> (Service Configuration) >> Service Manager

    Then check the monitor box under mysql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •