[Buildbot-commits] [Buildbot] #1054: sqlite3.ProgrammingError when starting a rebuild with non-ASCII chars in re-build reason

[Buildbot]

#1054: sqlite3.ProgrammingError when starting a rebuild with non-ASCII chars in
re-build reason
-------------------------+--------------------------------------------------
Reporter:  andialbrecht  |       Owner:           
    Type:  defect        |      Status:  new      
Priority:  major         |   Milestone:  undecided
 Version:  0.8.1         |    Keywords:           
-------------------------+--------------------------------------------------
 I've hit this bug when I tried to start a re-build of a failed build and
 entered a message with non-ASCII chars in the "Reason for re-build"
 textbox (buildbot 0.8.1p1 with SQLite database):

 {{{
 /home/build/.virtualenvs/buildbot/lib/python2.6/site-
 packages/buildbot/db/dbspec.py, line 105 in execute
 103      try:
 104        query_start_time = util.now()
 105        result = self.cursor.execute(*args, **kw)
 106        end_time = util.now()
 Self
 cursor  <sqlite3.Cursor object at 0xa8fda70>
 Locals
 kw      Dictionary instance @ 0xa96f604
 query_start_time        1289488174.3802421
 self
 buildbot.db.dbspec.RetryingCursor instance @ 0xa9f02ec
 <sqlite3.Cursor object at 0xa8fda70>
 args    ('INSERT INTO buildsets (external_idstring, reason, sourcestampid,
 submitted_at) VALUES (?,?,?,?)', (None, "The web-page 'rebuild' button was
 pressed by '<unknown>': Tabellenspalte erg\xc3\xa4nzt\n", 186,
 1289488174.3802321))
 Globals
 util    <module 'buildbot.util' from
 '/home/build/.virtualenvs/buildbot/lib/python2.6/site-
 packages/buildbot/util/__init__.pyc'>
 <class 'sqlite3.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.

 }}}

-- 
Ticket URL: <http://buildbot.net/trac/ticket/1054>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation