[Buildbot] #3419: tests are failing when using PostgreSQL database backend

[Buildbot trac]

#3419: tests are failing when using PostgreSQL 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
 PostgreSQL 9.5 instance following errors occurs:

 {{{
 ...
 sqlalchemy.exc.IntegrityError: (IntegrityError) duplicate key value
 violates unique constraint "buildslaves_name"
 DETAIL:  Key (name)=(bs1) already exists.
  'INSERT INTO buildslaves (name, info) VALUES (%(name)s, %(info)s)'
 ({'info': '{}', 'name': 'bs1'}, {'info': '{}', 'name': 'bs1'})


 buildbot.test.unit.test_db_migrate_versions_024_add_buildslaves_table.Migration.test_empty_migration
 ===============================================================================
 ...
 sqlalchemy.exc.InternalError: (InternalError) cannot drop table
 builder_masters because other objects depend on it
 DETAIL:  constraint configured_workers_buildermasterid_fkey on table
 configured_workers depends on table builder_masters
 HINT:  Use DROP ... CASCADE to drop the dependent objects too.
  '\nDROP TABLE builder_masters' {}

 buildbot.test.integration.test_upgrade.TestWeirdChanges.testUpgradeChangeNoRevision
 ===============================================================================
 ...
 exceptions.TypeError: can't escape unicode to binary

 buildbot.test.unit.test_db_logs.TestRealDB.test_addLogLines_big_chunk
 ===============================================================================
 ...
 }}}

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

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