Hello,
Thanks, this have been fixed for next release.
Bye
S.Lehmann8 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.
>
> 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
>
> Run Migration job
> JobName: MigrateIfWatermark
> Bootstrap: *None*
> Client: BACULA-TEST
> FileSet: LinuxFullSet
> Pool: Disk (From Job resource)
> Read Storage: File (From Pool resource)
> Write Storage: DLT-8000 (From Storage from Pool's NextPool resource)
> JobId: *None*
> When: 2008-04-23 11:30:12
> Catalog: MyCatalog
> Priority: 10
> OK to run? (yes/mod/no): yes
> Job queued. JobId=1224
> You have messages.
> *mess
> 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,3,27,4,28,5,30,6,31,7,32,8 AND Job.Type='B' ORDER
> by Job.StartTime: ERR=ERROR: syntax error at or near "," at character 113
>
>
> 23-Apr 11:30 bacula-dir JobId 1224: Bacula bacula-dir 2.2.8 (26Jan08):
> 23-Apr-2008 11:30:19
> Build OS: i486-pc-linux-gnu debian 4.0
> Prev Backup JobId: 0
> New Backup JobId: 0
> Migration JobId: 1224
> Migration Job: MigrateIfWatermark.2008-04-23_11.30.30
> Backup Level: Full
> Client: BACULA-TEST
> FileSet: "LinuxFullSet"
> Read Pool: "Disk" (From Job resource)
> Read Storage: "File" (From Pool resource)
> Write Pool: "Disk" (From Job resource)
> Write Storage: "DLT-8000" (From Storage from Pool's NextPool
> resource)
> Start time: 23-Apr-2008 11:30:19
> End time: 23-Apr-2008 11:30:19
> Elapsed time: 0 secs
> Priority: 10
> SD Files Written: 0
> SD Bytes Written: 0 (0 B)
> Rate: 0.0 KB/s
> Volume name(s):
> Volume Session Id: 0
> Volume Session Time: 0
> Last Volume Bytes: 0 (0 B)
> SD Errors: 0
> SD termination status:
> Termination: Migration -- no files to migrate
>
> *
> -------------------------------------------------------------------------
> 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
>
--
View this message in context:
http://www.nabble.com/BUG%3A-Migration-Job-with-PoolOccupancy-fails-tp16896330p16944889.html
Sent from the Bacula - Users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
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
|