[MacPorts] #71001: buildbot @3.10.1_0: Incompatible sqlalchemy version installed

[MacPorts]

#71001: buildbot @3.10.1_0: Incompatible sqlalchemy version installed
--------------------------+----------------------
 Reporter:  berg-michael  |      Owner:  (none)
     Type:  defect        |     Status:  new
 Priority:  Normal        |  Milestone:
Component:  ports         |    Version:
 Keywords:                |       Port:  buildbot
--------------------------+----------------------
 Verified on 10.4 ppc, probably exists elsewhere.

 Fixed in upstream: https://github.com/buildbot/buildbot/issues/7506
 (commit fixing the issue linked at bottom). It's due to an incompatible
 (too new) version of sqlalchemy being used. Newer upstreams allow for
 newer sqlalchemy.

 > Well, it seems problem is that Buildbot has frozen SQLAlchemy to 1.5
 however Fedora 40 installs 2.0.29.
 > Simple solution seems to be install Buildbot into virtualenv.

 On my machine:

 {{{
 tiger-g5$ port installed | grep sqlalchemy
   py310-sqlalchemy @2.0.34_0 (active)
   py310-sqlalchemy-migrate @0.13.0_0 (active)
 }}}


 {{{

 tiger-g5$ buildbot create-master /opt/mp-buildbot/master
 updating existing installation
 buildbot.tac already exists and is correct
 creating /opt/mp-buildbot/master/master.cfg.sample
 creating database (sqlite:///state.sqlite)
 Got fatal Exception on DB
 Traceback (most recent call last):
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/threadpool.py", line 260, in <lambda>
     inContext.theWork = lambda: context.call(  # type: ignore[attr-
 defined]
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/context.py", line 117, in callWithContext
     return self.currentContext().callWithContext(ctx, func, *args, **kw)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/context.py", line 82, in callWithContext
     return func(*args, **kw)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/pool.py", line 234, in __thd
     log.err(e, 'Got fatal Exception on DB')
 --- <exception caught here> ---
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/pool.py", line 207, in __thd
     rv = callable(arg, *args, **kwargs)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/model.py", line 1114, in thd
     test_unicode(conn)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/migrate_utils.py", line 33, in test_unicode
     test_unicode.create()
 builtins.TypeError: Table.create() missing 1 required positional argument:
 'bind'

 Traceback (most recent call last):
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 735, in errback
     self._startRunCallbacks(fail)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 798, in _startRunCallbacks
     self._runCallbacks()
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 892, in _runCallbacks
     current.result = callback(  # type: ignore[misc]
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 1792, in gotResult
     _inlineCallbacks(r, gen, status, context)
 --- <exception caught here> ---
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 1693, in _inlineCallbacks
     result = context.run(
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/failure.py", line 518, in
 throwExceptionIntoGenerator
     return g.throw(self.type, self.value, self.tb)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/scripts/create_master.py", line 99, in
 createMaster
     yield createDB(config)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 1693, in _inlineCallbacks
     result = context.run(
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/failure.py", line 518, in
 throwExceptionIntoGenerator
     return g.throw(self.type, self.value, self.tb)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/scripts/create_master.py", line 90, in createDB
     yield db.model.upgrade()
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 1693, in _inlineCallbacks
     result = context.run(
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/failure.py", line 518, in
 throwExceptionIntoGenerator
     return g.throw(self.type, self.value, self.tb)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/model.py", line 1140, in upgrade
     yield self.db.pool.do(thd)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/internet/defer.py", line 1693, in _inlineCallbacks
     result = context.run(
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/failure.py", line 518, in
 throwExceptionIntoGenerator
     return g.throw(self.type, self.value, self.tb)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/pool.py", line 244, in do
     ret = yield threads.deferToThreadPool(self.reactor, self._pool,
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/threadpool.py", line 244, in inContext
     result = inContext.theWork()  # type: ignore[attr-defined]
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/threadpool.py", line 260, in <lambda>
     inContext.theWork = lambda: context.call(  # type: ignore[attr-
 defined]
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/context.py", line 117, in callWithContext
     return self.currentContext().callWithContext(ctx, func, *args, **kw)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/twisted/python/context.py", line 82, in callWithContext
     return func(*args, **kw)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/pool.py", line 207, in __thd
     rv = callable(arg, *args, **kwargs)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/model.py", line 1114, in thd
     test_unicode(conn)
   File
 "/opt/local/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10
 /site-packages/buildbot/db/migrate_utils.py", line 33, in test_unicode
     test_unicode.create()
 builtins.TypeError: Table.create() missing 1 required positional argument:
 'bind'
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/71001>
MacPorts <https://www.macports.org/>
Ports system for macOS