MariaDB, WHMCS and SQLSTATE[HY000]

[bloatedstoat]

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

Thanks.

 

[cPanelMichael]

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.

 

[bloatedstoat]

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

 

[bloatedstoat]

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.