Red Hat Bugzilla – Bug 155341
MySQL-python-1.0.0 is not compatible with MySQL 4.1
Last modified: 2013-07-02 23:05:29 EDT
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050323 Firefox/1.0.2 Fedora/1.0.2-1.3.1
Description of problem:
The version of MySQL-python that is installed with RHEL4 does not match the version of MySQL that installed.
According to the developers of MySQL-python, to support MySQL 4.1, at least MySQL-python-1.2 is needed. Upgrading manually to that version solves the problem.
As mentioned in http://sourceforge.net/project/shownotes.php?release_id=243731, "MySQL-4.1 is not yet supported".
Version-Release number of selected component (if applicable):
Steps to Reproduce:
Python 2.3.4 (#1, Feb 22 2005, 04:09:37)
[GCC 3.4.3 20041212 (Red Hat 3.4.3-9.EL4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import MySQLdb
>>> import MySQLdb.cursors
>>> mysql_con = MySQLdb.connect(host='localhost', user='bugs', passwd='bugs', db='bugs', cursorclass=MySQLdb.cursors.DictCursor, compress=1)
>>> mysql_cur = mysql_con.cursor()
>>> mysql_cur.execute("select * from bugs")
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 95, in execute
return self._execute(query, args)
File "/usr/lib/python2.3/site-packages/MySQLdb/cursors.py", line 114, in _execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.3/site-packages/MySQLdb/connections.py", line 33, in defaulterrorhandler
raise errorclass, errorvalue
ValueError: invalid literal for int(): 1-
Actual Results: An exception was encountered instead of the correct result.
Expected Results: The data should have been returned correctly.
Using the upgraded python-MySQL-1.2 package, the query works as expected.
OK, I'll try to get the update into Fedora Core 4 and RHEL4 U2.
Switching back to ASSIGNED state because the fix was postponed till U3.
Is this still planned for U3? It doesn't seem to be in the beta packages yet.
Afraid not --- it's slipped to U4. (I'm not happy about this either, but there
are only so many packages that QA can deal with per update, and this fix didn't
make the cut.)
Hmm, that's disappointing. I rebuilt the FC4 RPM, but there seems to be a memory
leak somewhere. I guess I'll just keep waiting patiently or maybe get brave
enough to try release candidates :-)
Is there a timeframe for when this will be fixed? It has been over a year now :(
The right way to get the priority of this problem raised is to pester Red Hat
support and get them to open an issue tracker for it. I'm at the wrong end of
the food chain to have any leverage over which packages get updated in RHEL
The component of this request is planned to be updated in Red Hat enterprise
This enhancement request was evaluated by Red Hat Product Management for
inclusion in a Red Hat Enterprise Linux maintenance release.
Product Management has requested further review of this request by Red Hat
Engineering, for potential inclusion in a Red Hat Enterprise Linux Update
release for currently deployed products.
This request is not yet committed for inclusion in an Update release.
An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on the solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.