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

    -- 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)
    ;