Bug 202927 - run-buildbot-test: sqlalchemy exception when upgrading the database
Summary: run-buildbot-test: sqlalchemy exception when upgrading the database
Status: RESOLVED FIXED
Alias: None
Product: WebKit
Classification: Unclassified
Component: Tools / Tests (show other bugs)
Version: WebKit Nightly Build
Hardware: Unspecified Unspecified
: P2 Normal
Assignee: Carlos Alberto Lopez Perez
URL:
Keywords: InRadar
Depends on:
Blocks:
 
Reported: 2019-10-14 07:32 PDT by Carlos Alberto Lopez Perez
Modified: 2019-10-17 07:52 PDT (History)
8 users (show)

See Also:


Attachments
Patch (1.67 KB, patch)
2019-10-14 07:46 PDT, Carlos Alberto Lopez Perez
no flags Details | Formatted Diff | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Carlos Alberto Lopez Perez 2019-10-14 07:32:54 PDT
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
Comment 1 Carlos Alberto Lopez Perez 2019-10-14 07:46:45 PDT
Created attachment 380884 [details]
Patch
Comment 2 jadoreboc 2019-10-14 17:46:53 PDT Comment hidden (spam)
Comment 3 Carlos Alberto Lopez Perez 2019-10-17 07:51:26 PDT
Comment on attachment 380884 [details]
Patch

Clearing flags on attachment: 380884

Committed r251232: <https://trac.webkit.org/changeset/251232>
Comment 4 Carlos Alberto Lopez Perez 2019-10-17 07:51:30 PDT
All reviewed patches have been landed.  Closing bug.
Comment 5 Radar WebKit Bug Importer 2019-10-17 07:52:20 PDT
<rdar://problem/56370100>