[DocDB] Warn when unlocking a non-existent advisory lock

[yusong-yan]

Jira Link: DB-15515

Description

In PostgreSQL, attempting to unlock a non-existent advisory lock triggers a warning:

postgres=# select pg_advisory_unlock(1);
WARNING:  you don't own a lock of type ExclusiveLock
 pg_advisory_unlock 
--------------------
 f
(1 row)

However, in YugabyteDB, the same operation does not produce a warning:

postgres=# select pg_advisory_unlock(1);
 pg_advisory_unlock 
--------------------
 f
(1 row)

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.