[Zope] RE: [Zope-dev] Serious bug with gadfly transactions?

[Rob Page]

If you use relational databases with Zope, please read:

In the context of Database Adapters, Zope 2 introduces two new things:

(a) concurrency
(b) a different (better, faster, cheaper.. um, well still free) approach
to transactions

EACH Database Adapter has to be modified so that it addresses (a) above.
This will be done according to the Levels detailed in an earlier post.
To briefly recap:

o  Level 1 DA -- you must run Zope2 in single-threaded mode
o  Level 2 DA -- "thunked.."  transactions are serialized inside the DA
code
o  Level 3 DA -- fully threaded

A different and largely unrelated issue is how the DA interacts with
Zope's transaction machinery (i.e., (b) above).  With the exception of a
Sybase DA we are working internally for a consulting customer we have
not made any progress (internally) on this.  This will cause the
behavior Martijn describes below.

A DA can be Level 3, high-speed, long-range, low-drag and still not be
integrated with the new transaction machinery.  Conversely, a DA can be
integrated into the new transaction machinery and require Zope be run in
single threaded mode.

I _guarantee_ that today, we will make a Database Adapater status page
available on the Zope site.

--Rob

> -----Original Message-----
> From: Martijn Pieters [mailto:mj@antraciet.nl]
> Sent: Wednesday, July 28, 1999 7:36 AM
> To: Zope Development
> Subject: [Zope-dev] Serious bug with gadfly transactions?
> 
> 
> I'm looking for confirmation on this:
> 
> In Zope 2.0b1 (and the latest CVS):
> 
> - When using a gadfly database, nothing is committed, ever.
> When shutting down Zope, all transactions to gadfly are 
> aborted, and all 
> data is gone.
> 
> - When doing multiple SQL update/insert/create calls, and 
> making an error 
> in any but the first call leaves any previous call in the DB, 
> they are not 
> rolled back.
> So, when, in one request, you do an insert and an update, and 
> the update 
> raises an error, the insert is not rolled back.
> 
> Does anyone else see this?
> 
> --
> Martijn Pieters, Web Developer
> | Antraciet http://www.antraciet.nl
> | Tel: +31-35-7502100 Fax: +31-35-7502111
> | mailto:mj@antraciet.nl http://www.antraciet.nl/~mj
> | PGP: 
> http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149
> ------------------------------------------
> 
> _______________________________________________
> Zope-Dev maillist  -  Zope-Dev@zope.org
> http://www.zope.org/mailman/listinfo/zope-dev
> 
> (To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
> 
> For non-developer, user-level issues, 
> zope@zope.org, http://www.zope.org/mailman/listinfo/zope )
>