I have customer password change using this way and password change successfully

after i am login customer then login is not working below type error showing and before password change also not login this customer

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction, query was: UPDATE `customer_entity` SET `failures_num` = ?, `first_failure` = ?, `lock_expires` = ? WHERE (entity_id = '20377')

customer login 1205 Lock wait timeout exceeded; try restarting transaction,

After i have also truncate customer_visitor table and restart mysql server but still no luck for me

then i am login customer and it's going 504 Gateway Timeout


1 Answer 1


Try changing the innodb lock wait timeout setting in php.ini file.


If not working also try to ensure the nginx and php-fpm did not timeout.

fastcgi_read_timeout 600;
proxy_read_timeout 600;
  • Thank you for answer but same customer working on devsite and production website not working Commented Mar 26, 2020 at 17:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.