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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|