[Buildbot] #3420: tests are failing when using MySQL database backend

Buildbot trac trac at buildbot.net
Sun Jan 24 12:52:23 UTC 2016


#3420: tests are failing when using MySQL database backend
----------------------+-----------------------
Reporter:  rutsky     |      Owner:
    Type:  undecided  |     Status:  new
Priority:  major      |  Milestone:  undecided
 Version:  master     |   Keywords:
----------------------+-----------------------
 When running Buildbot test suite with `BUILDBOT_TEST_DB_URL` pointing to
 MySQL 5.5 instance following errors occurs:

 {{{
 ...
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: Incorrect string
 value: '\xE2\x98\x83' for column 'u' at row 1
 E/home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: Invalid utf8 character
 string: 'FFFF00'
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: Incorrect string
 value: '\xE2\x98\x83' for column 'u' at row 1
 ...........................................................................................................S...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................S......................................................../home/bob/stuff/buildbot
 /env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: BLOB/TEXT column
 'state_string' can't have a default value
 ./home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: BLOB/TEXT column
 'state_string' can't have a default value
 ./home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: BLOB/TEXT column
 'state_string' can't have a default value
 ./home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/sqlalchemy/engine/default.py:331: Warning: BLOB/TEXT column
 'state_string' can't have a default value
 ...
 [FAIL]
 Traceback (most recent call last):
   File "/home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/trial/_asynctest.py", line 75, in _eb
     raise self.failureException(output)
 twisted.trial.unittest.FailTest:
 Expected: (<type 'exceptions.UnicodeError'>,)
 Got:
 [Failure instance: Traceback: <type 'exceptions.AssertionError'>:
 /usr/lib/python2.7/threading.py:810:__bootstrap_inner
 /usr/lib/python2.7/threading.py:763:run
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/_threads/_threadworker.py:46:work
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/_threads/_team.py:190:doWork
 --- <exception caught here> ---
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/threadpool.py:246:inContext
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/threadpool.py:262:<lambda>
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/context.py:118:callWithContext
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/context.py:81:callWithContext
 /home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/pool.py:192:__thd
 /home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/model.py:818:thd
 /home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/model.py:759:upgrade
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/migrate/versioning/schema.py:91:runchange
 /home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/migrate/versioning/script/py.py:145:run
 /home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/migrate/versions/001_initial.py:254:upgrade
 /home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/migrate_utils.py:42:test_unicode
 ]

 buildbot.test.regressions.test_import_unicode_changes.TestUnicodeChanges.testNonUnicodeChange
 ===============================================================================
 [ERROR]
 Traceback (most recent call last):
   File "/home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/threadpool.py", line 246, in inContext
     result = inContext.theWork()
   File "/home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/threadpool.py", line 262, in <lambda>
     inContext.theWork = lambda: context.call(ctx, func, *args, **kw)
   File "/home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/context.py", line 118, in callWithContext
     return self.currentContext().callWithContext(ctx, func, *args, **kw)
   File "/home/bob/stuff/buildbot/env-master/local/lib/python2.7/site-
 packages/twisted/python/context.py", line 81, in callWithContext
     return func(*args,**kw)
   File "/home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/pool.py", line 192, in __thd
     rv = callable(arg, *args, **kwargs)
   File "/home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/model.py", line 823, in thd
     test_unicode(engine)
   File "/home/bob/stuff/buildbot/buildbot-
 master/master/buildbot/db/migrate_utils.py", line 42, in test_unicode
     assert row['u'] == u
 exceptions.AssertionError:

 buildbot.test.integration.test_upgrade.UpgradeTestEmpty.test_emptydb_modelmatches
 ===============================================================================
 [ERROR]
 }}}

 I used MySQL in Docker, I documented it here:
 ​https://github.com/buildbot/buildbot/pull/1955

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


More information about the bugs mailing list