Hello, Samuele.
We are running this instance of Invenio on an SL4 system using the SL
supplied httpd. I removed all of the MPM Worker lines from httpd.conf
and restarted apache. However, the same errors started occurring
again after several hours.
Just incase it helps, here are some messages we see in /var/log/httpd/
error_log.
/usr/lib/python2.3/site-packages/invenio/dbquery.py:54: Warning: Data
truncated for column 'session_expiry' at row 1
rc = cur.execute(sql, param)
/usr/lib/python2.3/site-packages/invenio/dbquery.py:54: Warning: Data
truncated for column 'file_version' at row 1
rc = cur.execute(sql, param)
Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out of
sync; you can't run this command now") in <bound method Cursor.__del__
of <MySQLdb.cursors.Cursor object at 0xb7962aec>> ignored
Exception _mysql_exceptions.ProgrammingError: (2014, "Commands out of
sync; you can't run this command now") in <bound method Cursor.__del__
of <MySQLdb.cursors.Cursor object at 0xb7962b6c>> ignored
...
And, here is the corresponding error in /opt/cds-invenio/var/log/
apache-ssl.err.
------
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
PythonHandler invenio.webinterface_layout: Traceback (most recent call
last):, referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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), referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/websearch_webinterface.py", line 387, in
display_collection\n req=req),
referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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),, referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/invenio/webuser.py", line 667, in create_userinfobox_body
\n guest = isGuestUser
(uid),, referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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,)), referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
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/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
PythonHandler invenio.webinterface_layout: File "/usr/lib/python2.3/
site-packages/MySQLdb/cursors.py", line 145, in execute\n charset =
db.character_set_name(),
referer: https://redms.classe.cornell.edu/
[Wed Aug 06 10:44:44 2008] [error] [client 192.168.213.159]
PythonHandler invenio.webinterface_layout: ProgrammingError: (2014,
"Commands out of sync; you can't run this command now"), referer: https://redms.classe.cornell.edu
/
------
Many thanks,
Devin
On Aug 4, 2008, at 12:25 PM, Samuele Kaplun wrote:
Dear Devin:
On Monday 04 August 2008, Devin Bougie wrote:
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
are you running the Apache server with MPM-Prefork modality or on
the contray
are you using something similar to MPM-Worker? Invenio 0.92.1 is not
thread-safe and concurrency errors in accessing the database could
happen
when using a multi-threaded Apache server (like when enabling the
Worker
mode). Things should go slightly better with Invenio 0.99.x with
multi-threaded Apache (in particular for accessing the database, the
above-mentioned error should not appear anymore) but we don't
officially
support this modality.
On the contrary, for the time being, it is always recommended to run
Apache
with MPM-Prefork modality.
Thanks for reporting this and let us know if you're still
encountering such
errors (after either switching to Prefork or to Invenio 0.99.1)
Best regards,
Samuele
--
.O.
..O
OOO
