IntegrityError: null value in column "sid" violates not-null constraintDETAIL: Failing row contains (null, 1, usermigration_emails, darius@dons.net.au doconnor@gsoft.com.au daniel@servalproject.or...).

[DanielO (Daniel O'Connor)]

How to Reproduce

I clicked on the "GitHub login" link at the top and got this..

While doing a GET operation on /github/oauth, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{u'code': u'931eeda79f35d4aeefe2', u'state': u'MjsDt0K8XzNNQQBy38g1ZlNSx937i9'}

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0.3 Safari/605.1.15

System Information

System information not available

Enabled Plugins

Plugin information not available

Interface Customization

Interface customization information not available

Python Traceback

Traceback (most recent call last):
  File "/var/www/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py", line 623, in _dispatch_request
    dispatcher.dispatch(req)
  File "/var/www/trac/virtualenv/lib/python2.7/site-packages/trac/web/main.py", line 239, in dispatch
    resp = chosen_handler.process_request(req)
  File "/var/www/trac/virtualenv/lib/python2.7/site-packages/tracext/github.py", line 109, in process_request
    self._do_oauth(req)
  File "/var/www/trac/virtualenv/lib/python2.7/site-packages/tracext/github.py", line 194, in _do_oauth
    (login, login, ' '.join(emails)))
  File "/var/www/trac/virtualenv/lib/python2.7/site-packages/trac/db/util.py", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "/var/www/trac/virtualenv/lib/python2.7/site-packages/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
IntegrityError: null value in column "sid" violates not-null constraint
DETAIL:  Failing row contains (null, 1, usermigration_emails, darius@dons.net.au doconnor@gsoft.com.au daniel@servalproject.or...).

[raimue (Rainer Müller)]

I checked, but the trac.log does not have more information than what is already given in the ticket description.

I do not think we have ever seen this before. The value that is tried to be inserted into the sid column would equal the username (or called login internally). For some reason the login field must have come back as a null value in ​trac-github.