0

I have upgraded the magento version to 2.3.3 successfully, but when I try to run command

php bin/magento setup:upgrade

I am getting error:

error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: ALTER TABLE sales_order_grid MODIFY COLUMN base_grand_total decimal(20, 4) NULL COMMENT "Base Grand Total", MODIFY COLUMN base_total_paid decimal(20, 4) NULL COMMENT "Base Total Paid", MODIFY COLUMN grand_total decimal(20, 4) NULL COMMENT "Grand Total", MODIFY COLUMN total_paid decimal(20, 4) NULL COMMENT "Total Paid", MODIFY COLUMN subtotal decimal(20, 4) NULL COMMENT "Subtotal", MODIFY COLUMN shipping_and_handling decimal(20, 4) NULL COMMENT "Shipping and handling amount", MODIFY COLUMN total_refunded decimal(20, 4) NULL COMMENT "Total Refunded"

Anyone have idea?

  • Unfortunately It won't worked for me :( . – konika Oct 14 at 12:24
  • 1
    did you try sudo php -dmemory_limit =-1 bin/magento setup:upgrade – ASQ Oct 14 at 12:39
  • is your mysql cofig default or custom? – MagenX Oct 14 at 12:47
  • So finally I got the solution. I just increase the memory limit with 4 GB and run command with memory limit: php -dmemory_limit=4G bin/magento setup:upgrade – konika Oct 18 at 10:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.