[Buildbot] #2845: buildbot-linux4's DB is messed up

[Buildbot trac]

#2845: buildbot-linux4's DB is messed up
-------------------+---------------------
Reporter:  dustin  |      Owner:  dustin
    Type:  task    |     Status:  new
Priority:  major   |  Milestone:  systems
 Version:  0.8.9   |   Keywords:
-------------------+---------------------
 {{{
 Traceback (most recent call last):
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/twisted/internet/defer.py", line 134, in maybeDeferred
     result = f(*args, **kw)
   File "/home/buildbot/slave/db-
 postgres/build/master/buildbot/db/model.py", line 765, in thd
     upgrade(engine)
   File "/home/buildbot/slave/db-
 postgres/build/master/buildbot/db/model.py", line 706, in upgrade
     schema.runchange(version, change, 1)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/migrate/versioning/schema.py", line 91, in runchange
     change.run(self.engine, step)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/migrate/versioning/script/py.py", line 145, in run
     script_func(engine)
   File "/home/buildbot/slave/db-
 postgres/build/master/buildbot/db/migrate/versions/004_add_autoincrement.py",
 line 125, in upgrade
     % (table_name, col_name))
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 2297, in execute
     return connection.execute(statement, *multiparams, **params)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1405, in execute
     params)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1582, in _execute_text
     statement, parameters
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
     context)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
     context)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-
 packages/sqlalchemy/engine/default.py", line 330, in do_execute
     cursor.execute(statement, parameters)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/dbapi.py", line
 243, in _fn
     return fn(self, *args, **kwargs)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/dbapi.py", line
 314, in execute
     self._execute(operation, args)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/dbapi.py", line
 319, in _execute
     self.cursor.execute(new_query, *new_args)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/interface.py", line
 304, in execute
     self._stmt.execute(*args, **kwargs)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/interface.py", line
 139, in execute
     self._row_desc, cmd = self.c.bind(self._portal_name,
 self._statement_name, args, self._parse_row_desc, kwargs.get("stream"))
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/protocol.py", line
 913, in _fn
     return fn(self, *args, **kwargs)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/protocol.py", line
 1107, in bind
     return reader.handle_messages()
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/protocol.py", line
 881, in handle_messages
     retval = handler(msg, *args, **kwargs)
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/protocol.py", line
 1146, in _bind_nodata
     reader.handle_messages()
   File "/home/buildbot/slave/db-postgres/sandbox-python-
 twistedsamigr-0.7.1/lib/python2.6/site-packages/pg8000/protocol.py", line
 886, in handle_messages
     raise exc
 sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('ERROR', '42P07',
 'relation "builds_id_seq" already exists') 'CREATE SEQUENCE builds_id_seq'
 ()
 }}}

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