1832083 - landing_job row lock is not released when queue is empty

Status: RESOLVED FIXED

(Conduit :: Lando, defect)

Description

[Zeid [:zeid]]

This lock is present even if the query returns an empty result, and could cause any migration on the landing_job table to hang forever if in maintenance mode.

>>> LandingJob.next_job_for_update_query(["m-c"]).first()
>>> db.session.execute("select pid, relation, granted, mode from pg_locks where relation=42264").fetchall()
[(27069, 42264, True, 'RowShareLock')]
>>> db.session.commit()
>>> db.session.execute("select pid, relation, granted, mode from pg_locks where relation=42264").fetchall()
[]

Comment 1

[BMO Github Automation]

Attachment: [mozilla-conduit/lando-api] landing_worker: release lock when queue is empty (bug 1832083) (#308)