For me it was resolved in this way:
Select advisory locks:
SELECT pid, locktype, mode FROM pg_locks WHERE locktype="advisory";
SELECT pg_terminate_backend(<PID>);
For me it was resolved in this way:
Select advisory locks:
SELECT pid, locktype, mode FROM pg_locks WHERE locktype="advisory";
SELECT pg_terminate_backend(<PID>);