I upgraded my ee v2 to v3 to buy some time for the rebuild to happen for this website. When I updated to this version everything seemed normal until this error message appeared in our VMs:
General error: 1290 The MySQL server is running with the --read-only option so it cannot execute this statement: DELETE FROM `exp_sessions` WHERE `last_activity ` < 1595353112 mysqli_connection.php:122
can anyone help me solving this issue, please? I have all the tracking sessions turned off and the config file is
$config["disable_all_tracking"] = "y";
this happens when I clear my sessions on logout of my website and it happens intermittently.
I really need your help with this.
I don’t think I’ve ever seen that error before. I don’t think it’s anything fixable in EE. Drop your host a support email/ticket, let them know that all of a sudden you’re getting that MySQL error and see what needs to be done to resolve it.
The query itself is fine and necessary, there’s something wrong with the db settings.
But reach out to your host, they should be able to fix it.
My setup is in the microsoft azure setup where we are serving from South Central and North Central Regions. South Central is our Master and North is a replica instance, thus having North not write to the DB. The error message appears only in NC region. I was wondering if there was any way to deactivate that exp_ssessions communication to the db??
It looks like any delete would fail, correct? If that’s the case, I don’t think it would be workable. Ditto just preventing that query across the board.
But I don’t have a firm grasp on how you’d need to modify ExpressionEngine for this particular setup. It’s got to be workable, though. Does microsoft have any suggestions that might apply?