Posted February 6, 20232 yr 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, 20232 yr by Trues
February 6, 20232 yr Community Expert 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.
February 6, 20232 yr Author 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.
February 7, 20232 yr Community Expert 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
February 7, 20232 yr Author Solution 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