Subject | first deadlock |
---|---|
Author | Duilio Foschi |
Post date | 2002-01-23T20:42:22Z |
Today - for the first time in my life - I did it :)
I run a SQL script with a simple INSERT from WISQL and the time stopped.
The cursor had the hourglass image and was fixing me from the center of the
screen.
The first thought was that WISQL had hanged, but I could easily switch to
other windows, the cursor followed the mouse: maybe it was something else.
I remembered that IB does housecleaning at unpredictable times, but I
waited long enough to decide that that was not the case.
Then I realized that I had IB_SQL in browse/data/edit mode and I was
editing a record referenced by the INSERT script.
Immediately after exiting the edit mode, WISQL finished the execution of
the script.
Well, know I definitely want to know more about IB deadlocks and how I can
prevent them in my programs, because a deadlock in a multiuser application
can be nasty.
Can somebody point me to some literature or explain the subject ?
Thank you
Duilio Foschi
I run a SQL script with a simple INSERT from WISQL and the time stopped.
The cursor had the hourglass image and was fixing me from the center of the
screen.
The first thought was that WISQL had hanged, but I could easily switch to
other windows, the cursor followed the mouse: maybe it was something else.
I remembered that IB does housecleaning at unpredictable times, but I
waited long enough to decide that that was not the case.
Then I realized that I had IB_SQL in browse/data/edit mode and I was
editing a record referenced by the INSERT script.
Immediately after exiting the edit mode, WISQL finished the execution of
the script.
Well, know I definitely want to know more about IB deadlocks and how I can
prevent them in my programs, because a deadlock in a multiuser application
can be nasty.
Can somebody point me to some literature or explain the subject ?
Thank you
Duilio Foschi