Skip to content

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
    • Help
    • Submit feedback
    • Contribute to GitLab
  • Sign in
haskell-gargantext
haskell-gargantext
  • Project
    • Project
    • Details
    • Activity
    • Releases
    • Cycle Analytics
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Charts
  • Issues 166
    • Issues 166
    • List
    • Board
    • Labels
    • Milestones
  • Merge Requests 11
    • Merge Requests 11
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
    • Charts
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Charts
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • gargantext
  • haskell-gargantexthaskell-gargantext
  • Issues
  • #300

Closed
Open
Opened Jan 22, 2024 by Fabien Maniere@fmaniere
  • Report abuse
  • New issue
Report abuse New issue

[Corpus importation] SQL error: sometimes, an sql "violates foreign key constraint" error occurs on importing a corpus

Typical error (both displayed on frontend as an error message, and also in gargantext logs):

FatalError {fatalErrorMessage = "SqlError {sqlState = \"23503\", sqlExecStatus = FatalError, sqlErrorMsg = \"insert or update on table \\\"node_stories\\\" violates foreign key constraint \\\"node_stories_node_id_fkey1\\\"\", sqlErrorDetail = \"Key (node_id)=(112202) is not present in table \\\"nodes\\\".\", sqlErrorHint = \"\"}"}

Edited Jan 22, 2024 by Fabien Maniere
Assignee
Assign to
Epic 0.0.6.9.9
Milestone
Epic 0.0.6.9.9
Assign milestone
Time tracking
None
Due date
None
1
Labels
Doing
Assign labels
  • View project labels
Reference: gargantext/haskell-gargantext#300