[egenix-users] ZmxODBCDA, MS-SQL under load

[nwingfield at che-llp.com]

Peter,
You're certainly not the only one.  This is a problem specific to SQL
Server.  I am currently working on an experimental workaround, which
involves removing Z SQL methods altogether.  I'll post to the board
whatever I find out, hopefully within the next day or two.
Nathaniel

egenix-users-bounces at lists.egenix.com wrote on 10/22/2003 01:40:33 PM:

>
> Hello list,
>
> I'm getting an error running ZmxODBCDA under load --
>
> 'HY000', 0, '[Microsoft][ODBC SQL Server Driver]Connection is busy with
> results for another hstmt', 5911
>
> This happens quite deterministically any time I put some load on the
server.
>
> Has anyone else seen this? Help much appreciated...
>
>
> System:
>
> * MS SQL 2000 (Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17
> 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard
> Edition on Windows NT 5.0 (Build 2195: Service Pack 4))
>
> * MDAC 2.8
>
> * Windows 2k SP4
>
> * Zope 2.6.1 binary w/ 4 threads, Python 2.1.3
>
> * Testbox is a PIII with 320Mb RAM
>
> * ZmxODBCDA is configured with 8 pooled connections, all other settings
> are default
>
>
> I've created a test case that (hopefully) makes this reproducible. The
> Zope testing app can be downloaded from
http://sabaini.at/zmxodbcda_tst.xml
>
> In the test app I generate 10 DB queries HTTP request (the query is
> 'select count(*) from sysobjects', which is around 1700 on my DB). Then
> I hit the testskript with something like
>
> ab2 -n 2000 -c 20 -k -v2  \
>     -C _ZopeId=35375730A1CCu3EFDTs \
>     http://<server>/zmxodbcda_tst/select_test_py
>
>
> Ie. 20 concurrent requests, 2000 total
>
>
>
> Thanks a lot for any feedback,
>
> peter sabaini.
>
>
>
>
>
>
>
> --
> =========================================================================
>    Peter Sabaini
>    ARC Seibersdorf research GmbH, Biosignal Processing and Telemedicine
>    Grottenhofstrasse 3, A-8053 Graz
>    T: +43 (0)316 265 158, F: +43 (0)316 265 155; E: sabaini at telbiomed.at
>    H: http://telbiomed.at, IM: chrome___ at jabber.at
> -----------------------------
> Meet us at the MEDICA 2003 in Duesseldorf
> 19. - 22. Nov. Hall 14 Stand D15
>
>
>
>
>
>
> _______________________________________________________________________
> eGenix.com User Mailing List                     http://www.egenix.com/
> http://lists.egenix.com/mailman/listinfo/egenix-users