[Zope] locking help
Hi, Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests. a Mark ___ 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] locking help
On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote: Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests. Don't know if this will help, but my Zope/Postgresql experience has gone remarkably well. I have the following packages installed on an otherwise regular Debian 2.2 machine: libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL postgresql7.0.2-6 Object-relational SQL database, descended fr postgresql-client 7.0.2-6 Front-end programs for PostgreSQL postgresql-dev7.0.2-6 Header files for libpq (postgresql library) postgresql-doc7.0.2-6 Documentation for the PostgreSQL database. python-pygresql 7.0.2-6 PostgreSQL module for Python zope 2.2.2-1 The Z Object Publishing Environment zope-pygresqlda 0.3rjr2-1 A Zope Database Adapter for PostgreSQL Between those packages, following the PostgreSQL tutorial at postgresql.org, and following the Z SQL Methods User's Guide (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm working fine. Where are the actual errors? -- Mike Renfro / RD Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- [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 )
Re: [Zope] locking help
Mark Twiddy writes: Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests. We saw a similar problem description recently in this list. There, ZODBCDA was blocking during database queries. Maybe, your database adapter has similar problems. 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] locking help
Hi thanks for the reply The problem is whenever i do really big query everything stops and waits. im using ZPyGreSQLDA-0.3-rjr2 and py-PyGreSQL-2.4 thanks Mark On Tue, 10 Oct 2000, Mike Renfro wrote: On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote: Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests. Don't know if this will help, but my Zope/Postgresql experience has gone remarkably well. I have the following packages installed on an otherwise regular Debian 2.2 machine: libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL postgresql7.0.2-6 Object-relational SQL database, descended fr postgresql-client 7.0.2-6 Front-end programs for PostgreSQL postgresql-dev7.0.2-6 Header files for libpq (postgresql library) postgresql-doc7.0.2-6 Documentation for the PostgreSQL database. python-pygresql 7.0.2-6 PostgreSQL module for Python zope 2.2.2-1 The Z Object Publishing Environment zope-pygresqlda 0.3rjr2-1 A Zope Database Adapter for PostgreSQL Between those packages, following the PostgreSQL tutorial at postgresql.org, and following the Z SQL Methods User's Guide (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm working fine. Where are the actual errors? -- Mike Renfro / RD Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- [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 ) ___ 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] locking help
this Postgres adapter is not multithreaded, check out the ZPoPyDA from zope.org. That is an alternative Postgres adapter that is multithreaded and does not lock up. phil *** REPLY SEPARATOR *** On 11.10.2000 at 08:48 Mark Twiddy wrote: Hi thanks for the reply The problem is whenever i do really big query everything stops and waits. im using ZPyGreSQLDA-0.3-rjr2 and py-PyGreSQL-2.4 thanks Mark On Tue, 10 Oct 2000, Mike Renfro wrote: On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote: Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests. Don't know if this will help, but my Zope/Postgresql experience has gone remarkably well. I have the following packages installed on an otherwise regular Debian 2.2 machine: libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL postgresql7.0.2-6 Object-relational SQL database, descended fr postgresql-client 7.0.2-6 Front-end programs for PostgreSQL postgresql-dev7.0.2-6 Header files for libpq (postgresql library) postgresql-doc7.0.2-6 Documentation for the PostgreSQL database. python-pygresql 7.0.2-6 PostgreSQL module for Python zope 2.2.2-1 The Z Object Publishing Environment zope-pygresqlda 0.3rjr2-1 A Zope Database Adapter for PostgreSQL Between those packages, following the PostgreSQL tutorial at postgresql.org, and following the Z SQL Methods User's Guide (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm working fine. Where are the actual errors? -- Mike Renfro / RD Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- [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 ) ___ 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] locking help
Hi all, Thanks for all the help Ive installed PoPy-1.36 and ZPoPyDA-0.64 and it works like a bastard : Thanks all Mark On Wed, 11 Oct 2000, Philipp Auersperg wrote: this Postgres adapter is not multithreaded, check out the ZPoPyDA from zope.org. That is an alternative Postgres adapter that is multithreaded and does not lock up. phil *** REPLY SEPARATOR *** On 11.10.2000 at 08:48 Mark Twiddy wrote: Hi thanks for the reply The problem is whenever i do really big query everything stops and waits. im using ZPyGreSQLDA-0.3-rjr2 and py-PyGreSQL-2.4 thanks Mark On Tue, 10 Oct 2000, Mike Renfro wrote: On Tue, Oct 10, 2000 at 04:58:46PM +0930, Mark Twiddy wrote: Can someone please tell me what is going on. while querying a postgres database i am unable to access any crap from zope. I have tried creating a db connection in a enternal method and querying through that but it still locks and wont serve any requests. Don't know if this will help, but my Zope/Postgresql experience has gone remarkably well. I have the following packages installed on an otherwise regular Debian 2.2 machine: libpgsql2 7.0.2-6 Shared library libpq.so.2 for PostgreSQL postgresql7.0.2-6 Object-relational SQL database, descended fr postgresql-client 7.0.2-6 Front-end programs for PostgreSQL postgresql-dev7.0.2-6 Header files for libpq (postgresql library) postgresql-doc7.0.2-6 Documentation for the PostgreSQL database. python-pygresql 7.0.2-6 PostgreSQL module for Python zope 2.2.2-1 The Z Object Publishing Environment zope-pygresqlda 0.3rjr2-1 A Zope Database Adapter for PostgreSQL Between those packages, following the PostgreSQL tutorial at postgresql.org, and following the Z SQL Methods User's Guide (http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html), I'm working fine. Where are the actual errors? -- Mike Renfro / RD Engineer, Center for Manufacturing Research, 931 372-3601 / Tennessee Technological University -- [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 ) ___ 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 )