Issue
The following error appears in the logs:
[2022-02-02 18:36:06.523 | ERROR | MainThread | django.request:230] Internal Server
Error: /saml2/acs/\nTraceback (most recent call last):\n
File \"/var/www/venv/lib/python3.7/site-packages/django/db/backends/utils.py\", line 84,
in _execute\n return self.cursor.execute(sql, params)\n
File \"/var/www/forms/forms/forms/db/backends/mssql/pyodbc/base.py\", line 422, in execute\n
return self.cursor.execute(sql, params)\npyodbc.ProgrammingError: ('42000', \"[42000] [Microsoft][ODBC Driver 17 for SQL Server]
[SQL Server]Could not allocate space for object 'dbo.activity_auditlog'.'PK__reports___123456789' in database 'dbname' because the
'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files
to the filegroup, or setting autogrowth on for existing files in the filegroup. (1105) (SQLExecDirectW)\")\n\nThe above exception was
the direct cause of the following exception:\n\nTraceback (most recent call last):\n
File \"/var/www/venv/lib/python3.7/site-packages/django/core/handlers/exception.py\", line 47, in inner\n
response = get_response(request)\n File \"/var/www/venv/lib/python3.7/site-packages/django/core/handlers/base.py\", line 181,
in _get_response\n response = wrapped_callback(request, *callback_args, **callback_kwargs)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/views/generic/base.py\", line 70, in view\n
return self.dispatch(request, *args, **kwargs)\n File \"/var/www/venv/lib/python3.7/site-packages/django/utils/decorators.py\",
line 43, in _wrapper\n return bound_method(*args, **kwargs)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/views/decorators/csrf.py\",
line 54, in wrapped_view\n return view_func(*args, **kwargs)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/views/generic/base.py\",
line 98, in dispatch\n return handler(request, *args, **kwargs)\n
File \"/var/www/venv/lib/python3.7/site-packages/djangosaml2/views.py\", line 529,
in post\n auth.login(self.request, user)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/contrib/auth/__init__.py\", line 135, in login\n
user_logged_in.send(sender=user.__class__, request=request, user=user)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/dispatch/dispatcher.py\",
line 182, in send\n for receiver in self._live_receivers(sender)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/dispatch/dispatcher.py\",
line 182, in \n for receiver in self._live_receivers(sender)\n File \"/var/www/forms/forms/user_profile/signals.py\",
line 16, in track_user_logged_in\n app_config.user_logged_in(user)\n File \"/var/www/forms/forms/reports/apps.py\",
line 46, in user_logged_in\n ActivityTracker.log(UserActivityType.LOGIN, user)\n
File \"/var/www/forms/forms/activity/activity_tracking.py\", line 49, in log\n
ActivityTracker.bulk_create([ActivityTracker.build(activity_name, user, **kwargs)])\n
File \"/var/www/forms/forms/activity/activity_tracking.py\", line 112, in bulk_create\n
AuditLog.objects.bulk_create(audit_logs)\n File \"/var/www/venv/lib/python3.7/site-packages/django/db/models/manager.py\",
line 85, in manager_method\n return getattr(self.get_queryset(), name)(*args, **kwargs)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/db/models/query.py\", line 515, in bulk_create\n
objs_without_pk, fields, batch_size, ignore_conflicts=ignore_conflicts,\n
File \"/var/www/venv/lib/python3.7/site-packages/django/db/models/query.py\", line 1293, in _batched_insert\n
self._insert(item, fields=fields, using=self.db, ignore_conflicts=ignore_conflicts)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/db/models/query.py\", line 1270, in _insert\n
return query.get_compiler(using=using).execute_sql(returning_fields)\n
File \"/var/www/forms/forms/forms/db/backends/mssql/compiler.py\", line 142, in execute_sql\n
ret = super().execute_sql(*args, **kwargs)\n File \"/var/www/venv/lib/python3.7/site-packages/django/db/models/sql/compiler.py\", line 1416,
in execute_sql\n cursor.execute(sql, params)\n File \"/var/www/venv/lib/python3.7/site-packages/django/db/backends/utils.py\", line 66,
in execute\n return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)\n
File \"/var/www/venv/lib/python3.7/site-packages/django/db/backends/utils.py\", line 75, in _execute_with_wrappers\n
return executor(sql, params, many, context)\n File \"/var/www/venv/lib/python3.7/site-packages/django/db/backends/utils.py\", line 84,
in _execute\n return self.cursor.execute(sql, params)\n File \"/var/www/venv/lib/python3.7/site-packages/django/db/utils.py\", line 90,
in __exit__\n raise dj_exc_value.with_traceback(traceback) from exc_value\n
File \"/var/www/venv/lib/python3.7/site-packages/django/db/backends/utils.py\", line 84, in _execute\n
return self.cursor.execute(sql, params)\n File \"/var/www/forms/forms/forms/db/backends/mssql/pyodbc/base.py\", line 422, in execute\n
return self.cursor.execute(sql, params)\ndjango.db.utils.ProgrammingError: ('42000', \"[42000] [Microsoft][ODBC Driver 17 for SQL Server]
[SQL Server]Could not allocate space for object 'dbo.activity_auditlog'.'PK__reports___123456789'
in database 'dbname' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup,
adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. (1105) (SQLExecDirectW)\")
Affected versions
All versions
Affected configurations
All configurations with an MSSQL database
Cause
If the mentioned storage for the database is full, the database will not be able to utilize it.
Solution / Workaround
The storage on the database server should be reviewed for potential cleanup, or it should have additional capacity allocated to it.