Falk Sauer wrote:
> Hi Robert,
> 
> On Montag 15 Juni 2009 06:13:21 wrote:
>> Falk Sauer wrote:
>>> Hi Bob,
>>>
>>> On Sonntag 14 Juni 2009 23:35:43 wrote:
>>>> I have installed both 3.0.0 & 3.0.1 on a test sever using the
>>>> same configuration and hardware as my production serer.
>>>> Everything works as expected until I enable accurate backups. I
>>>> can run a level full backup which runs with no problem but when
>>>> I try an incremental i get this error.
>>>>
>>>> JobId 2: Start Backup JobId 2,
>>>> Job=Ws-104.2009-06-14_13.42.24_05 JobId 2: Created new Volume
>>>> "DDS4-Daily_Vol-002" in catalog. JobId 2: Using Device "DDS4-1"
>>>> JobId 2: Fatal error: Cannot find previous jobids.
>>>>
>>>>
>>>> and the email from the job contains this:
>>>>
>>>> JobId 2: Start Backup JobId 2,
>>>> Job=Ws-104.2009-06-14_13.42.24_05 JobId 2: Created new Volume
>>>> "DDS4-Daily_Vol-002" in catalog. JobId 2: Using Device "DDS4-1"
>>>> JobId 2: Fatal error: Cannot find previous jobids.
>>>> JobId 2: Fatal error: Network error with FD during Backup:
>>>> ERR=Interrupted system call
>>>> JobId 2: Job Ws-104.2009-06-14_13.42.24_05 marked to be
>>>> canceled. JobId 2: Fatal error: No Job status returned from FD.
>>>> JobId 2: Error: Bacula Ws-104-dir 3.0.1 (30Apr09): 14-Jun-2009
>>>> 13:45:32
>>>>
>>>>
>>>> The only thing that is see when running bacula with debug
>>>> enabled is some connection time out errors. These errors don't
>>>> occur when I disable accurate backups.
>>>>
>>>> OS is Solaris 10-5/09 X86
>>>>
>>>> Any idea what may be causing this?
>>> assumed bacula has no error in this new function ...
>>> sounds like a performance problem with your database. Can you
>>> try this again with a very small job and a new database?
>>>
>>> Regards
>>>    Falk
>> Since this is a test server i have tried many different size jobs
>> from 20mb to 20gb all still with the same results :( I'm using
>> MySQL 4.0.31. This error returns almost instantly after the job
>> starts.
>>
>> I have also just noticed that i cannot select individual files
>> when doing a restore the error basically equates to
>>
>> Building directory tree for JobId(s) 1 ...  Query failed:
>> -snip-
>> ASC: ERR=You have an error in your SQL syntax.
> 
> can you find this sql query in your debug output? If yes put it in 
> your mySqlAdmin and try this sql statement alone, then you see if 
> the sql syntax is really broken or what the error can be in your 
> database ... possibly you hit a problem with charactersets or 
> filenames.

> Regards
>    Falk
> 

Ok i can confirm that th query does fail when entered manualy into mysql

building directory tree for JobId(s) 1 ...  Query failed: SELECT Path.Path,
Filename.Name, File.FileIndex, File.JobId, File.LStat FROM ( SELECT 
max(FileId)
as FileId, PathId, FilenameId FROM (SELECT FileId, PathId, FilenameId FROM
File WHERE JobId IN (1)) AS F GROUP BY PathId, FilenameId ) AS Temp JOIN
Filename ON (Filename.FilenameId = Temp.FilenameId) JOIN Path ON
(Path.PathId = Temp.PathId) JOIN File ON (File.FileId = Temp.FileId) WHERE
File.FileIndex > 0 ORDER BY JobId, FileIndex

ASC: ERR=You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the right
syntax to use near
'SELECT max(FileId) as FileId, PathId, FilenameId FROM (SELECT F

There were no files inserted into the tree, so file selection
is not possible.Most likely your retention policy pruned the files

Do you want to restore all the files? (yes|no):

Thanks for looking into this... I know nothing about data querys.
Bob

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users