remove print statement in test_ingest
explicit transaction rollback in the case of insert failure in ingest.py