Re: [Dbi-interbase-devel] Deadlocks galore

[Edwin P. <ed....@co...>]

Sorry folks for my late reply, I was off the office for the last two
days.

"Mark D. Anderson" wrote:
> 
> > Commit-retaining should IMHO only be used in autocommit mode (it only
> > matters in autocommit mode as commits are more infrequent in normal mode,
> > so the performance hit from starting a new transcation is much smaller)
> 
> i don't think commit_retaining should be the default behavior in either mode,
> as i think i've ranted about previously in this forum :).
> it has a very specialized use, when there is only a single writer for a table.
> it should be an optional behavior, set at create time or commit time.

I've just dropped commit_retaining. See the new InterBase.xs and
dbdimp.c in the cvs repository.
The changes are the improved Flemming's patch which was unsufficient
(but very clear in reflecting his idea, 
thanks to Flemming).

Let me know if there's still any problem with this.

> 
> > * Explicit commits/rollbacks always commit_transcation /
> > rollback_transaction and then end the transaction, completely.
> > * any operation that needs a query should check to see if one is active
> > and start one if not.
> 
> the above is how the new dbd driver works in autocommit mode, but not how
> it used to work, and it was definitely a problem. i haven't ranted as much about

Is it? It would be very useful if you can reproduce the problem for me.

 
> > I don't know if these changes would fix my immediate problem, but they are
> > correct and I expect they will fix my problem.
> 
> i've been having a variety of problems with my apache/modperl/dbi system, and
> not using the old driver (which had a variety of problems, some in dbd and some
> in ibperl) has now allowed me to pay attention to some database server-side problems.
> 
> are you using SS or classic? on linux? local or remote mode?
> it'd be nice to know there is someone else doing the same thing architecture as me -- most
> of the discussion on the support lists is concerning all these moribund borland
> fabrications like ibx/delphi/etc.

the SS of IB 6.0 for _Linux_ is not supposed to use on production
application. 

Rgds,
Edwin.