fix issue with being able to provision a connection that was not commited (solution: have allocated flag in database)