Hi Andy & all!
I need your general advice on debuggin following problem:
Module None, line 9, in getEvent_py
- <PythonScript at="" jo.hogg="" event.catalog="" getEvent_py="">
- Line 9
Module Shared.DC.ZRDB.DA, line 454, in call
- <SQL instance="" at="" b1dffc20="">
Module Products.ZMySQLDA.db, line 284, in query
InterfaceError: (0, '')
I can not generally reproduce the problem.
Things I know exactly:
It only started to appear with latest upgrade
This error does not appear immediately. For
me it seems to be random, not depending
on server load, etc.
In fact what happen is: at first we have upgraded our
development server (Zope 2.8.4, python 2.4,
mysql-python 1.2.0). It worked fine for a week. Since
4.1.21 version of mysql has been marked as "security"
we processed to upgrade all production servers.
And now, on all our production serves this error
appears. After mysql upgrade we have reinstalled
python-mysql drivers again. Restarted MySQL, Zope, etc.
All works for some time, and then, all connections from
Zope stops working.
I tried to reproduce this error at home. And was able
to reproduce it stable by restarting MySQl while Zope
is up and running. Close/Open db connection helps to
reinitiate connection. Also Zope restart also helps...
When I compiled again 1.2.0 - problem disappears
forever. I was not able to reproduce it.
I also was not able to reproduce problem by trying high
load on our sites.
Nothing interesting here:
Also found a few follow-ups but they do not describe
the problem I have.
of course I looked at forums:
It does not match 100% my problem.
I only know that its started from MySQL 4.1.21. And it
affected all our servers located in different countries.
Any help & advices where to look to debug this problem
would be good.
Log in to post a comment.