RE: [Zope] database connection problem (halting Zope)
Yes, it is indeed the same here and in Spain, thankfully. I have read the DARoadmap already. And thanks to Ayhan Ergul <[EMAIL PROTECTED]> I now have binaries for OracleDA which works as supposed - i.e. fine. Is there somebody with nt binaries of SybaseDA? I will probably get it running on Linux anyway, but for now I have to use NT. Best regards, Petr Hrasky -Original Message- From: Francisco José Esteban Risueño [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 05, 2000 12:01 PM To: Hrasky Petr Cc: '[EMAIL PROTECTED]' Subject: Re: [Zope] database connection problem (halting Zope) In this document: http://www.zope.org/Members/petrilli/DARoadmap the behaviour of different database adapters in a multithreaded environment is discussed. We've observered in our Zope instalation that a long query via ZODBCDA halts (this is similar in the Czech Republic and in Spain). Howerver, if we issue the same query via ZOracleDA, the server still responds while the quere is executing (like a multithreaded server should do) Hrasky Petr escribió: > thanks again, > yes, the python versions I use are compiled for threads, they link > against libpthread under linux. I have also found ZmxODBCDA adapter and > it does not work for me yet - it shows in Zope as broken product. > I also spoke to local Oracle hotline and they said that ODBC access is > not thread safe until 8.1.6.1.1 due to some error in OCI libs. Now I am > downloading Oracle for Linux and Sybase for Linux and I will try to > compile OracleDA and SybaseDA. > > Thanks a lot all. > > Regards, > > Petr > > -Original Message- > From: Dieter Maurer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 03, 2000 11:17 PM > To: Hrasky Petr > Cc: '[EMAIL PROTECTED]' > Subject: RE: [Zope] database connection problem (halting Zope) > > Hrasky Petr writes: > > thank you for answers. To clarify: > > I run Zope-2.2.2/Linux2.2.14/MySQL-ZMySQLDA1.1.3nonbin at home and > > Zope-2.2.2-binary/NT4.0Workstation/ZODBCDA3.1.0b2 (Oracle 8i ODBC, > > Sybase11.5)at work. Oracle connection at work and MySQL (at home just > > for testing) run looong queries and halt Zope. I have no such queries > > for Sybase yet. > > I will try to recompile python for linux, but I can't do so for > WinNT > > as I have no compiler. Anyway I thought the python distributed with > > binary release of Zope is threaded, no? > If Python is compiled without threads, there is no module > "thread". Zope relies on this module. It dies immediately, > if it is not there. Thus, you can be sure, your > Python has thread support compiled in. > > > So, does anybody know of either binary and threaded Zope driver for > > Oracle , Sybase etc. or the same ODBC driver? And what is the state > of > > python threading on WinNT paltform? > The Python that comes with Zope has thread support compiled in. > > Maybe, your Python-ODBC connection "forgets" to release > Python's interpreter lock. > > We, once, had such a problem. >Accidentally, the DCOracle module had been set up with a standard >Python distribution (with threading disabled) rather >than the Zope Python. As a consequence, the >DCOracle did not call "releaseLock" and >"acquireLock" (as they would not be present >in a non-threaded Python). >And, of course, database operations blocked Zope. > > Dieter > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 ) > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] database connection problem (halting Zope)
In this document: http://www.zope.org/Members/petrilli/DARoadmap the behaviour of different database adapters in a multithreaded environment is discussed. We've observered in our Zope instalation that a long query via ZODBCDA halts (this is similar in the Czech Republic and in Spain). Howerver, if we issue the same query via ZOracleDA, the server still responds while the quere is executing (like a multithreaded server should do) Hrasky Petr escribió: > thanks again, > yes, the python versions I use are compiled for threads, they link > against libpthread under linux. I have also found ZmxODBCDA adapter and > it does not work for me yet - it shows in Zope as broken product. > I also spoke to local Oracle hotline and they said that ODBC access is > not thread safe until 8.1.6.1.1 due to some error in OCI libs. Now I am > downloading Oracle for Linux and Sybase for Linux and I will try to > compile OracleDA and SybaseDA. > > Thanks a lot all. > > Regards, > > Petr > > -Original Message- > From: Dieter Maurer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 03, 2000 11:17 PM > To: Hrasky Petr > Cc: '[EMAIL PROTECTED]' > Subject: RE: [Zope] database connection problem (halting Zope) > > Hrasky Petr writes: > > thank you for answers. To clarify: > > I run Zope-2.2.2/Linux2.2.14/MySQL-ZMySQLDA1.1.3nonbin at home and > > Zope-2.2.2-binary/NT4.0Workstation/ZODBCDA3.1.0b2 (Oracle 8i ODBC, > > Sybase11.5)at work. Oracle connection at work and MySQL (at home just > > for testing) run looong queries and halt Zope. I have no such queries > > for Sybase yet. > > I will try to recompile python for linux, but I can't do so for > WinNT > > as I have no compiler. Anyway I thought the python distributed with > > binary release of Zope is threaded, no? > If Python is compiled without threads, there is no module > "thread". Zope relies on this module. It dies immediately, > if it is not there. Thus, you can be sure, your > Python has thread support compiled in. > > > So, does anybody know of either binary and threaded Zope driver for > > Oracle , Sybase etc. or the same ODBC driver? And what is the state > of > > python threading on WinNT paltform? > The Python that comes with Zope has thread support compiled in. > > Maybe, your Python-ODBC connection "forgets" to release > Python's interpreter lock. > > We, once, had such a problem. >Accidentally, the DCOracle module had been set up with a standard >Python distribution (with threading disabled) rather >than the Zope Python. As a consequence, the >DCOracle did not call "releaseLock" and >"acquireLock" (as they would not be present >in a non-threaded Python). >And, of course, database operations blocked Zope. > > Dieter > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 ) > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] database connection problem (halting Zope)
thanks again, yes, the python versions I use are compiled for threads, they link against libpthread under linux. I have also found ZmxODBCDA adapter and it does not work for me yet - it shows in Zope as broken product. I also spoke to local Oracle hotline and they said that ODBC access is not thread safe until 8.1.6.1.1 due to some error in OCI libs. Now I am downloading Oracle for Linux and Sybase for Linux and I will try to compile OracleDA and SybaseDA. Thanks a lot all. Regards, Petr -Original Message- From: Dieter Maurer [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 11:17 PM To: Hrasky Petr Cc: '[EMAIL PROTECTED]' Subject: RE: [Zope] database connection problem (halting Zope) Hrasky Petr writes: > thank you for answers. To clarify: > I run Zope-2.2.2/Linux2.2.14/MySQL-ZMySQLDA1.1.3nonbin at home and > Zope-2.2.2-binary/NT4.0Workstation/ZODBCDA3.1.0b2 (Oracle 8i ODBC, > Sybase11.5)at work. Oracle connection at work and MySQL (at home just > for testing) run looong queries and halt Zope. I have no such queries > for Sybase yet. > I will try to recompile python for linux, but I can't do so for WinNT > as I have no compiler. Anyway I thought the python distributed with > binary release of Zope is threaded, no? If Python is compiled without threads, there is no module "thread". Zope relies on this module. It dies immediately, if it is not there. Thus, you can be sure, your Python has thread support compiled in. > So, does anybody know of either binary and threaded Zope driver for > Oracle , Sybase etc. or the same ODBC driver? And what is the state of > python threading on WinNT paltform? The Python that comes with Zope has thread support compiled in. Maybe, your Python-ODBC connection "forgets" to release Python's interpreter lock. We, once, had such a problem. Accidentally, the DCOracle module had been set up with a standard Python distribution (with threading disabled) rather than the Zope Python. As a consequence, the DCOracle did not call "releaseLock" and "acquireLock" (as they would not be present in a non-threaded Python). And, of course, database operations blocked Zope. Dieter ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] database connection problem (halting Zope)
Hrasky Petr writes: > thank you for answers. To clarify: > I run Zope-2.2.2/Linux2.2.14/MySQL-ZMySQLDA1.1.3nonbin at home and > Zope-2.2.2-binary/NT4.0Workstation/ZODBCDA3.1.0b2 (Oracle 8i ODBC, > Sybase11.5)at work. Oracle connection at work and MySQL (at home just > for testing) run looong queries and halt Zope. I have no such queries > for Sybase yet. > I will try to recompile python for linux, but I can't do so for WinNT > as I have no compiler. Anyway I thought the python distributed with > binary release of Zope is threaded, no? If Python is compiled without threads, there is no module "thread". Zope relies on this module. It dies immediately, if it is not there. Thus, you can be sure, your Python has thread support compiled in. > So, does anybody know of either binary and threaded Zope driver for > Oracle , Sybase etc. or the same ODBC driver? And what is the state of > python threading on WinNT paltform? The Python that comes with Zope has thread support compiled in. Maybe, your Python-ODBC connection "forgets" to release Python's interpreter lock. We, once, had such a problem. Accidentally, the DCOracle module had been set up with a standard Python distribution (with threading disabled) rather than the Zope Python. As a consequence, the DCOracle did not call "releaseLock" and "acquireLock" (as they would not be present in a non-threaded Python). And, of course, database operations blocked Zope. Dieter ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] database connection problem (halting Zope)
Hello, thank you for answers. To clarify: I run Zope-2.2.2/Linux2.2.14/MySQL-ZMySQLDA1.1.3nonbin at home and Zope-2.2.2-binary/NT4.0Workstation/ZODBCDA3.1.0b2 (Oracle 8i ODBC, Sybase11.5)at work. Oracle connection at work and MySQL (at home just for testing) run looong queries and halt Zope. I have no such queries for Sybase yet. I will try to recompile python for linux, but I can't do so for WinNT as I have no compiler. Anyway I thought the python distributed with binary release of Zope is threaded, no? So, does anybody know of either binary and threaded Zope driver for Oracle , Sybase etc. or the same ODBC driver? And what is the state of python threading on WinNT paltform? Thanks, Petr -Original Message- From: Tim Cook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 3:13 PM To: Hrasky Petr Cc: '[EMAIL PROTECTED]' Subject: Re: [Zope] database connection problem (halting Zope) > Could it be that the python binary > used is not compiled for threading? I spent yesterday afternoon and this Count on it. That's why the install instructions explain that python isn't compiled with threads by default. -- Tim Cook -- Cook Information Systems | Office: (901) 884-4126 8am-5pm CDT * It's easy to stop making mistakes. Just stop having ideas. * FreePM Project Coordinator http://www.freepm.org OSHCA Founding Supporter http://www.oshca.org ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] database connection problem (halting Zope)
> Could it be that the python binary > used is not compiled for threading? I spent yesterday afternoon and this Count on it. That's why the install instructions explain that python isn't compiled with threads by default. -- Tim Cook -- Cook Information Systems | Office: (901) 884-4126 8am-5pm CDT * It's easy to stop making mistakes. Just stop having ideas. * FreePM Project Coordinator http://www.freepm.org OSHCA Founding Supporter http://www.oshca.org ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] database connection problem (halting Zope)
+---[ Hrasky Petr ]-- | Hello everybody, Hi.. | I understand that long query blocks database connection, but I thought | Zope is threaded, so it should run other requests not using this | database connection just fine, no? You are correct, that should be the case. | Could it be that the python binary used is not compiled for threading? Perhaps, but, I think Zope will fail to start if your python does not support threading. | I spent yesterday afternoon and this | morning looking for solution to this problem on the net, but with no | luck yet. | | Can anybody enlighten me why is that? And what can I do to fix this. It might be that the ODBC driver for MySQL is serialising all accesses to MySQL (i.e. the MySQL ODBC driver is not threaded). This is a bit of a guess though. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068|[EMAIL PROTECTED]| ___ Zope maillist - [EMAIL PROTECTED] 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 )