Tag relation table not cleaned up in retention service

ClusterCockpit / cc-backend

Web frontend and API backend server for ClusterCockpit Monitoring Framework

https://www.clustercockpit.org

MIT License

15 stars 14 forks source link

Tag relation table not cleaned up in retention service #155

Closed moebiusband73 closed 1 year ago

moebiusband73 commented 1 year ago

The retention service deletes jobs from the Job archive and also offers to delete the jobs from the database. Still in this case the links between tags and deleted jobs are currently not cleaned up.

moebiusband73 commented 1 year ago

The current DB Schema for jobtag already sets ON DELETE CASCADE.

NOTE: If sqlite PRAGMA option foreign_keys must be explicitly set to ON. If using the sqlite3 console it is per default set to false! On every console session you must set: sqlite> PRAGMA foreign_keys = ON;