FlywayException: Number of retries exceeded while attempting to acquire PostgreSQL advisory loc

平淡的才是生活

已于 2022-07-06 10:01:03 修改

阅读量1.7k

点赞数 1

分类专栏：数据库文章标签： postgresql 数据库

于 2022-07-06 09:56:50 首次发布

本文链接：https://blog.csdn.net/A2830563/article/details/125633378

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

FlywayException: Number of retries exceeded while attempting to acquire PostgreSQL advisory lock

There are some script about advisory:

----this will try to obtain the lock. If the lock is successfully obtained, Postgres will return 't', otherwise 'f' if you failed you obtain the lock,will not wait until it can obtain the lock, it will return immediately with 't' or 'f'.
SELECT pg_try_advisory_lock(1);
---- This will release one lock reference for the id n.
SELECT pg_advisory_unlock(1)
----this will unlock all advisory locks currently held by you in your session
SELECT pg_advisory_unlock_all();