View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001588bareos-corewebuipublic2024-01-03 15:272024-02-28 10:00
Reporterraschu Assigned Tobruno-at-bareos  
PriorityurgentSeveritycrashReproducibilityalways
Status closedResolutionno change required 
PlatformLinuxOSDebianOS Version10
Summary0001588: 23.0.1~pre7 WebUI: "There was an error while loading data for this tree."
DescriptionHi,

I have a large backup client with many small files. If I want to restore files from this backup client over the WebUI - the generation of the file tree crashes.

"""
There was an error while loading data for this tree.
Error: ajax
Plugin: core
Reason: Could not load node
Data: "readyState":4,"responseText":"Decoding failed: Syntax error[]","status":200,"statusText":"OK"
"""

I have already update the bvfs cache.

If I enable the debug level to 200 I get this message at the error time:

"""
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
"""

What can I do to avoid the error?

Thanks Ralf
TagsNo tags attached.

Activities

raschu

raschu

2024-01-03 15:27

reporter  

webui_crash.png (132,644 bytes)   
webui_crash.png (132,644 bytes)   
bruno-at-bareos

bruno-at-bareos

2024-01-03 16:02

manager   ~0005664

use bconsole
module sqlquery
and try to run the 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

check if you got a return and check if you have enough free tmp space for postgresql.

if you got a return, maybe you want to make it a compressed file and attach it here if < 2MB (you can use private checkbox so it will not be visible)
raschu

raschu

2024-01-03 16:22

reporter   ~0005665

Thanks Bruno!

I'm surprised, I get no return. :-(

>>>>>

*sqlquery
Entering SQL query mode.
Terminate each query with a semicolon.
Terminate query mode with a blank line.
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;
No results to list.
End query mode.:

<<<<<

Bye Ralf
raschu

raschu

2024-01-03 16:27

reporter   ~0005666

Last edited: 2024-01-03 16:31

 Here the full output from the debug level=200 attached

Thanks Ralf


Update:
/var/lib/postgresql has over 64G free, that won't be the problem
bareos-dir.trace (36,846 bytes)    
...
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
bareos-dir.trace (36,846 bytes)   
bruno-at-bareos

bruno-at-bareos

2024-01-03 16:44

manager   ~0005667

> /var/lib/postgresql has over 64G free, that won't be the problem

It may still be a problem if those 64GB are less that 50% of free space. It is not rare to see some of the big queries using 50 ot 70% of the size of the db has temp.

You should now try to restore from bconsole -> restore -> option 5
then select your client and fileset to see if building the tree work
raschu

raschu

2024-01-03 17:09

reporter   ~0005668

Thank you for the fast replay.

The Diskspace is save, there are 70% free.

The Test over the bconsole works fine.

>>>>>>
...
| 7849 | I | 6,698 | 331,052,824 | 2024-01-02 20:00:02 | aincr30d-bsd02-2207 |
+-------+-------+------------+-----------------+---------------------+----------------------+
You have selected the following JobIds: 6591,6687,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7474,7521,7568,7615,7662,7709,7755,7800,7849

Building directory tree for JobId(s) 6591,6687,6774,6838,6889,6937,6987,7035,7082,7130,7179,7231,7283,7334,7383,7474,7521,7568,7615,7662,7709,7755,7800,7849 ... +++++++++++++++++++++++++++++++++++++++++++++
17,984,253 files inserted into the tree.

You are now entering file selection mode where you add (mark) and
remove (unmark) files to be restored. No files are initially added, unless
you used the "all" keyword on the command line.
Enter "done" to leave this mode.

cwd is: /
$
<<<<<<

I think the problem is located in the webui (apache2) oder some timeout or limit settings!?

Thank you very much, Ralf
bruno-at-bareos

bruno-at-bareos

2024-01-05 09:49

manager   ~0005669

I'm still asking myself why this would failed in the webui, especially the query, because the root tree in not rebuild completely (if bvfs_cache is accurate) and only parts are send to the ui for rendering.

