GET_LOCK and database sessions causing issues with AWS serverless database |
You can read more about in the manual:
https://codeigniter.com/user_guide/libra...oncurrency If you want to trigger RELEASE_LOCK you will need to close it manually. $this->session->close(); https://dev.mysql.com/doc/refman/5.7/en/...tions.html "A lock obtained with GET_LOCK() is released explicitly by executing RELEASE_LOCK() or implicitly when your session terminates (either normally or abnormally). Locks obtained with GET_LOCK() are not released when transactions commit or roll back." GET_LOCK are set to timeout after 300 seconds. And will be released after that time, if not being used. |
Welcome Guest, Not a member yet? Register Sign In |