PostgreSQL: WARNING: you don't own a lock of type ExclusiveLock

### Describe the bug

Postgres Log getting spammed with following error which caused /var to fill up and postgres/authentik to halt:

WARNING: you don't own a lock of type ExclusiveLock

This seems to be a re-ocurrence of #17770 / #17993

### How to reproduce

Use authentik 2026.5.5 on docker with postgresql

### Expected behavior

Not spam the log

### Screenshots

_No response_

### Additional context

_No response_

### Deployment Method

Docker

### Version

2026.5.5

### Relevant log output

```shell
2026-07-17 07:45:05.151 CEST [3320107] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.157 CEST [3320086] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.162 CEST [3320114] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.216 CEST [3320091] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.216 CEST [3320097] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.218 CEST [3320109] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.220 CEST [3320092] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.221 CEST [3320106] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.227 CEST [3320113] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.228 CEST [3320101] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.240 CEST [3320105] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.267 CEST [3320082] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
2026-07-17 07:45:05.285 CEST [3320093] authentik@authentik WARNING: you don't own a lock of type ExclusiveLock
```

Reproduce the warning with authentik 2026.5.5 in Docker using PostgreSQL, then compare the behavior with issues #17770 and #17993. Trace the operation that produces the ExclusiveLock warnings; done means the warning no longer floods the PostgreSQL log or causes /var and authentik to halt.

Written by the indexing model from the issue text.