[Buildbot] #3419: tests are failing when using PostgreSQL database backend
Buildbot trac
trac at buildbot.net
Fri Feb 5 02:40:52 UTC 2016
#3419: tests are failing when using PostgreSQL database backend
----------------------+------------------------
Reporter: rutsky | Owner: dustin
Type: undecided | Status: assigned
Priority: major | Milestone: undecided
Version: master | Resolution:
Keywords: |
----------------------+------------------------
Comment (by dustin):
To reproduce, I ran
{{{
docker run -P -e POSTGRES_USER=bbtest -e POSTGRES_PASSWORD=bbtest
postgres:9.5
}}}
then looked up the port with 'docker port', set
{{{
export
BUILDBOT_TEST_DB_URL=postgresql+pg8000://bbtest:bbtest at 127.0.0.1:32769/bbtest
}}}
and then ran the test suite.
I got a different set of errors:
{{{
Traceback (most recent call last):
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/threadpool.py", line 246, in inContext
result = inContext.theWork()
File "/home/dustin/p/buildbot/sandbox/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/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/context.py", line 118, in callWithContext
return self.currentContext().callWithContext(ctx, func, *args, **kw)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/context.py", line 81, in callWithContext
return func(*args,**kw)
File "/home/dustin/p/buildbot/master/buildbot/db/pool.py", line 192, in
__thd
rv = callable(arg, *args, **kwargs)
File
"/home/dustin/p/buildbot/master/buildbot/test/unit/test_db_migrate_versions_018_add_sourcestampset.py",
line 156, in verify_thd
], with_constrained_columns=['sourcestampsetid'])
File
"/home/dustin/p/buildbot/master/buildbot/test/unit/test_db_migrate_versions_018_add_sourcestampset.py",
line 137, in thd_assertForeignKeys
self.assertEqual(fks, exp)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/trial/_synctest.py", line 437, in assertEqual
super(_Assertions, self).assertEqual(first, second, msg)
File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
assertion_func(first, second, msg=msg)
File "/usr/lib/python2.7/unittest/case.py", line 742, in assertListEqual
self.assertSequenceEqual(list1, list2, msg, seq_type=list)
File "/usr/lib/python2.7/unittest/case.py", line 724, in
assertSequenceEqual
self.fail(msg)
twisted.trial.unittest.FailTest: Lists differ: [{'referred_columns':
[u'id'],... != [{'referred_table': 'sourcesta...
First differing element 0:
{'referred_columns': [u'id'], 'referred_table': u'sourcestampsets',
'constrained_columns': [u'sourcestampsetid'], 'options': {'onupdate':
None, 'deferrable': None, 'ondelete': None, 'initially': None, 'match':
None}}
{'referred_table': 'sourcestampsets', 'referred_columns': ['id'],
'constrained_columns': ['sourcestampsetid']}
- [{'constrained_columns': [u'sourcestampsetid'],
? -
+ [{'constrained_columns': ['sourcestampsetid'],
- 'options': {'deferrable': None,
- 'initially': None,
- 'match': None,
- 'ondelete': None,
- 'onupdate': None},
- 'referred_columns': [u'id'],
? -
+ 'referred_columns': ['id'],
- 'referred_table': u'sourcestampsets'}]
? -
+ 'referred_table': 'sourcestampsets'}]
buildbot.test.unit.test_db_migrate_versions_018_add_sourcestampset.Migration.test_1_buildsets
===============================================================================
[FAIL]
Traceback (most recent call last):
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/threadpool.py", line 246, in inContext
result = inContext.theWork()
File "/home/dustin/p/buildbot/sandbox/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/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/context.py", line 118, in callWithContext
return self.currentContext().callWithContext(ctx, func, *args, **kw)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/context.py", line 81, in callWithContext
return func(*args,**kw)
File "/home/dustin/p/buildbot/master/buildbot/db/pool.py", line 192, in
__thd
rv = callable(arg, *args, **kwargs)
File
"/home/dustin/p/buildbot/master/buildbot/test/unit/test_db_migrate_versions_018_add_sourcestampset.py",
line 182, in verify_thd
], with_constrained_columns=['sourcestampsetid'])
File
"/home/dustin/p/buildbot/master/buildbot/test/unit/test_db_migrate_versions_018_add_sourcestampset.py",
line 137, in thd_assertForeignKeys
self.assertEqual(fks, exp)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/trial/_synctest.py", line 437, in assertEqual
super(_Assertions, self).assertEqual(first, second, msg)
File "/usr/lib/python2.7/unittest/case.py", line 513, in assertEqual
assertion_func(first, second, msg=msg)
File "/usr/lib/python2.7/unittest/case.py", line 742, in assertListEqual
self.assertSequenceEqual(list1, list2, msg, seq_type=list)
File "/usr/lib/python2.7/unittest/case.py", line 724, in
assertSequenceEqual
self.fail(msg)
twisted.trial.unittest.FailTest: Lists differ: [{'referred_columns':
[u'id'],... != [{'referred_table': 'sourcesta...
First differing element 0:
{'referred_columns': [u'id'], 'referred_table': u'sourcestampsets',
'constrained_columns': [u'sourcestampsetid'], 'options': {'onupdate':
None, 'deferrable': None, 'ondelete': None, 'initially': None, 'match':
None}}
{'referred_table': 'sourcestampsets', 'referred_columns': ['id'],
'constrained_columns': ['sourcestampsetid']}
- [{'constrained_columns': [u'sourcestampsetid'],
? -
+ [{'constrained_columns': ['sourcestampsetid'],
- 'options': {'deferrable': None,
- 'initially': None,
- 'match': None,
- 'ondelete': None,
- 'onupdate': None},
- 'referred_columns': [u'id'],
? -
+ 'referred_columns': ['id'],
- 'referred_table': u'sourcestampsets'}]
? -
+ 'referred_table': 'sourcestampsets'}]
buildbot.test.unit.test_db_migrate_versions_018_add_sourcestampset.Migration.test_2_sourcestamp
===============================================================================
[ERROR]
Traceback (most recent call last):
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/threadpool.py", line 246, in inContext
result = inContext.theWork()
File "/home/dustin/p/buildbot/sandbox/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/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/context.py", line 118, in callWithContext
return self.currentContext().callWithContext(ctx, func, *args, **kw)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/twisted/python/context.py", line 81, in callWithContext
return func(*args,**kw)
File "/home/dustin/p/buildbot/master/buildbot/db/pool.py", line 192, in
__thd
rv = callable(arg, *args, **kwargs)
File "/home/dustin/p/buildbot/master/buildbot/test/util/migration.py",
line 82, in upgrade_thd
schema.runchange(version, change, 1)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File
"/home/dustin/p/buildbot/master/buildbot/db/migrate/versions/028_sourcestamps_refactor.py",
line 333, in upgrade
drop_old_schema_parts(migrate_engine)
File
"/home/dustin/p/buildbot/master/buildbot/db/migrate/versions/028_sourcestamps_refactor.py",
line 308, in drop_old_schema_parts
sa.Column('id', sa.Integer, primary_key=True),
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 416, in __new__
metadata._remove_table(name, schema)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 411, in __new__
table._init(name, metadata, *args, **kw)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 488, in _init
self._init_items(*args)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 72, in _init_items
item._set_parent_with_dispatch(self)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/base.py", line 433, in _set_parent_with_dispatch
self._set_parent(parent)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 1299, in _set_parent
self._setup_on_memoized_fks(lambda fk: fk._set_remote_table(table))
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 1310, in _setup_on_memoized_fks
fn(fk)
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 1299, in <lambda>
self._setup_on_memoized_fks(lambda fk: fk._set_remote_table(table))
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 1820, in _set_remote_table
parenttable, tablekey, colname = self._resolve_col_tokens()
File "/home/dustin/p/buildbot/sandbox/local/lib/python2.7/site-
packages/sqlalchemy/sql/schema.py", line 1693, in _resolve_col_tokens
"this ForeignKey's parent column is not yet associated "
sqlalchemy.exc.InvalidRequestError: this ForeignKey's parent column is not
yet associated with a Table.
buildbot.test.unit.test_db_migrate_versions_028_sourcestamps_refactor.Migration.test_migration
}}}
--
Ticket URL: <http://trac.buildbot.net/ticket/3419#comment:2>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation
More information about the bugs
mailing list