ProgrammingError using PostgreSQL

[abompard]

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
         '
CREATE TEMPORARY TABLE bbtmp_claim_ids (
	brid INTEGER
)

' {}

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

[Dustin J. Mitchell]

test to replicate #2010 - postgres can't create bbtmp_claim_ids

Refs #2010.

Changeset: bb765dbf6930b75c6543679b4f786781cb2cfdb9

[Dustin J. Mitchell]

Fix postgres problems with bbtmp_claim_ids

Fixes #2010.

Changeset: 3f6b61e8f5f03b29b8393cd912f06b09906c02fc

[Dustin J. Mitchell]

Fix postgres problems with bbtmp_claim_ids

Fixes #2010.

Changeset: ba9ddd59e8d8e8026e46d3c3bb83a39cddb15500