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.