database-deadlocks - w3toppers.com

How is Hibernate deciding order of update/insert/delete

The problem you describe is not handled by the database, and from my experience is not entirely handled by Hibernate either. You have to take explicit steps to avoid it being a problem. Hibernate does some of the work for you. As per the previous answer, Hibernate ensures that within an isolated flush the inserts, … Read more

Working around MySQL error “Deadlock found when trying to get lock; try restarting transaction”

If you are using InnoDB or any row-level transactional RDBMS, then it is possible that any write transaction can cause a deadlock, even in perfectly normal situations. Larger tables, larger writes, and long transaction blocks will often increase the likelihood of deadlocks occurring. In your situation, it’s probably a combination of these. The only way … Read more