> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Nigel Weeks
> Sent: Friday, 19 August 2005 4:37 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Transaction isolation and server type
>
> > Hi Helen,
> >
> > Thanks for that - it sorted us out.
> >
> > Cheers,
> >
> > Ryan Thomas
> > TransActive Systems
> >
>
>
> What did you find in the end? What caused the deadlocks?

Sorry,

We had to set the RecVersion to true for both of our transactions - so they
ended up as:

RecVersion = true;
LockWait = false;
Isolation = tiCommitted;

One of our guys also found this on the IBObjects site which pretty much
described the scenario we were in:

http://faq.ibobjects.com/scripts/ibofaq.dll/ppQueryResult?submit=+Query+&key
wdid=503

We also found that once we moved to SS it seemed to work - then after a
couple of hours the problems started to occur again. So (as Helen pointed
out) it was not a problem with the server arch, which was my first thought.

It just seemed like the logical step that is was CS as we have the same code
deployed to many sites all running on SS and have never seen this before
(until this database however).

Anyway, it's beer-o'clock here so thanks for the help Helen, and have a good
weekend all.

-ryan.

> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> <font face=arial size=-1><a
> href="http://us.ard.yahoo.com/SIG=12hp59h1e/M=362329.6886308.7
> 839368.1510227/D=groups/S=1705115386:TM/Y=YAHOO/EXP=1124440612
> /A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?p
> age_id=1992
> ">Fair play? Video games influencing politics. Click and talk
> back!</a>.</font>
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>