View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001516 | bareos-core | director | public | 2023-02-28 16:01 | 2023-07-18 17:14 |
| Reporter | hostedpower | Assigned To | bruno-at-bareos | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | Linux | OS | Debian | OS Version | 10 |
| Product Version | 22.0.2 | ||||
| Summary | 0001516: Problem with failing queries in postgresql logs | ||||
| Description | Hi, We use PostgreSQL 14 together with Bareos 22.x and we find some worrisome errors in the logs. We recently upgrade to Bareos 22, as far as I can see the same problems existed in 21.x I'm attaching the error logs | ||||
| Tags | No tags attached. | ||||
 |
sql_errors.txt (111,845 bytes)
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;
|
|
|
By any chance do you still have the joblog of running jobs at that time ? |
|
|
I can make a new export, just let me know what's the best way to retrieve those logs of a specific time? Are they just in /var/log/bareos, or can I issue a message command or similar? |
|
|
Usually you should find the joblog in bareos.log, but also if you check your `list jobs` ouput in joblog you will have the start time of the job, then you can extract the joblog list joblog jobid=XXX |
|
|
Ok I checked, it's happening with (virtually) all jobs most likely. I attach matching logs here. I just anonimised the server names. bareos-logs.txt (10,486 bytes)
All logs from job around 15:03 2023-03-02 15:03:08.509 CET [479710] bareos@bareos ERROR: syntax error at or near ")" at character 34 2023-03-02 15:03:08.509 CET [479710] bareos@bareos STATEMENT: DELETE FROM File WHERE JobId IN () 2023-03-02 15:03:08.532 CET [479725] bareos@bareos ERROR: syntax error at or near ")" at character 34 2023-03-02 15:03:08.532 CET [479725] bareos@bareos STATEMENT: DELETE FROM File WHERE JobId IN () 2023-03-02 15:03:08.532 CET [479725] bareos@bareos ERROR: syntax error at or near ")" at character 39 2023-03-02 15:03:08.532 CET [479725] bareos@bareos STATEMENT: DELETE FROM BaseFiles WHERE JobId IN () 2023-03-02 15:03:08.555 CET [479726] bareos@bareos ERROR: syntax error at or near ")" at character 39 2023-03-02 15:03:08.555 CET [479726] bareos@bareos STATEMENT: DELETE FROM BaseFiles WHERE JobId IN () 2023-03-02 15:03:08.556 CET [479726] bareos@bareos ERROR: syntax error at or near ")" at character 46 2023-03-02 15:03:08.556 CET [479726] bareos@bareos STATEMENT: UPDATE Job SET PurgedFiles=1 WHERE JobId IN () 2023-03-02 15:03:08.579 CET [479727] bareos@bareos ERROR: syntax error at or near ")" at character 46 2023-03-02 15:03:08.579 CET [479727] bareos@bareos STATEMENT: UPDATE Job SET PurgedFiles=1 WHERE JobId IN () 2023-03-02 15:03:08.579 CET [479727] bareos@bareos ERROR: syntax error at or near ")" at character 38 2023-03-02 15:03:08.579 CET [479727] bareos@bareos STATEMENT: DELETE FROM JobMedia WHERE JobId IN () 2023-03-02 15:03:08.601 CET [479728] bareos@bareos ERROR: syntax error at or near ")" at character 38 2023-03-02 15:03:08.601 CET [479728] bareos@bareos STATEMENT: DELETE FROM JobMedia WHERE JobId IN () 2023-03-02 15:03:08.601 CET [479728] bareos@bareos ERROR: syntax error at or near ")" at character 33 2023-03-02 15:03:08.601 CET [479728] bareos@bareos STATEMENT: DELETE FROM Log WHERE JobId IN () 2023-03-02 15:03:08.624 CET [479729] bareos@bareos ERROR: syntax error at or near ")" at character 33 2023-03-02 15:03:08.624 CET [479729] bareos@bareos STATEMENT: DELETE FROM Log WHERE JobId IN () 2023-03-02 15:03:08.624 CET [479729] bareos@bareos ERROR: syntax error at or near ")" at character 43 2023-03-02 15:03:08.624 CET [479729] bareos@bareos STATEMENT: DELETE FROM RestoreObject WHERE JobId IN () 2023-03-02 15:03:08.647 CET [479730] bareos@bareos ERROR: syntax error at or near ")" at character 43 2023-03-02 15:03:08.647 CET [479730] bareos@bareos STATEMENT: DELETE FROM RestoreObject WHERE JobId IN () 2023-03-02 15:03:08.647 CET [479730] bareos@bareos ERROR: syntax error at or near ")" at character 44 2023-03-02 15:03:08.647 CET [479730] bareos@bareos STATEMENT: DELETE FROM PathVisibility WHERE JobId IN () 2023-03-02 15:03:08.670 CET [479731] bareos@bareos ERROR: syntax error at or near ")" at character 44 2023-03-02 15:03:08.670 CET [479731] bareos@bareos STATEMENT: DELETE FROM PathVisibility WHERE JobId IN () 2023-03-02 15:03:08.670 CET [479731] bareos@bareos ERROR: syntax error at or near ")" at character 48 2023-03-02 15:03:08.670 CET [479731] bareos@bareos STATEMENT: DELETE FROM NDMPJobEnvironment WHERE JobId IN () 2023-03-02 15:03:08.693 CET [479732] bareos@bareos ERROR: syntax error at or near ")" at character 48 2023-03-02 15:03:08.693 CET [479732] bareos@bareos STATEMENT: DELETE FROM NDMPJobEnvironment WHERE JobId IN () 2023-03-02 15:03:08.693 CET [479732] bareos@bareos ERROR: syntax error at or near ")" at character 38 2023-03-02 15:03:08.693 CET [479732] bareos@bareos STATEMENT: DELETE FROM JobStats WHERE JobId IN () 2023-03-02 15:03:08.715 CET [479733] bareos@bareos ERROR: syntax error at or near ")" at character 38 2023-03-02 15:03:08.715 CET [479733] bareos@bareos STATEMENT: DELETE FROM JobStats WHERE JobId IN () 2023-03-02 15:03:08.715 CET [479733] bareos@bareos ERROR: syntax error at or near ")" at character 109 2023-03-02 15:03:08.715 CET [479733] 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-03-02 15:03:08.737 CET [479734] bareos@bareos ERROR: syntax error at or near ")" at character 109 2023-03-02 15:03:08.737 CET [479734] 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-03-02 15:03:08.738 CET [479734] bareos@bareos ERROR: relation "cpy_tmp" does not exist at character 60 2023-03-02 15:03:08.738 CET [479734] bareos@bareos STATEMENT: UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp ) 2023-03-02 15:03:08.758 CET [479735] bareos@bareos ERROR: relation "cpy_tmp" does not exist at character 60 2023-03-02 15:03:08.758 CET [479735] bareos@bareos STATEMENT: UPDATE Job SET Type='B' WHERE JobId IN ( SELECT JobId FROM cpy_tmp ) 2023-03-02 15:03:08.759 CET [479735] bareos@bareos ERROR: relation "cpy_tmp" does not exist at character 70 2023-03-02 15:03:08.759 CET [479735] bareos@bareos STATEMENT: DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp ) 2023-03-02 15:03:08.779 CET [479736] bareos@bareos ERROR: relation "cpy_tmp" does not exist at character 70 2023-03-02 15:03:08.779 CET [479736] bareos@bareos STATEMENT: DELETE FROM Job WHERE Type='c' AND priorjobid IN ( SELECT JobId FROM cpy_tmp ) 2023-03-02 15:03:08.779 CET [479736] bareos@bareos ERROR: table "cpy_tmp" does not exist 2023-03-02 15:03:08.779 CET [479736] bareos@bareos STATEMENT: DROP TABLE cpy_tmp 2023-03-02 15:03:08.800 CET [479737] bareos@bareos ERROR: table "cpy_tmp" does not exist 2023-03-02 15:03:08.800 CET [479737] bareos@bareos STATEMENT: DROP TABLE cpy_tmp 2023-03-02 15:03:08.800 CET [479737] bareos@bareos ERROR: syntax error at or near ")" at character 33 2023-03-02 15:03:08.800 CET [479737] bareos@bareos STATEMENT: DELETE FROM Job WHERE JobId IN () 2023-03-02 15:03:08.821 CET [479738] bareos@bareos ERROR: syntax error at or near ")" at character 33 2023-03-02 15:03:08.821 CET [479738] bareos@bareos STATEMENT: DELETE FROM Job WHERE JobId IN () All job logs from same timestamp 02-Mar 15:03 backup4-dir JobId 1309: Start Backup JobId 1309, Job=xxx.example.com-postgresql-incr.2023-03-02_15.03.00_19 02-Mar 15:03 backup4-dir JobId 1309: Connected Storage daemon at mybackupserver:9103, encryption: TLS_CHACHA20_POLY1305_SHA256 TLSv1.3 02-Mar 15:03 backup4-dir JobId 1309: Encryption: TLS_CHACHA20_POLY1305_SHA256 TLSv1.3 02-Mar 15:03 backup4-dir JobId 1309: Connected Client: xxx.example.com at 5.22.209.36:9102, encryption: TLS_CHACHA20_POLY1305_SHA256 TLSv1.3 02-Mar 15:03 backup4-dir JobId 1309: Handshake: Immediate TLS 02-Mar 15:03 backup4-dir JobId 1309: Encryption: TLS_CHACHA20_POLY1305_SHA256 TLSv1.3 02-Mar 15:03 xxx.example.com JobId 1309: python3-fd-mod: Got lastBackupStopTime 1677762184 from restore object of job 1308 02-Mar 15:03 xxx.example.com JobId 1309: python3-fd-mod: Got lastLSN 000000BE/15000000 from restore object of job 1308 02-Mar 15:03 backup4-dir JobId 1309: Using Device "R-Incremental0001" to write. 02-Mar 15:03 xxx.example.com JobId 1309: Connected Storage daemon at mybackupserver:9103, encryption: TLS_CHACHA20_POLY1305_SHA256 TLSv1.3 02-Mar 15:03 xxx.example.com JobId 1309: Encryption: TLS_CHACHA20_POLY1305_SHA256 TLSv1.3 02-Mar 15:03 xxx.example.com JobId 1309: Extended attribute support is enabled 02-Mar 15:03 backup4-sd JobId 1309: Volume "vol-rincr-0013" previously written, moving to end of data. 02-Mar 15:03 xxx.example.com JobId 1309: ACL support is enabled 02-Mar 15:03 backup4-sd JobId 1309: Ready to append to end of Volume "vol-rincr-0013" size=230556187 02-Mar 15:03 xxx.example.com JobId 1309: python3-fd-mod: Connected to Postgres version 140006 02-Mar 15:03 xxx.example.com JobId 1309: python3-fd-mod: Current LSN 000000BE/1FA1DE18, last LSN: 000000BE/15000000 02-Mar 15:03 backup4-sd JobId 1309: Releasing device "R-Incremental0001" (/var/lib/bareos/storage). 02-Mar 15:03 backup4-sd JobId 1309: Elapsed time=00:00:04, Transfer rate=13.52 M Bytes/second 02-Mar 15:03 backup4-dir JobId 1309: Insert of attributes batch table with 11 entries start 02-Mar 15:03 backup4-dir JobId 1309: Insert of attributes batch table done 02-Mar 15:03 backup4-dir JobId 1309: Bareos backup4-dir 22.0.1 (02Jan23): Build OS: Debian GNU/Linux 11 (bullseye) JobId: 1309 Job: xxx.example.com-postgresql-incr.2023-03-02_15.03.00_19 Backup Level: Incremental, since=2023-03-02 14:03:03 Client: "xxx.example.com" 22.0.2 (07Feb23) Debian GNU/Linux 11 (bullseye),debian FileSet: "postgresql-incr" 2023-02-06 20:05:00 Pool: "R-Incremental" (From Job IncPool override) Catalog: "MyCatalog" (From Client resource) Storage: "R-Incremental" (From Pool resource) Scheduled time: 02-Mar-2023 15:03:00 Start time: 02-Mar-2023 15:03:04 End time: 02-Mar-2023 15:03:08 Elapsed time: 4 secs Priority: 10 FD Files Written: 12 SD Files Written: 12 FD Bytes Written: 54,111,292 (54.11 MB) SD Bytes Written: 54,115,873 (54.11 MB) Rate: 13527.8 KB/s Software Compression: 70.7 % (gzip3) VSS: no Encryption: no Accurate: no Volume name(s): vol-rincr-0013 Volume Session Id: 1250 Volume Session Time: 1675801957 Last Volume Bytes: 284,737,136 (284.7 MB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: OK SD termination status: OK Bareos binary info: Bareos subscription release Job triggered by: Scheduler Termination: Backup OK 02-Mar 15:03 backup4-dir JobId 1309: Begin pruning Jobs older than 6 months . 02-Mar 15:03 backup4-dir JobId 1309: Purging the following 0 JobIds: 02-Mar 15:03 backup4-dir JobId 1309: No Jobs found to prune. 02-Mar 15:03 backup4-dir JobId 1309: Begin pruning Files. 02-Mar 15:03 backup4-dir JobId 1309: No Files found to prune. 02-Mar 15:03 backup4-dir JobId 1309: End auto prune. |
|
|
If it was happening with almost all jobs, we would have those error in postgresql logs when running the systemtest which is unfortunately not the case. For example we are not able to reproduce the case of jobid in () ... We really wonder what is triggering this. Do you have any admin job routine or similar scripts doing purge,prune deleting volume, job client ? Thanks. |
|
|
The job is using these jobdefs JobDefs { Name = "FullRJob" Type = Backup Level = Full Client = xxxx.bla.com Write Bootstrap = "/var/lib/bareos/%c.bsr" Accurate = No Messages = Standard # Be careful not to start double jobs (since ran every hour by default) Allow Duplicate Jobs = No Allow Higher Duplicates = No Cancel Queued Duplicates = No Cancel Running Duplicates = No Allow Mixed Priority = True Priority = 10 Pool = R-Full Incremental Backup Pool = R-Incremental Differential Backup Pool = R-Differential Full Backup Pool = R-Full Run Script { RunsWhen = After RunsOnFailure = No FailJobOnError = No RunsOnClient = No console = ".bvfs_update jobid=%i" } } |
|
|
Thanks the jobdef is completely normal, The interesting part in job log is the run of autoprune/autopurge on client. I had to mention that this part of the code is deprecated (22) and will normally not trigger something. but still some queries seems to be run. 02-Mar 15:03 backup4-dir JobId 1309: Begin pruning Jobs older than 6 months . 02-Mar 15:03 backup4-dir JobId 1309: Purging the following 0 JobIds: 02-Mar 15:03 backup4-dir JobId 1309: No Jobs found to prune. 02-Mar 15:03 backup4-dir JobId 1309: Begin pruning Files. 02-Mar 15:03 backup4-dir JobId 1309: No Files found to prune. 02-Mar 15:03 backup4-dir JobId 1309: End auto prune. |
|
|
Well I saw similar errors in 21. But what part is deprecated? Can we no longer truncate? |
|
|
The part that is deprecated, is the autoprune parameter Files and Job normally attached to Client definition. Too many are hit by the purge done here, and then doesn't understand why they can't restore (or at least can see anymore jobs and files, while the volume is still valid). So the vast majority want to see into the database what they have on volumes, so mainly the pruning will occur on volume only soon. |
|
|
So I should remove this in the client def to resolve it? Client { Name = "xxx" .... AutoPrune = yes } What should I do instead to make sure old stuff is getting properly deleted timely from disk and database? Maybe I'm "overly" pruning atm :) |
|
|
So you can move Autoprune from yes to no (new default in 22 and will be removed afterwards) and check how your database is behaving. Check your volumes retention, has those will drive the pruning of jobs and files in DB. Of course the errors will not disappear completely (not all case belong to that part of the code), but should happen really less. |
|
|
Ok, I'll try to rely on the volumes, for example: Pool { Name = R-Incremental Storage = R-Incremental LabelFormat = "vol-rincr-" Pool Type = Backup Recycle = yes # Bareos can automatically recycle Volumes Auto Prune = yes # Prune expired volumes Volume Retention = 2 days # How long should jobs be kept? Maximum Volume Bytes = 100G # Limit Volume size to something reasonable -> Keep it small so it can be pruned fast Volume Use Duration = 23h Action On Purge = Truncate } ---> This would remove any volumes AND related jobs after 2 days maximum? Also remove from disk? I'm also using the always incremental scheme for certain jobs, I should "rely" on the always incremental system to do the pruning? I have these kind of settings there: Pool { Name = AI-Incremental Storage = AI-Incremental LabelFormat = "vol-incr-" Next Pool = AI-Consolidated Pool Type = Backup Recycle = yes # Bareos can automatically recycle Volumes Auto Prune = yes # Prune expired volumes Volume Retention = 120 days # How long should jobs be kept? <----- Keeping this as a safety measure for the moment, I expect alwaysincremental consolidate to cleanup properly ... ? Maximum Volume Bytes = 200G # Limit Volume size to something reasonable Volume Use Duration = 23h Action On Purge = Truncate } Pool { Name = AI-Consolidated Storage = AI-Consolidated LabelFormat = "vol-cons-" Pool Type = Backup Recycle = yes # Bareos can automatically recycle Volumes Auto Prune = yes # Prune expired volumes Volume Retention = 120 days # How long should jobs be kept? <----- Keeping this as a safety measure for the moment, I expect alwaysincremental consolidate to cleanup properly ... ? Maximum Volume Bytes = 200G # Limit Volume size to something reasonable Volume Use Duration = 23h Action On Purge = Truncate } Is this right? Because I have the feeling that not everything is removed always. Sometimes I find really old volumes, while tje always incremental scheme only has 20 days: JobDefs { Name = "AIJob" Type = Backup Level = Incremental Client = xxx Write Bootstrap = "/var/lib/bareos/%c.bsr" Accurate=yes Messages = Standard Always Incremental = yes Always Incremental Job Retention = 20 days # The resulting interval between full consolidations when running daily backups and daily consolidations is Always Incremental Max Full Age Dir Job - Always Incremental Job Retention Dir Job. Always Incremental Max Full Age = 30 days # should NEVER be less then Always Incremental Job Retention -> Every 15 days the full backup is also consolidated ( Always Incremental Max Full Age Dir Job - Always Incremental Job Retention Dir ) Always Incremental Keep Number = 6 # Guarantee that at least the specified number of Backup Jobs will persist, even if they are older than "Always Incremental Job Retention". Must be less than Always Incremental Job Retention # Maximum Concurrent Jobs = 10 # Let up to 10 jobs run # Max Virtual Full Interval = 20 days # Convert regular jobs to virtual full when this limit is passed Allow Mixed Priority = True Priority = 10 Pool = AI-Incremental Full Backup Pool = AI-Consolidated Run Script { RunsWhen = After RunsOnFailure = No FailJobOnError = No RunsOnClient = No console = ".bvfs_update jobid=%i" } } Job { Name = "Consolidate" Type = "Consolidate" Accurate = "yes" JobDefs = "DefaultJob" Schedule = "ConsolidateCycle" Max Full Consolidations = 500 # Don't limit on this, run as needed Maximum Concurrent Jobs = 1 Prune Volumes = yes # Priority = 11 ### Fix: Set same priority as other jobs so they can be mixed together Priority = 10 } How is it possible I still tumble on such old data in volumes from time to time? |
|
|
point a : yes (and no, because if the volume doesn't need to be pruned for example it will be kept intact, until it get recycled for writing a new job on) so starting after 2 days this volume may be pruned/recycled/truncated and jobs/files cleaned up if no other appendable volumes exist point b: yes in AI scheme the consolidation will prune the jobs/files once they get consolidated and you got that information at the end of the job. point c: Volumes in Error in Archive and job in Error, Cancel status will not be touched/pruned automatically. So a volume containing a failed incremental will be not purged because it still contain a job. Personally I've organised myself to do some admin cleanup from time to time to avoid such situation. |
|
|
Ok one final question regarding this truncating, is there anything that could be done about the example in attachment? This has been a volume from always incremental. The retention was for "safety" put on 8 months, but apparently nothing is left on it. Why is it keeping over 200 Gb of disk space on our storage? It's also not being reused or anything, how can this be solved since atm we need to cleanup a lot manually in order not to fill up our disks. |
|
|
You should first check what jobs are still existing on this volume, (bconsole query choice 13 or 14 to see if you want to prune/purge them You can then purge and truncate the volume. I've not seen disk filling up out of control with a good planning and estimation. |
|
|
Fixes to avoid running invalid queries will appear in https://github.com/bareos/bareos/pull/1512 A backport for future bareos 22.1.1 will be done afterwards. |
|
|
ok I can check the logs after we updated |
|
|
Fixes are provided in master with PR1512, backports will be done in PR1513 for next 22.1.1 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-02-28 16:01 | hostedpower | New Issue | |
| 2023-02-28 16:01 | hostedpower | File Added: sql_errors.txt | |
| 2023-03-02 09:51 | bruno-at-bareos | Note Added: 0004885 | |
| 2023-03-02 10:22 | hostedpower | Note Added: 0004886 | |
| 2023-03-02 14:11 | bruno-at-bareos | Note Added: 0004889 | |
| 2023-03-02 15:06 | hostedpower | Note Added: 0004893 | |
| 2023-03-02 15:06 | hostedpower | File Added: bareos-logs.txt | |
| 2023-03-02 16:18 | bruno-at-bareos | Note Added: 0004894 | |
| 2023-03-02 16:30 | hostedpower | Note Added: 0004895 | |
| 2023-03-06 12:03 | bruno-at-bareos | Note Added: 0004896 | |
| 2023-03-06 22:28 | hostedpower | Note Added: 0004899 | |
| 2023-03-07 09:59 | bruno-at-bareos | Note Added: 0004900 | |
| 2023-03-07 10:14 | hostedpower | Note Added: 0004901 | |
| 2023-03-07 12:12 | bruno-at-bareos | Note Added: 0004903 | |
| 2023-03-07 14:01 | hostedpower | Note Added: 0004905 | |
| 2023-03-07 15:17 | bruno-at-bareos | Note Added: 0004906 | |
| 2023-03-08 09:12 | hostedpower | Note Added: 0004907 | |
| 2023-03-08 09:12 | hostedpower | File Added: volume.png | |
| 2023-03-21 17:36 | bruno-at-bareos | Note Added: 0004920 | |
| 2023-07-18 16:08 | bruno-at-bareos | Note Added: 0005216 | |
| 2023-07-18 16:08 | bruno-at-bareos | Assigned To | => bruno-at-bareos |
| 2023-07-18 16:08 | bruno-at-bareos | Status | new => assigned |
| 2023-07-18 16:30 | hostedpower | Note Added: 0005217 | |
| 2023-07-18 17:14 | bruno-at-bareos | Status | assigned => closed |
| 2023-07-18 17:14 | bruno-at-bareos | Resolution | open => fixed |
| 2023-07-18 17:14 | bruno-at-bareos | Note Added: 0005220 |
