<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugs.webkit.org/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.0.4.1"
          urlbase="https://bugs.webkit.org/"
          
          maintainer="admin@webkit.org"
>

    <bug>
          <bug_id>202927</bug_id>
          
          <creation_ts>2019-10-14 07:32:54 -0700</creation_ts>
          <short_desc>run-buildbot-test: sqlalchemy exception when upgrading the database</short_desc>
          <delta_ts>2019-10-17 07:52:20 -0700</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>WebKit</product>
          <component>Tools / Tests</component>
          <version>WebKit Nightly Build</version>
          <rep_platform>Unspecified</rep_platform>
          <op_sys>Unspecified</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>FIXED</resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords>InRadar</keywords>
          <priority>P2</priority>
          <bug_severity>Normal</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Carlos Alberto Lopez Perez">clopez</reporter>
          <assigned_to name="Carlos Alberto Lopez Perez">clopez</assigned_to>
          <cc>aakash_jain</cc>
    
    <cc>aperez</cc>
    
    <cc>bugs-noreply</cc>
    
    <cc>cgarcia</cc>
    
    <cc>clopez</cc>
    
    <cc>jadoreboc</cc>
    
    <cc>mcatanzaro</cc>
    
    <cc>webkit-bug-importer</cc>
          

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>1579627</commentid>
    <comment_count>0</comment_count>
    <who name="Carlos Alberto Lopez Perez">clopez</who>
    <bug_when>2019-10-14 07:32:54 -0700</bug_when>
    <thetext>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 &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py&quot;, line 397, in errback
    self._startRunCallbacks(fail)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py&quot;, line 464, in _startRunCallbacks
    self._runCallbacks()
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py&quot;, line 551, in _runCallbacks
    current.result = callback(current.result, *args, **kw)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py&quot;, line 916, in gotResult
    _deferGenerator(g, deferred)
--- &lt;exception caught here&gt; ---
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py&quot;, line 891, in _deferGenerator
    result = g.next()
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/scripts/runner.py&quot;, line 434, in upgradeMaster
    wfd.getResult()
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/internet/defer.py&quot;, line 870, in getResult
    self.result.raiseException()
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/python/threadpool.py&quot;, line 167, in _worker
    result = context.call(ctx, function, *args, **kwargs)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/python/context.py&quot;, line 118, in callWithContext
    return self.currentContext().callWithContext(ctx, func, *args, **kw)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/twisted/python/context.py&quot;, line 81, in callWithContext
    return func(*args,**kw)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/pool.py&quot;, line 183, in __thd
    rv = callable(arg, *args, **kwargs)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/model.py&quot;, line 501, in thd
    upgrade(engine)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/model.py&quot;, line 442, in upgrade
    schema.runchange(version, change, 1)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py&quot;, line 91, in runchange
    change.run(self.engine, step)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/migrate/versioning/script/py.py&quot;, line 145, in run
    script_func(engine)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/buildbot/db/migrate/versions/018_add_sourcestampset.py&quot;, line 26, in upgrade
    buildsets_table = sa.Table(&apos;buildsets&apos;, metadata, autoload=True)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py&quot;, line 318, in __new__
    table._init(name, metadata, *args, **kw)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py&quot;, line 381, in _init
    self._autoload(metadata, autoload_with, include_columns)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py&quot;, line 408, in _autoload
    self, include_columns, exclude_columns
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py&quot;, line 2426, in run_callable
    return conn.run_callable(callable_, *args, **kwargs)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py&quot;, line 1969, in run_callable
    return callable_(self, *args, **kwargs)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py&quot;, line 260, in reflecttable
    return insp.reflecttable(table, include_columns, exclude_columns)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py&quot;, line 448, in reflecttable
    **reflection_options
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py&quot;, line 318, in __new__
    table._init(name, metadata, *args, **kw)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py&quot;, line 381, in _init
    self._autoload(metadata, autoload_with, include_columns)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/schema.py&quot;, line 397, in _autoload
    self, include_columns, exclude_columns
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py&quot;, line 1969, in run_callable
    return callable_(self, *args, **kwargs)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py&quot;, line 260, in reflecttable
    return insp.reflecttable(table, include_columns, exclude_columns)
  File &quot;/tmp/tmpQHUOYP/venv/local/lib/python2.7/site-packages/sqlalchemy/engine/reflection.py&quot;, line 412, in reflecttable
    raise exc.NoSuchTableError(table.name)
