Zope/Zserver died today on my test machine when a remote user performed a sql query that returned most of the 40Mb of the database. This was basically searching for the letter 'A' about the description fields. I am using NT4 sp5 with 128Mb ram, and Zope 2.1.2 NT monitor showed that memory usage only climbed to 50%. On the 2nd 'next 50 records', Zserver/Zope dies with a python.exe exception. I can consistently reproduce this. I don't think this should be happening to me :-( ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin
Graham, What exactly was the exception. I see no symptoms like this at all. What I do see is when usng a POST for the first time into the report screen. Zope loses the query string (since obviously there wasn't one). Is that what's happening here? HTH Phil phil.haris@zope.co.uk | -----Original Message----- | From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of | Graham Chiu | Sent: Saturday, February 05, 2000 10:52 AM | To: zope@zope.org | Subject: [Zope] Python.exe causes an exception in NT | | | | Zope/Zserver died today on my test machine when a remote user performed | a sql query that returned most of the 40Mb of the database. This was | basically searching for the letter 'A' about the description fields. | | I am using NT4 sp5 with 128Mb ram, and Zope 2.1.2 | | NT monitor showed that memory usage only climbed to 50%. | | On the 2nd 'next 50 records', Zserver/Zope dies with a python.exe | exception. I can consistently reproduce this. | | I don't think this should be happening to me :-( | | ------- | Regards, Graham Chiu | gchiu<at>compkarori.co.nz | http://www.compkarori.com/dynamo - The Homebuilt Dynamo | http://www.compkarori.com/dbase - The dBase bulletin | | _______________________________________________ | Zope maillist - Zope@zope.org | 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 ) |
In article <NDBBIJNJLMIKIMAEGEPMAEEACHAA.phil.harris@zope.co.uk>, Phil Harris <phil.harris@zope.co.uk> writes
Graham,
What exactly was the exception.
Dr Watson gives this: Application exception occurred: App: ./python.exe (pid=306) When: 2/6/2000 @ 16:16:26.160 Exception number: c0000005 (access violation) and python.exe gets terminated. I tried it on two different machines and the same happens. As a temporary fix, I have changed single character searches so that they go from like '%c%' to like 'c%' which returns a much smaller set of the table. So, apparently some python code is choking when a large dataset is returned by a sqlquery. ------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin
participants (2)
-
Graham Chiu -
Phil Harris