Re: [Bacula-users] Out of range value for column 'FileIndex' at row 1

[Kern Sibbald]

Hello, It looks to me like you forgot to run the update_bacula_tables script prior to running jobs. Best regards, Kern On 9/8/19 11:07 AM, Eyermann, Frank wrote: Dear all,   since upgrading to 9.4.4 (from 9.2.1) most of my backups fail.   Error message is: Fatal error: sql_create.c:841 Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name): ERR=Out of range value for column 'FileIndex' at row 1   I’m using a MySQL database.   Digging around in database and increasing MySQL logging, I’ve found that bacula is inserting records with negative FileIndex into batch, but in Table File column FileIndex is unsigned bigint.   Best regards,   Frank     _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users