[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

InterBase DeadLock

Posted on 2002-04-09
2
Medium Priority
?
553 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 200 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This is an update to some code that someone else posted on Experts Exchange. It is an alternate approach, I think a little easier to use, & makes sure that things like the Task Bar will update.
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

607 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