create new database connection for each connection to avoid connections stuck in a bad transaction