[Buildbot-devel] IntegrityError on postgresql, "claimed_at" violates not-null constraint

Dustin J. Mitchell dustin at v.igoro.us
Fri Sep 21 12:30:53 UTC 2012


On Fri, Sep 21, 2012 at 5:53 AM, Benoît Allard <benoit at aeteurope.nl> wrote:
> Does someone already has a fix in the pipeline for this ?

I haven't heard of this *specific* problem before.  I also don't see
how it can happen:

102         if claimed_at is not None:
103             claimed_at = datetime2epoch(claimed_at)
104         else:
105             claimed_at = _reactor.seconds()

The problem of catching exceptions is tricky - we can't match on
message text, as it can be localized.  And SQLAlchemy isn't very
specific in breaking db errors down to exceptions.

We can add an assert that claimed_at is not None, but I'm not sure
that will help.

Dustin




More information about the devel mailing list