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!

MariaDB, WHMCS and SQLSTATE[HY000]

Discussion in 'Database Discussion' started by bloatedstoat, Mar 22, 2019.

Tags:
  1. bloatedstoat

    bloatedstoat Well-Known Member

    Joined:
    Jun 14, 2012
    Messages:
    150
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Victoria, Australia
    cPanel Access Level:
    Root Administrator
    Hello,

    We migrated (successfully) earlier this month from mySQL to MariaDB 10.1.38 on our version 78.0.18 server.

    Randomly we are receiving errors from WHMCS as per below when this command is issued php -q /home/homedir/public_html/crons/cron.php escalations.

    All other databases appear to be humming along nicely.

    Anyone else having this issue? Can anyone suggest a fix for this?

    Code:
    [Illuminate\Database\QueryException]  SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select * from `tbltask_status` where `tbltask_status`.`task_id` = 23 and `tbltask_status`.`task_id` is not null limit 1) 
    
    [PDOException]                                                                   
    SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared all [-F|--force] [--email-report [EMAIL-REPORT]]
    Thanks.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,503
    Likes Received:
    2,179
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @bloatedstoat,

    There's an older thread on the WHMCS support forums with a potential workaround:

    Critical Error SQLSTATE[HY000]

    However, due to the age of that thread I recommend reporting this directly to WHMCS via their ticket system. Let us know the outcome once they respond.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. bloatedstoat

    bloatedstoat Well-Known Member

    Joined:
    Jun 14, 2012
    Messages:
    150
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Victoria, Australia
    cPanel Access Level:
    Root Administrator
    @cPanelMichael thanks, I will keep that article on ice for now.

    I added this: innodb_buffer_pool_size = 2G to my.cnf and restarted mysql, since then there have been no further errors.

    I read that the default innodb_buffer_pool_size is set to 128M by default, raising it to 2GB has (thus far) solved the problem for us.

    Thanks.
     
    cPanelMichael likes this.
  4. bloatedstoat

    bloatedstoat Well-Known Member

    Joined:
    Jun 14, 2012
    Messages:
    150
    Likes Received:
    18
    Trophy Points:
    18
    Location:
    Victoria, Australia
    cPanel Access Level:
    Root Administrator
    As an update, the innodb_buffer_pool_size = 2G update I made was not the solution.

    Error happened again this morning. I will contact WHMCS. Thanks.
     
    Peter Smith and cPanelMichael like this.
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