try adding commit/rollback to solve mysql issues