Splunk: CAPA grading exception

Description

Another Splunk query shows the below exception has started occurring since November of this year.

Although there have been only 242 events since then, it would be good for a team to assess this bug - as it may cause downstream issues - which are then harder to debug - and become "mystery" issues.

Side note: It would be great if a team owns receiving Splunk alerts whenever new grades-related bugs are introduced.

Dec 7 20:08:03 ip-10-2-13-33 [service_variant=lms][edx.courseware][envrod-edx-edxapp] ERROR [ip-10-2-13-33 2058] [capa_module.py:109] - Unknown error when dispatching problem_check to block-v1:HarvardX+PH525.1x+2T2017+type@problem+block@bf616b4f21914f3d990da35784521e90 for user None
Traceback (most recent call last):
File "/edx/app/edxapp/edx-platform/common/lib/xmodule/xmodule/capa_module.py", line 92, in handle_ajax
result = handlers[dispatch](data)
File "/edx/app/edxapp/edx-platform/common/lib/xmodule/xmodule/capa_base.py", line 1265, in submit_problem
published_grade = self.publish_grade()
File "/edx/app/edxapp/edx-platform/common/lib/xmodule/xmodule/capa_base.py", line 1145, in publish_grade
'only_if_higher': only_if_higher,
File "/edx/app/edxapp/edx-platform/lms/djangoapps/courseware/module_render.py", line 499, in publish
handle_event(block, event)
File "/edx/app/edxapp/edx-platform/lms/djangoapps/courseware/module_render.py", line 538, in handle_grade_event
score_deleted=event.get('score_deleted'),
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/dispatch/dispatcher.py", line 189, in send
response = receiver(signal=self, sender=sender, **named)
File "/edx/app/edxapp/edx-platform/lms/djangoapps/grades/signals/handlers.py", line 151, in score_published_handler
score_modified_time = set_score(user.id, block.location, raw_earned, raw_possible)
File "/edx/app/edxapp/edx-platform/lms/djangoapps/courseware/model_data.py", line 1003, in set_score
'max_grade': max_score,
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 407, in get_or_create
return self._create_object_from_params(lookup, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 447, in _create_object_from_params
six.reraise(*exc_info)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 439, in _create_object_from_params
obj = self.create(**params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 348, in create
obj.save(force_insert=True, using=self.db)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 734, in save
force_update=force_update, update_fields=update_fields)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 762, in save_base
updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 846, in _save_table
result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/base.py", line 885, in _do_insert
using=using, raw=raw)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/manager.py", line 127, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/query.py", line 920, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 974, in execute_sql
cursor.execute(sql, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 129, in execute
six.reraise(utils.IntegrityError, utils.IntegrityError(*tuple(e.args)), sys.exc_info()[2])
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 124, in execute
return self.cursor.execute(query, args)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/newrelic/hooks/database_dbapi2.py", line 25, in execute
*args, **kwargs)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
self.errorhandler(self, exc, value)
File "/edx/app/edxapp/venvs/edxapp/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
IntegrityError: (1048, "Column 'student_id' cannot be null")

Steps to Reproduce

None

Current Behavior

None

Expected Behavior

None

Reason for Variance

None

Release Notes

None

User Impact Summary

Impact is not clear yet as this issue apparently affect Anonymous users not real ones.

Status

Assignee

Uzair Rasheed

Reporter

Nimisha Asthagiri

Reach

None

Impact

None

Customer

None

Partner Manager

None

URL

None

Contributor Name

None

Groups with Read-Only Access

None

Actual Points

None

Category of Work

None

Stakeholders

None

Priority

CAT-3
Configure