I am not a developer, Just a user using Bareos for backup of multiple machines
on my home network. Only trying to use as the developers are getting rid of
bat. Without the restore function working correctly, it seems I either use
bconsole to restore or nothing. Webui is supposed to do this for me.
I turned on mysql.log in mysqld.conf
It showed activity for approximately the time the wheel was spining and then
nothing more (I discuss a little more at end of this email).
There was a mysql thread for Bareos but it showed sleeping and reset the timer
(I guess that is what it was) about every 25 seconds.
While i did hit f12 (as suggested) while on the bareos-webui site and the tab
was on the restore tab, nothing appeared after selecting the correct computer.
my actions to setup the webui in case it helps were
1) on ubuntu 16.04 server run synaptic and select bareos-webui for install -
all went well
2) ran service apache2 restart and service bareos-dir restart
3) started bconsole
4) ran configure add console name=admin password=secret profile=webui-admin -
which failed
5) modified bareos-dir.conf adding the profile
Profile {
Name = webui-admin
CommandACL = !.bvfs_clear_cache, !.exit, !.sql, !configure, !create, !delete,
!purge, !sqlquery, !umount, !unmount, *all*
Job ACL = *all*
Schedule ACL = *all*
Catalog ACL = *all*
Pool ACL = *all*
Storage ACL = *all*
Client ACL = *all*
FileSet ACL = *all*
Where ACL = *all*
Plugin Options ACL = *all*
}
6) ran configure add console name=admin password=secret profile=webui-admin -
which suceeded
7) ran google-chrome at http://bareos-webui - and successfully logged in.
8) looked around and all but the restore tab seemed to be working right.
9) decided to reboot server and tried to log in to bareos-webui - this failed
10) end up creating admin2 using the bconsole configure as above and
successfully logged in on admin2 account but admin account still failed. On
reboot again, I could not log in to either account.
11) after some more reading and interperting decided to add the following to my
bareos-director.conf
Console {
Name = admin
Password = "secret"
profile = webui-admin
}
and restarted both apache2 and bareos-dir
I was then able to login to bareos-webui site on admin.
I then deleted the file /etc/bareos/bareos-dir.d/admin2.conf as being redundant
for my purposes
I have looked at the mysql.log which is attached and it looks clean to me but I
really do not know much about what is supposed to happen. Have attached incase
you do know.
in mysql_bareos.log lines 1-167 are the startup portions of webui and 168-194
are initial restore tab selection where the defaulted computer has no backups.
the 195 and beyond are what happens when I select one of the computers with
backup files associated.
I also ran /usr/sbin/bareos-dir -f -d 100 and watched the interrogations of
mysql from there with similar results to the mysql log attached.
not sure of any other places to look for issues.
any clues of where to look next?
I have also compared my bareos-dir.conf with the default and I seem to have all
of the configuration items there.
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.
/usr/sbin/mysqld, Version: 5.7.16-0ubuntu0.16.04.1-log ((Ubuntu)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
2017-01-08T15:58:29.467540Z 2 Connect root@localhost on using Socket
2017-01-08T15:58:29.467555Z 2 Connect Access denied for user
'root'@'localhost' (using password: NO)
2017-01-08T15:58:48.452067Z 3 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:48.452613Z 3 Query SELECT VersionId FROM Version
2017-01-08T15:58:48.457285Z 3 Query SET wait_timeout=691200
2017-01-08T15:58:48.457470Z 3 Query SET interactive_timeout=691200
2017-01-08T15:58:48.457765Z 3 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'R' AND
Job.SchedTime > '2017-01-07 10:58:48' ORDER BY StartTime
2017-01-08T15:58:48.555507Z 3 Quit
2017-01-08T15:58:48.595727Z 4 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:48.595848Z 4 Query SELECT VersionId FROM Version
2017-01-08T15:58:48.596027Z 4 Query SET wait_timeout=691200
2017-01-08T15:58:48.596068Z 4 Query SET interactive_timeout=691200
2017-01-08T15:58:48.596173Z 4 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'l' AND
Job.SchedTime > '2017-01-07 10:58:48' ORDER BY StartTime
2017-01-08T15:58:48.675504Z 4 Quit
2017-01-08T15:58:48.715728Z 5 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:48.715850Z 5 Query SELECT VersionId FROM Version
2017-01-08T15:58:48.716026Z 5 Query SET wait_timeout=691200
2017-01-08T15:58:48.716140Z 5 Query SET interactive_timeout=691200
2017-01-08T15:58:48.716250Z 5 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'F' AND
Job.SchedTime > '2017-01-07 10:58:48' ORDER BY StartTime
2017-01-08T15:58:48.795528Z 5 Quit
2017-01-08T15:58:48.835712Z 6 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:48.835835Z 6 Query SELECT VersionId FROM Version
2017-01-08T15:58:48.836012Z 6 Query SET wait_timeout=691200
2017-01-08T15:58:48.836053Z 6 Query SET interactive_timeout=691200
2017-01-08T15:58:48.836153Z 6 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'S' AND
Job.SchedTime > '2017-01-07 10:58:48' ORDER BY StartTime
2017-01-08T15:58:48.915504Z 6 Quit
2017-01-08T15:58:48.955739Z 7 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:48.955862Z 7 Query SELECT VersionId FROM Version
2017-01-08T15:58:48.956041Z 7 Query SET wait_timeout=691200
2017-01-08T15:58:48.956154Z 7 Query SET interactive_timeout=691200
2017-01-08T15:58:48.956263Z 7 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 's' AND
Job.SchedTime > '2017-01-07 10:58:48' ORDER BY StartTime
2017-01-08T15:58:49.035457Z 7 Quit
2017-01-08T15:58:49.075685Z 8 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.075807Z 8 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.075985Z 8 Query SET wait_timeout=691200
2017-01-08T15:58:49.076019Z 8 Query SET interactive_timeout=691200
2017-01-08T15:58:49.076122Z 8 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'm' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.155507Z 8 Quit
2017-01-08T15:58:49.195729Z 9 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.195850Z 9 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.196027Z 9 Query SET wait_timeout=691200
2017-01-08T15:58:49.196093Z 9 Query SET interactive_timeout=691200
2017-01-08T15:58:49.196184Z 9 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'M' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.275644Z 9 Quit
2017-01-08T15:58:49.315783Z 10 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.315929Z 10 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.316131Z 10 Query SET wait_timeout=691200
2017-01-08T15:58:49.316255Z 10 Query SET interactive_timeout=691200
2017-01-08T15:58:49.316390Z 10 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'j' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.395830Z 10 Quit
2017-01-08T15:58:49.435944Z 11 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.436122Z 11 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.436390Z 11 Query SET wait_timeout=691200
2017-01-08T15:58:49.436500Z 11 Query SET interactive_timeout=691200
2017-01-08T15:58:49.436663Z 11 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'c' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.515526Z 11 Quit
2017-01-08T15:58:49.555729Z 12 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.555852Z 12 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.556029Z 12 Query SET wait_timeout=691200
2017-01-08T15:58:49.556142Z 12 Query SET interactive_timeout=691200
2017-01-08T15:58:49.556252Z 12 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'C' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.635506Z 12 Quit
2017-01-08T15:58:49.675728Z 13 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.675850Z 13 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.676027Z 13 Query SET wait_timeout=691200
2017-01-08T15:58:49.676141Z 13 Query SET interactive_timeout=691200
2017-01-08T15:58:49.676250Z 13 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'd' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.755814Z 13 Quit
2017-01-08T15:58:49.796179Z 14 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.796451Z 14 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.796866Z 14 Query SET wait_timeout=691200
2017-01-08T15:58:49.797076Z 14 Query SET interactive_timeout=691200
2017-01-08T15:58:49.797419Z 14 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 't' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.875672Z 14 Quit
2017-01-08T15:58:49.915955Z 15 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:49.916164Z 15 Query SELECT VersionId FROM Version
2017-01-08T15:58:49.916452Z 15 Query SET wait_timeout=691200
2017-01-08T15:58:49.916582Z 15 Query SET interactive_timeout=691200
2017-01-08T15:58:49.916814Z 15 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'p' AND
Job.SchedTime > '2017-01-07 10:58:49' ORDER BY StartTime
2017-01-08T15:58:49.995507Z 15 Quit
2017-01-08T15:58:50.035732Z 16 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.035853Z 16 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.036029Z 16 Query SET wait_timeout=691200
2017-01-08T15:58:50.036089Z 16 Query SET interactive_timeout=691200
2017-01-08T15:58:50.036179Z 16 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'q' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.115506Z 16 Quit
2017-01-08T15:58:50.155728Z 17 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.155850Z 17 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.156028Z 17 Query SET wait_timeout=691200
2017-01-08T15:58:50.156141Z 17 Query SET interactive_timeout=691200
2017-01-08T15:58:50.156250Z 17 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'T' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.235767Z 17 Quit
2017-01-08T15:58:50.276041Z 18 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.276263Z 18 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.276602Z 18 Query SET wait_timeout=691200
2017-01-08T15:58:50.276685Z 18 Query SET interactive_timeout=691200
2017-01-08T15:58:50.276952Z 18 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'W' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.355818Z 18 Quit
2017-01-08T15:58:50.396058Z 19 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.396296Z 19 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.396609Z 19 Query SET wait_timeout=691200
2017-01-08T15:58:50.396788Z 19 Query SET interactive_timeout=691200
2017-01-08T15:58:50.397075Z 19 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'A' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.475817Z 19 Quit
2017-01-08T15:58:50.516177Z 20 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.516452Z 20 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.516816Z 20 Query SET wait_timeout=691200
2017-01-08T15:58:50.516991Z 20 Query SET interactive_timeout=691200
2017-01-08T15:58:50.517366Z 20 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'E' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.595666Z 20 Quit
2017-01-08T15:58:50.635890Z 21 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.636079Z 21 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.636315Z 21 Query SET wait_timeout=691200
2017-01-08T15:58:50.636447Z 21 Query SET interactive_timeout=691200
2017-01-08T15:58:50.636640Z 21 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'e' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.715898Z 21 Quit
2017-01-08T15:58:50.755943Z 22 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:50.756138Z 22 Query SELECT VersionId FROM Version
2017-01-08T15:58:50.756451Z 22 Query SET wait_timeout=691200
2017-01-08T15:58:50.756629Z 22 Query SET interactive_timeout=691200
2017-01-08T15:58:50.756894Z 22 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobStatus = 'f' AND
Job.SchedTime > '2017-01-07 10:58:50' ORDER BY StartTime
2017-01-08T15:58:50.795649Z 22 Quit
2017-01-08T15:58:51.367648Z 23 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:51.367771Z 23 Query SELECT VersionId FROM Version
2017-01-08T15:58:51.367928Z 23 Query SET wait_timeout=691200
2017-01-08T15:58:51.368042Z 23 Query SET interactive_timeout=691200
2017-01-08T15:58:51.368116Z 23 Query SELECT LogId, JobName,
ClientName, Time, LogText FROM (SELECT LogId, Job.Name AS JobName, Client.Name
As ClientName, Time, LogText FROM Log JOIN Job USING (JobId) LEFT JOIN Client
USING (ClientId) WHERE Job.Type != 'C' ORDER BY Log.LogId DESC LIMIT 50) AS
sub ORDER BY LogId ASC
2017-01-08T15:58:51.479161Z 23 Quit
2017-01-08T15:58:51.559694Z 24 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:58:51.559834Z 24 Query SELECT VersionId FROM Version
2017-01-08T15:58:51.559983Z 24 Query SET wait_timeout=691200
2017-01-08T15:58:51.560018Z 24 Query SET interactive_timeout=691200
2017-01-08T15:58:51.560126Z 24 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId INNER JOIN ( SELECT MAX(Job.JobId) as MaxJobId
FROM Job LEFT JOIN Client ON Client.ClientId=Job.ClientId LEFT JOIN Pool ON
Pool.PoolId=Job.PoolId LEFT JOIN JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN
Media ON JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 GROUP BY Job.Name )
LastJob ON Job.JobId = LastJob.MaxJobId ORDER BY StartTime
2017-01-08T15:58:51.715386Z 24 Quit
2017-01-08T15:59:09.311776Z 25 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:09.311938Z 25 Query SELECT VersionId FROM Version
2017-01-08T15:59:09.312101Z 25 Query SET wait_timeout=691200
2017-01-08T15:59:09.312185Z 25 Query SET interactive_timeout=691200
2017-01-08T15:59:09.312246Z 25 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client ORDER BY
ClientId
2017-01-08T15:59:09.391800Z 25 Quit
2017-01-08T15:59:09.432035Z 26 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:09.432184Z 26 Query SELECT VersionId FROM Version
2017-01-08T15:59:09.432510Z 26 Query SET wait_timeout=691200
2017-01-08T15:59:09.432692Z 26 Query SET interactive_timeout=691200
2017-01-08T15:59:09.433051Z 26 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.Type='B' AND
Client.Name='laptop-light-fd' AND JobStatus IN ('T','W') AND
(FileSet='Audiobook Set' OR FileSet='Catalog' OR FileSet='Full GreenOsprey Set'
OR FileSet='Static GreenOsprey Set' OR FileSet='Full HP11 Set' OR FileSet='Full
Laptop Set' OR FileSet='Full Nautilus Set' OR FileSet='pemdas Set' OR
FileSet='Photos Set' OR FileSet='Full Server Set' OR FileSet='Full Venus Set'
OR FileSet='Windows All Drives') ORDER BY StartTime DESC LIMIT 1
2017-01-08T15:59:09.511504Z 26 Quit
2017-01-08T15:59:09.551711Z 27 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:09.551834Z 27 Query SELECT VersionId FROM Version
2017-01-08T15:59:09.551991Z 27 Query SET wait_timeout=691200
2017-01-08T15:59:09.552106Z 27 Query SET interactive_timeout=691200
2017-01-08T15:59:09.552169Z 27 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 Job=''
2017-01-08T15:59:09.631506Z 27 Quit
2017-01-08T15:59:09.671734Z 28 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:09.671857Z 28 Query SELECT VersionId FROM Version
2017-01-08T15:59:09.672014Z 28 Query SET wait_timeout=691200
2017-01-08T15:59:09.672129Z 28 Query SET interactive_timeout=691200
2017-01-08T15:59:09.672266Z 28 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.Type='B' AND
Client.Name='laptop-light-fd' AND JobStatus IN ('T','W') AND
(FileSet='Audiobook Set' OR FileSet='Catalog' OR FileSet='Full GreenOsprey Set'
OR FileSet='Static GreenOsprey Set' OR FileSet='Full HP11 Set' OR FileSet='Full
Laptop Set' OR FileSet='Full Nautilus Set' OR FileSet='pemdas Set' OR
FileSet='Photos Set' OR FileSet='Full Server Set' OR FileSet='Full Venus Set'
OR FileSet='Windows All Drives') ORDER BY StartTime DESC
2017-01-08T15:59:09.751507Z 28 Quit
2017-01-08T15:59:09.791731Z 29 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:09.791853Z 29 Query SELECT VersionId FROM Version
2017-01-08T15:59:09.792011Z 29 Query SET wait_timeout=691200
2017-01-08T15:59:09.792125Z 29 Query SET interactive_timeout=691200
2017-01-08T15:59:09.792196Z 29 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client ORDER BY
ClientId
2017-01-08T15:59:09.871507Z 29 Quit
2017-01-08T15:59:30.340010Z 30 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:30.340251Z 30 Query SELECT VersionId FROM Version
2017-01-08T15:59:30.340566Z 30 Query SET wait_timeout=691200
2017-01-08T15:59:30.340657Z 30 Query SET interactive_timeout=691200
2017-01-08T15:59:30.341011Z 30 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.Type='B' AND
Client.Name='greenosprey-fd' AND JobStatus IN ('T','W') AND (FileSet='Audiobook
Set' OR FileSet='Catalog' OR FileSet='Full GreenOsprey Set' OR FileSet='Static
GreenOsprey Set' OR FileSet='Full HP11 Set' OR FileSet='Full Laptop Set' OR
FileSet='Full Nautilus Set' OR FileSet='pemdas Set' OR FileSet='Photos Set' OR
FileSet='Full Server Set' OR FileSet='Full Venus Set' OR FileSet='Windows All
Drives') ORDER BY StartTime DESC LIMIT 1
2017-01-08T15:59:30.419581Z 30 Quit
2017-01-08T15:59:30.459820Z 31 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:30.459927Z 31 Query SELECT VersionId FROM Version
2017-01-08T15:59:30.460088Z 31 Query SET wait_timeout=691200
2017-01-08T15:59:30.460137Z 31 Query SET interactive_timeout=691200
2017-01-08T15:59:30.460219Z 31 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=5983
2017-01-08T15:59:30.460441Z 31 Query SELECT MAX(FileSet.FileSetId)
FROM FileSet JOIN Job USING (FileSetId) WHERE Job.ClientId=12 GROUP BY FileSet
2017-01-08T15:59:30.462576Z 31 Query SELECT
FileSetId,FileSet,MD5,CreateTime FROM FileSet WHERE FileSetId=19
2017-01-08T15:59:30.462782Z 31 Query CREATE TABLE btemp30 AS SELECT
JobId, StartTime, EndTime, JobTDate, PurgedFiles FROM Job JOIN FileSet USING
(FileSetId) WHERE ClientId = 12 AND Level='F' AND JobStatus IN ('T','W') AND
Type='B' AND StartTime<'2017-01-07 23:05:03' AND FileSet.FileSet=(SELECT
FileSet FROM FileSet WHERE FileSetId = 19) ORDER BY Job.JobTDate DESC LIMIT 1
2017-01-08T15:59:30.692702Z 31 Query INSERT INTO btemp30 (JobId,
StartTime, EndTime, JobTDate, PurgedFiles) SELECT JobId, StartTime, EndTime,
JobTDate, PurgedFiles FROM Job JOIN FileSet USING (FileSetId) WHERE ClientId =
12 AND Level='D' AND JobStatus IN ('T','W') AND Type='B' AND StartTime >
(SELECT EndTime FROM btemp30 ORDER BY EndTime DESC LIMIT 1) AND StartTime <
'2017-01-07 23:05:03' AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE
FileSetId = 19) ORDER BY Job.JobTDate DESC LIMIT 1
2017-01-08T15:59:30.694365Z 31 Query INSERT INTO btemp30 (JobId,
StartTime, EndTime, JobTDate, PurgedFiles) SELECT JobId, StartTime, EndTime,
JobTDate, PurgedFiles FROM Job JOIN FileSet USING (FileSetId) WHERE ClientId =
12 AND Level='I' AND JobStatus IN ('T','W') AND Type='B' AND StartTime >
(SELECT EndTime FROM btemp30 ORDER BY EndTime DESC LIMIT 1) AND StartTime <
'2017-01-07 23:05:03' AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE
FileSetId = 19) ORDER BY Job.JobTDate DESC
2017-01-08T15:59:30.717575Z 31 Query SELECT JobId FROM btemp30 ORDER
by JobTDate
2017-01-08T15:59:30.717679Z 31 Query DROP TABLE btemp30
2017-01-08T15:59:30.868248Z 31 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=5958
2017-01-08T15:59:30.868493Z 31 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:30.868592Z 31 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=5969
2017-01-08T15:59:30.868678Z 31 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:30.868755Z 31 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=5976
2017-01-08T15:59:30.868848Z 31 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:30.868911Z 31 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=5983
2017-01-08T15:59:30.868985Z 31 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:30.907469Z 31 Quit
2017-01-08T15:59:30.947686Z 32 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:30.947810Z 32 Query SELECT VersionId FROM Version
2017-01-08T15:59:30.947967Z 32 Query SET wait_timeout=691200
2017-01-08T15:59:30.948001Z 32 Query SET interactive_timeout=691200
2017-01-08T15:59:30.948127Z 32 Query SELECT DISTINCT Job.JobId,
Job.Job, Job.Name, Job.PurgedFiles, Job.Type, Job.Level, Job.ClientId,
Client.Name as Client, Job.JobStatus, Job.SchedTime, Job.StartTime,
Job.EndTime, Job.RealEndTime, Job.JobTDate, Job.VolSessionId,
Job.VolSessionTime, Job.JobFiles, Job.JobBytes, Job.JobErrors,
Job.JobMissingFiles, Job.PoolId, Pool.Name as PoolName, Job.PriorJobId,
Job.FileSetId, FileSet.FileSet FROM Job LEFT JOIN Client ON
Client.ClientId=Job.ClientId LEFT JOIN Pool ON Pool.PoolId=Job.PoolId LEFT JOIN
JobMedia ON JobMedia.JobId=Job.JobId LEFT JOIN Media ON
JobMedia.MediaId=Media.MediaId LEFT JOIN FileSet ON
FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0 AND Job.Type='B' AND
Client.Name='greenosprey-fd' AND JobStatus IN ('T','W') AND (FileSet='Audiobook
Set' OR FileSet='Catalog' OR FileSet='Full GreenOsprey Set' OR FileSet='Static
GreenOsprey Set' OR FileSet='Full HP11 Set' OR FileSet='Full Laptop Set' OR
FileSet='Full Nautilus Set' OR FileSet='pemdas Set' OR FileSet='Photos Set' OR
FileSet='Full Server Set' OR FileSet='Full Venus Set' OR FileSet='Windows All
Drives') ORDER BY StartTime DESC
2017-01-08T15:59:31.031470Z 32 Quit
2017-01-08T15:59:31.071862Z 33 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:31.071984Z 33 Query SELECT VersionId FROM Version
2017-01-08T15:59:31.072143Z 33 Query SET wait_timeout=691200
2017-01-08T15:59:31.072176Z 33 Query SET interactive_timeout=691200
2017-01-08T15:59:31.072218Z 33 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client ORDER BY
ClientId
2017-01-08T15:59:31.151823Z 33 Quit
2017-01-08T15:59:31.991694Z 34 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:31.991766Z 34 Query SELECT VersionId FROM Version
2017-01-08T15:59:31.991883Z 34 Query SET wait_timeout=691200
2017-01-08T15:59:31.991913Z 34 Query SET interactive_timeout=691200
2017-01-08T15:59:31.991963Z 34 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=5983
2017-01-08T15:59:31.992098Z 34 Query SELECT MAX(FileSet.FileSetId)
FROM FileSet JOIN Job USING (FileSetId) WHERE Job.ClientId=12 GROUP BY FileSet
2017-01-08T15:59:31.993322Z 34 Query SELECT
FileSetId,FileSet,MD5,CreateTime FROM FileSet WHERE FileSetId=19
2017-01-08T15:59:31.993458Z 34 Query CREATE TABLE btemp30 AS SELECT
JobId, StartTime, EndTime, JobTDate, PurgedFiles FROM Job JOIN FileSet USING
(FileSetId) WHERE ClientId = 12 AND Level='F' AND JobStatus IN ('T','W') AND
Type='B' AND StartTime<'2017-01-07 23:05:03' AND FileSet.FileSet=(SELECT
FileSet FROM FileSet WHERE FileSetId = 19) ORDER BY Job.JobTDate DESC LIMIT 1
2017-01-08T15:59:32.202902Z 34 Query INSERT INTO btemp30 (JobId,
StartTime, EndTime, JobTDate, PurgedFiles) SELECT JobId, StartTime, EndTime,
JobTDate, PurgedFiles FROM Job JOIN FileSet USING (FileSetId) WHERE ClientId =
12 AND Level='D' AND JobStatus IN ('T','W') AND Type='B' AND StartTime >
(SELECT EndTime FROM btemp30 ORDER BY EndTime DESC LIMIT 1) AND StartTime <
'2017-01-07 23:05:03' AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE
FileSetId = 19) ORDER BY Job.JobTDate DESC LIMIT 1
2017-01-08T15:59:32.205129Z 34 Query INSERT INTO btemp30 (JobId,
StartTime, EndTime, JobTDate, PurgedFiles) SELECT JobId, StartTime, EndTime,
JobTDate, PurgedFiles FROM Job JOIN FileSet USING (FileSetId) WHERE ClientId =
12 AND Level='I' AND JobStatus IN ('T','W') AND Type='B' AND StartTime >
(SELECT EndTime FROM btemp30 ORDER BY EndTime DESC LIMIT 1) AND StartTime <
'2017-01-07 23:05:03' AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE
FileSetId = 19) ORDER BY Job.JobTDate DESC
2017-01-08T15:59:32.227660Z 34 Query SELECT JobId FROM btemp30 ORDER
by JobTDate
2017-01-08T15:59:32.227758Z 34 Query DROP TABLE btemp30
2017-01-08T15:59:32.386644Z 34 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=5958
2017-01-08T15:59:32.386833Z 34 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.386937Z 34 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=5969
2017-01-08T15:59:32.387038Z 34 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.387104Z 34 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=5976
2017-01-08T15:59:32.387179Z 34 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.387252Z 34 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=5983
2017-01-08T15:59:32.387333Z 34 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.427465Z 34 Quit
2017-01-08T15:59:32.467724Z 35 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:32.467845Z 35 Query SELECT VersionId FROM Version
2017-01-08T15:59:32.468010Z 35 Query SET wait_timeout=691200
2017-01-08T15:59:32.468102Z 35 Query SET interactive_timeout=691200
2017-01-08T15:59:32.470392Z 35 Query SELECT 1 FROM Job WHERE JobId =
5958 AND HasCache=1
2017-01-08T15:59:32.470560Z 35 Query SELECT 1 FROM Job WHERE JobId =
5969 AND HasCache=1
2017-01-08T15:59:32.470613Z 35 Query SELECT 1 FROM Job WHERE JobId =
5976 AND HasCache=1
2017-01-08T15:59:32.470660Z 35 Query SELECT 1 FROM Job WHERE JobId =
5983 AND HasCache=1
2017-01-08T15:59:32.507552Z 35 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=5958
2017-01-08T15:59:32.507757Z 35 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.507843Z 35 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=5969
2017-01-08T15:59:32.507959Z 35 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.508113Z 35 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=5976
2017-01-08T15:59:32.508274Z 35 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.508367Z 35 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=5983
2017-01-08T15:59:32.508480Z 35 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:32.508554Z 35 Query SELECT PathId FROM Path WHERE
Path=''
2017-01-08T15:59:32.531467Z 35 Query SELECT FilenameId FROM Filename
WHERE Name = ''
2017-01-08T15:59:32.671146Z 35 Query SELECT 'D', tmp.PathId, 0,
tmp.Path, JobId, LStat, FileId FROM (SELECT PPathId AS PathId, '..' AS Path
FROM PathHierarchy WHERE PathId = 0 UNION SELECT 0 AS PathId, '.' AS Path) AS
tmp LEFT JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId,
File1.LStat AS LStat, File1.FileId AS FileId FROM File AS File1 WHERE
File1.FilenameId = 5 AND File1.JobId IN (5958,5969,5976,5983)) AS listfile1 ON
(tmp.PathId = listfile1.PathId) ORDER BY tmp.Path, JobId DESC
2017-01-08T15:59:33.890725Z 35 Query SELECT 'D', PathId, 0, Path,
JobId, LStat, FileId FROM ( SELECT Path1.PathId AS PathId, Path1.Path AS Path,
lower(Path1.Path) AS lpath, listfile1.JobId AS JobId, listfile1.LStat AS LStat,
listfile1.FileId AS FileId FROM ( SELECT DISTINCT PathHierarchy1.PathId AS
PathId FROM PathHierarchy AS PathHierarchy1 JOIN Path AS Path2 ON
(PathHierarchy1.PathId = Path2.PathId) JOIN PathVisibility AS PathVisibility1
ON (PathHierarchy1.PathId = PathVisibility1.PathId) WHERE
PathHierarchy1.PPathId = 0 AND PathVisibility1.JobId IN (5958,5969,5976,5983)
) AS listpath1 JOIN Path AS Path1 ON (listpath1.PathId = Path1.PathId) LEFT
JOIN ( SELECT File1.PathId AS PathId, File1.JobId AS JobId, File1.LStat AS
LStat, File1.FileId AS FileId FROM File AS File1 WHERE File1.FilenameId = 5 AND
File1.JobId IN (5958,5969,5976,5983)) AS listfile1 ON (listpath1.PathId =
listfile1.PathId) ) AS A ORDER BY 2,3 DESC LIMIT 2000 OFFSET 0
2017-01-08T15:59:33.935501Z 35 Quit
2017-01-08T15:59:33.975727Z 36 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:33.975848Z 36 Query SELECT VersionId FROM Version
2017-01-08T15:59:33.976004Z 36 Query SET wait_timeout=691200
2017-01-08T15:59:33.976095Z 36 Query SET interactive_timeout=691200
2017-01-08T15:59:33.976156Z 36 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=5983
2017-01-08T15:59:33.976308Z 36 Query SELECT MAX(FileSet.FileSetId)
FROM FileSet JOIN Job USING (FileSetId) WHERE Job.ClientId=12 GROUP BY FileSet
2017-01-08T15:59:33.977658Z 36 Query SELECT
FileSetId,FileSet,MD5,CreateTime FROM FileSet WHERE FileSetId=19
2017-01-08T15:59:33.977770Z 36 Query CREATE TABLE btemp30 AS SELECT
JobId, StartTime, EndTime, JobTDate, PurgedFiles FROM Job JOIN FileSet USING
(FileSetId) WHERE ClientId = 12 AND Level='F' AND JobStatus IN ('T','W') AND
Type='B' AND StartTime<'2017-01-07 23:05:03' AND FileSet.FileSet=(SELECT
FileSet FROM FileSet WHERE FileSetId = 19) ORDER BY Job.JobTDate DESC LIMIT 1
2017-01-08T15:59:34.213172Z 36 Query INSERT INTO btemp30 (JobId,
StartTime, EndTime, JobTDate, PurgedFiles) SELECT JobId, StartTime, EndTime,
JobTDate, PurgedFiles FROM Job JOIN FileSet USING (FileSetId) WHERE ClientId =
12 AND Level='D' AND JobStatus IN ('T','W') AND Type='B' AND StartTime >
(SELECT EndTime FROM btemp30 ORDER BY EndTime DESC LIMIT 1) AND StartTime <
'2017-01-07 23:05:03' AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE
FileSetId = 19) ORDER BY Job.JobTDate DESC LIMIT 1
2017-01-08T15:59:34.214890Z 36 Query INSERT INTO btemp30 (JobId,
StartTime, EndTime, JobTDate, PurgedFiles) SELECT JobId, StartTime, EndTime,
JobTDate, PurgedFiles FROM Job JOIN FileSet USING (FileSetId) WHERE ClientId =
12 AND Level='I' AND JobStatus IN ('T','W') AND Type='B' AND StartTime >
(SELECT EndTime FROM btemp30 ORDER BY EndTime DESC LIMIT 1) AND StartTime <
'2017-01-07 23:05:03' AND FileSet.FileSet= (SELECT FileSet FROM FileSet WHERE
FileSetId = 19) ORDER BY Job.JobTDate DESC
2017-01-08T15:59:34.238039Z 36 Query SELECT JobId FROM btemp30 ORDER
by JobTDate
2017-01-08T15:59:34.238146Z 36 Query DROP TABLE btemp30
2017-01-08T15:59:34.372020Z 36 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=5958
2017-01-08T15:59:34.372219Z 36 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.372305Z 36 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=5969
2017-01-08T15:59:34.372412Z 36 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.372545Z 36 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=5976
2017-01-08T15:59:34.372664Z 36 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.372754Z 36 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=5983
2017-01-08T15:59:34.372856Z 36 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.411502Z 36 Quit
2017-01-08T15:59:34.451725Z 37 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:34.451847Z 37 Query SELECT VersionId FROM Version
2017-01-08T15:59:34.452004Z 37 Query SET wait_timeout=691200
2017-01-08T15:59:34.452112Z 37 Query SET interactive_timeout=691200
2017-01-08T15:59:34.472945Z 37 Query SELECT 1 FROM Job WHERE JobId =
5958 AND HasCache=1
2017-01-08T15:59:34.473117Z 37 Query SELECT 1 FROM Job WHERE JobId =
5969 AND HasCache=1
2017-01-08T15:59:34.473199Z 37 Query SELECT 1 FROM Job WHERE JobId =
5976 AND HasCache=1
2017-01-08T15:59:34.473301Z 37 Query SELECT 1 FROM Job WHERE JobId =
5983 AND HasCache=1
2017-01-08T15:59:34.491440Z 37 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=5958
2017-01-08T15:59:34.491631Z 37 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.491791Z 37 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=5969
2017-01-08T15:59:34.491936Z 37 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.492020Z 37 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=5976
2017-01-08T15:59:34.492140Z 37 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.492222Z 37 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=5983
2017-01-08T15:59:34.492309Z 37 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.492370Z 37 Query SELECT PathId FROM Path WHERE
Path=''
2017-01-08T15:59:34.492524Z 37 Query SELECT PathId FROM Path WHERE
Path=''
2017-01-08T15:59:34.492682Z 37 Query SELECT 'F', T1.PathId,
T1.FilenameId, Filename.Name, File.JobId, File.LStat, File.FileId FROM Job,
File, ( SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId FROM ( SELECT
JobTDate, PathId, FilenameId FROM File JOIN Job USING (JobId) WHERE File.JobId
IN (5958,5969,5976,5983) AND PathId = 0 UNION ALL SELECT JobTDate, PathId,
FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job ON (BaseJobId =
Job.JobId) WHERE BaseFiles.JobId IN (5958,5969,5976,5983) AND PathId = 0 ) AS
tmp GROUP BY PathId, FilenameId LIMIT 2000 OFFSET 0) AS T1 JOIN Filename USING
(FilenameId) WHERE T1.JobTDate = Job.JobTDate AND Job.JobId = File.JobId AND
T1.PathId = File.PathId AND T1.FilenameId = File.FilenameId AND Filename.Name
!= '' AND File.FileIndex > 0 AND (Job.JobId IN ( SELECT DISTINCT BaseJobId
FROM BaseFiles WHERE JobId IN (5958,5969,5976,5983)) OR Job.JobId IN
(5958,5969,5976,5983))
2017-01-08T15:59:34.571506Z 37 Quit
2017-01-08T15:59:34.611729Z 38 Connect bareos@localhost on bareos
using Socket
2017-01-08T15:59:34.611850Z 38 Query SELECT VersionId FROM Version
2017-01-08T15:59:34.612007Z 38 Query SET wait_timeout=691200
2017-01-08T15:59:34.612073Z 38 Query SET interactive_timeout=691200
2017-01-08T15:59:34.614576Z 38 Query SELECT 1 FROM Job WHERE JobId =
5958 AND HasCache=1
2017-01-08T15:59:34.614790Z 38 Query SELECT 1 FROM Job WHERE JobId =
5969 AND HasCache=1
2017-01-08T15:59:34.614846Z 38 Query SELECT 1 FROM Job WHERE JobId =
5976 AND HasCache=1
2017-01-08T15:59:34.614894Z 38 Query SELECT 1 FROM Job WHERE JobId =
5983 AND HasCache=1
2017-01-08T15:59:34.651548Z 38 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=5958
2017-01-08T15:59:34.651800Z 38 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.651968Z 38 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=5969
2017-01-08T15:59:34.652132Z 38 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.652224Z 38 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=5976
2017-01-08T15:59:34.652338Z 38 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.652417Z 38 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=5983
2017-01-08T15:59:34.652506Z 38 Query SELECT
ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE
Client.ClientId=12
2017-01-08T15:59:34.652568Z 38 Query SELECT PathId FROM Path WHERE
Path='@'
2017-01-08T15:59:34.652714Z 38 Query SELECT PathId FROM Path WHERE
Path='\0'
2017-01-08T15:59:34.652869Z 38 Query SELECT 'F', T1.PathId,
T1.FilenameId, Filename.Name, File.JobId, File.LStat, File.FileId FROM Job,
File, ( SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId FROM ( SELECT
JobTDate, PathId, FilenameId FROM File JOIN Job USING (JobId) WHERE File.JobId
IN (5958,5969,5976,5983) AND PathId = 0 UNION ALL SELECT JobTDate, PathId,
FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job ON (BaseJobId =
Job.JobId) WHERE BaseFiles.JobId IN (5958,5969,5976,5983) AND PathId = 0 ) AS
tmp GROUP BY PathId, FilenameId LIMIT 2000 OFFSET 0) AS T1 JOIN Filename USING
(FilenameId) WHERE T1.JobTDate = Job.JobTDate AND Job.JobId = File.JobId AND
T1.PathId = File.PathId AND T1.FilenameId = File.FilenameId AND Filename.Name
!= '' AND File.FileIndex > 0 AND (Job.JobId IN ( SELECT DISTINCT BaseJobId
FROM BaseFiles WHERE JobId IN (5958,5969,5976,5983)) OR Job.JobId IN
(5958,5969,5976,5983))
2017-01-08T15:59:34.691503Z 38 Quit
