Hi guys,
I'm using Version: 23.0.1~pre7.606b211eb (19 December 2023)
The following command does not work after I upgraded my server to Debian 12
and the database from postgres 13 to 15:
*list jobid=36197 hours=24
You have messages.
*m
03-Jan 08:54 bareos-dir JobId 0: Fatal error: cats/sql_list.cc:593
cats/sql_list.cc:593 query SELECT DISTINCT Job.JobId,Job.Name, Client.Name
as Client, Job.StartTime, CASE WHEN Job.endtime IS NOT NULL AND Job.endtime
>= Job.starttime THEN Job.endtime - Job.starttime ELSE CURRENT_TIMESTAMP(0)
- Job.starttime END as Duration,
Job.Type,Job.Level,Job.JobFiles,Job.JobBytes,Job.JobStatus FROM Job LEFT
JOIN Client ON Client.ClientId=Job.ClientId LEFT JOIN JobMedia ON
JobMedia.JobId=Job.JobId LEFT JOIN Media ON JobMedia.MediaId=Media.MediaId
LEFT JOIN FileSet ON FileSet.FileSetId=Job.FileSetId WHERE Job.JobId > 0
AND Job.JobId=36197AND Job.SchedTime > '2024-01-02 08:54:37' ORDER BY
StartTime; failed:
FEHLER: Müll folgt auf numerische Konstante bei »36197A«
ZEILE 1: ...d=Job.FileSetId WHERE Job.JobId > 0 AND Job.JobId=36197AND J...
Seems like the missing blank between the JobId and the `AND` in the
SQL-command is causing the trouble. Running the command without `hours=24`
works as expected:
*list jobid=36197
+-------+-------------------------------------------+------------------------------------+---------------------+----------+------+-------+----------+----------+-----------+
| jobid | name | client
| starttime | duration | type | level | jobfiles |
jobbytes | jobstatus |
+-------+-------------------------------------------+------------------------------------+---------------------+----------+------+-------+----------+----------+-----------+
| 36197 | backup-laptop-XXXX-fd | laptop-XXXX-fd | 2024-01-02 09:07:08 |
00:00:02 | C | I | 1 | 81 | T |
+-------+-------------------------------------------+------------------------------------+---------------------+----------+------+-------+----------+----------+-----------+
Does anyone know what could be the reason for this?
btw: I'm using this command inside a python script to regularly backup
remote clients.
Greetings, Jens
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to bareos-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/bareos-users/d901a186-f85f-4015-878e-a7956891b7c0n%40googlegroups.com.
