Update worker transaction bookkeeping

Created by: efritz

Promote the entire worker transactionally instead of just the database to reduce transaction bookkeeping errors.

Source: https://github.com/sourcegraph/sourcegraph/pull/10818#discussion_r427628160