Latest upgrade 4.7.6 problem

[Trues]

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, 2023 by Trues

[Jim M]

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.

 

[Trues]

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.

[Marc]

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

[Trues]

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

[Marc]

Glad to hear it 🙂