Hi,

Nice. Should i create an entry in the bug-list?

Sebastian

> -----Ursprüngliche Nachricht-----
> Von: bacula-users-bounces AT lists.sourceforge DOT net 
> [mailto:bacula-users-bounces AT lists.sourceforge DOT net] Im 
> Auftrag von ebollengier
> Gesendet: Montag, 28. April 2008 20:16
> An: bacula-users AT lists.sourceforge DOT net
> Betreff: Re: [Bacula-users] BUG: Migration-Job with 
> PoolOccupancy fails
> 
> 
> 
> 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

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