2023-02-28 02:00:07.130 CET [183866] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:00:07.152 CET [183867] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:00:07.152 CET [183867] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:00:07.152 CET [183867] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:00:07.152 CET [183867] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:00:07.171 CET [183868] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:00:07.171 CET [183868] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:00:07.172 CET [183868] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:00:07.172 CET [183868] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:00:07.186 CET [183869] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:00:07.186 CET [183869] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:00:07.186 CET [183869] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:00:07.186 CET [183869] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:07.208 CET [183870] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:00:07.208 CET [183870] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:07.209 CET [183870] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:00:07.209 CET [183870] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:07.228 CET [183871] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:00:07.228 CET [183871] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:07.228 CET [183871] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:00:07.228 CET [183871] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:00:07.249 CET [183872] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:00:07.249 CET [183872] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:00:07.249 CET [183872] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:00:07.249 CET [183872] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:00:07.272 CET [183873] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:00:07.272 CET [183873] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:00:57.669 CET [183873] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:00:57.669 CET [183873] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:00:57.691 CET [184180] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:00:57.691 CET [184180] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:00:57.691 CET [184180] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:00:57.691 CET [184180] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:00:57.713 CET [184181] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:00:57.713 CET [184181] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:00:57.713 CET [184181] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:00:57.713 CET [184181] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:00:57.736 CET [184182] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:00:57.736 CET [184182] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:00:57.736 CET [184182] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:00:57.736 CET [184182] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:00:57.761 CET [184183] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:00:57.761 CET [184183] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:00:57.761 CET [184183] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:00:57.761 CET [184183] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:00:57.785 CET [184184] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:00:57.785 CET [184184] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:00:57.785 CET [184184] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:00:57.785 CET [184184] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:00:57.809 CET [184185] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:00:57.809 CET [184185] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:00:57.809 CET [184185] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:00:57.809 CET [184185] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:00:57.833 CET [184186] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:00:57.833 CET [184186] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:00:57.833 CET [184186] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:00:57.833 CET [184186] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:00:57.858 CET [184187] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:00:57.858 CET [184187] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:00:57.858 CET [184187] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:00:57.858 CET [184187] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:00:57.881 CET [184188] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:00:57.881 CET [184188] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:00:57.881 CET [184188] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:00:57.881 CET [184188] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:00:57.904 CET [184189] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:00:57.904 CET [184189] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:00:57.905 CET [184189] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:00:57.905 CET [184189] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:57.929 CET [184190] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:00:57.929 CET [184190] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:57.930 CET [184190] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:00:57.930 CET [184190] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:57.953 CET [184191] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:00:57.953 CET [184191] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:00:57.954 CET [184191] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:00:57.954 CET [184191] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:00:57.977 CET [184192] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:00:57.977 CET [184192] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:00:57.977 CET [184192] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:00:57.977 CET [184192] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:00:58.000 CET [184193] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:00:58.000 CET [184193] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:03:43.231 CET [184193] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:03:43.231 CET [184193] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:03:43.254 CET [184658] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:03:43.254 CET [184658] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:03:43.254 CET [184658] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:03:43.254 CET [184658] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:03:43.273 CET [184659] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:03:43.273 CET [184659] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:03:43.273 CET [184659] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:03:43.273 CET [184659] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:03:43.295 CET [184660] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:03:43.295 CET [184660] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:03:43.295 CET [184660] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:03:43.295 CET [184660] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:03:43.318 CET [184661] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:03:43.318 CET [184661] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:03:43.319 CET [184661] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:03:43.319 CET [184661] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:03:43.342 CET [184662] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:03:43.342 CET [184662] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:03:43.342 CET [184662] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:03:43.342 CET [184662] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:03:43.365 CET [184663] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:03:43.365 CET [184663] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:03:43.365 CET [184663] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:03:43.365 CET [184663] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:03:43.389 CET [184664] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:03:43.389 CET [184664] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:03:43.389 CET [184664] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:03:43.389 CET [184664] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:03:43.413 CET [184665] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:03:43.413 CET [184665] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:03:43.413 CET [184665] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:03:43.413 CET [184665] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:03:43.437 CET [184666] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:03:43.437 CET [184666] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:03:43.438 CET [184666] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:03:43.438 CET [184666] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:03:43.462 CET [184667] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:03:43.462 CET [184667] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:03:43.463 CET [184667] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:03:43.463 CET [184667] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:03:43.487 CET [184668] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:03:43.487 CET [184668] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:03:43.488 CET [184668] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:03:43.488 CET [184668] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:03:43.513 CET [184669] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:03:43.513 CET [184669] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:03:43.513 CET [184669] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:03:43.513 CET [184669] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:03:43.537 CET [184670] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:03:43.537 CET [184670] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:03:43.537 CET [184670] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:03:43.537 CET [184670] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:03:43.560 CET [184671] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:03:43.560 CET [184671] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:11:12.180 CET [184671] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:11:12.180 CET [184671] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:11:12.203 CET [186013] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:11:12.203 CET [186013] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:11:12.203 CET [186013] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:11:12.203 CET [186013] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:11:12.223 CET [186014] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:11:12.223 CET [186014] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:11:12.223 CET [186014] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:11:12.223 CET [186014] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:11:12.246 CET [186015] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:11:12.246 CET [186015] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:11:12.246 CET [186015] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:11:12.246 CET [186015] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:11:12.267 CET [186016] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:11:12.267 CET [186016] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:11:12.268 CET [186016] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:11:12.268 CET [186016] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:11:12.290 CET [186017] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:11:12.290 CET [186017] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:11:12.290 CET [186017] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:11:12.290 CET [186017] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:11:12.313 CET [186018] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:11:12.313 CET [186018] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:11:12.313 CET [186018] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:11:12.313 CET [186018] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:11:12.337 CET [186019] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:11:12.337 CET [186019] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:11:12.337 CET [186019] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:11:12.337 CET [186019] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:11:12.361 CET [186020] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:11:12.361 CET [186020] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:11:12.361 CET [186020] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:11:12.361 CET [186020] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:11:12.385 CET [186021] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:11:12.385 CET [186021] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:11:12.385 CET [186021] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:11:12.385 CET [186021] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:11:12.407 CET [186022] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:11:12.407 CET [186022] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:11:12.408 CET [186022] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:11:12.408 CET [186022] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:11:12.432 CET [186023] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:11:12.432 CET [186023] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:11:12.433 CET [186023] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:11:12.433 CET [186023] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:11:12.457 CET [186024] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:11:12.457 CET [186024] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:11:12.457 CET [186024] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:11:12.457 CET [186024] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:11:12.480 CET [186025] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:11:12.480 CET [186025] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:11:12.480 CET [186025] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:11:12.480 CET [186025] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:11:12.504 CET [186026] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:11:12.504 CET [186026] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:18:25.141 CET [186026] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:18:25.141 CET [186026] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:18:25.155 CET [186937] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:18:25.155 CET [186937] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:18:25.155 CET [186937] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:18:25.155 CET [186937] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:18:25.169 CET [186938] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:18:25.169 CET [186938] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:18:25.169 CET [186938] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:18:25.169 CET [186938] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:18:25.192 CET [186939] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:18:25.192 CET [186939] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:18:25.192 CET [186939] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:18:25.192 CET [186939] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:18:25.213 CET [186940] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:18:25.213 CET [186940] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:18:25.213 CET [186940] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:18:25.213 CET [186940] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:18:25.235 CET [186941] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:18:25.235 CET [186941] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:18:25.235 CET [186941] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:18:25.235 CET [186941] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:18:25.257 CET [186942] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:18:25.257 CET [186942] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:18:25.257 CET [186942] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:18:25.257 CET [186942] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:18:25.278 CET [186943] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:18:25.278 CET [186943] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:18:25.278 CET [186943] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:18:25.278 CET [186943] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:18:25.301 CET [186944] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:18:25.301 CET [186944] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:18:25.301 CET [186944] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:18:25.301 CET [186944] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:18:25.323 CET [186945] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:18:25.323 CET [186945] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:18:25.323 CET [186945] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:18:25.323 CET [186945] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:18:25.346 CET [186946] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:18:25.346 CET [186946] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:18:25.346 CET [186946] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:18:25.346 CET [186946] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:18:25.372 CET [186947] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:18:25.372 CET [186947] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:18:25.372 CET [186947] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:18:25.372 CET [186947] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:18:25.396 CET [186948] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:18:25.396 CET [186948] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:18:25.396 CET [186948] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:18:25.396 CET [186948] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:18:25.417 CET [186949] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:18:25.417 CET [186949] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:18:25.417 CET [186949] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:18:25.417 CET [186949] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:18:25.440 CET [186950] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:18:25.440 CET [186950] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:23:49.306 CET [186950] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:23:49.306 CET [186950] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:23:49.330 CET [187728] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:23:49.330 CET [187728] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:23:49.330 CET [187728] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:23:49.330 CET [187728] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:23:49.353 CET [187729] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:23:49.353 CET [187729] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:23:49.353 CET [187729] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:23:49.353 CET [187729] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:23:49.376 CET [187730] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:23:49.376 CET [187730] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:23:49.376 CET [187730] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:23:49.376 CET [187730] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:23:49.398 CET [187731] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:23:49.398 CET [187731] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:23:49.399 CET [187731] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:23:49.399 CET [187731] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:23:49.421 CET [187732] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:23:49.421 CET [187732] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:23:49.421 CET [187732] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:23:49.421 CET [187732] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:23:49.442 CET [187738] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:23:49.442 CET [187738] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:23:49.442 CET [187738] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:23:49.442 CET [187738] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:23:49.466 CET [187739] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:23:49.466 CET [187739] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:23:49.466 CET [187739] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:23:49.466 CET [187739] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:23:49.490 CET [187740] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:23:49.490 CET [187740] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:23:49.490 CET [187740] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:23:49.490 CET [187740] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:23:49.512 CET [187741] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:23:49.512 CET [187741] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:23:49.512 CET [187741] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:23:49.512 CET [187741] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:23:49.534 CET [187742] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:23:49.534 CET [187742] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:23:49.534 CET [187742] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:23:49.534 CET [187742] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:23:49.558 CET [187743] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:23:49.558 CET [187743] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:23:49.559 CET [187743] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:23:49.559 CET [187743] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:23:49.583 CET [187744] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:23:49.583 CET [187744] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:23:49.584 CET [187744] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:23:49.584 CET [187744] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:23:49.605 CET [187745] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:23:49.605 CET [187745] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:23:49.606 CET [187745] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:23:49.606 CET [187745] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:23:49.628 CET [187746] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:23:49.628 CET [187746] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:28:15.081 CET [187746] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:28:15.081 CET [187746] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:28:15.095 CET [188306] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:28:15.095 CET [188306] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:28:15.095 CET [188306] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:28:15.095 CET [188306] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:28:15.109 CET [188307] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:28:15.109 CET [188307] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:28:15.109 CET [188307] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:28:15.109 CET [188307] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:28:15.131 CET [188308] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:28:15.131 CET [188308] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:28:15.131 CET [188308] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:28:15.131 CET [188308] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:28:15.152 CET [188309] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:28:15.152 CET [188309] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:28:15.153 CET [188309] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:28:15.153 CET [188309] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:28:15.173 CET [188310] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:28:15.173 CET [188310] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:28:15.174 CET [188310] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:28:15.174 CET [188310] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:28:15.195 CET [188311] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:28:15.195 CET [188311] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:28:15.195 CET [188311] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:28:15.195 CET [188311] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:28:15.218 CET [188312] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:28:15.218 CET [188312] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:28:15.218 CET [188312] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:28:15.218 CET [188312] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:28:15.241 CET [188313] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:28:15.241 CET [188313] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:28:15.241 CET [188313] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:28:15.241 CET [188313] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:28:15.265 CET [188314] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:28:15.265 CET [188314] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:28:15.265 CET [188314] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:28:15.265 CET [188314] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:28:15.288 CET [188315] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:28:15.288 CET [188315] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:28:15.289 CET [188315] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:28:15.289 CET [188315] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:28:15.312 CET [188316] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:28:15.312 CET [188316] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:28:15.312 CET [188316] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:28:15.312 CET [188316] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:28:15.336 CET [188317] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:28:15.336 CET [188317] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:28:15.336 CET [188317] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:28:15.336 CET [188317] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:28:15.359 CET [188318] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:28:15.359 CET [188318] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:28:15.360 CET [188318] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:28:15.360 CET [188318] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:28:15.381 CET [188319] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:28:15.381 CET [188319] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:29:56.703 CET [188319] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:29:56.703 CET [188319] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:29:56.728 CET [188576] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:29:56.728 CET [188576] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:29:56.728 CET [188576] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:29:56.728 CET [188576] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:29:56.743 CET [188577] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:29:56.743 CET [188577] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:29:56.743 CET [188577] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:29:56.743 CET [188577] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:29:56.756 CET [188578] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:29:56.756 CET [188578] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:29:56.757 CET [188578] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:29:56.757 CET [188578] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:29:56.772 CET [188579] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:29:56.772 CET [188579] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:29:56.772 CET [188579] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:29:56.772 CET [188579] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:29:56.794 CET [188580] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:29:56.794 CET [188580] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:29:56.795 CET [188580] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:29:56.795 CET [188580] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:29:56.818 CET [188581] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:29:56.818 CET [188581] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:29:56.818 CET [188581] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:29:56.818 CET [188581] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:29:56.842 CET [188582] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:29:56.842 CET [188582] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:29:56.842 CET [188582] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:29:56.842 CET [188582] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:29:56.865 CET [188583] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:29:56.865 CET [188583] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:29:56.865 CET [188583] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:29:56.865 CET [188583] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:29:56.886 CET [188584] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:29:56.886 CET [188584] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:29:56.887 CET [188584] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:29:56.887 CET [188584] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:29:56.909 CET [188585] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:29:56.909 CET [188585] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:29:56.909 CET [188585] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:29:56.909 CET [188585] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:29:56.934 CET [188586] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:29:56.934 CET [188586] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:29:56.934 CET [188586] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:29:56.934 CET [188586] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:29:56.957 CET [188587] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:29:56.957 CET [188587] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:29:56.958 CET [188587] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:29:56.958 CET [188587] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:29:56.982 CET [188588] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:29:56.982 CET [188588] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:29:56.982 CET [188588] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:29:56.982 CET [188588] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:29:57.005 CET [188589] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:29:57.005 CET [188589] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:47:23.918 CET [188589] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:47:23.918 CET [188589] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:47:23.940 CET [191101] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 02:47:23.940 CET [191101] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 02:47:23.940 CET [191101] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:47:23.940 CET [191101] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:47:23.958 CET [191102] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 02:47:23.958 CET [191102] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 02:47:23.958 CET [191102] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:47:23.958 CET [191102] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:47:23.978 CET [191103] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 02:47:23.978 CET [191103] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 02:47:23.978 CET [191103] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:47:23.978 CET [191103] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:47:24.000 CET [191104] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:47:24.000 CET [191104] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 02:47:24.000 CET [191104] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:47:24.000 CET [191104] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:47:24.023 CET [191105] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:47:24.023 CET [191105] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 02:47:24.023 CET [191105] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:47:24.023 CET [191105] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:47:24.046 CET [191106] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 02:47:24.046 CET [191106] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 02:47:24.046 CET [191106] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:47:24.046 CET [191106] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:47:24.070 CET [191107] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 02:47:24.070 CET [191107] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 02:47:24.070 CET [191107] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:47:24.070 CET [191107] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:47:24.093 CET [191108] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 02:47:24.093 CET [191108] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 02:47:24.093 CET [191108] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:47:24.093 CET [191108] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:47:24.115 CET [191111] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 02:47:24.115 CET [191111] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 02:47:24.116 CET [191111] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:47:24.116 CET [191111] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:47:24.137 CET [191112] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 02:47:24.137 CET [191112] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 02:47:24.138 CET [191112] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:47:24.138 CET [191112] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:47:24.160 CET [191113] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 02:47:24.160 CET [191113] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:47:24.161 CET [191113] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:47:24.161 CET [191113] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:47:24.184 CET [191114] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 02:47:24.184 CET [191114] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 02:47:24.184 CET [191114] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:47:24.184 CET [191114] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:47:24.208 CET [191118] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 02:47:24.208 CET [191118] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 02:47:24.208 CET [191118] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:47:24.208 CET [191118] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 02:47:24.221 CET [191120] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 02:47:24.221 CET [191120] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 04:06:18.803 CET [191120] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 04:06:18.803 CET [191120] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 04:06:18.826 CET [202301] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 04:06:18.826 CET [202301] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 04:06:18.826 CET [202301] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 04:06:18.826 CET [202301] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 04:06:18.848 CET [202302] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 04:06:18.848 CET [202302] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 04:06:18.848 CET [202302] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 04:06:18.848 CET [202302] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 04:06:18.869 CET [202303] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 04:06:18.869 CET [202303] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 04:06:18.870 CET [202303] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 04:06:18.870 CET [202303] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 04:06:18.890 CET [202304] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 04:06:18.890 CET [202304] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 04:06:18.890 CET [202304] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 04:06:18.890 CET [202304] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 04:06:18.910 CET [202305] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 04:06:18.910 CET [202305] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 04:06:18.910 CET [202305] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 04:06:18.910 CET [202305] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 04:06:18.932 CET [202306] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 04:06:18.932 CET [202306] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 04:06:18.933 CET [202306] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 04:06:18.933 CET [202306] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 04:06:18.956 CET [202307] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 04:06:18.956 CET [202307] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 04:06:18.956 CET [202307] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 04:06:18.956 CET [202307] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 04:06:18.979 CET [202308] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 04:06:18.979 CET [202308] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 04:06:18.979 CET [202308] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 04:06:18.979 CET [202308] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 04:06:19.002 CET [202309] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 04:06:19.002 CET [202309] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 04:06:19.002 CET [202309] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 04:06:19.002 CET [202309] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 04:06:19.025 CET [202310] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 04:06:19.025 CET [202310] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 04:06:19.026 CET [202310] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 04:06:19.026 CET [202310] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 04:06:19.050 CET [202311] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 04:06:19.050 CET [202311] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 04:06:19.050 CET [202311] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 04:06:19.050 CET [202311] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 04:06:19.075 CET [202312] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 04:06:19.075 CET [202312] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 04:06:19.075 CET [202312] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 04:06:19.075 CET [202312] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 04:06:19.099 CET [202314] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 04:06:19.099 CET [202314] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 04:06:19.099 CET [202314] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 04:06:19.099 CET [202314] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 04:06:19.121 CET [202315] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 04:06:19.121 CET [202315] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 09:05:16.021 CET [202315] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 09:05:16.021 CET [202315] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 09:05:16.045 CET [245954] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 09:05:16.045 CET [245954] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 09:05:16.045 CET [245954] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 09:05:16.045 CET [245954] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 09:05:16.064 CET [245955] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 09:05:16.064 CET [245955] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 09:05:16.064 CET [245955] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 09:05:16.064 CET [245955] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 09:05:16.078 CET [245956] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 09:05:16.078 CET [245956] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 09:05:16.078 CET [245956] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:05:16.078 CET [245956] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 09:05:16.096 CET [245957] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:05:16.096 CET [245957] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 09:05:16.096 CET [245957] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:05:16.096 CET [245957] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 09:05:16.115 CET [245958] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:05:16.115 CET [245958] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 09:05:16.115 CET [245958] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 09:05:16.115 CET [245958] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 09:05:16.138 CET [245959] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 09:05:16.138 CET [245959] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 09:05:16.139 CET [245959] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 09:05:16.139 CET [245959] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 09:05:16.159 CET [245960] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 09:05:16.159 CET [245960] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 09:05:16.159 CET [245960] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 09:05:16.159 CET [245960] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 09:05:16.180 CET [245961] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 09:05:16.180 CET [245961] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 09:05:16.180 CET [245961] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:05:16.180 CET [245961] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 09:05:16.204 CET [245962] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:05:16.204 CET [245962] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 09:05:16.204 CET [245962] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 09:05:16.204 CET [245962] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 09:05:16.227 CET [245963] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 09:05:16.227 CET [245963] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 09:05:16.228 CET [245963] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 09:05:16.228 CET [245963] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:05:16.250 CET [245964] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 09:05:16.250 CET [245964] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:05:16.251 CET [245964] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 09:05:16.251 CET [245964] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:05:16.272 CET [245965] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 09:05:16.272 CET [245965] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:05:16.272 CET [245965] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 09:05:16.272 CET [245965] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 09:05:16.296 CET [245966] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 09:05:16.296 CET [245966] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 09:05:16.296 CET [245966] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:05:16.296 CET [245966] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 09:05:16.318 CET [245967] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:05:16.318 CET [245967] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 09:14:06.447 CET [245967] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 09:14:06.447 CET [245967] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 09:14:06.471 CET [247175] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 09:14:06.471 CET [247175] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 09:14:06.471 CET [247175] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 09:14:06.471 CET [247175] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 09:14:06.490 CET [247178] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 09:14:06.490 CET [247178] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 09:14:06.490 CET [247178] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 09:14:06.490 CET [247178] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 09:14:06.509 CET [247179] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 09:14:06.509 CET [247179] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 09:14:06.509 CET [247179] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:14:06.509 CET [247179] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 09:14:06.529 CET [247180] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:14:06.529 CET [247180] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 09:14:06.529 CET [247180] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:14:06.529 CET [247180] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 09:14:06.548 CET [247181] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:14:06.548 CET [247181] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 09:14:06.548 CET [247181] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 09:14:06.548 CET [247181] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 09:14:06.571 CET [247182] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 09:14:06.571 CET [247182] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 09:14:06.571 CET [247182] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 09:14:06.571 CET [247182] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 09:14:06.594 CET [247183] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 09:14:06.594 CET [247183] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 09:14:06.594 CET [247183] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 09:14:06.594 CET [247183] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 09:14:06.617 CET [247184] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 09:14:06.617 CET [247184] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 09:14:06.617 CET [247184] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:14:06.617 CET [247184] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 09:14:06.640 CET [247185] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 09:14:06.640 CET [247185] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 09:14:06.641 CET [247185] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 09:14:06.641 CET [247185] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 09:14:06.662 CET [247186] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 09:14:06.662 CET [247186] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 09:14:06.663 CET [247186] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 09:14:06.663 CET [247186] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:14:06.685 CET [247187] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 09:14:06.685 CET [247187] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:14:06.686 CET [247187] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 09:14:06.686 CET [247187] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:14:06.709 CET [247188] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 09:14:06.709 CET [247188] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 09:14:06.710 CET [247188] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 09:14:06.710 CET [247188] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 09:14:06.730 CET [247189] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 09:14:06.730 CET [247189] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 09:14:06.730 CET [247189] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:14:06.730 CET [247189] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 09:14:06.753 CET [247190] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 09:14:06.753 CET [247190] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 12:05:13.969 CET [247190] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 12:05:13.969 CET [247190] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 12:05:13.993 CET [270534] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 12:05:13.993 CET [270534] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 12:05:13.993 CET [270534] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 12:05:13.993 CET [270534] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 12:05:14.015 CET [270535] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 12:05:14.015 CET [270535] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 12:05:14.015 CET [270535] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 12:05:14.015 CET [270535] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 12:05:14.038 CET [270536] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 12:05:14.038 CET [270536] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 12:05:14.038 CET [270536] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:05:14.038 CET [270536] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 12:05:14.059 CET [270537] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:05:14.059 CET [270537] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 12:05:14.060 CET [270537] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:05:14.060 CET [270537] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 12:05:14.082 CET [270538] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:05:14.082 CET [270538] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 12:05:14.082 CET [270538] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 12:05:14.082 CET [270538] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 12:05:14.104 CET [270539] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 12:05:14.104 CET [270539] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 12:05:14.105 CET [270539] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 12:05:14.105 CET [270539] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 12:05:14.126 CET [270540] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 12:05:14.126 CET [270540] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 12:05:14.126 CET [270540] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 12:05:14.126 CET [270540] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 12:05:14.149 CET [270541] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 12:05:14.149 CET [270541] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 12:05:14.149 CET [270541] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:05:14.149 CET [270541] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 12:05:14.172 CET [270542] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:05:14.172 CET [270542] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 12:05:14.172 CET [270542] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 12:05:14.172 CET [270542] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 12:05:14.195 CET [270543] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 12:05:14.195 CET [270543] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 12:05:14.196 CET [270543] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 12:05:14.196 CET [270543] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:05:14.219 CET [270544] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 12:05:14.219 CET [270544] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:05:14.220 CET [270544] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 12:05:14.220 CET [270544] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:05:14.243 CET [270545] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 12:05:14.243 CET [270545] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:05:14.243 CET [270545] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 12:05:14.243 CET [270545] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 12:05:14.265 CET [270546] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 12:05:14.265 CET [270546] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 12:05:14.265 CET [270546] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:05:14.265 CET [270546] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 12:05:14.286 CET [270547] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:05:14.286 CET [270547] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 12:32:24.662 CET [270547] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 12:32:24.662 CET [270547] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 12:32:24.685 CET [274152] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 12:32:24.685 CET [274152] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 12:32:24.685 CET [274152] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 12:32:24.685 CET [274152] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 12:32:24.703 CET [274153] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 12:32:24.703 CET [274153] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 12:32:24.703 CET [274153] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 12:32:24.703 CET [274153] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 12:32:24.722 CET [274154] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 12:32:24.722 CET [274154] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 12:32:24.722 CET [274154] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:32:24.722 CET [274154] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 12:32:24.742 CET [274155] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:32:24.742 CET [274155] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 12:32:24.742 CET [274155] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:32:24.742 CET [274155] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 12:32:24.763 CET [274156] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:32:24.763 CET [274156] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 12:32:24.763 CET [274156] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 12:32:24.763 CET [274156] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 12:32:24.786 CET [274157] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 12:32:24.786 CET [274157] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 12:32:24.786 CET [274157] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 12:32:24.786 CET [274157] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 12:32:24.808 CET [274158] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 12:32:24.808 CET [274158] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 12:32:24.808 CET [274158] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 12:32:24.808 CET [274158] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 12:32:24.830 CET [274159] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 12:32:24.830 CET [274159] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 12:32:24.830 CET [274159] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:32:24.830 CET [274159] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 12:32:24.852 CET [274160] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 12:32:24.852 CET [274160] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 12:32:24.852 CET [274160] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 12:32:24.852 CET [274160] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 12:32:24.872 CET [274161] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 12:32:24.872 CET [274161] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 12:32:24.873 CET [274161] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 12:32:24.873 CET [274161] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:32:24.896 CET [274162] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 12:32:24.896 CET [274162] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:32:24.896 CET [274162] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 12:32:24.896 CET [274162] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:32:24.921 CET [274163] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 12:32:24.921 CET [274163] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 12:32:24.921 CET [274163] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 12:32:24.921 CET [274163] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 12:32:24.944 CET [274164] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 12:32:24.944 CET [274164] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 12:32:24.945 CET [274164] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:32:24.945 CET [274164] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 12:32:24.968 CET [274165] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 12:32:24.968 CET [274165] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 14:50:22.881 CET [304437] bareos@bareos ERROR:  table "btempb2000121804" does not exist
2023-02-28 14:50:22.881 CET [304437] bareos@bareos STATEMENT:  DROP TABLE btempb2000121804
2023-02-28 14:50:22.905 CET [304447] bareos@bareos ERROR:  table "btempb2000121804" does not exist
2023-02-28 14:50:22.905 CET [304447] bareos@bareos STATEMENT:  DROP TABLE btempb2000121804
2023-02-28 14:50:22.905 CET [304447] bareos@bareos ERROR:  table "b2000121804" does not exist
2023-02-28 14:50:22.905 CET [304447] bareos@bareos STATEMENT:  DROP TABLE b2000121804
2023-02-28 14:50:22.921 CET [304448] bareos@bareos ERROR:  table "b2000121804" does not exist
2023-02-28 14:50:22.921 CET [304448] bareos@bareos STATEMENT:  DROP TABLE b2000121804
2023-02-28 14:50:40.732 CET [274165] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 14:50:40.732 CET [274165] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 14:50:40.754 CET [304501] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 14:50:40.754 CET [304501] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 14:50:40.754 CET [304501] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 14:50:40.754 CET [304501] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 14:50:40.776 CET [304502] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 14:50:40.776 CET [304502] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 14:50:40.777 CET [304502] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 14:50:40.777 CET [304502] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 14:50:40.800 CET [304503] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 14:50:40.800 CET [304503] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 14:50:40.800 CET [304503] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:50:40.800 CET [304503] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 14:50:40.824 CET [304504] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:50:40.824 CET [304504] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 14:50:40.824 CET [304504] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:50:40.824 CET [304504] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 14:50:40.846 CET [304505] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:50:40.846 CET [304505] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 14:50:40.846 CET [304505] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 14:50:40.846 CET [304505] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 14:50:40.869 CET [304506] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 14:50:40.869 CET [304506] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 14:50:40.869 CET [304506] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 14:50:40.869 CET [304506] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 14:50:40.892 CET [304509] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 14:50:40.892 CET [304509] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 14:50:40.892 CET [304509] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 14:50:40.892 CET [304509] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 14:50:40.915 CET [304510] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 14:50:40.915 CET [304510] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 14:50:40.915 CET [304510] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:50:40.915 CET [304510] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 14:50:40.936 CET [304511] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:50:40.936 CET [304511] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 14:50:40.937 CET [304511] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 14:50:40.937 CET [304511] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 14:50:40.957 CET [304512] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 14:50:40.957 CET [304512] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 14:50:40.957 CET [304512] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 14:50:40.957 CET [304512] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:50:40.980 CET [304516] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 14:50:40.980 CET [304516] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:50:40.981 CET [304516] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 14:50:40.981 CET [304516] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:50:41.001 CET [304517] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 14:50:41.001 CET [304517] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:50:41.001 CET [304517] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 14:50:41.001 CET [304517] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 14:50:41.023 CET [304519] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 14:50:41.023 CET [304519] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 14:50:41.023 CET [304519] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:50:41.023 CET [304519] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 14:50:41.044 CET [304520] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:50:41.044 CET [304520] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 14:51:37.358 CET [304772] bareos@bareos ERROR:  table "btempb2000520583" does not exist
2023-02-28 14:51:37.358 CET [304772] bareos@bareos STATEMENT:  DROP TABLE btempb2000520583
2023-02-28 14:51:37.382 CET [304782] bareos@bareos ERROR:  table "btempb2000520583" does not exist
2023-02-28 14:51:37.382 CET [304782] bareos@bareos STATEMENT:  DROP TABLE btempb2000520583
2023-02-28 14:51:37.382 CET [304782] bareos@bareos ERROR:  table "b2000520583" does not exist
2023-02-28 14:51:37.382 CET [304782] bareos@bareos STATEMENT:  DROP TABLE b2000520583
2023-02-28 14:51:37.405 CET [304783] bareos@bareos ERROR:  table "b2000520583" does not exist
2023-02-28 14:51:37.405 CET [304783] bareos@bareos STATEMENT:  DROP TABLE b2000520583
2023-02-28 14:51:52.496 CET [304520] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 14:51:52.496 CET [304520] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 14:51:52.519 CET [304856] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 14:51:52.519 CET [304856] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 14:51:52.519 CET [304856] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 14:51:52.519 CET [304856] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 14:51:52.539 CET [304857] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 14:51:52.539 CET [304857] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 14:51:52.539 CET [304857] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 14:51:52.539 CET [304857] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 14:51:52.560 CET [304858] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 14:51:52.560 CET [304858] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 14:51:52.560 CET [304858] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:51:52.560 CET [304858] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 14:51:52.583 CET [304859] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:51:52.583 CET [304859] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 14:51:52.583 CET [304859] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:51:52.583 CET [304859] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 14:51:52.605 CET [304860] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:51:52.605 CET [304860] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 14:51:52.605 CET [304860] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 14:51:52.605 CET [304860] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 14:51:52.626 CET [304861] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 14:51:52.626 CET [304861] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 14:51:52.626 CET [304861] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 14:51:52.626 CET [304861] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 14:51:52.646 CET [304862] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 14:51:52.646 CET [304862] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 14:51:52.646 CET [304862] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 14:51:52.646 CET [304862] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 14:51:52.666 CET [304863] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 14:51:52.666 CET [304863] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 14:51:52.667 CET [304863] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:51:52.667 CET [304863] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 14:51:52.688 CET [304865] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 14:51:52.688 CET [304865] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 14:51:52.688 CET [304865] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 14:51:52.688 CET [304865] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 14:51:52.710 CET [304866] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 14:51:52.710 CET [304866] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 14:51:52.711 CET [304866] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 14:51:52.711 CET [304866] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:51:52.734 CET [304867] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 14:51:52.734 CET [304867] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:51:52.735 CET [304867] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 14:51:52.735 CET [304867] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:51:52.758 CET [304868] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 14:51:52.758 CET [304868] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 14:51:52.758 CET [304868] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 14:51:52.758 CET [304868] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 14:51:52.778 CET [304869] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 14:51:52.778 CET [304869] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 14:51:52.778 CET [304869] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:51:52.778 CET [304869] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 14:51:52.799 CET [304870] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 14:51:52.799 CET [304870] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 15:05:09.140 CET [304870] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 15:05:09.140 CET [304870] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 15:05:09.170 CET [306829] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 15:05:09.170 CET [306829] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 15:05:09.170 CET [306829] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 15:05:09.170 CET [306829] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 15:05:09.183 CET [306830] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 15:05:09.183 CET [306830] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 15:05:09.183 CET [306830] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 15:05:09.183 CET [306830] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 15:05:09.197 CET [306831] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 15:05:09.197 CET [306831] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 15:05:09.197 CET [306831] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:05:09.197 CET [306831] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 15:05:09.214 CET [306832] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:05:09.214 CET [306832] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 15:05:09.214 CET [306832] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:05:09.214 CET [306832] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 15:05:09.231 CET [306833] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:05:09.231 CET [306833] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 15:05:09.232 CET [306833] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 15:05:09.232 CET [306833] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 15:05:09.253 CET [306834] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 15:05:09.253 CET [306834] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 15:05:09.253 CET [306834] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 15:05:09.253 CET [306834] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 15:05:09.276 CET [306835] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 15:05:09.276 CET [306835] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 15:05:09.276 CET [306835] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 15:05:09.276 CET [306835] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 15:05:09.299 CET [306836] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 15:05:09.299 CET [306836] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 15:05:09.299 CET [306836] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:05:09.299 CET [306836] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 15:05:09.322 CET [306837] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:05:09.322 CET [306837] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 15:05:09.322 CET [306837] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 15:05:09.322 CET [306837] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 15:05:09.346 CET [306838] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 15:05:09.346 CET [306838] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 15:05:09.346 CET [306838] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 15:05:09.346 CET [306838] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:05:09.370 CET [306839] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 15:05:09.370 CET [306839] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:05:09.370 CET [306839] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 15:05:09.370 CET [306839] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:05:09.393 CET [306840] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 15:05:09.393 CET [306840] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:05:09.394 CET [306840] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 15:05:09.394 CET [306840] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 15:05:09.417 CET [306841] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 15:05:09.417 CET [306841] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 15:05:09.418 CET [306841] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:05:09.418 CET [306841] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 15:05:09.439 CET [306842] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:05:09.439 CET [306842] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 15:11:10.794 CET [306842] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 15:11:10.794 CET [306842] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 15:11:10.818 CET [307691] bareos@bareos ERROR:  syntax error at or near ")" at character 34
2023-02-28 15:11:10.818 CET [307691] bareos@bareos STATEMENT:  DELETE FROM File WHERE JobId IN ()
2023-02-28 15:11:10.819 CET [307691] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 15:11:10.819 CET [307691] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 15:11:10.833 CET [307692] bareos@bareos ERROR:  syntax error at or near ")" at character 39
2023-02-28 15:11:10.833 CET [307692] bareos@bareos STATEMENT:  DELETE FROM BaseFiles WHERE JobId IN ()
2023-02-28 15:11:10.834 CET [307692] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 15:11:10.834 CET [307692] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 15:11:10.847 CET [307693] bareos@bareos ERROR:  syntax error at or near ")" at character 46
2023-02-28 15:11:10.847 CET [307693] bareos@bareos STATEMENT:  UPDATE Job SET PurgedFiles=1 WHERE JobId IN ()
2023-02-28 15:11:10.847 CET [307693] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:11:10.847 CET [307693] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 15:11:10.870 CET [307694] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:11:10.870 CET [307694] bareos@bareos STATEMENT:  DELETE FROM JobMedia WHERE JobId IN ()
2023-02-28 15:11:10.870 CET [307694] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:11:10.870 CET [307694] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 15:11:10.892 CET [307695] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:11:10.892 CET [307695] bareos@bareos STATEMENT:  DELETE FROM Log WHERE JobId IN ()
2023-02-28 15:11:10.892 CET [307695] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 15:11:10.892 CET [307695] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 15:11:10.914 CET [307696] bareos@bareos ERROR:  syntax error at or near ")" at character 43
2023-02-28 15:11:10.914 CET [307696] bareos@bareos STATEMENT:  DELETE FROM RestoreObject WHERE JobId IN ()
2023-02-28 15:11:10.914 CET [307696] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 15:11:10.914 CET [307696] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 15:11:10.937 CET [307697] bareos@bareos ERROR:  syntax error at or near ")" at character 44
2023-02-28 15:11:10.937 CET [307697] bareos@bareos STATEMENT:  DELETE FROM PathVisibility WHERE JobId IN ()
2023-02-28 15:11:10.937 CET [307697] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 15:11:10.937 CET [307697] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 15:11:10.960 CET [307698] bareos@bareos ERROR:  syntax error at or near ")" at character 48
2023-02-28 15:11:10.960 CET [307698] bareos@bareos STATEMENT:  DELETE FROM NDMPJobEnvironment WHERE JobId IN ()
2023-02-28 15:11:10.960 CET [307698] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:11:10.960 CET [307698] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 15:11:10.982 CET [307699] bareos@bareos ERROR:  syntax error at or near ")" at character 38
2023-02-28 15:11:10.982 CET [307699] bareos@bareos STATEMENT:  DELETE FROM JobStats WHERE JobId IN ()
2023-02-28 15:11:10.983 CET [307699] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 15:11:10.983 CET [307699] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 15:11:11.003 CET [307700] bareos@bareos ERROR:  syntax error at or near ")" at character 109
2023-02-28 15:11:11.003 CET [307700] bareos@bareos STATEMENT:  CREATE TEMPORARY TABLE cpy_tmp AS SELECT MIN(JobId) AS JobId FROM Job WHERE Type = 'C' AND ( PriorJobId IN () OR PriorJobId IN ( SELECT PriorJobId FROM Job WHERE JobId IN () AND Type = 'B' ) ) GROUP BY PriorJobId
2023-02-28 15:11:11.004 CET [307700] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 15:11:11.004 CET [307700] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:11:11.026 CET [307701] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 60
2023-02-28 15:11:11.026 CET [307701] bareos@bareos STATEMENT:  UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:11:11.026 CET [307701] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 15:11:11.026 CET [307701] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:11:11.049 CET [307702] bareos@bareos ERROR:  relation "cpy_tmp" does not exist at character 70
2023-02-28 15:11:11.049 CET [307702] bareos@bareos STATEMENT:  DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp )
2023-02-28 15:11:11.050 CET [307702] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 15:11:11.050 CET [307702] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 15:11:11.072 CET [307703] bareos@bareos ERROR:  table "cpy_tmp" does not exist
2023-02-28 15:11:11.072 CET [307703] bareos@bareos STATEMENT:  DROP TABLE cpy_tmp
2023-02-28 15:11:11.073 CET [307703] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:11:11.073 CET [307703] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 15:11:11.095 CET [307704] bareos@bareos ERROR:  syntax error at or near ")" at character 33
2023-02-28 15:11:11.095 CET [307704] bareos@bareos STATEMENT:  DELETE FROM Job WHERE JobId IN ()
2023-02-28 15:52:20.258 CET [313225] root@bareos ERROR:  syntax error at or near "delcandidates" at character 1
2023-02-28 15:52:20.258 CET [313225] root@bareos STATEMENT:  delcandidates
        ;
2023-02-28 15:52:26.012 CET [313225] root@bareos ERROR:  relation "delcandidates" does not exist at character 15
2023-02-28 15:52:26.012 CET [313225] root@bareos STATEMENT:  select * from delcandidates;