In the doc section over transaction, for a lower-level transaction API, the following example is given:

transaction = await database.transaction()
try:
    ...
except:
    transaction.rollback()
else:
    transaction.commit()

Actually the rollback and commit are all async methods. So they shall be all awaited.