[Buildbot-commits] [Buildbot] #827: ChangeSources may produce changes containing non-ascii bytestrings

[Buildbot]

#827: ChangeSources may produce changes containing non-ascii bytestrings
------------------------------+---------------------
Reporter:  dustin             |       Owner:
    Type:  defect             |      Status:  closed
Priority:  critical           |   Milestone:  0.8.+
 Version:  0.7.12             |  Resolution:  fixed
Keywords:  encoding database  |
------------------------------+---------------------

Comment (by birbilakos):

 I'm having a similar issue with 0.8.4p1 and P4 changesource:

           File "/usr/local/lib/python2.6/site-
 packages/SQLAlchemy-0.7.1-py2.6-linux-i686.egg/sqlalchemy/engine/base.py",
 line 1491, in _execute_clauseelement
             compiled_sql, distilled_params
           File "/usr/local/lib/python2.6/site-
 packages/SQLAlchemy-0.7.1-py2.6-linux-i686.egg/sqlalchemy/engine/base.py",
 line 1599, in _execute_context
             context)
           File "/usr/local/lib/python2.6/site-
 packages/SQLAlchemy-0.7.1-py2.6-linux-i686.egg/sqlalchemy/engine/base.py",
 line 1592, in _execute_context
             context)
           File "/usr/local/lib/python2.6/site-
 packages/SQLAlchemy-0.7.1-py2.6-linux-i686.egg/sqlalchemy/engine/default.py",
 line 325, in do_execute
             cursor.execute(statement, parameters)
         sqlalchemy.exc.ProgrammingError: (ProgrammingError) You must not
 use 8-bit bytestrings unless you use a text_factory that can interpret
 8-bit bytestrings (like text_factory = str). It is highly recommended that
 you instead just switch your application to Unicode strings. u'INSERT INTO
 changes (author, comments, is_dir, branch, revision, revlink,
 when_timestamp, category, repository, project) VALUES (?, ?, ?, ?, ?, ?,
 ?, ?, ?, ?)' ('aluo', 'Change 83431 by uname_1.1 on 2011/07/12
 02:13:52\n\n\tbug39265: - there should be warning message for changing
 System IP.\n\t\n\nJobs fixed ...\n\nbug39265 by uname at company.com
 *RESOLVED-FIXED*\n\n\t- there should be warning message for changing
 \x93System IP\x94.\n\n', 0, '1.1', '83431', '', 1310462032, None, '', '')

 I think the special characters: \x93\x94 are causing these issues.

-- 
Ticket URL: <http://trac.buildbot.net/ticket/827#comment:14>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation