There is a long standing problem that MiddleKit doesn't like MySQLdb 0.9.2,=
although it gets along great with 0.9.1 and many versions prior. Under=
MySQLdb 0.9.2, some of the MiddleKit tests yield "Too many connections":
line 34, in newConnection
conn =3D self.dbapiModule().connect(**args)
File "C:\Python23\Lib\site-packages\MySQLdb\__init__.py", line 63, in=
return apply(Connection, args, kwargs)
File "C:\Python23\Lib\site-packages\MySQLdb\connections.py", line 115, in=
File "C:\Python23\Lib\site-packages\MySQLdb\connections.py", line 41, in=
apply(super(ConnectionBase, self).__init__, args, kwargs)
OperationalError: (1040, 'Too many connections')
In fact, here are the results:
*** FAILED *** MKDelete.mkmodel
*** FAILED *** MKDeleteMark.mkmodel
*** FAILED *** MKMultipleThreads.mkmodel
This problem is so bad that one of the tests completely freezes and I have=
to *kill* it with the Task Manager. (Each MK test is run in a separate=
process, so the main Test.py keeps going with the other ones after any kind=
IIRC this problem happens under Linux as well, but it would be nice to=
verify. Also, it happens with both Python 2.2.x and 2.3.x.
I spoke with Andy Dustman, author of MySQLdb, awhile back but didn't=
convince him it was a MySQLdb flaw (which is still my inclination, but not=
proven) nor did the two of us come up with any good ideas.
The impact of this problem goes like this: If a new user (or a user with a=
new machine like me) downloads the latest stable versions of Python,=
Webware and MySQLdb, then that user will have this problem. Yuk.
Also, MySQLdb doesn't provide a 0.9.1 binary for Python 2.3 so the fix isn't=
as easy as a download.
Btw I tried this really cheesy fix:
=09=09=09=09import gc, time
with a loop of 5 attempts. No change in results.
And my db server is not used by anything else. It's completely local,=
private and freshly installed.
I will follow up more on this, but for now it's getting late. I'd appreciate=
any kind of help on this, even if it's as small as running the test suite=
on platform X and reporting the results.
Of course, solutions are welcome too. :-)
So are speculations.
And finally, instructions to run the test suite:
* cd to MiddleKit/Tests
* if you're in cvs: cvs upd -dP
* If needed, edit TestRun.py line 23 from
=09store =3D MySQLObjectStore()
=09store =3D MySQLObjectStore(user=3D'foo', passwd=3D'bar')
* If needed, edit Test.py line 28 from
=09=09return 'mysql -u foo -pbar'
* Type: python Test.py MKDelete
* or to run all tests, simply: python Test.py
All tests take 75 seconds on my 3GHz P4.
Sorry for the two edits. I plan to factor those out to a config file so you=
can specify all the info in one place or via command line.