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

原创

已于 2022-07-06 10:01:03 修改 · 2.1k 阅读

标签

#postgresql #数据库

收录于

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

博客提到出现FlywayException，在尝试获取PostgreSQL咨询锁时重试次数超出限制，还提及存在关于咨询的脚本以及配置锁重试次数的路径。

开发板推荐：天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

点击查看

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 r