[Buildbot-devel] missing DB entry + fix

[tom fogal]

One of my schedulers had an empty "state".  This was causing the
following error on startup using current master (df0a02ffd...):

  2010-03-11 10:21:49-0700 [-] adbapi connecting: pysqlite2.dbapi2 ('/home/visit/master/state.sqlite',){'check_same_thread': False}
  2010-03-11 10:21:49-0700 [-] Unhandled Error
          Traceback (most recent call last):
            File "/usr/lib/python2.5/threading.py", line 446, in run
              self.__target(*self.__args, **self.__kwargs)
            File "/usr/lib/python2.5/site-packages/twisted/python/threadpool.py", line 161, in _worker
              context.call(ctx, function, *args, **kwargs)
            File "/usr/lib/python2.5/site-packages/twisted/python/context.py", line 59, in callWithContext
              return self.currentContext().callWithContext(ctx, func, *args, **kw)
            File "/usr/lib/python2.5/site-packages/twisted/python/context.py", line 37, in callWithContext
              return func(*args,**kw)
          --- <exception caught here> ---
            File "/usr/lib/python2.5/site-packages/twisted/internet/threads.py", line 24, in _putResultInDeferred
              result = f(*args, **kwargs)
            File "/usr/lib/python2.5/site-packages/twisted/enterprise/adbapi.py", line 375, in _runInteraction
              result = interaction(trans, *args, **kw)
            File "/usr/local/lib/python2.5/site-packages/buildbot-latest-py2.5.egg/buildbot/schedulers/base.py", line 134, in classify_changes
              last_processed = state["last_processed"]
          exceptions.KeyError: 'last_processed'

I was able to fix this by manually updating the DB record for the
scheduler:

  update schedulers set state = '{"last_processed": 9}' where schedulerid=2;

I've no idea what the JSON entry means, I just pulled it from my other
scheduler.

-tom