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.