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.

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

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

  1. vicos

    vicos Well-Known Member

    Joined:
    Apr 18, 2003
    Messages:
    62
    Likes Received:
    0
    Trophy Points:
    6
    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:
    1
    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:
    746
    Likes Received:
    11
    Trophy Points:
    18
    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!
     
  4. headout

    headout Well-Known Member

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

Share This Page