[users at bb.net] SQLAlchemy and SQLAlchemy-Migrate versions?

Barta, Hank hank.barta at sandc.com
Mon Aug 8 17:06:41 UTC 2016


OS: Ubuntu 16.04 LTS
Python 2.7.12
Buildbot version: 0.8.12
Twisted version: 16.0.0

I'm confused. The manual at http://docs.buildbot.net/current/manual/installation.html#requirements (Says "Buildbot 0.8.12 documentation" at the top of the page) states:

"Buildbot requires SQLAlchemy 0.6.0 or higher. SQLAlchemy allows Buildbot to build database schemas and queries for a wide variety of database systems."

I have the default package for Ubuntu 16.04 installed:
"ii  python-sqlalchemy          1.0.11+ds1-1ubuntu2             all          SQL toolkit and Object Relational Mapper for Python"
(Looks like 1.0.11 to me.)

A bit further on the same page I see:
"Buildbot requires one of the following SQLAlchemy-Migrate versions: 0.7.1, 0.7.2 and 0.9. SQLAlchemy-Migrate-0.9 is required for compatibility with SQLAlchemy versions 0.8 and above. Buildbot uses SQLAlchemy-Migrate to manage schema upgrades from version to version."

I install 0.9 using:
"pip install -I sqlalchemy-migrate==0.9 --force-reinstall"

When I run Buildbot it starts up but when it tries to send email, it gets an error:
2016-08-08 16:50:29+0000 [-] Exception caught notifying <buildbot.status.mail.MailNotifier object at 0x7f9aa740e390> of buildFinished event
2016-08-08 16:50:29+0000 [-] Unhandled Error
        Traceback (most recent call last):
          File "/usr/lib/python2.7/dist-packages/buildbot/status/build.py", line 320, in buildFinished
            w.callback(self)
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 393, in callback
            self._startRunCallbacks(result)
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 501, in _startRunCallbacks
            self._runCallbacks()
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 588, in _runCallbacks
            current.result = callback(current.result, *args, **kw)
        --- <exception caught here> ---
          File "/usr/lib/python2.7/dist-packages/buildbot/status/builder.py", line 597, in _buildFinished
            w.buildFinished(name, s, results)
          File "/usr/lib/python2.7/dist-packages/buildbot/status/mail.py", line 537, in buildFinished
            return self.buildMessage(name, [build], results)
          File "/usr/lib/python2.7/dist-packages/buildbot/status/mail.py", line 735, in buildMessage
            build=build, results=build.results)
          File "/usr/lib/python2.7/dist-packages/buildbot/status/mail.py", line 716, in buildMessageDict
            self.master_status)
          File "/var/lib/devops/buildbot/master/master.cfg", line 143, in messageFormatter
            result = util.Results[results]
          File "/usr/lib/python2.7/dist-packages/buildbot/plugins/db.py", line 238, in __getattr__
            raise AttributeError(str(err))
        exceptions.AttributeError: Requirements are not satisfied for buildbot.util:Results: (sqlalchemy-migrate 0.9 (/usr/local/lib/python2.7/dist-packages), Requirement.parse('sqlalchemy-migrate==0.7.2'))

If I try sqlalchemy-migrate==0.7.2 the master errors on startup with:
2016-08-08 16:46:43+0000 [-] while starting BuildMaster
        Traceback (most recent call last):
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 501, in _startRunCallbacks
            self._runCallbacks()
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 588, in _runCallbacks
            current.result = callback(current.result, *args, **kw)
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1184, in gotResult
            _inlineCallbacks(r, g, deferred)
          File "/usr/lib/python2.7/dist-packages/twisted/internet/defer.py", line 1128, in _inlineCallbacks
            result = g.send(result)
        --- <exception caught here> ---
          File "/usr/lib/python2.7/dist-packages/buildbot/master.py", line 206, in startService
            yield self.db.setup()
          File "/usr/lib/python2.7/dist-packages/buildbot/db/connector.py", line 101, in setup
            basedir=self.basedir)
          File "/usr/lib/python2.7/dist-packages/buildbot/db/enginestrategy.py", line 249, in create_engine
            return sa.create_engine(*args, **kwargs)
          File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/__init__.py", line 386, in create_engine
            return strategy.create(*args, **kwargs)
          File "/usr/lib/python2.7/dist-packages/buildbot/db/enginestrategy.py", line 203, in create
            self.check_sqlalchemy_version()
          File "/usr/lib/python2.7/dist-packages/buildbot/db/enginestrategy.py", line 198, in check_sqlalchemy_version
            "SQLAlchemy-Migrate version %d.%d.%d" % (version, mvt[0], mvt[1], mvt[2]))
        exceptions.RuntimeError: SQLAlchemy version 1.0.14 is not supported by SQLAlchemy-Migrate version 0.7.2

(Hmmm... package name is 1.0.11 and module identifies itself as 1.0.14 ...)

What versions of these modules should I be running?

Thanks,
hank
________________________________
NOTICE OF CONFIDENTIALITY:
This message may contain information that is considered confidential and which may be prohibited from disclosure under applicable law or by contractual agreement. The information is intended solely for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the information contained in or attached to this message is strictly prohibited. If you have received this email transmission in error, please notify the sender by replying to this email and then delete it from your system.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 12768 bytes
Desc: not available
URL: <http://lists.buildbot.net/pipermail/users/attachments/20160808/1d63e367/attachment.bin>


More information about the users mailing list