[Zope] ZPygreSQL woes

TFE MMS JARVIS JOHN jarvis.sd082@ex.tel.co.jp
Tue, 27 Jul 1999 12:37:52 +0900


I found that getresult in pg.py was dumping core.
It turns out that this is a known bug.

According to http://www.druid.net/pygresql/ , it 
has been fixed in PyGreSQL version 2.4

The version that came with the DA is 2.3.
--

John Jarvis

> -----Original Message-----
> From:	TFE MMS JARVIS JOHN [SMTP:jarvis.sd082@ex.tel.co.jp]
> Sent:	Tuesday, July 27, 1999 10:56 AM
> To:	nathan frund; zope@zope.org
> Subject:	RE: [Zope] ZPygreSQL woes
> 
> oh...
> This query outright crashes Zope on my system!
> 
	<SNIP> 
> --
> John Jarvis
> 
> > -----Original Message-----
> > From:	nathan frund [SMTP:ndf@rocketmail.com]
> > Sent:	Tuesday, July 27, 1999 2:04 AM
> > To:	Hannu Krosing
> > Cc:	zope@zope.org
> > Subject:	Re: [Zope] ZPygreSQL woes
> > 
> > 
> > ---Hannu Krosing <hannu@trust.ee> wrote:
> > >
> > > ndf@rocketmail.com wrote:
> > > > 
> > > > I've run into a problem with Zope with
> > PostgreSQL.  The query runs and
> > > > runs and runs till all the memory on the server
> > is used up and Zope
> > > > falls over. 
> > > 
> > > I'm using it all the time with no major problems.
> > > 
> > > Do the same queries run fine from psql ?
> > 
> > 
> > 
> > Yea, even from from 'regular old Python' and with
> > PGaccess.
> > 
> > Here is the SQL that I used to create the table.
> > -------------------------------
> > items.sql
> > -------------------------------
> > CREATE TABLE items (
> >         prodname char(20),
> >         retailPrice     money,
> >         description     char(80),
> >         prodVis char(80),
> >         IMpartNumber char(20),
> >         size    float4,
> >         speed float4,
> >         color   char(8),
> >         weight  int8,
> >         height  int8,
> >         width int8,
> >         onhand  int8,
> >         reorder int8,
> >         discontinued    boolean,
> >         supplier        char(20),
> >         supplierPartNumber      char(20),
> >         manufacturer    char(16),
> >         cost    money
> > );
> > 
> > 
> > copy items from stdin using delimiters ',';
> > "15"" 5VX   28mm",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004520,0,200
> > "17"" 7SP .28mm 1280x1024(1yrs
> warr)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004190,
> > 0,250
> > "17"" 70+ .28mm 1280x1024",0,0,0,0,0,0,0,0,0,0,0,0,0,0,9004120,0,300
> > -----------------------------------------------------
> > 
> > psql database < items.sql
> > 
> > 
> > 
> > Python code that works.
> > ------------------------------------------
> > 
> > from pg import *
> > 
> > cnx=connect('database','localhost',5432)
> > 
> > query=cnx.query('select * from items')
> > print "\n"
> > 
> > fields=query.listfields()
> > print fields
> > 
> > ------------------------------------------
> > 
> > 
> > > Schemas, row counts, queries executed ?
> > 
> > 
> > The query with Zope is the same exact query with the
> > python...  "Select * from items"
> > 
> > 
> > It stops even with only three rows in the database. 
> > The SQL above for me stops Zope and Postgres in their
> > tracks.
> > 
> > 
> > > Also OS, postgres and ZPygreSQLDA versions.
> > 
> > 
> > I'm running Red Hat Linux 5.2 with kernel 2.2.9
> > Python 1.5.2 from Oliver Andrich's site. 
> > Postgres is version 6.4.2-5.  
> > ZPyGreSQLDA version is 0.3.
> > Zope 2.0.0b1 and Zope 1.10.3
> > 
> > I also have python-PyGreSQL-2.3.2.rpm installed.  I
> > got it from rufus.w3.org.  I removed it thinking that
> > it conflicted or caused the problem.  But removing it
> > didn't seem to help so I reinstalled the package.
> > 
> > 
> > I haven't tried yet but I'm going to write an
> > external method and see if that works.
> > 
> > 
> > I've put up a lot of info, thanks for your help.
> > _________________________________________________________
> > DO YOU YAHOO!?
> > Get your free @yahoo.com address at http://mail.yahoo.com
> > 
> > 
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://www.zope.org/mailman/listinfo/zope
> > 
> > (To receive general Zope announcements, see:
> > http://www.zope.org/mailman/listinfo/zope-announce
> > 
> > For developer-specific issues, zope-dev@zope.org -
> > http://www.zope.org/mailman/listinfo/zope-dev )
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://www.zope.org/mailman/listinfo/zope
> 
> (To receive general Zope announcements, see:
> http://www.zope.org/mailman/listinfo/zope-announce
> 
> For developer-specific issues, zope-dev@zope.org -
> http://www.zope.org/mailman/listinfo/zope-dev )