Has anyone come across anything like this ? I have a site www.tunedb.org which is using a MySQL backend. We are getting this error Error Type : Operation Error Error Value : (1100,"Table 'n' was not locked with lock tables") When anyone submits a search (e.g. Searh by Tune name) This seems to have been triggered when someone dip a query to the site which addressed a results page directly eg http://tunedb.nipltd.net/tunedb/tune_details_results.html?tune_id=23&tune_na... After that everyone gets the error until I restart Zope - (closing an re-opening the MySQL connections has the same effect). I have four MySQL connections open. Any ideas gratefully received Thanks Full traceback Traceback (innermost last): File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 187, in publish File /home/sites/site7/users/tunedb/2-2-2/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook (Object: Traversable) File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 171, in publish File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 112, in call_object (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/OFS/DTMLMethod.py, line 172, in __call__ (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: tune_search_logic.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/OFS/DTMLMethod.py, line 168, in __call__ (Object: tune_search_results.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_String.py, line 528, in __call__ (Object: tune_search_results.html) File /home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_In.py, line 630, in renderwob (Object: tune_search_exact) File /home/sites/site7/users/tunedb/2-2-2/lib/python/Shared/DC/ZRDB/DA.py, line 453, in __call__ (Object: tune_search_exact) File /usr/share/zope/lib/python/Products/ZMySQLDA/db.py, line 184, in query OperationalError: (see above) Richard Moon richard@dcs.co.uk
participants (1)
-
Richard Moon