The branch puller is sometimes getting this error (from the XML-RPC server):
Traceback (innermost last):
Module zope.publisher.publish, line 143, in publish
publication.afterCall(request, object)
Module canonical.launchpad.webapp.publication, line 363, in afterCall
txn.commit()
Module transaction._transaction, line 380, in commit
self._saveCommitishError() # This raises!
Module transaction._transaction, line 378, in commit
self._commitResources()
Module transaction._transaction, line 431, in _commitResources
rm.tpc_begin(self)
Module storm.zope.zstorm, line 268, in tpc_begin
self._store.flush()
Module storm.store, line 484, in flush
self._flush_one(obj_info)
Module storm.store, line 546, in _flush_one
self._connection.execute(expr, noresult=True)
Module storm.databases.postgres, line 257, in execute
return Connection.execute(self, statement, params, noresult)
Module storm.database, line 200, in execute
raw_cursor = self.raw_execute(statement, params)
Module storm.databases.postgres, line 267, in raw_execute
return Connection.raw_execute(self, statement, params)
Module storm.database, line 284, in raw_execute
statement, params or (), error)
Module storm.tracer, line 85, in trace
attr(*args, **kwargs)
Module canonical.launchpad.webapp.adapter, line 338, in connection_raw_execute_error
raise TimeoutError(statement, params)
TimeoutError: 'UPDATE Branch SET mirror_failures=%s, mirror_status_message=%s WHERE Branch.id = %s', [<storm.variables.IntVariable object at 0x5e9baa0>, <storm.sqlobject.AutoUnicodeVariable object at 0x5e9bb18>, <storm.variables.IntVariable object at 0x7c72c80>]
It seems odd to time out updating a single row.
See OOPS-1013XMLP7, OOPS-1013XMLP5 and OOPS-1013XMLP6 from the XML-RPC server, and OOPS-1013SMPU14, OOPS-1013SMPU13 and OOPS-1013SMPU12 from the branch puller.
The OOPS show most of the time is not database queries.