More transaction usage in async tasks

[StephenChan]

Issue #447 left the database in an inconsistent state because an uncaught error was happening in the middle of a task, and that task wasn't running in a database transaction. We should use transactions more consistently in async tasks to minimize these kinds of situations.