From ebd91a51c58fe73974dd64e8183e4b95b7ee2efb Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Tue, 15 Mar 2022 14:55:33 +0100 Subject: [PATCH] Purge metadata when deleting jobs --- bacula/src/dird/ua_purge.c | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/bacula/src/dird/ua_purge.c b/bacula/src/dird/ua_purge.c index d15c39cb5..8970770cb 100644 --- a/bacula/src/dird/ua_purge.c +++ b/bacula/src/dird/ua_purge.c @@ -361,6 +361,14 @@ void purge_files_from_jobs(UAContext *ua, char *jobs) { POOL_MEM query(PM_MESSAGE); + Mmsg(query, "DELETE FROM MetaEmail WHERE JobId IN (%s)", jobs); + db_sql_query(ua->db, query.c_str(), NULL, (void *)NULL); + Dmsg1(050, "Delete MetaEmail sql=%s\n", query.c_str()); + + Mmsg(query, "DELETE FROM MetaAttachment WHERE JobId IN (%s)", jobs); + db_sql_query(ua->db, query.c_str(), NULL, (void *)NULL); + Dmsg1(050, "Delete MetaAttachment sql=%s\n", query.c_str()); + Mmsg(query, "DELETE FROM TagJob WHERE JobId IN (%s)", jobs); db_sql_query(ua->db, query.c_str(), NULL, (void *)NULL); Dmsg1(050, "Delete TagJob sql=%s\n", query.c_str()); -- 2.47.3