[Buildbot] #2981: Bitbucket hook doesn't work when specifying project

[Buildbot trac]

#2981: Bitbucket hook doesn't work when specifying project
-----------------------------+--------------------
Reporter:  jpihl             |       Owner:
    Type:  defect            |      Status:  new
Priority:  patches-accepted  |   Milestone:  0.9.+
 Version:  0.8.9             |  Resolution:
Keywords:  bitbucket, hook   |
-----------------------------+--------------------
Changes (by sa2ajj):

 * priority:  minor => patches-accepted
 * type:  undecided => defect
 * milestone:  undecided => 0.9.+


Comment:

 Copying text from the pastebin (as it might be gone soonish):

 {{{


     bitbucket error

     2014-10-27 13:42:59+0100 [HTTPChannel,494,131.103.20.165] Attempting
 to load module buildbot.status.web.hooks.bitbucket
     2014-10-27 13:42:59+0100 [HTTPChannel,494,131.103.20.165] New
 revision: 7613d3fda345
     2014-10-27 13:42:59+0100 [HTTPChannel,494,131.103.20.165] Received 1
 changes from bitbucket
     2014-10-27 13:42:59+0100 [HTTPChannel,494,131.103.20.165] Got the
 following changes [{'files': [u'hook_test'], 'project': ['my-project-
 name'], 'repository': u'https://bitbucket.org/some-org/my-project-name/',
 'branch': u'test-hooks', 'author': u'jpihl <jpihl at email.com>',
 'when_timestamp': datetime.datetime(2014, 10, 27, 12, 42, 47,
 tzinfo=tzutc()), 'revlink': u'https://bitbucket.org/some-org/my-project-
 name/7613d3fda3453e1e94b1608421ae2be1fecc6cae', 'comments': u'testing
 hook\n', 'revision': u'7613d3fda3453e1e94b1608421ae2be1fecc6cae'}]
     2014-10-27 13:42:59+0100 [HTTPChannel,494,131.103.20.165] Payload:
 {'project': ['my-project-name'], 'payload': ['{"repository": {"website":
 "", "fork": false, "name": "my-project-name", "scm": "git", "owner":
 "some-org", "absolute_url": "/some-org/my-project-name/", "slug": "my-
 project-name", "is_private": true}, "truncated": false, "commits":
 [{"node": "7613c3fda345", "files": [{"type": "added", "file":
 "hook_test"}], "raw_author": "jpihl <jpihl at email.com>", "utctimestamp":
 "2014-10-27 12:42:47+00:00", "author": "jpihl", "timestamp": "2014-10-27
 13:42:47", "raw_node": "7613d3fda3453e1e94b1608421ae2be1fecc6cae",
 "parents": ["5e19533870dc"], "branch": "test-hooks", "message": "testing
 hook\\n", "revision": null, "size": -1}], "canon_url":
 "https://bitbucket.org", "user": "jpihl"}']}
     2014-10-27 13:42:59+0100 [-] adding changes from web hook
         Traceback (most recent call last):
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/internet/defer.py", line 423, in errback
             self._startRunCallbacks(fail)
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/internet/defer.py", line 490, in _startRunCallbacks
             self._runCallbacks()
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/internet/defer.py", line 577, in _runCallbacks
             current.result = callback(current.result, *args, **kw)
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/internet/defer.py", line 1155, in gotResult
             _inlineCallbacks(r, g, deferred)
         --- <exception caught here> ---
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/internet/defer.py", line 1097, in _inlineCallbacks
             result = result.throwExceptionIntoGenerator(g)
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/python/failure.py", line 389, in
 throwExceptionIntoGenerator
             return g.throw(self.type, self.value, self.tb)
           File "/usr/local/lib/python2.7/dist-
 packages/buildbot/status/web/change_hook.py", line 140, in submitChanges
             change = yield master.addChange(src=src, **chdict)
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/python/threadpool.py", line 196, in _worker
             result = context.call(ctx, function, *args, **kwargs)
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/python/context.py", line 118, in callWithContext
             return self.currentContext().callWithContext(ctx, func, *args,
 **kw)
           File "/usr/local/lib/python2.7/dist-
 packages/twisted/python/context.py", line 81, in callWithContext
             return func(*args,**kw)
           File "/usr/local/lib/python2.7/dist-
 packages/buildbot/db/pool.py", line 191, in __thd
             rv = callable(arg, *args, **kwargs)
           File "/usr/local/lib/python2.7/dist-
 packages/buildbot/db/changes.py", line 82, in thd
             project=project))
           File "/usr/local/lib/python2.7/dist-
 packages/sqlalchemy/engine/base.py", line 1449, in execute
             params)
           File "/usr/local/lib/python2.7/dist-
 packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
             compiled_sql, distilled_params
           File "/usr/local/lib/python2.7/dist-
 packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
             context)
           File "/usr/local/lib/python2.7/dist-
 packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
             context)
           File "/usr/local/lib/python2.7/dist-
 packages/sqlalchemy/engine/default.py", line 331, in do_execute
             cursor.execute(statement, parameters)
         sqlalchemy.exc.InterfaceError: (InterfaceError) Error binding
 parameter 10 - probably unsupported type. u'INSERT INTO changes (author,
 comments, is_dir, branch, revision, revlink, when_timestamp, category,
 repository, codebase, project) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
 (u'jpihl <jpihl at email.com>', u'testing hook\n', 0, u'test-hooks',
 u'7613d3fda3453e1e94b1608421ae2be1fecc6cae', u'https://bitbucket.org/some-
 org/my-project-name/7613d3fda3453e1e94b1608421ae2be1fecc6cae', 1414413767,
 None, u'https://bitbucket.org/some-org/my-project-name/', '', ['my-
 project-name'])

 }}}

--
Ticket URL: <http://trac.buildbot.net/ticket/2981#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation