Bug 202927 – run-buildbot-test: sqlalchemy exception when upgrading the database

• Status: RESOLVED
• Resolution: FIXED
• Component: Tools / Tests

[Carlos Alberto Lopez Perez]

When trying to use run-buildbot-test from Tools/BuildSlaveSupport/build.webkit.org-config to test the master config locally the following exception happens when the script tries to upgrade the database on Debian 10:

checking for running master
checking master.cfg
upgrading basedir
populating /tmp/tmpQHUOYP/ac/build.webkit.org-config/public_html/favicon.ico
/tmp/tmpQHUOYP/ac/build.webkit.org-config/public_html/robots.txt has old/modified contents
 writing new contents to /tmp/tmpQHUOYP/ac/build.webkit.org-config/public_html/robots.txt.new
populating /tmp/tmpQHUOYP/ac/build.webkit.org-config/public_html/bg_gradient.jpg
/tmp/tmpQHUOYP/ac/build.webkit.org-config/public_html/default.css has old/modified contents
 writing new contents to /tmp/tmpQHUOYP/ac/build.webkit.org-config/public_html/default.css.new
populating /tmp/tmpQHUOYP/ac/build.webkit.org-config/master.cfg.sample
upgrading database (sqlite:///state.sqlite)
Traceback (most recent call last):
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 397, in errback
    self._startRunCallbacks(fail)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 464, in _startRunCallbacks
    self._runCallbacks()
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 551, in _runCallbacks
    current.result = callback(current.result, *args, **kw)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 916, in gotResult
    _deferGenerator(g, deferred)
--- <exception caught here> ---
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 891, in _deferGenerator
    result = g.next()
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/scripts/runner.py", line 434, in upgradeMaster
    wfd.getResult()
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py", line 870, in getResult
    self.result.raiseException()
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/python/threadpool.py", line 167, in _worker
    result = context.call(ctx, function, *args, **kwargs)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/python/context.py", line 118, in callWithContext
    return self.currentContext().callWithContext(ctx, func, *args, **kw)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/python/context.py", line 81, in callWithContext
    return func(*args,**kw)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/pool.py", line 183, in __thd
    rv = callable(arg, *args, **kwargs)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/model.py", line 501, in thd
    upgrade(engine)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/model.py", line 442, in upgrade
    schema.runchange(version, change, 1)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 91, in runchange
    change.run(self.engine, step)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 145, in run
    script_func(engine)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/migrate/versions/018_add_sourcestampset.py", line 26, in upgrade
    buildsets_table = sa.Table('buildsets', metadata, autoload=True)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py", line 318, in __new__
    table._init(name, metadata, *args, **kw)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py", line 381, in _init
    self._autoload(metadata, autoload_with, include_columns)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py", line 408, in _autoload
    self, include_columns, exclude_columns
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2426, in run_callable
    return conn.run_callable(callable_, *args, **kwargs)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1969, in run_callable
    return callable_(self, *args, **kwargs)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 260, in reflecttable
    return insp.reflecttable(table, include_columns, exclude_columns)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py", line 448, in reflecttable
    **reflection_options
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py", line 318, in __new__
    table._init(name, metadata, *args, **kw)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py", line 381, in _init
    self._autoload(metadata, autoload_with, include_columns)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py", line 397, in _autoload
    self, include_columns, exclude_columns
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1969, in run_callable
    return callable_(self, *args, **kwargs)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 260, in reflecttable
    return insp.reflecttable(table, include_columns, exclude_columns)
  File "/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py", line 412, in reflecttable
    raise exc.NoSuchTableError(table.name)
sqlalchemy.exc.NoSuchTableError: migration_tmp

[Carlos Alberto Lopez Perez]

Created attachment 380884 [details]
Patch

wanna a great floor sanding and polishing? You have actually found out the best way. Just open this url on your browser
http://www.sunshinefloorsanding.com.au/ 
Visit us

[Carlos Alberto Lopez Perez]

Comment on attachment 380884 [details]
Patch

Clearing flags on attachment: 380884

Committed r251232: <https://trac.webkit.org/changeset/251232>

[Carlos Alberto Lopez Perez]

All reviewed patches have been landed.  Closing bug.

[Radar WebKit Bug Importer]

<rdar://problem/56370100>