[Buildbot-commits] [Buildbot] #2010: ProgrammingError using PostgreSQL

[Buildbot]

#2010: ProgrammingError using PostgreSQL
----------------------+-----------------------
Reporter:  abompard   |      Owner:
    Type:  undecided  |     Status:  new
Priority:  major      |  Milestone:  undecided
 Version:  0.8.4p1    |   Keywords:  database
----------------------+-----------------------
 I have migrated to Builbot 0.8.4p1, and switched the database backend to
 PostgreSQL using buildbot upgrade-master.
 Now I get these messages in the log :

 {{{
 2011-06-22 11:46:03+0200 [-] in maybeStartBuild for <Builder ''unit-
 mes5-64'' at 43428824>
         Traceback (most recent call last):
           File "/usr/lib64/python2.5/site-
 packages/twisted/internet/defer.py", line 269, in errback
             self._startRunCallbacks(fail)
           File "/usr/lib64/python2.5/site-
 packages/twisted/internet/defer.py", line 312, in _startRunCallbacks
             self._runCallbacks()
           File "/usr/lib64/python2.5/site-
 packages/twisted/internet/defer.py", line 328, in _runCallbacks
             self.result = callback(self.result, *args, **kw)
           File "/usr/lib64/python2.5/site-
 packages/twisted/internet/defer.py", line 614, in gotResult
             _deferGenerator(g, deferred)
         --- <exception caught here> ---
           File "/usr/lib64/python2.5/site-
 packages/twisted/internet/defer.py", line 589, in _deferGenerator
             result = g.next()
           File "/usr/lib/python2.5/site-
 packages/buildbot/process/builder.py", line 689, in maybeStartBuild
             wfd.getResult()
           File "/usr/lib64/python2.5/site-
 packages/twisted/internet/defer.py", line 568, in getResult
             self.result.raiseException()
           File "/usr/lib/python2.5/site-packages/buildbot/db/pool.py",
 line 150, in thd
             rv = callable(conn, *args, **kwargs)
           File "/usr/lib/python2.5/site-
 packages/buildbot/db/buildrequests.py", line 217, in thd
             tmp.create()
           File "/usr/lib/python2.5/site-packages/sqlalchemy/schema.py",
 line 477, in create
             bind.create(self, checkfirst=checkfirst)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1437, in create
             return self.engine.create(entity, connection=self, **kwargs)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1698, in create
             connection=connection, **kwargs)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1740, in _run_visitor
             **kwargs).traverse_single(element)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/sql/visitors.py", line 86, in traverse_single
             return meth(obj, **kw)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/ddl.py", line 58, in visit_table
             self.connection.execute(schema.CreateTable(table))
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1191, in execute
             params)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1244, in _execute_ddl
             return self.__execute_context(context)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1302, in __execute_context
             context.parameters[0], context=context)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
             context)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
             context)
           File "/usr/lib/python2.5/site-
 packages/sqlalchemy/engine/default.py", line 299, in do_execute
             cursor.execute(statement, parameters)
         sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation
 "bbtmp_claim_ids" already exists
          '\nCREATE TEMPORARY TABLE bbtmp_claim_ids (\n\tbrid
 INTEGER\n)\n\n' {}
 }}}

 When I look in the database using the command-line client, I see no
 bbtmp_claim_ids table.

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