Hello, All.
We started seeing a "Commands out of sync; you can't run this command
now" error when browsing our installation of v0.92.1. If we then hit
reload in our browser (sometimes twice), the page would load fine. I
couldn't find any other clues, and the error seemed to stop occurring
after I restarted apache.
We are working on an upgrade to v0.99.1, so hopefully this is not a
serious issue. Just for your reference, I am attaching some of the
messages we saw in our logs. Please let me know if you would like any
other information.
Many thanks,
Devin
------
Mod_python error: "PythonHandler invenio.webinterface_layout"
Traceback (most recent call last):
File "/usr/lib/python2.3/site-packages/mod_python/apache.py", line
299, in HandlerDispatch
result = object(req)
File "/usr/lib/python2.3/site-packages/invenio/
webinterface_handler.py", line 231, in _handler
return root._traverse(req, path)
File "/usr/lib/python2.3/site-packages/invenio/
webinterface_handler.py", line 191, in _traverse
result = obj(req, form)
File "/usr/lib/python2.3/site-packages/invenio/
websearch_webinterface.py", line 293, in answer
return display_collection(req, **argd)
File "/usr/lib/python2.3/site-packages/invenio/
websearch_webinterface.py", line 387, in display_collection
req=req)
File "/usr/lib/python2.3/site-packages/invenio/webpage.py", line
106, in page
userinfobox = create_userinfobox_body(req, uid, language),
File "/usr/lib/python2.3/site-packages/invenio/webuser.py", line
667, in create_userinfobox_body
guest = isGuestUser(uid),
File "/usr/lib/python2.3/site-packages/invenio/webuser.py", line
232, in isGuestUser
res = run_sql("select email from user where id=%s", (uid,))
File "/usr/lib/python2.3/site-packages/invenio/dbquery.py", line 54,
in run_sql
rc = cur.execute(sql, param)
File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line
145, in execute
charset = db.character_set_name()
ProgrammingError: (2014, "Commands out of sync; you can't run this
command now")
------
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: Traceback (most recent call
last):
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/mod_python/apache.py", line 299, in HandlerDispatch\n
result = object(req)
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 231, in _handler
\n return root._traverse
(req, path)
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 191, in _traverse
\n result = obj(req, fo
rm)
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 293, in answer
\n return display_collec
tion(req, **argd)
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 387, in
display_collection\n req=req)
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webpage.py", line 106, in page\n userinfobox
= create_userinfobox_body(
req, uid, language),
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 667, in create_userinfobox_body
\n guest = isGuestUser
(uid),
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 232, in isGuestUser\n res =
run_sql("select email fro
m user where id=%s", (uid,))
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/dbquery.py", line 54, in run_sql\n rc =
cur.execute(sql, param)
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/cursors.py", line 145, in execute\n charset =
db.character_set_name()
[Mon Aug 04 10:49:43 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: InterfaceError: (0, '')
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: Traceback (most recent call
last):, referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/mod_python/apache.py", line 299, in HandlerDispatch\n
result = object(req), ref
erer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 231, in _handler
\n return root._traverse
(req, path), referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 191, in _traverse
\n result = obj(req, fo
rm), referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 181, in __call__
\n uid = getUid(req),
referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 163, in getUid\n s =
sm.get_session(req), referer: ht
tps://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/session.py", line 595, in get_session\n s =
SessionManager.get_session(
self, rw ), referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/session.py", line 352, in get_session\n
session = self.get(sessid), ref
erer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/session.py", line 222, in get\n return
self.sessions.get(session_id, de
fault), referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
UserDict.py", line 51, in get\n if not self.has_key(key):, referer: https://redms.classe.corn
ell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websession.py", line 179, in has_key\n
self.__includeItemFromDB( key ),
referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websession.py", line 152, in __includeItemFromDB
\n s = pSession.retriev
e( key ), referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websession.py", line 98, in retrieve\n res =
run_sql(sql), referer: htt
ps://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/dbquery.py", line 54, in run_sql\n rc =
cur.execute(sql, param), refere
r: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/cursors.py", line 164, in execute\n
self.errorhandler(self, exc, value)
, referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
\n raise errorclass, er
rorvalue, referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:06 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: InterfaceError: (0, ''),
referer: https://redms.classe.cornell.edu/collection/CLEO
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: Traceback (most recent call
last):
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/mod_python/apache.py", line 299, in HandlerDispatch\n
result = object(req)
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 231, in _handler
\n return root._traverse
(req, path)
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 191, in _traverse
\n result = obj(req, fo
rm)
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 293, in answer
\n return display_collec
tion(req, **argd)
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 387, in
display_collection\n req=req)
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webpage.py", line 106, in page\n userinfobox
= create_userinfobox_body(
req, uid, language),
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 667, in create_userinfobox_body
\n guest = isGuestUser
(uid),
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 232, in isGuestUser\n res =
run_sql("select email fro
m user where id=%s", (uid,))
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/dbquery.py", line 54, in run_sql\n rc =
cur.execute(sql, param)
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/cursors.py", line 145, in execute\n charset =
db.character_set_name()
[Mon Aug 04 10:50:12 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: ProgrammingError: (2014,
"Commands out of sync; you can't run this command now")
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: Traceback (most recent call
last):
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/mod_python/apache.py", line 299, in HandlerDispatch\n
result = object(req)
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 231, in _handler
\n return root._traverse
(req, path)
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 191, in _traverse
\n result = obj(req, fo
rm)
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 293, in answer
\n return display_collec
tion(req, **argd)
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 387, in
display_collection\n req=req)
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webpage.py", line 106, in page\n userinfobox
= create_userinfobox_body(
req, uid, language),
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 667, in create_userinfobox_body
\n guest = isGuestUser
(uid),
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 232, in isGuestUser\n res =
run_sql("select email fro
m user where id=%s", (uid,))
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/dbquery.py", line 54, in run_sql\n rc =
cur.execute(sql, param)
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/cursors.py", line 145, in execute\n charset =
db.character_set_name()
[Mon Aug 04 10:50:28 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: InterfaceError: (0, '')
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: Traceback (most recent call
last):
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/mod_python/apache.py", line 299, in HandlerDispatch\n
result = object(req)
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 231, in _handler
\n return root._traverse
(req, path)
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webinterface_handler.py", line 191, in _traverse
\n result = obj(req, fo
rm)
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 293, in answer
\n return display_collec
tion(req, **argd)
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 387, in
display_collection\n req=req)
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webpage.py", line 106, in page\n userinfobox
= create_userinfobox_body(
req, uid, language),
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 667, in create_userinfobox_body
\n guest = isGuestUser
(uid),
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 232, in isGuestUser\n res =
run_sql("select email fro
m user where id=%s", (uid,))
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/dbquery.py", line 54, in run_sql\n rc =
cur.execute(sql, param)
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/cursors.py", line 145, in execute\n charset =
db.character_set_name()
[Mon Aug 04 10:50:44 2008] [error] [client 192.168.213.167]
PythonHandler invenio.webinterface_layout: ProgrammingError: (2014,
"Commands out of sync; you can't run this command now")