Skip to content

Database inconstistency in nG6

Problem: 673 links project/run while the run doesn't exist anymore. The most recent run in this series was made Monday 3 April 2017 22:00:00. (This error impacts at least the migration process.)

SELECT * FROM tx_nG6_project_run WHERE run_id NOT IN (SELECT uid FROM tx_nG6_run)

Tests: Deleting the run via the web interface also deletes the link. So the inconstistency doesn't come from here.

To do:

  • Remove the obsolete links
  • Test if the purge process is responsible. (It shouldn't delete the run nor the link.)
  • Update the database structure to add an integrity constaint.
  • Check if the analyzes have the same problem (project/analyze, run/analyze, analyze/result).
Edited by Romain Therville