Solved

InterBase DeadLock

Posted on 2002-04-09
2
533 Views
Last Modified: 2010-04-04
I am a delphi Programmer and using IBX
every time i use interbase over multi user i get error message "deadlock"
what should i do in my program to avoid this problem ?
0
Comment
Question by:osasoft
2 Comments
 
LVL 7

Expert Comment

by:God_Ares
ID: 6930580
it has somthing to do with transactions


t1    |t2
      | r(x)  
r(x)  |        
x=x+20|        
      | r(y)  
      | y=x+20
w(x)  |        
      | w(x)  
commit|
      |commit  

this are Bad transactions. t1 shoudn't read x until t2 has unlocked it.

you should learn more about this subject, search the internet, or take a course.

0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 50 total points
ID: 6930806
yep, its a transaction problem,
normally caused by two session like

session1 starts a transaction
session2 starts a transaction

session1 modifies table a
session2 modifies table b

session1 wants to modify table b
session2 wants to modify table a
-->deadlock, each session waits for the other

well, there is no common solution,
it depends on your code,
maybe you never end a transaction?

meikl ;-)


0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question