MariaDB, WHMCS and SQLSTATE[HY000]

bloatedstoat

Well-Known Member
Jun 14, 2012
173
22
68
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.
 

bloatedstoat

Well-Known Member
Jun 14, 2012
173
22
68
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.
 
  • Like
Reactions: cPanelMichael