I am looking for help for our production system. Our App was working fine in AWS RDS 5.6 but after upgrade to AWS RDS 5.7 we are getting locking problem.
here is error i captured from error log
" Lock wait timeout exceeded; try restarting transaction"
we tried to increase innodb_lock_wait_timeout but no luck.
Any suggestion ?
Let me add more facts we are using same region, same instance size and same application code. Only thing we changed is MySQL version.