Wrap query in transaction

This alleviates current locking issues.

Related to swh/infra/sysadm-environment#4228 (closed)

Test Plan

swh/infra/sysadm-environment#4228 (closed)

Corrupt objects are popping up now (and growing fast):

Tue 31 May 2022 11:01:14 AM CEST (every 2s)

+-------------------------------+-------+
|              now              | count |
+-------------------------------+-------+
| 2022-05-31 09:01:14.233113+00 |  1620 |
+-------------------------------+-------+
(1 row)
+-------------------------------+-------+
|              now              | count |
+-------------------------------+-------+
| 2022-05-31 09:01:54.394741+00 |  3233 |
+-------------------------------+-------+
(1 row)

Time: 6.463 ms

---

Migrated from D7914 (view on Phabricator)

Build is green

Patch application report for D7914 (id=28526)

Rebasing onto f2485046...

Current branch diff-target is up to date.

Changes applied before test

commit 377f5e084ab71ec6fb4f9c69b89ff2364d93c3eb
Author: Antoine R. Dumont (@ardumont) <antoine.romain.dumont@gmail.com>
Date:   Tue May 31 10:35:45 2022 +0200

    Wrap query in transaction
    
    This might help alleviate current locking issues.
    
    Related to swh/infra/sysadm-environment#4228

See https://jenkins.softwareheritage.org/job/DSCRUB/job/tests-on-diff/46/ for more details.

mentioned in issue swh-core#4305 (closed)

makes sense to me

Merge request was accepted

approved this merge request

Some references in the commit message have been migrated:

• T4228 is now swh/infra/sysadm-environment#4228 (closed)

Reword commit message

Build is green

Patch application report for D7914 (id=28527)

Rebasing onto f2485046...

Current branch diff-target is up to date.

Changes applied before test

commit 31bcec6000a8e7130f67a1d0f3b3d9c5f4fd6aba
Author: Antoine R. Dumont (@ardumont) <antoine.romain.dumont@gmail.com>
Date:   Tue May 31 10:35:45 2022 +0200

    Wrap queries in transaction
    
    This alleviates current locking issues where nothing gets written in production.
    
    Related to swh/infra/sysadm-environment#4228

See https://jenkins.softwareheritage.org/job/DSCRUB/job/tests-on-diff/47/ for more details.

Merge request was merged

closed