Even if we use "reasonable" idea, it's good idea to allow users to configure error handling mode (ignore, log, or retry) because even some major databases doesn't support transactions (MyISAM! It's still major for analytics). MyISAM can't rollback bulk-INSERT transaction.