Hi,
29.04.2008 12:27, S.Lehmann8 AT DeutschePost DOT de wrote:
> Hi,
>
> Nice. Should i create an entry in the bug-list?
That's probably not necessary... I guess Eric would close the bug
immediately now. Of course, if you want it, for reference, documented,
in the bugs database feel free to add it (plus the fact that it's been
fixed in svn).
Arno
> 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
>>
>
--
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
|
