Internal Server Error when editing NGO Form
heyhey, once in awhile i get the following error when editing the NGO form
Internal Server Error: /api/organisations/13/
Traceback (most recent call last):
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.IntegrityError: UNIQUE constraint failed: data_manager_organisation_org_actions.organisation_id, data_manager_organisation_org_actions.actiongroup_id
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/core/handlers/exception.py", line 41, in inner
response = get_response(request)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/core/handlers/base.py", line 187, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/core/handlers/base.py", line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/views/decorators/csrf.py", line 58, in wrapped_view
return view_func(*args, **kwargs)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/rest_framework/viewsets.py", line 116, in view
return self.dispatch(request, *args, **kwargs)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/djangoldp/views.py", line 204, in dispatch
response = super(LDPViewSet, self).dispatch(request, *args, **kwargs)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/rest_framework/views.py", line 495, in dispatch
response = self.handle_exception(exc)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/rest_framework/views.py", line 455, in handle_exception
self.raise_uncaught_exception(exc)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/rest_framework/views.py", line 492, in dispatch
response = handler(request, *args, **kwargs)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/djangoldp/views.py", line 153, in update
self.perform_update(serializer)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/rest_framework/mixins.py", line 80, in perform_update
serializer.save()
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/rest_framework/serializers.py", line 209, in save
self.instance = self.update(self.instance, validated_data)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/djangoldp/serializers.py", line 526, in update
self.save_or_update_nested_list(instance, nested_fields)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/djangoldp/serializers.py", line 599, in save_or_update_nested_list
manager.add(saved_item)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 934, in add
self._add_items(self.source_field_name, self.target_field_name, *objs)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/models/fields/related_descriptors.py", line 1103, in _add_items
for obj_id in new_ids
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/models/query.py", line 443, in bulk_create
ids = self._batched_insert(objs_without_pk, fields, batch_size)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/models/query.py", line 1102, in _batched_insert
self._insert(item, fields=fields, using=self.db)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/models/query.py", line 1079, in _insert
return query.get_compiler(using=using).execute_sql(return_id)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/models/sql/compiler.py", line 1112, in execute_sql
cursor.execute(sql, params)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/utils.py", line 79, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/utils.py", line 94, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/utils/six.py", line 685, in reraise
raise value.with_traceback(tb)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.IntegrityError: UNIQUE constraint failed: data_manager_organisation_org_actions.organisation_id, data_manager_organisation_org_actions.actiongroup_id
Internal Server Error: /api/organisations/13/
Traceback (most recent call last):
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/utils.py", line 64, in execute
return self.cursor.execute(sql, params)
File "/mnt/c/Users/maxim/Documents/taf/ppl4gaia/3_site/dev-appli/united4earth/env/lib/python3.6/site-packages/django/db/backends/sqlite3/base.py", line 328, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.IntegrityError: UNIQUE constraint failed: data_manager_organisation_org_actions.organisation_id, data_manager_organisation_org_actions.actiongroup_id
Not too sure what makes it happen.. It happened across multiples NGO pages, and on the same page i was able, some times, to link it, others not.
I feel like it's linked to loading --> If all the resources have loaded then i can edit, if they're still loading then i get the error but really not sure at all
Have you ever experienced this by any chance @alexandre @sylvain or @matthieu ?