sqlalchemy.exc.NoSuchTableError: migration_tmp</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1579629</commentid>
    <comment_count>1</comment_count>
      <attachid>380884</attachid>
    <who name="Carlos Alberto Lopez Perez">clopez</who>
    <bug_when>2019-10-14 07:46:45 -0700</bug_when>
    <thetext>Created attachment 380884
Patch</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1579931</commentid>
    <comment_count>2</comment_count>
    <who name="">jadoreboc</who>
    <bug_when>2019-10-14 17:46:53 -0700</bug_when>
    <thetext>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</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1580949</commentid>
    <comment_count>3</comment_count>
      <attachid>380884</attachid>
    <who name="Carlos Alberto Lopez Perez">clopez</who>
    <bug_when>2019-10-17 07:51:26 -0700</bug_when>
    <thetext>Comment on attachment 380884
Patch

Clearing flags on attachment: 380884

Committed r251232: &lt;https://trac.webkit.org/changeset/251232&gt;</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1580950</commentid>
    <comment_count>4</comment_count>
    <who name="Carlos Alberto Lopez Perez">clopez</who>
    <bug_when>2019-10-17 07:51:30 -0700</bug_when>
    <thetext>All reviewed patches have been landed.  Closing bug.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1580951</commentid>
    <comment_count>5</comment_count>
    <who name="Radar WebKit Bug Importer">webkit-bug-importer</who>
    <bug_when>2019-10-17 07:52:20 -0700</bug_when>
    <thetext>&lt;rdar://problem/56370100&gt;</thetext>
  </long_desc>
      
          <attachment
              isobsolete="0"
              ispatch="1"
              isprivate="0"
          >
            <attachid>380884</attachid>
            <date>2019-10-14 07:46:45 -0700</date>
            <delta_ts>2019-10-17 07:51:26 -0700</delta_ts>
            <desc>Patch</desc>
            <filename>bug-202927-20191014164641.patch</filename>
            <type>text/plain</type>
            <size>1707</size>
            <attacher name="Carlos Alberto Lopez Perez">clopez</attacher>
            
              <data encoding="base64">U3VidmVyc2lvbiBSZXZpc2lvbjogMjUxMDcxCmRpZmYgLS1naXQgYS9Ub29scy9DaGFuZ2VMb2cg
