Deadlock reported by database about authentik HOT 1 OPEN

Hello,

I had a similar issue.
I was trying to deploy a clean install of authentik and i was having this error.

I spent a couple of days trying to actually understand the issue but without success.

I was having issues reporting that the initial-setup page was not found and after a couple of changes i was able to get to the page to create the akadmin user but every time that i set a password i got another error.

The workaround i found it is quite peculiar but it worked.

I used the docker images as seen on the image above.

Started with the first release 2023.1.1 which worked without any issue.
I then used the image 2023.8.1 which is required before updating to the later version 2023.10.2 and where i believe the login has an issue as it did not require a password when login. This was reported on the post below.

https://github.com/goauthentik/authentik/security/advisories/GHSA-rjvp-29xq-f62w.

This issue was resolved on the version 2013.10.2.
I then used the version of 2024.2.0 which also worked and then proceeded to update it to the latest version 2024.4.2

Best Regards

from authentik.