Cannot rerun monitoring on runs where information already stored in database
Error message:
File "replace_runs.py", line 52, in <module>
main()
File "replace_runs.py", line 49, in main
combinerTrunk.write_to_db()
File "/calib/velo/dqm/lhcb-prerelease/Today/LOVELL/LOVELL_HEAD/VeloAnalysisFramework/python/veloview/core/combiners.py", line 284, in write_to_db
writer.fill(self.runnr, self._get_writable_results())
File "/calib/velo/dqm/lhcb-prerelease/Today/LOVELL/LOVELL_HEAD/VeloAnalysisFramework/python/veloview/core/io.py", line 71, in fill
c.execute('INSERT INTO runs(runnr, timestamp, runendtimestamp) VALUES(?, ?, ?)', (runnr, now, runendtimestamp))
sqlite3.IntegrityError: PRIMARY KEY must be unique
Lennaert suggests:
replace the INSERT statement with INSERT OR IGNORE