You have AutoCommit set to 0, and you never call $dbh->commit;
So DBI explicitly calls: $dbh->rollback for you just before exit, thus generating your warning.