AW: [Zope] Calling external Methods blocks ZODBCDA
Hello some new Material about my Problem: I have set up a Zope-Python-Scipt called 'GetMallMerchantID' which is called from an external Server. This Scipt starts, but holds until an other (independent) Python-Script called 'Dispatcher' ist ready. 'GetMallMerchantID' does some Log in a SQL-Database. Are there the simultanous ZODBC requests limmited? What can be the reason? Regards Armin My code at this place is: (...) if TransactionID == '0401FF': return 'MallMerchantID=armin' context.logs('SYSTEM', 'Start: GetMallMerchantID') context.logs('SYSTEM', 'Start: GetMallMerchantID 2') # The script is hold here ! context.logs('SYSTEM', 'Start: GetMallMerchantID 3') context.logs('SYSTEM', 'Start: GetMallMerchantID 4') context.logs('SYSTEM', 'Start: GetMallMerchantID 5') context.logs('SYSTEM', 'GetMallMerchantID: TransactionID= '+ TransactionID) context.logs('SYSTEM', 'GetMallMerchantID: sqlGetTransaction start') for result1 in context.Database.sqlGetTransaction (tid=TransactionID): context.logs('SYSTEM', 'GetMallMerchantID: sqlGetTransaction gotten') (...) my Log is: (..) MERCHANTID TIMEWERT LOG SYSTEM 2001-11-15 12:10:05 GetMallMerchantID: sqlGetTransaction gotten SYSTEM 2001-11-15 12:10:05 GetMallMerchantID: sqlGetTransaction start SYSTEM 2001-11-15 12:10:05 GetMallMerchantID: TransactionID= 31130332269834268968 SYSTEM 2001-11-15 12:10:05 Start: GetMallMerchantID 5 SYSTEM 2001-11-15 12:10:05 Start: GetMallMerchantID 4 SYSTEM 2001-11-15 12:10:05 Start: GetMallMerchantID 3 SYSTEM 2001-11-15 12:10:05 Start: GetMallMerchantID 2 SYSTEM 2001-11-15 12:10:04 Dispatcher: DoRequest done. SYSTEM 2001-11-15 12:09:07 Start: GetMallMerchantID
Hello,
I'm calling in a External Method an another Server and waiting at this point for the externals Server's result. This works fine. This external Server askes back Zope at a different connection (Python Script) to get additional data. This works also fine if I deliver over this connection static datas. It fails, if I try to get the data from a Z ODBC Database Connection - there is no data delivered. My external Server runs in timeout and closes the connction to Zope. At this moment my Python Script runs an takes the data from the Database, but can't deliver it back t my external Server because the connection was just closed.
All the scripts work by there own well but only in this conjunction they don't. Any Ideas?
regards Armin Krone
TeleCash GmbH Produktmanagement Internet Payment Systeme Support Internet Theodor-Heuss-Str. 8 D-70174 Stuttgart
Tel. +49 (0)711 16264 924 Fax +49 (0)711 2270644
mailto:Armin.Krone@telecash.de http://www.telecash.de
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )Viruses are not found. Checked by AVP.
Maybe, you should switch to "mxZODBCDA". "ZODBCDA" is known to forget releasing the global interpreter lock. Thus, multi-threading does not work as it should be.
From your problem description, it does not seem to be your problem. But, maybe, "mxZODBCDA" solves this nevertheless...
Dieter
participants (2)
-
Dieter Maurer -
Krone, Armin