fix sqlite rollback error and reword some tests