Skip to content

IntegrityError: insert or update on table "kolibri_public_file" violates foreign key constraint "kolibri_public_f... #4136

@sentry

Description

@sentry

Sentry Issue: STUDIO-GCS

ForeignKeyViolation: insert or update on table "kolibri_public_file" violates foreign key constraint "kolibri_public_file_contentnode_id_bba72681_fk_kolibri_p"
DETAIL:  Key (contentnode_id)=(67ae8982-b210-550c-8f2e-0435a600eda5) is not present in table "kolibri_public_contentnode".

  File "django/db/backends/base/base.py", line 242, in _commit
    return self.connection.commit()

IntegrityError: insert or update on table "kolibri_public_file" violates foreign key constraint "kolibri_public_file_contentnode_id_bba72681_fk_kolibri_p"
DETAIL:  Key (contentnode_id)=(67ae8982-b210-550c-8f2e-0435a600eda5) is not present in table "kolibri_public_contentnode".

(4 additional frame(s) were not displayed)
...
  File "kolibri_public/management/commands/export_channels_to_kolibri_public.py", line 77, in handle
    self._export_channel(channel_id)
  File "kolibri_public/management/commands/export_channels_to_kolibri_public.py", line 67, in _export_channel
    mapper.run()
  File "kolibri_public/utils/mapper.py", line 52, in run
    set_channel_metadata_fields(self.mapped_channel.id, public=self.public)

Failed to export channel b431ba9f16a3588b89700f3eb8281af0 to kolibri_public because of error: insert or update on table "kolibri_public_file" violates foreign key constraint "kolibri_public_file_contentnode_id_bba72681_fk_kolibri_p"
DETAIL:  Key (contentnode_id)=(67ae8982-b210-550c-8f2e-0435a600eda5) is not present in table "kolibri_public_contentnode".

Metadata

Metadata

Assignees

Labels

P0 - criticalPriority: Release blocker or regression

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions