Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#2845 closed task (fixed)

buildbot-linux4's DB is messed up

Reported by: dustin Owned by: dustin
Priority: major Milestone: sys - other
Version: 0.8.9 Keywords:
Cc:

Description

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' ()

Change History (2)

comment:1 Changed 5 years ago by dustin

  • Resolution set to fixed
  • Status changed from new to closed

Well, the obvious "drop sequence builds_id_seq" did the trick.

comment:2 Changed 5 years ago by dustin

  • Milestone changed from systems to sys - other

Milestone renamed

Note: See TracTickets for help on using tickets.