[Bacula-users] BUG: Migration-Job with PoolOccupancy fails

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.

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

Attached is the full status message.


Best regards

Sebastian Lehmann

Bacula BUG Migration PoolOccupancy.txt
Description: Bacula BUG Migration PoolOccupancy.txt

-------------------------------------------------------------------------
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