kevinight
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 implemented
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 implemented
10 replies