Thread: [SQLObject] 'Lost connection to MySQL server during query'
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Frank B. <fb...@fo...> - 2003-11-09 14:25:28
|
Hallo, I have a problem with my Webware/SQLObject application again. :( It's a webshop running Webware and using SQLObject. If I click like a mad scientist on Mozilla's Reload-button I am able to crash the Webware server. The error I get is: ... File "/usr/lib/python2.2/site-packages/SQLObject/DBConnection.py", line 168, in _iterSelect cursor.execute(query) File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 61, in execute r = self._query(query) File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 168, in _query rowcount = self._BaseCursor__do_query(q) File "/usr/lib/python2.2/site-packages/MySQLdb/cursors.py", line 112, in __do_query db.query(q) OperationalError: (2013, 'Lost connection to MySQL server during query') /home/fbar/webware/workdir/AppServer: line 9: 5395 Segmentation fault /usr/bin/env python2.2 Launch.py ThreadedAppServer $* This happens with using python2.2 mysqldb 0.9.1 (the Debian package) as well as with python2.3-mysqldb 0.9.2 and SQLObject CVS or 0.5. Did anybody here run into something like this before and/or does someone have an idea, what to do against this? If this happens, I get stale Webware threads, which makes automatic restarting a bit of a hassle. ciao -- Frank Barknecht _ ______footils.org__ |
From: Ian B. <ia...@co...> - 2003-11-09 18:28:04
|
On Nov 9, 2003, at 8:25 AM, Frank Barknecht wrote: > This happens with using python2.2 mysqldb 0.9.1 (the Debian package) > as well as with python2.3-mysqldb 0.9.2 and SQLObject CVS or 0.5. Did > anybody here run into something like this before and/or does someone > have an idea, what to do against this? If this happens, I get stale > Webware threads, which makes automatic restarting a bit of a hassle. Could this be related to the problem people are discussing with MiddleKit and MySQL on the Webware list? I don't really have any further thoughts, but maybe you should bounce this off them too. -- Ian Bicking | ia...@co... | http://blog.ianbicking.org |
From: Frank B. <fb...@fo...> - 2003-11-09 20:28:28
|
Hallo, Ian Bicking hat gesagt: // Ian Bicking wrote: > On Nov 9, 2003, at 8:25 AM, Frank Barknecht wrote: > >This happens with using python2.2 mysqldb 0.9.1 (the Debian package) > >as well as with python2.3-mysqldb 0.9.2 and SQLObject CVS or 0.5. Did > >anybody here run into something like this before and/or does someone > >have an idea, what to do against this? If this happens, I get stale > >Webware threads, which makes automatic restarting a bit of a hassle. > > Could this be related to the problem people are discussing with > MiddleKit and MySQL on the Webware list? I don't really have any > further thoughts, but maybe you should bounce this off them too. Well, the problem discussed on webware-devel has two differences: the error message is another one ("too many connections") and it seems to only happen with mysqldb 0.9.2, whereas my problem also occurs on 0.9.1. Of course it might still be related. Searching the web, I found two possible reasons. One is related to MySQL doing slow DNS lookups, but that isn't the case on my machines: TCP connect to mysql is disabled. The other thing seems to be related to DB-connections not getting closed or garbage-collected. But this is a quite bit over my Pythonic head and my insight into SQLObject. ciao -- Frank Barknecht _ ______footils.org__ |