ArchiveTrace worker is holding long running transaction

Description

Sampling PG stats data revealed that ArchiveTrace worker is holding some long running transactions.

Is it possible that we remove build trace chunks stored in Object Storage inside a database transactions. This needs investigation.

Surfaced during my discussion with @andrewn.