Hi,

25.04.2008 14:27, S.Lehmann8 AT DeutschePost DOT de wrote:
> Hello,
> 
> I think we found a bug in the migration job feature with PoolOccupancy.
> 
> Our environment:
> Bacula-dir 2.2.7 with postgresql 8
> 
> We have got the following error message:
> 23-Apr 11:30 bacula-dir JobId 1224: Fatal error: SQL failed. ERR=Query
> failed: SELECT DISTINCT Job.JobId,Job.StartTime FROM JobMedia,Job WHERE
> JobMedia.JobId=Job.JobId AND JobMedia.MediaId=25,9,26 AND Job.Type='B'
> ORDER by Job.StartTime: ERR=ERROR:  syntax error at or near "," at
> character 113
> 
> I think, the sql-syntax "JobMedia.MediaId=25,9,26" is not correct. IMHO
> correct would be "JobMedia.MediaId=in(25,9,26)". Testing the corrected
> sql-statement against the catalog returns the right result.

Looks quite straightforward.

I recommend you put this report into bugs.bacula.org as the main 
developers don't read the -users mailing list very closely.

> If this is truly a bug, it would be fine to be corrected in the next
> release. Patching every release for ourselves is horrible.

Definitely.

> Attached is the full status message.

It would be great if you attached your path to the bug report, too...

> Best regards
> 
> Sebastian Lehmann

Arno, also Lehmann

-- 
Arno Lehmann
IT-Service Lehmann
www.its-lehmann.de

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users