Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-04 Thread Matthew T. Kromer
I'm pretty confident that the db component (the C layer) doesn't have any GIL problems. However, the DA component (the Zope layer) *may* have all sorts of unusual failure modes. Debugging transaction concurrency problems is always tricky, but keep in mind there are Python layer abstraction

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-03 Thread Maciej Wisniowski
Michael Mauws wrote: Thanks yet again, Dieter, particularly for putting to rest a few of the "solutions" I found while poking around. As you might expect, I've been continuing to explore this problem and, at the moment, I'm zeroing in on rollback segments. If this is indeed the problem, it would

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-03 Thread Michael Mauws
Thanks yet again, Dieter, particularly for putting to rest a few of the "solutions" I found while poking around. As you might expect, I've been continuing to explore this problem and, at the moment, I'm zeroing in on rollback segments. If this is indeed the problem, it would fit well with what you

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-03 Thread Dieter Maurer
Please always stay on the list! Michael Mauws wrote at 2006-5-2 14:39 -0600: > ... >In light of the above, I don't think it's a GIL problem (without >having a clue what a GIL actually is) This is the "Global Interpreter Lock". It prevents more than a single thread to run Python code at the same t

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-02 Thread Dieter Maurer
Michael Mauws wrote at 2006-5-1 19:02 -0600: > ... >However, the problem I'm having is that it's not just the >"update request" that hangs. Rather, it's the whole Zope that hangs >until this one request has been satisfied. Even Zope requests that have nothing to do with Oracle? This would indic

Re: [Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-01 Thread Chris Withers
Michael Mauws wrote: For better or for worse, I can live with the situation I've just described. However, the problem I'm having is that it's not just the "update request" that hangs. Rather, it's the whole Zope that hangs until this one request has been satisfied. Are you _sure_ your other req

[Zope-DB] Zope, DCOracle2, concurrent transactions, etc.

2006-05-01 Thread Michael Mauws
I've built a rather complex OLTP application using Apache, Zope, and Oracle (with DCOracle2 linking the latter two). I occasionally perform lengthy database updates in the background and, during that time, someone inevitably requests a page that updates a record that has been locked by the backgro