Either you have a bvfs_cache which need to be cleanup and rebuild, either you have one directory with millions of objects in, either the php settings for your fpm need to be increased (runtime etc)

You maybe want to play with the following parameters in the bareos-webui/configuration.ini
[restore]
; Restore filetree refresh timeout in milliseconds
; Default:
;filetree_refresh_timeout=120000

; Merge jobs on client selection
; Default:
;merge_jobs=true

; Merge filesets on client selection
; Default:
;merge_filesets=true

Try to set merge_filesets=false this is useful for a client that do a lot of different jobs.
raschu

raschu

2024-01-08 15:58

reporter   ~0005670

Hi Bruno, thanks.

"Try to set merge_filesets=false this is useful for a client that do a lot of different jobs."

This works a bit better but later there also errors. We try to provide the bconsole for restore-tasks. But the Webui is better for normal users. :-/

The other options like "filetree_refresh_timeout" will also not help.

Hints are welcome :-)

Thanks Ralf
bruno-at-bareos

bruno-at-bareos

2024-01-08 16:41

manager   ~0005673

I can't provide any good advise without a full diagnose of it.
I can't say what is the better tools, but I would always recommend tools that behave always the same, any give predictable results, as they are easier to document ;-)
bruno-at-bareos

bruno-at-bareos

2024-01-08 17:26

manager   ~0005677

The best things is trying to increase the values for the php-fpm engine like memory_limit (512MB) and max_execution_time
enabling error_log can help to determine what parameter is needed.
raschu

raschu

2024-01-12 10:02

reporter   ~0005683

Thank you, I'll keep trying and get back to you
bruno-at-bareos

bruno-at-bareos

2024-01-18 10:35

manager   ~0005700

Any news.
raschu

raschu

2024-01-19 11:28

reporter   ~0005705

Hi Bruno, thanks for asking.

So far it's not working any better but I want to investigate it further.
Will report back with results when I've been able to test more.

Many greetings Ralf
bruno-at-bareos

bruno-at-bareos

2024-02-06 09:35

manager   ~0005734

Ping we would like to have news or close
bruno-at-bareos

bruno-at-bareos

2024-02-28 10:00

manager   ~0005818

closing without feedback return

Issue History

Date Modified Username Field Change
2024-01-03 15:27 raschu New Issue
2024-01-03 15:27 raschu File Added: webui_crash.png
2024-01-03 16:02 bruno-at-bareos Note Added: 0005664
2024-01-03 16:22 raschu Note Added: 0005665
2024-01-03 16:27 raschu Note Added: 0005666
2024-01-03 16:27 raschu File Added: bareos-dir.trace
2024-01-03 16:31 raschu Note Edited: 0005666
2024-01-03 16:44 bruno-at-bareos Note Added: 0005667
2024-01-03 17:09 raschu Note Added: 0005668
2024-01-05 09:49 bruno-at-bareos Note Added: 0005669
2024-01-08 15:58 raschu Note Added: 0005670
2024-01-08 16:41 bruno-at-bareos Note Added: 0005673
2024-01-08 17:26 bruno-at-bareos Note Added: 0005677
2024-01-12 10:02 raschu Note Added: 0005683
2024-01-18 10:35 bruno-at-bareos Assigned To => bruno-at-bareos
2024-01-18 10:35 bruno-at-bareos Status new => feedback
2024-01-18 10:35 bruno-at-bareos Note Added: 0005700
2024-01-19 11:28 raschu Note Added: 0005705
2024-01-19 11:28 raschu Status feedback => assigned
2024-02-06 09:35 bruno-at-bareos Status assigned => feedback
2024-02-06 09:35 bruno-at-bareos Note Added: 0005734
2024-02-28 10:00 bruno-at-bareos Status feedback => closed
2024-02-28 10:00 bruno-at-bareos Resolution open => no change required
2024-02-28 10:00 bruno-at-bareos Note Added: 0005818