Enable to release PostgreSQL advisory lock

General
1

while using flyway to apply migrations I am getting error: enable to release PostgreSQL advisory lock the flag yb_silence_advisory_locks_not_supported_error is on at DB level. How to bypass this error.
using yb : 2.20.1.3

2

Hi

You need to set <set yb_silence_advisory_locks_not_supported_error=‘on’;> this session variable and run it.

3

Hi,
it is already set to ‘on’.

4

Hi
Got it. if you are running from flyway

You need to set at the user level like below
alter role flywayuser set yb_silence_advisory_locks_not_supported_error=on;

Here I assumed you have flywayuser in your db, if not please replace it with correct user name.