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