Yi9Ub29scy9DaGFuZ2VMb2cKaW5kZXggN2M0YjA5ZGRkNTFjZTNmZWQ5YWZkMGJjZmZmYzY4ZDVj
MzU4YzU3MS4uYTNlMDg3MjliYjAzMDU0YTkxZTE5NWI1NWQ4YTI0N2U4NzA0YmIzOSAxMDA2NDQK
LS0tIGEvVG9vbHMvQ2hhbmdlTG9nCisrKyBiL1Rvb2xzL0NoYW5nZUxvZwpAQCAtMSwzICsxLDE1
IEBACisyMDE5LTEwLTE0ICBDYXJsb3MgQWxiZXJ0byBMb3BleiBQZXJleiAgPGNsb3BlekBpZ2Fs
aWEuY29tPgorCisgICAgICAgIHJ1bi1idWlsZGJvdC10ZXN0OiBzcWxhbGNoZW15IGV4Y2VwdGlv
biB3aGVuIHVwZ3JhZGluZyB0aGUgZGF0YWJhc2UKKyAgICAgICAgaHR0cHM6Ly9idWdzLndlYmtp
dC5vcmcvc2hvd19idWcuY2dpP2lkPTIwMjkyNworCisgICAgICAgIFJldmlld2VkIGJ5IE5PQk9E
WSAoT09QUyEpLgorCisgICAgICAgIFVwZGF0ZSB0aGUgdmVyc2lvbiBvZiBzcWxhbGNoZW15LW1p
Z3JhdGUgZm9yIHBpcCB1c2VkIGZvciB0aGUgdGVzdC4KKyAgICAgICAgVGhhdCBmaXhlcyB0aGUg
ZXhjZXB0aW9uIHdoZW4gdXBncmFkaW5nIHRoZSBkYXRhYmFzZS4KKworICAgICAgICAqIEJ1aWxk
U2xhdmVTdXBwb3J0L2J1aWxkLndlYmtpdC5vcmctY29uZmlnL3J1bi1idWlsZGJvdC10ZXN0LnB5
OgorCiAyMDE5LTEwLTE0ICBBZHJpYW4gUGVyZXogZGUgQ2FzdHJvICA8YXBlcmV6QGlnYWxpYS5j
b20+CiAKICAgICAgICAgVW5yZXZpZXdlZCwgc2V0IEFkcmlhbiBQZXJleiBkZSBDYXN0cm8gYXMg
V2ViS2l0IFJldmlld2VyCmRpZmYgLS1naXQgYS9Ub29scy9CdWlsZFNsYXZlU3VwcG9ydC9idWls
ZC53ZWJraXQub3JnLWNvbmZpZy9ydW4tYnVpbGRib3QtdGVzdC5weSBiL1Rvb2xzL0J1aWxkU2xh
dmVTdXBwb3J0L2J1aWxkLndlYmtpdC5vcmctY29uZmlnL3J1bi1idWlsZGJvdC10ZXN0LnB5Cmlu
ZGV4IGEzMTg5ZWRkNGIxN2RmYTRkZDVjY2FjYWQ1ZDgwMjM1NWE5Y2FkNWQuLjczNDEwMzNkNmNm
YWMzMWU0MjUyMmM5MzFhZWQ5MGUxYTc0YWJlOGYgMTAwNzU1Ci0tLSBhL1Rvb2xzL0J1aWxkU2xh
dmVTdXBwb3J0L2J1aWxkLndlYmtpdC5vcmctY29uZmlnL3J1bi1idWlsZGJvdC10ZXN0LnB5Cisr
KyBiL1Rvb2xzL0J1aWxkU2xhdmVTdXBwb3J0L2J1aWxkLndlYmtpdC5vcmctY29uZmlnL3J1bi1i
dWlsZGJvdC10ZXN0LnB5CkBAIC0yNjAsNyArMjYwLDcgQEAgZGVmIHNldHVwX3ZpcnR1YWxlbnYo
YmFzZV93b3JrZGlyX3RlbXApOgogICAgICAgICAgICAgICAgICAgICAndHdpc3RlZD09MTIuMS4w
JywKICAgICAgICAgICAgICAgICAgICAgJ2ppbmphMj09Mi42JywKICAgICAgICAgICAgICAgICAg
ICAgJ3NxbGFsY2hlbXk9PTAuNy44JywKLSAgICAgICAgICAgICAgICAgICAgJ3NxbGFsY2hlbXkt
bWlncmF0ZT09MC43LjInXQorICAgICAgICAgICAgICAgICAgICAnc3FsYWxjaGVteS1taWdyYXRl
PT0wLjEyLjAnXQogICAgICAgICBwaXBfcHJvY2VzcyA9IHN1YnByb2Nlc3MuUG9wZW4ocGlwX2Nt
ZCwgY3dkPWJhc2Vfd29ya2Rpcl90ZW1wLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgc3Rkb3V0PXN1YnByb2Nlc3MuUElQRSwgc3RkZXJyPXN1YnByb2Nlc3MuU1RET1VU
KQogICAgICAgICBzdGRvdXQsIHN0ZGVyciA9IHBpcF9wcm9jZXNzLmNvbW11bmljYXRlKCkK
</data>

          </attachment>
      

    </bug>

</bugzilla>