github2fedmsg
github2fedmsg copied to clipboard
fedora-infra
500 error when authenticating to github
I renamed my GitHub account from 'CodeBlock' to 'relrod'. To update the username github2fedmsg had stored, I unlinked my GitHub account and attempted to relink my account.
When I go to relink, I get a 500 error.
The URL is https://apps.fedoraproject.org/github2fedmsg/login/github/callback?code=[redacted]&state=[redacted]
[Thu Dec 18 21:29:06.234892 2014] [:error] [pid 5844] 2014-12-18 21:29:06,234 INFO [urllib3.connectionpool][Dummy-1] Starting new HTTPS connection (1): github.com
[Thu Dec 18 21:29:06.496932 2014] [:error] [pid 5844] 2014-12-18 21:29:06,496 INFO [urllib3.connectionpool][Dummy-1] Starting new HTTPS connection (1): api.github.com
[Thu Dec 18 21:29:06.811110 2014] [:error] [pid 5844] /usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py:585: SAWarning: Unicode type received non-unicodebind param value.
[Thu Dec 18 21:29:06.811137 2014] [:error] [pid 5844] processors[key](compiled_params[key])
[Thu Dec 18 21:29:06.907874 2014] [:error] [pid 5844] [remote 192.168.1.14:132] mod_wsgi (pid=5844): Exception occurred processing WSGI script '/usr/share/github2fedmsg/github2fedmsg.wsgi'.
[Thu Dec 18 21:29:06.907928 2014] [:error] [pid 5844] [remote 192.168.1.14:132] Traceback (most recent call last):
[Thu Dec 18 21:29:06.907944 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/tw2/core/middleware.py", line 204, in __call__
[Thu Dec 18 21:29:06.907966 2014] [:error] [pid 5844] [remote 192.168.1.14:132] resp = req.get_response(self.app, catch_exc_info=True)
[Thu Dec 18 21:29:06.907975 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/webob/request.py", line 1292, in send
[Thu Dec 18 21:29:06.907991 2014] [:error] [pid 5844] [remote 192.168.1.14:132] application, catch_exc_info=True)
[Thu Dec 18 21:29:06.908006 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/webob/request.py", line 1260, in call_application
[Thu Dec 18 21:29:06.908029 2014] [:error] [pid 5844] [remote 192.168.1.14:132] app_iter = application(self.environ, start_response)
[Thu Dec 18 21:29:06.908043 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/paste/deploy/config.py", line 291, in __call__
[Thu Dec 18 21:29:06.908065 2014] [:error] [pid 5844] [remote 192.168.1.14:132] return self.app(environ, start_response)
[Thu Dec 18 21:29:06.908074 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/pyramid/router.py", line 251, in __call__
[Thu Dec 18 21:29:06.908087 2014] [:error] [pid 5844] [remote 192.168.1.14:132] response = self.invoke_subrequest(request, use_tweens=True)
[Thu Dec 18 21:29:06.908095 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/pyramid/router.py", line 227, in invoke_subrequest
[Thu Dec 18 21:29:06.908107 2014] [:error] [pid 5844] [remote 192.168.1.14:132] response = handle_request(request)
[Thu Dec 18 21:29:06.908115 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/pyramid/tweens.py", line 21, in excview_tween
[Thu Dec 18 21:29:06.908127 2014] [:error] [pid 5844] [remote 192.168.1.14:132] response = handler(request)
[Thu Dec 18 21:29:06.908135 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 82, in tm_tween
[Thu Dec 18 21:29:06.908148 2014] [:error] [pid 5844] [remote 192.168.1.14:132] reraise(*exc_info)
[Thu Dec 18 21:29:06.908155 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 70, in tm_tween
[Thu Dec 18 21:29:06.908188 2014] [:error] [pid 5844] [remote 192.168.1.14:132] manager.commit()
[Thu Dec 18 21:29:06.908204 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/transaction/_manager.py", line 111, in commit
[Thu Dec 18 21:29:06.908220 2014] [:error] [pid 5844] [remote 192.168.1.14:132] return self.get().commit()
[Thu Dec 18 21:29:06.908228 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/transaction/_transaction.py", line 280, in commit
[Thu Dec 18 21:29:06.908240 2014] [:error] [pid 5844] [remote 192.168.1.14:132] reraise(t, v, tb)
[Thu Dec 18 21:29:06.908247 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/transaction/_transaction.py", line 271, in commit
[Thu Dec 18 21:29:06.908274 2014] [:error] [pid 5844] [remote 192.168.1.14:132] self._commitResources()
[Thu Dec 18 21:29:06.908286 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/transaction/_transaction.py", line 417, in _commitResources
[Thu Dec 18 21:29:06.908299 2014] [:error] [pid 5844] [remote 192.168.1.14:132] reraise(t, v, tb)
[Thu Dec 18 21:29:06.908306 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/transaction/_transaction.py", line 389, in _commitResources
[Thu Dec 18 21:29:06.908318 2014] [:error] [pid 5844] [remote 192.168.1.14:132] rm.tpc_begin(self)
[Thu Dec 18 21:29:06.908326 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib/python2.7/site-packages/zope/sqlalchemy/datamanager.py", line 90, in tpc_begin
[Thu Dec 18 21:29:06.908343 2014] [:error] [pid 5844] [remote 192.168.1.14:132] self.session.flush()
[Thu Dec 18 21:29:06.908351 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1919, in flush
[Thu Dec 18 21:29:06.908363 2014] [:error] [pid 5844] [remote 192.168.1.14:132] self._flush(objects)
[Thu Dec 18 21:29:06.908371 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2037, in _flush
[Thu Dec 18 21:29:06.908383 2014] [:error] [pid 5844] [remote 192.168.1.14:132] transaction.rollback(_capture_exception=True)
[Thu Dec 18 21:29:06.908391 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
[Thu Dec 18 21:29:06.908403 2014] [:error] [pid 5844] [remote 192.168.1.14:132] compat.reraise(exc_type, exc_value, exc_tb)
[Thu Dec 18 21:29:06.908411 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2001, in _flush
[Thu Dec 18 21:29:06.908422 2014] [:error] [pid 5844] [remote 192.168.1.14:132] flush_context.execute()
[Thu Dec 18 21:29:06.908430 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
[Thu Dec 18 21:29:06.908442 2014] [:error] [pid 5844] [remote 192.168.1.14:132] rec.execute(self)
[Thu Dec 18 21:29:06.908449 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
[Thu Dec 18 21:29:06.908461 2014] [:error] [pid 5844] [remote 192.168.1.14:132] uow
[Thu Dec 18 21:29:06.908468 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 60, in save_obj
[Thu Dec 18 21:29:06.908480 2014] [:error] [pid 5844] [remote 192.168.1.14:132] mapper, table, update)
[Thu Dec 18 21:29:06.908487 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 518, in _emit_update_statements
[Thu Dec 18 21:29:06.908500 2014] [:error] [pid 5844] [remote 192.168.1.14:132] execute(statement, params)
[Thu Dec 18 21:29:06.908507 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 729, in execute
[Thu Dec 18 21:29:06.908519 2014] [:error] [pid 5844] [remote 192.168.1.14:132] return meth(self, multiparams, params)
[Thu Dec 18 21:29:06.908526 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 321, in _execute_on_connection
[Thu Dec 18 21:29:06.908539 2014] [:error] [pid 5844] [remote 192.168.1.14:132] return connection._execute_clauseelement(self, multiparams, params)
[Thu Dec 18 21:29:06.908546 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
[Thu Dec 18 21:29:06.908574 2014] [:error] [pid 5844] [remote 192.168.1.14:132] compiled_sql, distilled_params
[Thu Dec 18 21:29:06.908584 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
[Thu Dec 18 21:29:06.908604 2014] [:error] [pid 5844] [remote 192.168.1.14:132] context)
[Thu Dec 18 21:29:06.908620 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
[Thu Dec 18 21:29:06.908649 2014] [:error] [pid 5844] [remote 192.168.1.14:132] exc_info
[Thu Dec 18 21:29:06.908667 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
[Thu Dec 18 21:29:06.908698 2014] [:error] [pid 5844] [remote 192.168.1.14:132] reraise(type(exception), exception, tb=exc_tb)
[Thu Dec 18 21:29:06.908716 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
[Thu Dec 18 21:29:06.908746 2014] [:error] [pid 5844] [remote 192.168.1.14:132] context)
[Thu Dec 18 21:29:06.908764 2014] [:error] [pid 5844] [remote 192.168.1.14:132] File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
[Thu Dec 18 21:29:06.908794 2014] [:error] [pid 5844] [remote 192.168.1.14:132] cursor.execute(statement, parameters)
[Thu Dec 18 21:29:06.908863 2014] [:error] [pid 5844] [remote 192.168.1.14:132] IntegrityError: (IntegrityError) update or delete on table "users" violates foreign key constraint "org_to_user_mapping_org_id_fkey" on table "org_to_user_mapping"
[Thu Dec 18 21:29:06.908876 2014] [:error] [pid 5844] [remote 192.168.1.14:132] DETAIL: Key (github_username)=(CodeBlock) is still referenced from table "org_to_user_mapping".
[Thu Dec 18 21:29:06.908881 2014] [:error] [pid 5844] [remote 192.168.1.14:132] 'UPDATE users SET github_username=%(github_username)s, oauth_access_token=%(oauth_access_token)s WHERE users.username = %(users_username)s' {'users_username': u'codeblock', 'oauth_access_token': '[REDACTED]', 'github_username': u'relrod'}