struggling to apply schema: "function procrastinate_fetch_job_v2(character varying[], smallint) does not exist"

[Victornovikov]

Very new to procrastinate.
I have been struggling with some weird issues when applying the schema to my Supabase instance.

I run procrastinate -a procrastinate_app.app worker

Everything seems to work at first, and then, when I try to restart a worker I would get errors like these:

relation "procrastinate_workers" does not exist
LINE 1: DELETE FROM procrastinate_workers
                    ^
QUERY:  DELETE FROM procrastinate_workers
    WHERE last_heartbeat < NOW() - (seconds_since_heartbeat || 'SECOND')::INTERVAL
    RETURNING procrastinate_workers.id
CONTEXT:  PL/pgSQL function procrastinate_prune_stalled_workers_v1(double precision) line 3 at RETURN QUERY
Database error.

I fixed it by manually creating the table (#1363)
but then I got the following error

function procrastinate_fetch_job_v2(character varying[], smallint) does not exist
LINE 2:     FROM procrastinate_fetch_job_v2($1::varchar[], $2);
                 ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Database error.

So basically, the schema wasn't applied fully (or things got lost?).. but then.. how come it worked right after I applied the schema and not when I tried to restart the worker?

I would appreciate any suggestions -- what am I doing wrong?

[Victornovikov]

Yeah.. after a couple of hours, if I try to restart a worker, I am getting an error... seemingly out of nowhere.

The function is, indeed, not in my DB. I only have v2

[Victornovikov]

I was on 2.9.1, lets see if updating to the latest will fix it