[Zope] ZPygreSQL woes

[TFE MMS JARVIS JOHN]

oh...
This query outright crashes Zope on my system!

  PostgreSQL 6.5
  Vine linux 1.1 (Japanese Red Hat clone)
  Linux 2.2.9 (with appropriate updates :^)
  Python 1.5.1
  Zope 1.10.3
  ZPyGreSQLDA 0.3

I noticed that if you take out both MONEY types from the query, Zope
doesn't crash. If you take out one, Zope doesn't crash, but only returns
one row. It sure looks like a ZPyGreSQLDA bug.
I've never had any other problems like this.

pcgi.log entry:
--------------------
Tue Jul 27 10:39:22 1999
  pcgi-wrapper: unexpected out-of-bound data in stdin  t[0] = 80

queries:
-----------
vvvvvvvvvvvvvvv
CRASHES:
^^^^^^^^^^^^^^^
select prodname,
        description,
        retailprice,
        prodVis,
        IMpartNumber,
        size,
        speed ,
        color,
        weight ,
        height ,
        width ,
        onhand ,
        reorder ,
        discontinued ,
        supplier ,
        supplierPartNumber ,
        manufacturer,
        cost
 from items

====

select retailprice, cost from items

------------------------------
Returns only one row:
------------------------------
select prodname,
        description,
        prodVis,
        IMpartNumber,
        size,
        speed ,
        color,
        weight ,
        height ,
        width ,
        onhand ,
        reorder ,
        discontinued ,
        supplier ,
        supplierPartNumber ,
        manufacturer,
        cost
 from items

====

select retailprice from items

====

select cost from items

------------------------
Returns all rows:
------------------------
select prodname,
        description,
        prodVis,
        IMpartNumber,
        size,
        speed ,
        color,
        weight ,
        height ,
        width ,
        onhand ,
        reorder ,
        discontinued ,
        supplier ,
        supplierPartNumber ,
        manufacturer
 from items

--
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 )