Trues Posted February 6 Share Posted February 6 (edited) Hello, I recently had to migrate my site to a new server as the old one didn't support PHP 8. The migration went fine but now when i try to run the upgrade, It either times out with a 50X page or I get this error. Â Any help would be greatly appreciated. Thanks, MIke Edited February 6 by Trues Link to comment Share on other sites More sharing options...
Jim M Posted February 6 Share Posted February 6 Please contact your hosting provider as this is a MySQL server issue. The UPDATE command on that table is taking longer than what you are allowing it to, thus you are getting a lock timeout. Â Link to comment Share on other sites More sharing options...
Trues Posted February 6 Author Share Posted February 6 Thanks so much Jim. I'll contact my host again with this info and see what they say. I've been working with them on this issue for the past week with no luck. I'll keep trying. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 7 Share Posted February 7 It should be noted, all your tables should be using the INNODB table engine. I suspect that one at the least is running MyIsam. Without being over technical, its more efficient with locks Link to comment Share on other sites More sharing options...
Solution Trues Posted February 7 Author Solution Share Posted February 7 I made these changes to mysql and all is good now. Thanks again. innodb_lock_wait_timeout=1200 innodb_file_per_table=1 innodb_buffer_pool_size = 12G innodb_lock_wait_timeout = 200 innodb_log_file_size= 1600M Link to comment Share on other sites More sharing options...
Marc Stridgen Posted February 7 Share Posted February 7 Glad to hear it 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts