windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.41_17 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <952295004.1507075901@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK qO8kEPR+aPXVd1b/wnhUlA windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <9414293682.1507075901@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: k//nW4+Bhg5Qg5/Fw4+oyD windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline list jobtotals windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56e400e490 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: list jobtotals windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,Name AS Job FROM Job GROUP BY Name windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT COUNT(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) As Bytes FROM Job windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56e400e490 windwalker-dir (100): mysql.c:258-0 close db=7f56e400e490 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.41_18 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <261318648.1507075901@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK PgMP1mIgOwSeAuRnmmAVsQ windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <7793676693.1507075901@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: 0Sw3KQgkkRUxDW9inG4m3A windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs last current enabled windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56f0001d90 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs last current enabled windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long_last (9) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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; windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Windwalker_Excluded_Files, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Taffy_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Sonny_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_MuadDib_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Samson_Weekly, suppress output windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56f0001d90 windwalker-dir (100): mysql.c:258-0 close db=7f56f0001d90 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (10): ua_audit.c:143-0 : Console [windwalker-mon] from [192.168.9.1] cmdline status dir windwalker-dir (20): ua_status.c:154-0 status:status dir: windwalker-dir (200): ua_status.c:889-0 enter list_sched_jobs() windwalker-dir (200): ua_output.c:1444-0 now=1507075902 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075902 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075902 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075902 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075902 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075902 runtime=1507079400 windwalker-dir (200): ua_output.c:1446-0 Found it level=70 F windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Main_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=5 windwalker-dir (50): next_vol.c:71-0 find_next_vol_for_append: JobId=0 PoolId=5, MediaType=Vchanger_8TB_50GB_Volumes windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name sql_media_order_most_recently_written (44) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId windwalker-dir (100): sql_find.c:414-0 fnextvol=SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (40): sql_find.c:512-0 Rtn numrows=1 windwalker-dir (50): next_vol.c:190-0 VolJobs=3 FirstWritten=1504329214 windwalker-dir (50): next_vol.c:285-0 Vol=vchanger_8tb_drives_0011_0132 expired=0 windwalker-dir (50): next_vol.c:208-0 return ok=1 find_next_vol windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Main_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=5 windwalker-dir (50): next_vol.c:71-0 find_next_vol_for_append: JobId=0 PoolId=5, MediaType=Vchanger_8TB_50GB_Volumes windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name sql_media_order_most_recently_written (44) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId windwalker-dir (100): sql_find.c:414-0 fnextvol=SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (40): sql_find.c:512-0 Rtn numrows=1 windwalker-dir (50): next_vol.c:190-0 VolJobs=3 FirstWritten=1504329214 windwalker-dir (50): next_vol.c:285-0 Vol=vchanger_8tb_drives_0011_0132 expired=0 windwalker-dir (50): next_vol.c:208-0 return ok=1 find_next_vol windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Main_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=5 windwalker-dir (50): next_vol.c:71-0 find_next_vol_for_append: JobId=0 PoolId=5, MediaType=Vchanger_8TB_50GB_Volumes windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name sql_media_order_most_recently_written (44) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId windwalker-dir (100): sql_find.c:414-0 fnextvol=SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (40): sql_find.c:512-0 Rtn numrows=1 windwalker-dir (50): next_vol.c:190-0 VolJobs=3 FirstWritten=1504329214 windwalker-dir (50): next_vol.c:285-0 Vol=vchanger_8tb_drives_0011_0132 expired=0 windwalker-dir (50): next_vol.c:208-0 return ok=1 find_next_vol windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Main_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=5 windwalker-dir (50): next_vol.c:71-0 find_next_vol_for_append: JobId=0 PoolId=5, MediaType=Vchanger_8TB_50GB_Volumes windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name sql_media_order_most_recently_written (44) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId windwalker-dir (100): sql_find.c:414-0 fnextvol=SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (40): sql_find.c:512-0 Rtn numrows=1 windwalker-dir (50): next_vol.c:190-0 VolJobs=3 FirstWritten=1504329214 windwalker-dir (50): next_vol.c:285-0 Vol=vchanger_8tb_drives_0011_0132 expired=0 windwalker-dir (50): next_vol.c:208-0 return ok=1 find_next_vol windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Main_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=5 windwalker-dir (50): next_vol.c:71-0 find_next_vol_for_append: JobId=0 PoolId=5, MediaType=Vchanger_8TB_50GB_Volumes windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name sql_media_order_most_recently_written (44) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId windwalker-dir (100): sql_find.c:414-0 fnextvol=SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (40): sql_find.c:512-0 Rtn numrows=1 windwalker-dir (50): next_vol.c:190-0 VolJobs=3 FirstWritten=1504329214 windwalker-dir (50): next_vol.c:285-0 Vol=vchanger_8tb_drives_0011_0132 expired=0 windwalker-dir (50): next_vol.c:208-0 return ok=1 find_next_vol windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Main_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=5 windwalker-dir (50): next_vol.c:71-0 find_next_vol_for_append: JobId=0 PoolId=5, MediaType=Vchanger_8TB_50GB_Volumes windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name sql_media_order_most_recently_written (44) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId windwalker-dir (100): sql_find.c:414-0 fnextvol=SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE PoolId=5 AND MediaType='Vchanger_8TB_50GB_Volumes' AND Enabled=1 AND VolStatus='Append' AND InChanger=1 AND StorageId=2 ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId LIMIT 1 windwalker-dir (40): sql_find.c:512-0 Rtn numrows=1 windwalker-dir (50): next_vol.c:190-0 VolJobs=3 FirstWritten=1504329214 windwalker-dir (50): next_vol.c:285-0 Vol=vchanger_8tb_drives_0011_0132 expired=0 windwalker-dir (50): next_vol.c:208-0 return ok=1 find_next_vol windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (200): ua_status.c:946-0 Leave list_sched_jobs_runs() windwalker-dir (200): ua_status.c:959-0 enter list_run_jobs() windwalker-dir (200): ua_status.c:979-0 leave list_run_jobs() windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.45_19 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1337011203.1507075905@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK qk8gGFHbcllakKDZBo+Y3g windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <4096861354.1507075905@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: iA/ZMQ/j66+D8icej+/DNB windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=R jobname="" limit=1000 offset=0 windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56f0001d90 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=R jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56f0001d90 windwalker-dir (100): mysql.c:258-0 close db=7f56f0001d90 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.47_20 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1540222983.1507075907@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK yuIytxf5fj3FlpnUGZFW8g windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <7900052394.1507075907@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: 1k+Eb58glScp1UIDd9df2A windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=F days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56e4014410 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=F days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=S days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=S days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=s days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=s days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=m days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=m days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=M days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=M days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:47' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=j days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=j days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=c days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=c days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=C days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=C days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=d days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=d days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=t days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=t days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=p days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=p days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=q days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=q days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=R days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=R days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=l days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=l days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=1000 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=1000 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 1000; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:48' ORDER BY StartTime LIMIT 1000 OFFSET 1000; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=W days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=W days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=A days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=A days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=E days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=E days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=e days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=e days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=f days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=f days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:11:49' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56e4014410 windwalker-dir (100): mysql.c:258-0 close db=7f56e4014410 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.49_21 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1538766642.1507075909@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK o+Afthe5dfXK+rVT2rBIeA windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <6156287101.1507075909@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: Li+nSV5klU/GsRNcv2+1tB windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline list jobtotals windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56f0004600 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: list jobtotals windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,Name AS Job FROM Job GROUP BY Name windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT COUNT(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) As Bytes FROM Job windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56f0004600 windwalker-dir (100): mysql.c:258-0 close db=7f56f0004600 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.51_22 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <489429837.1507075911@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK 7Pr7LnVU3u7MCN6erPyTAA windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <9828598621.1507075911@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: bCFp6BxAdk9UX6BWWC/RrC windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs last current enabled windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56f0004600 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs last current enabled windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long_last (9) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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; windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Windwalker_Excluded_Files, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Taffy_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Sonny_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_MuadDib_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Samson_Weekly, suppress output windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56f0004600 windwalker-dir (100): mysql.c:258-0 close db=7f56f0004600 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello *UserAgent* calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.52_23 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1226057135.1507075912@windwalker-dir> ssl=0 windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <1141072631.1507075912@bconsole> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: D/0Kq9+n1h51BH+Ld8NNUA windwalker-dir (10): ua_audit.c:143-0 : Console [default] from [192.168.9.1] cmdline update slots storage=vchanger_monthly_1.5tb windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (100): ua_select.c:1166-0 get_storage_resource: autochangers_only is 1 windwalker-dir (50): storage.c:182-0 wstore=vchanger_monthly_1.5tb where=command line windwalker-dir (100): ua_update.c:1114-0 max_slots=26 windwalker-dir (100): ua_select.c:1811-0 Slots turned on: windwalker-dir (100): ua_select.c:1814-0 1 windwalker-dir (100): ua_select.c:1814-0 2 windwalker-dir (100): ua_select.c:1814-0 3 windwalker-dir (100): ua_select.c:1814-0 4 windwalker-dir (100): ua_select.c:1814-0 5 windwalker-dir (100): ua_select.c:1814-0 6 windwalker-dir (100): ua_select.c:1814-0 7 windwalker-dir (100): ua_select.c:1814-0 8 windwalker-dir (100): ua_select.c:1814-0 9 windwalker-dir (100): ua_select.c:1814-0 10 windwalker-dir (100): ua_select.c:1814-0 11 windwalker-dir (100): ua_select.c:1814-0 12 windwalker-dir (100): ua_select.c:1814-0 13 windwalker-dir (100): ua_select.c:1814-0 14 windwalker-dir (100): ua_select.c:1814-0 15 windwalker-dir (100): ua_select.c:1814-0 16 windwalker-dir (100): ua_select.c:1814-0 17 windwalker-dir (100): ua_select.c:1814-0 18 windwalker-dir (100): ua_select.c:1814-0 19 windwalker-dir (100): ua_select.c:1814-0 20 windwalker-dir (100): ua_select.c:1814-0 21 windwalker-dir (100): ua_select.c:1814-0 22 windwalker-dir (100): ua_select.c:1814-0 23 windwalker-dir (100): ua_select.c:1814-0 24 windwalker-dir (100): ua_select.c:1814-0 25 windwalker-dir (100): ua_select.c:1814-0 26 windwalker-dir (100): storage.c:602-0 Freeing volume list windwalker-dir (100): sd_cmds.c:115-0 bnet_connect to Storage daemon windwalker:9103 windwalker-dir (100): bsock.c:70-0 All source addresses windwalker-dir (100): bsock_tcp.c:230-0 Current host[ipv4;192.168.9.1;9103] All host[ipv4;192.168.9.1;9103] windwalker-dir (100): bsock_tcp.c:153-0 who=Storage daemon host=windwalker port=9103 windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <350718977.1507075912@windwalker-sd> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: ph/OxzIBf6+PbwVSKG+9JD windwalker-dir (50): cram-md5.c:75-0 send: auth cram-md5 <1826404168.1507075912@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK WAVrXT/wO5+kz7/Gn5+a5B windwalker-dir (116): authenticate.c:98-0 >stored: 1000 OK auth windwalker-dir (110): authenticate.c:105-0 ssl=0 windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <594708088.1507075912@bconsole> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: B+4uD9lvI+8YTW+/P5A2zA windwalker-dir (10): ua_audit.c:143-0 : Console [default] from [192.168.9.1] cmdline update volume=vchanger_monthly_1.5tb_drives_0001_0001 ActionOnPurge=Truncate windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE VolumeName='vchanger_monthly_1.5tb_drives_0001_0001' windwalker-dir (100): sql_update.c:320-0 update_media: FirstWritten=1493646908 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query UPDATE Media Set LastWritten='2017-07-31 19:42:15' WHERE VolumeName='vchanger_monthly_1.5tb_drives_0001_0001' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query UPDATE Media SET VolJobs=1,VolFiles=12,VolBlocks=832203,VolBytes=53687079247,VolMounts=1,VolErrors=0,VolWrites=832204,MaxVolBytes=53687091200,VolStatus='Append',Slot=1,InChanger=1,VolReadTime=0,VolWriteTime=583967158,LabelType=0,StorageId=3,PoolId=6,VolRetention=7344000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,Enabled=1,LocationId=0,ScratchPoolId=0,RecyclePoolId=0,RecycleCount=0,Recycle=1,ActionOnPurge=1,MinBlocksize=0,MaxBlocksize=0 WHERE VolumeName='vchanger_monthly_1.5tb_drives_0001_0001' windwalker-dir (100): sql_update.c:481-0 UPDATE Media SET InChanger=0, Slot=0 WHERE Slot=1 AND StorageId=3 AND MediaId!=3487 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query UPDATE Media SET InChanger=0, Slot=0 WHERE Slot=1 AND StorageId=3 AND MediaId!=3487 windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello *UserAgent* calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.52_25 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1294463323.1507075912@windwalker-dir> ssl=0 windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <912967127.1507075912@bconsole> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: u//YGk/QRk+Re6AAP5IjZC windwalker-dir (10): ua_audit.c:143-0 : Console [default] from [192.168.9.1] cmdline purge volume=vchanger_monthly_1.5tb_drives_0001_0001 action=truncate storage=vchanger_monthly_1.5tb pool=Off-site_Pool windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f5710847270 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime,ActionOnPurge,EncryptionKey,MinBlocksize,MaxBlocksize FROM Media WHERE VolumeName='vchanger_monthly_1.5tb_drives_0001_0001' windwalker-dir (100): sql_query.c:140-0 called: bool B_DB::sql_query(const char*, int (*)(void*, int, char**), void*) with query SELECT 1 FROM JobMedia WHERE MediaId=3487 LIMIT 1 windwalker-dir (100): sql_update.c:320-0 update_media: FirstWritten=1493646908 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query UPDATE Media Set LastWritten='2017-07-31 19:42:15' WHERE VolumeName='vchanger_monthly_1.5tb_drives_0001_0001' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query UPDATE Media SET VolJobs=1,VolFiles=12,VolBlocks=832203,VolBytes=53687079247,VolMounts=1,VolErrors=0,VolWrites=832204,MaxVolBytes=53687091200,VolStatus='Purged',Slot=1,InChanger=1,VolReadTime=0,VolWriteTime=583967158,LabelType=0,StorageId=3,PoolId=6,VolRetention=7344000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,Enabled=1,LocationId=0,ScratchPoolId=0,RecyclePoolId=0,RecycleCount=0,Recycle=1,ActionOnPurge=1,MinBlocksize=0,MaxBlocksize=0 WHERE VolumeName='vchanger_monthly_1.5tb_drives_0001_0001' windwalker-dir (100): sql_update.c:481-0 UPDATE Media SET InChanger=0, Slot=0 WHERE Slot=1 AND StorageId=3 AND MediaId!=3487 windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query UPDATE Media SET InChanger=0, Slot=0 WHERE Slot=1 AND StorageId=3 AND MediaId!=3487 windwalker-dir (150): dir_plugins.c:211-0 No bplugin_list: generate_plugin_event ignored. windwalker-dir (100): ua_select.c:1166-0 get_storage_resource: autochangers_only is 0 windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat,RecyclePoolId,ScratchPoolId,ActionOnPurge,MinBlocksize,MaxBlocksize FROM Pool WHERE Pool.Name='Off-site_Pool' windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) from Media WHERE PoolId=6 windwalker-dir (100): sql_get.c:973-0 query=SELECT DISTINCT MediaId FROM Media WHERE Recycle=1 AND Enabled=1 AND StorageId=3 AND PoolId=6 AND VolBytes > 10000 AND VolStatus = 'Purged' windwalker-dir (100): mysql.c:251-0 closedb ref=1 connected=1 db=7f573c002ae0 windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f5710847270 windwalker-dir (100): mysql.c:258-0 close db=7f5710847270 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello *UserAgent* calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.11.52_26 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1206305343.1507075912@windwalker-dir> ssl=0 windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <821173938.1507075912@bconsole> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: V/Yh8i+5zg/sj//wM9EU7C windwalker-dir (10): ua_audit.c:143-0 : Console [default] from [192.168.9.1] cmdline update volume=vchanger_monthly_1.5tb_drives_0001_0001 volstatus=Append storage=vchanger_monthly_1.5tb pool=Off-site_Pool windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (10): ua_audit.c:143-0 : Console [windwalker-mon] from [192.168.9.1] cmdline status dir windwalker-dir (20): ua_status.c:154-0 status:status dir: windwalker-dir (200): ua_status.c:889-0 enter list_sched_jobs() windwalker-dir (200): ua_output.c:1444-0 now=1507075912 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075912 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075912 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075912 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075912 runtime=1507078800 windwalker-dir (200): ua_output.c:1446-0 Found it level=73 I windwalker-dir (200): ua_output.c:1444-0 now=1507075912 runtime=1507079400 windwalker-dir (200): ua_output.c:1446-0 Found it level=70 F windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): ua_output.c:1476-0 complete_jcr open db windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:857-0 DB REopen bareos windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.12.29_27 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <425516426.1507075949@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK faV21zEl31O/nlfj2c5geA windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <9463447132.1507075949@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: E7+fgwIzg581k4oBS1gKQC windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=R jobname="" limit=1000 offset=0 windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56e40148e0 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=R jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56e40148e0 windwalker-dir (100): mysql.c:258-0 close db=7f56e40148e0 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.12.32_28 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <884320093.1507075952@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK YT5zI0QPyHUWN/lXXKpNnA windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <1862955500.1507075952@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: c6+7D0+RR7/LK4Z3D4Mv1A windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=F days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56e40148e0 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=F days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:32' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:32' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=S days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=S days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:32' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:32' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=s days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=s days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:32' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:32' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=m days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=m days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=M days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=M days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=j days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=j days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=c days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=c days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=C days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=C days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=d days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=d days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=t days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=t days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=p days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=p days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=q days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=q days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=R days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=R days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=l days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=l days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:33' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=1000 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=T days=1 jobname="" limit=1000 offset=1000 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 1000; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 1000; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=W days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=W days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=A days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=A days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=E days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=E days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=e days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=e days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=f days=1 jobname="" limit=1000 offset=0 windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=f days=1 jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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-10-02 18:12:34' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56e40148e0 windwalker-dir (100): mysql.c:258-0 close db=7f56e40148e0 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.12.41_29 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <823410052.1507075961@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK y17ueb3PLxaR7X4dLeL8Sw windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <7080219049.1507075961@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: jwpZrA54TB+DW//W48xoAA windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline list jobtotals windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f56e40148e0 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: list jobtotals windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT count(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) AS Bytes,Name AS Job FROM Job GROUP BY Name windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with query SELECT COUNT(*) AS Jobs,sum(JobFiles) AS Files,sum(JobBytes) As Bytes FROM Job windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f56e40148e0 windwalker-dir (100): mysql.c:258-0 close db=7f56e40148e0 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.12.41_30 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <1943629129.1507075961@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK zGtKCKh+Gd2Ws2wXs/9jOQ windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <7380189933.1507075961@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: G9/6Vw/KD6++t8ErE4A6bD windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs last current enabled windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f5710847270 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs last current enabled windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long_last (9) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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; windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Windwalker_Excluded_Files, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Taffy_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Sonny_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_MuadDib_Weekly, suppress output windwalker-dir (200): ua_output.c:1612-0 filterit: Filter on resource_type 1004 value Backup_Samson_Weekly, suppress output windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f5710847270 windwalker-dir (100): mysql.c:258-0 close db=7f5710847270 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (110): socket_server.c:87-0 Conn: Hello chris calling windwalker-dir (100): storage.c:146-0 wstorage=vchanger_8tb windwalker-dir (100): storage.c:146-0 wstorage=vchanger_3tb windwalker-dir (100): storage.c:155-0 wstore=vchanger_8tb where=Job resource windwalker-dir (100): job.c:1484-0 JobId=0 created Job=-Console-.2017-10-03_18.12.45_31 windwalker-dir (50): cram-md5.c:68-0 send: auth cram-md5 <387527882.1507075965@windwalker-dir> ssl=0 windwalker-dir (50): cram-md5.c:94-0 Authenticate OK Syn5LBxIG6mRYgSYJ14AhQ windwalker-dir (100): cram-md5.c:123-0 cram-get received: auth cram-md5 <3460456885.1507075965@php-bsock> ssl=0 windwalker-dir (99): cram-md5.c:143-0 sending resp to challenge: K+/fx99piiETk2kbaHB3bB windwalker-dir (10): ua_audit.c:143-0 : Console [chris] from [127.0.0.1] cmdline llist jobs jobstatus=R jobname="" limit=1000 offset=0 windwalker-dir (100): ua_db.c:150-0 UA Open database windwalker-dir (100): sql_pooling.c:60-0 db_sql_get_non_pooled_connection allocating 1 new non pooled database connection to database bareos, backend type mysql windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename dbi, partly_compare = true windwalker-dir (100): cats_backends.c:65-0 db_init_database: Trying to find mapping of given interfacename mysql to mapping interfacename mysql, partly_compare = false windwalker-dir (100): mysql.c:863-0 db_init_database first time windwalker-dir (50): mysql.c:180-0 mysql_init done windwalker-dir (50): mysql.c:204-0 mysql_real_connect done windwalker-dir (50): mysql.c:206-0 db_user=bareos db_name=bareos db_password=onebackuptorulethemall windwalker-dir (100): mysql.c:229-0 opendb ref=1 connected=1 db=7f5710847270 windwalker-dir (150): ua_db.c:183-0 DB bareos opened windwalker-dir (20): ua_output.c:565-0 list: llist jobs jobstatus=R jobname="" limit=1000 offset=0 windwalker-dir (100): sql_query.c:96-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) with query name list_jobs_long (6) windwalker-dir (100): sql_query.c:102-0 called: void B_DB::fill_query_va_list(POOL_MEM&, B_DB_QUERY_ENUM_CLASS::SQL_QUERY_ENUM, __va_list_tag*) query is now 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' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): sql_query.c:124-0 called: bool B_DB::sql_query(const char*, int) with 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' ORDER BY StartTime LIMIT 1000 OFFSET 0; windwalker-dir (100): mysql.c:251-0 closedb ref=0 connected=1 db=7f5710847270 windwalker-dir (100): mysql.c:258-0 close db=7f5710847270 windwalker-dir (200): job.c:1525-0 Start dird free_jcr windwalker-dir (200): job.c:1589-0 End dird free_jcr windwalker-dir (10): ua_audit.c:143-0 : Console [default] from [192.168.9.1] cmdline setdebug director level=7 trace=0 windwalker-dir (120): ua_cmds.c:1305-0 setdebug:setdebug director level=7 trace=0: