[Zope] MySQL on 2.3.0

Lee Marzke lmarzke@kns.com
Fri, 02 Mar 2001 11:33:18 -0500 (EST)


On 02-Mar-01 Oleg Broytmann wrote:
>> I thought it might be a DA issue.
> 
>    May be. But again, may be not. It is possibly the problem with that
> exact version of MySQL you are using. Upgrading or downgrading to next/prev
> version is a god thing to try.

I'm having similiar problems with ZSQL methods that intermittently
cause Zope to break the connection ( and restart itself ? ).

Using a ZSQL method containing:

ConnectionID:  MySQL ( A ZMySQL db connection )
Args: Owner

select * from notify WHERE FileOwner = <!--#sqlvar Owner type="string" -->
GROUP BY ChangeNum

Using the TEST tab on the ZSQL method:

If Owner is set to a value in the column everything works OK.
e.g  Owner=lmarzke@kns.com

But if Owner is a string which is not in the column
e.g. Owner=lmarzke

the broswer doens't get a page, and Zope doesn't respond for 10 seconds
or so.

The Z2.log shows the lmarzke@kns.com access, but does NOT show the lmarzke
access at all.

Solaris 2.7
Zope 2.3.0 source build
ZMySQLDA 2.0.4
MySQLdb 0.3.2 
MySQL 3.23.32
Python 2.0 build from source with threads



Lee Marzke <lmarzke@kns.com>             02-Mar-01, 11:12:21
Kulicke & Soffa Industries
2101 Blair Mill Rd                       +1 215 784-6217
Willow Grove, PA 19090                   +1 215 784-6014 fax