Your message dated Mon, 11 Jan 2016 14:40:18 +0100
with message-id <[email protected]>
and subject line Re: bacula: PostgreSQL syntax error
has caused the Debian Bug report #764314,
regarding bacula: PostgreSQL syntax error
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
764314: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=764314
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: bacula
Version: 5.2.6+dfsg-9.3
Severity: important
Dear Maintainer,
*** Reporter, please consider answering these questions, where
appropriate ***
* What led up to the situation? Upgrade from 5.2.6+dfsg-9.2
* What exactly did you do (or not do) that was effective (or
ineffective)?
* What was the outcome of this action?
bacula=# SELECT DISTINCT j.JobId, j.Name AS JobName, j.Level,
j.ClientId, j.StartTime, j.EndTime, j.VolSessionId, j.VolSessionTime,
j.JobFiles, j.JobBytes, j.JobErrors, j.Reviewed, j.PoolId, j.FileSetId,
j.PurgedFiles, j.JobStatus, j.(NOW() - StartTime) AS DurationTime,
s.JobStatusLong, c.Name AS ClientName, p.Name AS PoolName FROM Job AS j
LEFT JOIN Status AS s ON j.JobStatus = s.JobStatus LEFT JOIN Client AS c
ON j.ClientId = c.ClientId LEFT JOIN Pool AS p ON j.PoolId = p.PoolId
WHERE ((j.EndTime IS NULL) OR (j.JobStatus IN
('C','R','B','e','F','S','m','M','s','j','c','d','t','p','i','a','l','L')))
AND (j.StartTime > ( NOW() - INTERVAL '7 days' )) ORDER BY StartTime
ASC, JobId ASC
;
ERROR: syntax error at or near "("
LINE 1: ...oolId, j.FileSetId, j.PurgedFiles, j.JobStatus, j.(NOW() -
S...
^
* What outcome did you expect instead?
*** End of the template - remove these template lines ***
-- System Information:
Debian Release: jessie/sid
APT prefers testing-updates
APT policy: (500, 'testing-updates'), (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.16-2-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages bacula depends on:
ii bacula-client 5.2.6+dfsg-9.3
ii bacula-common 5.2.6+dfsg-9.3
ii bacula-server 5.2.6+dfsg-9.3
bacula recommends no packages.
Versions of packages bacula suggests:
pn bacula-doc <none>
-- no debconf information
--- End Message ---
--- Begin Message ---
Version: 5.2.6+dfsg-9.3
Almost 5 months have passed with no further explanation under what
circumstances this error occurred, so I'm closing this bug.
Feel free to report a new bug or reopen this one when you can supply
more details.
Thanks,
leo
--- End Message ---
