start tx in all modes except prod. We need TX on the test to support logged in users properly, while on prod we don't want the tx to prevent possible site rendering problems if DB is not available