Enable to release PostgreSQL advisory lock

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 :


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

it is already set to ‘on’.

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.