I have a TurboGears application using SQLObject, and upgraded from
SQLite 3.2.1 to 3.3.4 to see if it would solve a performance problem
[1]. Instead I get an exception (below) whenever I hit a page that
does any query. If I downgrade SQLite, the old behavior returns. I'm
using SQLObject 0.7.1dev_r1613 with TurboGears 0.9a1. Is there a
version of SQLObject which does better with SQLite 3.3.4?
Page handler: <bound method ChemicalDirectory.default of
<cameosd.controllers.ChemicalDirectory object at 0xb7474d2c>>
Traceback (most recent call last):
File
"/usr/local/lib/python2.4/CherryPy-2.2.0betadev_r980-py2.4.egg/cherrypy/_cphttptools.py",
line 99, in _run
self.main()
File
"/usr/local/lib/python2.4/CherryPy-2.2.0betadev_r980-py2.4.egg/cherrypy/_cphttptools.py",
line 248, in main
body = page_handler(*virtual_path, **self.params)
File "<string>", line 3, in default
File
"/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/controllers.py",
line 210, in expose
tg_format, html, fragment, *args, **kw)
File
"/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/database.py",
line 193, in run_with_transaction
retval = func(*args, **kw)
File
"/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/controllers.py",
line 228, in _execute_func
output = errorhandling.try_call(func, *args, **kw)
File
"/usr/local/lib/python2.4/TurboGears-0.9a1-py2.4.egg/turbogears/errorhandling.py",
line 63, in try_call
output = func(self, *args, **kw)
File "/home/mso/svn/hazweb/Cameo-Search-Demo/cameosd/controllers.py",
line 36, in default
chem = Chemical.get(chem_id)
File
"/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobject/main.py",
line 912, in get
val._init(id, connection, selectResults)
File
"/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobject/main.py",
line 955, in _init
selectResults = self._connection._SO_selectOne(self, dbNames)
File
"/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobject/dbconnection.py",
line 571, in _SO_selectOne
return self.queryOne(
File
"/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobject/dbconnection.py",
line 748, in queryOne
return self._dbConnection._queryOne(self._connection, s)
File
"/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobject/dbconnection.py",
line 339, in _queryOne
self._executeRetry(conn, c, s)
File
"/usr/local/lib/python2.4/SQLObject-0.7.1dev_r1534-py2.4.egg/sqlobject/dbconnection.py",
line 295, in _executeRetry
return cursor.execute(query)
Warning: You can only execute one statement at a time.
[1] The original problem was, a query with a many:many join and a
substring search hangs the SQLObject library and prevents any other
web requests from completing. I heard the new version of SQLite
solved a multithreading bug so I wanted to see if it would work
better.
--
Mike Orr <[EMAIL PROTECTED]>
([EMAIL PROTECTED] address is semi-reliable)
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
