[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