On 08/03/2015 03:35 PM, Michael Schwager wrote: > In my case, there are Jobs associated with the MediaId in the JobMedia > database table, but this JobId does not exist in the Job table.
This means there should be a foreign key on jobmedia: jobid references job (jobid) on delete cascade. Looking at my 7.0.5/postgres 9.2, there should also be "mediaid references media (mediaid) on delete cascade". It does explain it: in my case I'm pretty sure it happened after something went pear-shaped and a running backup crashed or otherwise ended abnormally. Presumably leaving some of the tables updated but not the others. -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users