• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

What caused the transactions in database deadlock?

 
Ranch Foreman
Posts: 313
4
Android Tomcat Server Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Marco Behler,

My previous company is working with bank, which will stored a lot of transactions in database per day.
And almost everyday we will hit deadlock issue which require us to insert all the deadlock transactions into database manually and carefully since all the data are belong to production.

The language used by my previous company is Java Spring Boot + Hibernate, but I have forgotten what is the connection pool we used.
I would like to know what is actually happened inside the database which causing them to be deadlock although I have no longer working at there.  

After review your ebook, I am really interested on it ! I believe your book will cleared up my doubts.

Thanks,
Randy.
 
Author
Posts: 109
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Randy,
good question, but unfortunately there could be hundreds of reasons for deadloks. Though to be completely honest, it reads like there was something competely off in your company. The question is also, what are a "lot" of transactions. Are we talking millions? Or much less? Usually, stuff like that shouldn't happen, but I guess you will find the deadlock sections in my book rather helpful!
 
Randy Tong
Ranch Foreman
Posts: 313
4
Android Tomcat Server Java
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Marco Behler wrote:The question is also, what are a "lot" of transactions. Are we talking millions? ...


More than hundred transaction per day, but only few transaction will hit deadlock when storing to database.
 
Marco Behler
Author
Posts: 109
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is what makes it kind of weird.

Let's say 500 transactions a day, in 24 hrs, or maybe even just 10 hours which is 20-50 transactions per hour. Which really is nothing. Unfortunately I cannot diagnose from over here, but with that kind of volume, deadlocks really shouldn't happen.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!