Jeremy Worden•3w ago

GUI Down

Getting an error within docker for the windmill-server: PG lock already acquired by another server or worker, retrying in 5s. (look for the advisory lock in pg_lock with granted = true)

4 Replies

rubenf•3w ago

it's not an error it's waiting for the migration ran by another worker/server to be finished see #changelog about our latest big change

Jeremy WordenOP•3w ago

So if it's at this step I should just keep waiting:

    -- Migrate old `v2_job_completed.__logs` to `job_logs`
    INSERT INTO job_logs (job_id, workspace_id, logs)
    SELECT id, workspace_id, __logs
    FROM v2_job_completed
    WHERE __logs IS NOT NULL AND __logs IS DISTINCT FROM '##DELETED##'
    ON CONFLICT (job_id) DO UPDATE SET
        logs = CONCAT(job_logs.logs, EXCLUDED.logs)
    ;

    -- Migrate old `v2_job_completed.__logs` to `job_logs`
    INSERT INTO job_logs (job_id, workspace_id, logs)
    SELECT id, workspace_id, __logs
    FROM v2_job_completed
    WHERE __logs IS NOT NULL AND __logs IS DISTINCT FROM '##DELETED##'
    ON CONFLICT (job_id) DO UPDATE SET
        logs = CONCAT(job_logs.logs, EXCLUDED.logs)
    ;

My windmill-server is showing:

2025-02-06T21:19:06.851192Z  INFO src/main.rs:367: PostgreSQL version: PostgreSQL 14.15 (Debian 14.15-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit (windmill require PG >= 14)
2025-02-06T21:19:06.856538Z  INFO windmill-api/src/db.rs:71: Acquiring global PG lock for potential migration with pid: Some(420)
2025-02-06T21:19:06.857724Z  INFO windmill-api/src/db.rs:91: Acquired global PG lock
2025-02-06T21:19:06.862737Z  INFO windmill-api/src/db.rs:128: Started applying migration 20250201124748: v2 migrate from v1

2025-02-06T21:19:06.851192Z  INFO src/main.rs:367: PostgreSQL version: PostgreSQL 14.15 (Debian 14.15-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit (windmill require PG >= 14)
2025-02-06T21:19:06.856538Z  INFO windmill-api/src/db.rs:71: Acquiring global PG lock for potential migration with pid: Some(420)
2025-02-06T21:19:06.857724Z  INFO windmill-api/src/db.rs:91: Acquired global PG lock
2025-02-06T21:19:06.862737Z  INFO windmill-api/src/db.rs:128: Started applying migration 20250201124748: v2 migrate from v1

Just need to be patient?

rubenf•3w ago

yes

Jeremy WordenOP•3w ago

this ending up finishing after about 7 hours. all good now. thanks!

GUI Down

Did you find this page helpful?