Jump to content

Featured Replies

Posted

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.

Could contain: File, Webpage

 

Any help would be greatly appreciated.

Thanks,

MIke

Edited by Trues

Solved by Trues

Go to solution
  • 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.

 

  • 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.

  • 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

  • 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

Recently Browsing 0

  • No registered users viewing this page.