At work I periodically have append failures for my disk based volumes. The following is an example of the error:
21-Feb 14:20 fileserver-dir JobId 24345: Error: sql_create.c:152 sql_create.c:152 update UPDATE Media SET EndFile=0, EndBlock=3294226434 WHERE MediaId=275 failed: ERROR: integer out of range 21-Feb 14:20 fileserver-dir JobId 24345: Fatal error: Catalog error creating JobMedia record. sql_create.c:154 Update Media record UPDATE Media SET EndFile=0, EndBlock=3294226434 WHERE MediaId=275 failed: ERR=ERROR: integer out of range 21-Feb 14:20 fileserver-sd JobId 24345: Fatal error: Error creating JobMedia record: 1992 Create JobMedia error It appears the problem is with the catalog. I am using 64 bit gentoo linux and bacula-5.0.3 although the problem has persisted for years. I only use disk volumes for my catalog so I have not spent much effort investigating the cause. -- John M. Drescher ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users