Roundup Tracker - Issues

Message3740

Author alessandro
Recipients alessandro, matej, raphi
Date 2009-06-26.13:46:13
Message-id <1246023974.8.0.375998371038.issue2550495@psf.upfronthosting.co.za>
In-reply-to
This is my wsgi application, I run it with "python2.4
wsgi_application.py". I'm using mysql database


from wsgiref.simple_server import make_server
from roundup.cgi.wsgi_handler import RequestDispatcher

tracker_home = 'trackers'
app = RequestDispatcher(tracker_home) #, debug=True) # <= HERE

httpd = make_server('', 8000, app)
httpd.serve_forever()



Note that if I use debug=True I can't login inside the roundup web page,
I got an error page:
""
An error has occurred

A problem was encountered processing your request. The tracker
maintainers have been notified of the problem.
""

and -by email- roundup says:

Traceback (most recent call last):

  File "/usr/lib/python2.4/site-packages/roundup/cgi/client.py", line
443, in inner_main
    html = self.handle_action()

  File "/usr/lib/python2.4/site-packages/roundup/cgi/client.py", line
1053, in handle_action
    return action_klass(self).execute()

  File "/usr/lib/python2.4/site-packages/roundup/cgi/actions.py", line
38, in execute
    return self.handle()

  File "/usr/lib/python2.4/site-packages/roundup/cgi/actions.py", line
965, in handle
    self.client.session_api.set(user=self.client.user)

  File "/usr/lib/python2.4/site-packages/roundup/cgi/client.py", line
168, in set
    self._sid = self._gen_sid()

  File "/usr/lib/python2.4/site-packages/roundup/cgi/client.py", line
141, in _gen_sid
    if not self.session_db.exists(s):

  File
"/usr/lib/python2.4/site-packages/roundup/backends/sessions_rdbms.py",
line 27, in exists
    n, self.db.arg), (infoid,))

  File "/usr/lib/pymodules/python2.4/MySQLdb/cursors.py", line 147, in
execute
    charset = db.character_set_name()

InterfaceError: (0, '')



I changed some lines near sessions_rdbms.py line 27: I put many print,
in order to check the sql query and I saw it's all ok (I have put thet
query in a simple mysql client).
I got the same error substituting the query at line 26 with a simple
"SELECT 1"; the problem seem to be in the database cursor

It seems to me a mysql bug, 
http://bugs.mysql.com/bug.php?id=21543 


If I don't use the "debug" option roundup works correctly.

Tested with roundup 1.4.8 and 1.4.6, mysql version 5.0.51a and 5.0.32
for debian, python 2.4.6

I'm still thinking about a mysql bug..
History
Date User Action Args
2009-06-26 13:46:14alessandrosetmessageid: <1246023974.8.0.375998371038.issue2550495@psf.upfronthosting.co.za>
2009-06-26 13:46:14alessandrosetrecipients: + alessandro, matej, raphi
2009-06-26 13:46:14alessandrolinkissue2550495 messages
2009-06-26 13:46:13alessandrocreate