What is the SQL statements that require Postgres Advisory Lock
hi, could anyone help point what are the SQL statements that require Postgres Advisory Lock, which cause the following error:
thanks in advance!
jemalloc enabled
Connecting to database...
{"timestamp":"2025-05-27T17:02:29.786757Z","level":"INFO","message":"Could not remove sqlx migration with version=20250131115248: error returned from database: relation \"_sqlx_migrations\" does not exist","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.790508Z","level":"INFO","message":"Could not remove sqlx migration with version=20250201145632: error returned from database: relation \"_sqlx_migrations\" does not exist","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.794294Z","level":"INFO","message":"Could not remove sqlx migration with version=[20250201145630, 20250201145631] : error returned from database: relation \"_sqlx_migrations\" does not exist","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.800722Z","level":"INFO","message":"Acquiring global PG lock for potential migration with pid: Some(14391)","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.808052Z","level":"ERROR","message":"Error acquiring lock: error returned from database: advisory locks are not yet implemented","target":"windmill_api::db"}
Error: Error migrating db: Migrating database: while executing migrations: error returned from database: advisory locks are not yet implementedjemalloc enabled
Connecting to database...
{"timestamp":"2025-05-27T17:02:29.786757Z","level":"INFO","message":"Could not remove sqlx migration with version=20250131115248: error returned from database: relation \"_sqlx_migrations\" does not exist","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.790508Z","level":"INFO","message":"Could not remove sqlx migration with version=20250201145632: error returned from database: relation \"_sqlx_migrations\" does not exist","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.794294Z","level":"INFO","message":"Could not remove sqlx migration with version=[20250201145630, 20250201145631] : error returned from database: relation \"_sqlx_migrations\" does not exist","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.800722Z","level":"INFO","message":"Acquiring global PG lock for potential migration with pid: Some(14391)","target":"windmill_api::db"}
{"timestamp":"2025-05-27T17:02:29.808052Z","level":"ERROR","message":"Error acquiring lock: error returned from database: advisory locks are not yet implemented","target":"windmill_api::db"}
Error: Error migrating db: Migrating database: while executing migrations: error returned from database: advisory locks are not yet implementedthanks in advance!
