Hide Forgot
This bug has been copied from bug #765998 and has been proposed to be backported to 6.2 z-stream (EUS).
MRG REPRODUCE: # python reproducer.py sql is %(a)s %(b)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 6 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 6 reference count for vals[b] = 6 sql is %(a)s %(a)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 6 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 7 reference count for vals[b] = 6 sql is %(b)s %(b)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 7 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 7 reference count for vals[b] = 7 sql is %(b)s %(b)s %(b)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 7 reference count for vals[b] = 7 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 7 reference count for vals[b] = 9 MRG VERIFY: # python reproducer.py sql is %(a)s %(b)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 6 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 6 reference count for vals[b] = 6 sql is %(a)s %(a)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 6 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 6 reference count for vals[b] = 6 sql is %(b)s %(b)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 6 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 6 reference count for vals[b] = 6 sql is %(b)s %(b)s %(b)s vals {'a': 'unique string', 'b': 'some other string'} reference count for vals[a] = 6 reference count for vals[b] = 6 after call to cursor.mogrify(sql, vals)... reference count for vals[a] = 6 reference count for vals[b] = 6 reproducer - OK, references counts stay constant work with cumin - OK Analysis of cumin web.log: 1 error found from known Bug 782839 - OK No other errors. MRG OK
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. http://rhn.redhat.com/errata/RHBA-2012-0145.html
Technical note added. If any revisions are required, please edit the "Technical Notes" field accordingly. All revisions will be proofread by the Engineering Content Services team. New Contents: The python-psycopg2 package has been upgraded to upstream version 2.0.14, which provides a number of bug fixes and enhancements over the previous version, including the fix for a memory leak in cursor handling. This update also ensures better compatibility with the PostgreSQL object-relational database management system version 8.4.