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!

[Cpanel::TailWatch] [SQLERR] Could not prepare query

Discussion in 'Database Discussion' started by vicos, Feb 17, 2012.

  1. vicos

    vicos Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    62
    Likes Received:
    1
    Trophy Points:
    156
    The past few days, have received emails like the following:

    /var/log/chkservd.log was created several days ago and is zero/0 bytes.

    /usr/local/cpanel/logs/tailwatchd_log has the following at the tail end:

    Code:
    [2012-01-14 08:58:53 -0500] [Cpanel::TailWatch] [SQLERR] Could not prepare query, logging SQL to /var/cpanel/sql
    
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/cpanel/Cpanel/TailWatch/Eximstats.pm line 354, <GEN2> line 98253.
    
    [2012-02-14 09:34:04 -0500] [Cpanel::TailWatch] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql
    This log file goes back to 2009 and contains many instances of:

    Code:
    [Cpanel::TailWatch] [SQLERR] Could not prepare query, logging SQL to /var/cpanel/sql
    Not sure if there is more than one problem here.
     
  2. rocketpants

    rocketpants Registered

    Joined:
    Feb 21, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Did you find a resolution to this? I've started seeing the same issue as of today.

    The failed SQL is inserting into the eximstats.smtp table - looking at the SQL itself it appears OK, so not sure what the problem is here.
     
  3. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    751
    Likes Received:
    11
    Trophy Points:
    143
    Location:
    Texas
    cPanel Access Level:
    Root Administrator
    Howdy,

    I would like to take a closer look could one or both of you submit a ticket?

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. headout

    headout Well-Known Member

    Joined:
    Aug 20, 2003
    Messages:
    78
    Likes Received:
    0
    Trophy Points:
    156
    Any solution for this yet?
     
Loading...

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.
    Dismiss Notice