Hi, the problem is solved, I just want to put it here in case anybody stumbles across the same error message.
I recently got the following error message: Full backup fails : DB Error: mergejoin input data is out of order The postgres log had the following entry: INSERT INTO Log (JobId, Time, LogText) VALUES (52526,'2022-07-20 09:55:47','bpstation-dir JobId 52526: 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=ERROR: mergejoin input data is out of order The client was running Bacula 9.4.1, the director and storage daemon were under 9.4.4. All previous incremental backups, the last full (6 month ago) and even subsequent incrementals on that client and all other backups on all other computers ran smoothly. After a lot of head scratching I found out that the filename table had a lot of duplicate entries (~10,500). Where those came from, I have no idea. After dbcheck did fix those, the full backup succeeded as expected. Cheers Stefan Münkner -------------------------------------------------------------------------- -- this is an empty signature :-) _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
