MariaDB, WHMCS and SQLSTATE[HY000]

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?

[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 -REPORT]]

Thanks.

cPanelMichael

March 26, 2019 21:26

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

bloatedstoat

March 26, 2019 21:41

@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.

March 27, 2019 20:37

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.

MariaDB, WHMCS and SQLSTATE[HY000]

Comments

Didn't find what you were looking for?