... bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bee184a0: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bee18620: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bee187a0: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:208-0 Got job: HOST1 bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bee196a0: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bee19820: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bee199a0: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:208-0 Got job: HOST2 bareos-dir (200): dird/scheduler_private.cc:215-0 run@55b6bef65010: run_now=0 run_next_hour=0 bareos-dir (200): dird/scheduler_private.cc:232-0 Finished AddJobsForThisAndNextHourToQueue bareos-dir (100): dird/ua_dotcmds.cc:190-0 type=D bareos-dir (100): dird/ua_dotcmds.cc:190-0 type=D bareos-dir (10): dird/ua_audit.cc:136-0 : Console [admin] from [::1] cmdline .bvfs_lsfiles jobid=6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849 path= limit=1000 offset=0 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6591 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6687 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6730 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6774 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6838 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6889 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6937 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6987 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7035 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7082 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7130 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7179 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7231 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7283 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7334 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7383 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7429 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7474 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7521 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7568 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7615 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7662 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7709 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7755 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7800 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7849 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (10): cats/bvfs.cc:606-0 ls_files(99) bareos-dir (100): cats/sql_query.cc:104-0 called: void BareosDb::FillQueryVaList(PoolMem&, BareosDbQueryEnum::SQL_QUERY, __va_list_tag*) with query name bvfs_list_files (47) bareos-dir (100): cats/sql_query.cc:109-0 called: void BareosDb::FillQueryVaList(PoolMem&, BareosDbQueryEnum::SQL_QUERY, __va_list_tag*) query is now SELECT TYPE, PathId, Name, JobId, LStat, FileId FROM ( SELECT DISTINCT ON (Name) 'F' AS TYPE, PathId, FileName AS Name, JobId, LStat, FileId, FileIndex FROM ( SELECT FileId, JobId, PathId, Name AS FileName, FileIndex, LStat, MD5 FROM File WHERE JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND PathId = 99 UNION ALL SELECT File.FileId, File.JobId, PathId, File.Name AS FileName, File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND File.PathId = 99 ) AS T JOIN Job USING (JobId) WHERE FileName != '' ORDER BY FileName, StartTime DESC ) AS A WHERE A.FileIndex > 0 LIMIT 1000 OFFSET 0 bareos-dir (15): cats/bvfs.cc:337-0 q=SELECT TYPE, PathId, Name, JobId, LStat, FileId FROM ( SELECT DISTINCT ON (Name) 'F' AS TYPE, PathId, FileName AS Name, JobId, LStat, FileId, FileIndex FROM ( SELECT FileId, JobId, PathId, Name AS FileName, FileIndex, LStat, MD5 FROM File WHERE JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND PathId = 99 UNION ALL SELECT File.FileId, File.JobId, PathId, File.Name AS FileName, File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND File.PathId = 99 ) AS T JOIN Job USING (JobId) WHERE FileName != '' ORDER BY FileName, StartTime DESC ) AS A WHERE A.FileIndex > 0 LIMIT 1000 OFFSET 0 bareos-dir (100): cats/sql_query.cc:148-0 called: bool BareosDb::SqlQuery(const char*, int (*)(void*, int, char**), void*) with query SELECT TYPE, PathId, Name, JobId, LStat, FileId FROM ( SELECT DISTINCT ON (Name) 'F' AS TYPE, PathId, FileName AS Name, JobId, LStat, FileId, FileIndex FROM ( SELECT FileId, JobId, PathId, Name AS FileName, FileIndex, LStat, MD5 FROM File WHERE JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND PathId = 99 UNION ALL SELECT File.FileId, File.JobId, PathId, File.Name AS FileName, File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND File.PathId = 99 ) AS T JOIN Job USING (JobId) WHERE FileName != '' ORDER BY FileName, StartTime DESC ) AS A WHERE A.FileIndex > 0 LIMIT 1000 OFFSET 0 bareos-dir (10): dird/ua_audit.cc:136-0 : Console [admin] from [::1] cmdline .bvfs_lsfiles jobid=6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849 path=@ limit=1000 offset=0 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6591 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6687 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6730 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6774 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6838 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6889 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6937 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=6987 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7035 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7082 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7130 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7179 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7231 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7283 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7334 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7383 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7429 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7474 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7521 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7568 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7615 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7662 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7709 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7755 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7800 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=7849 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.ClientId=51 bareos-dir (100): cats/sql_query.cc:131-0 called: bool BareosDb::SqlQuery(const char*, int) with query SELECT PathId FROM Path WHERE Path='@' bareos-dir (10): cats/bvfs.cc:606-0 ls_files(0) bareos-dir (100): cats/sql_query.cc:104-0 called: void BareosDb::FillQueryVaList(PoolMem&, BareosDbQueryEnum::SQL_QUERY, __va_list_tag*) with query name bvfs_list_files (47) bareos-dir (100): cats/sql_query.cc:109-0 called: void BareosDb::FillQueryVaList(PoolMem&, BareosDbQueryEnum::SQL_QUERY, __va_list_tag*) query is now SELECT TYPE, PathId, Name, JobId, LStat, FileId FROM ( SELECT DISTINCT ON (Name) 'F' AS TYPE, PathId, FileName AS Name, JobId, LStat, FileId, FileIndex FROM ( SELECT FileId, JobId, PathId, Name AS FileName, FileIndex, LStat, MD5 FROM File WHERE JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND PathId = 99 UNION ALL SELECT File.FileId, File.JobId, PathId, File.Name AS FileName, File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND File.PathId = 99 ) AS T JOIN Job USING (JobId) WHERE FileName != '' ORDER BY FileName, StartTime DESC ) AS A WHERE A.FileIndex > 0 LIMIT 1000 OFFSET 0 bareos-dir (15): cats/bvfs.cc:337-0 q=SELECT TYPE, PathId, Name, JobId, LStat, FileId FROM ( SELECT DISTINCT ON (Name) 'F' AS TYPE, PathId, FileName AS Name, JobId, LStat, FileId, FileIndex FROM ( SELECT FileId, JobId, PathId, Name AS FileName, FileIndex, LStat, MD5 FROM File WHERE JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND PathId = 99 UNION ALL SELECT File.FileId, File.JobId, PathId, File.Name AS FileName, File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND File.PathId = 99 ) AS T JOIN Job USING (JobId) WHERE FileName != '' ORDER BY FileName, StartTime DESC ) AS A WHERE A.FileIndex > 0 LIMIT 1000 OFFSET 0 bareos-dir (100): cats/sql_query.cc:148-0 called: bool BareosDb::SqlQuery(const char*, int (*)(void*, int, char**), void*) with query SELECT TYPE, PathId, Name, JobId, LStat, FileId FROM ( SELECT DISTINCT ON (Name) 'F' AS TYPE, PathId, FileName AS Name, JobId, LStat, FileId, FileIndex FROM ( SELECT FileId, JobId, PathId, Name AS FileName, FileIndex, LStat, MD5 FROM File WHERE JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND PathId = 99 UNION ALL SELECT File.FileId, File.JobId, PathId, File.Name AS FileName, File.FileIndex, LStat, MD5 FROM BaseFiles JOIN File USING (FileId) WHERE BaseFiles.JobId IN (6591,6687,6730,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7429,7474,7521,7568,7615,7662,7709,7755,7800,7849) AND File.PathId = 99 ) AS T JOIN Job USING (JobId) WHERE FileName != '' ORDER BY FileName, StartTime DESC ) AS A WHERE A.FileIndex > 0 LIMIT 1000 OFFSET 0 bareos-dir (100): lib/output_formatter.cc:1024-0 Failed to send json message (length=49). Message: {"jsonrpc":"2.0","id":null,"result":{"files":[]}} bareos-dir (200): dird/job.cc:1519-0 Start dird FreeJcr bareos-dir (200): dird/job.cc:1587-0 End dird FreeJcr bareos-dir (100): lib/jcr.cc:267-0 FreeCommonJcr: 7f7a84011720 bareos-dir (100): lib/bsock.cc:137-0 Destruct BareosSocket