>>>>> On Sun, 15 Jun 2008 12:09:31 -0500, Terry L Inzauro said:

> i see this error every day. i know a full runs and completes successfully 
> every day.  any ideas whay the issue may be?
> 
> 
> ..snip from llist jobs
> 
> 
>            JobId: 1,498
>              Job: heather.2008-06-15_11.05.03
>             Name: heather
>      PurgedFiles: 0
>             Type: B
>            Level: F
>         ClientId: 9
>             Name: heather
>        JobStatus: T
>        SchedTime: 2008-06-15 11:05:02
>        StartTime: 2008-06-15 11:25:36
>          EndTime: 2008-06-15 11:29:38
>         JobTDate: 1,213,547,378
>     VolSessionId: 155
>   VolSessionTime: 1,211,146,570
>         JobFiles: 18,498
>        JobErrors: 0
>  JobMissingFiles: 0
>           PoolId: 1
>             Name: Default
>        FileSetId: 10
>          FileSet: Full Set
> 
> ...end snipt from llist jobs
> 
> ...snip from job error
> 
> 15-Jun 11:25 jenna-dir: sql_find.c:126 No Job record found: ERR=
> CMD=SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B' AND Level='F' 
> AND Name='heather' AND ClientId=9 AND FileSetId=10 ORDER BY
> StartTime DESC LIMIT 1
> 15-Jun 11:25 jenna-dir: No prior or suitable Full backup found. Doing FULL 
> backup.
> 
> ...end snip

Which version of Bacula?  Which database backend?

Does the SQL command

SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B' AND Level='F' AND 
Name='heather' AND ClientId=9 AND FileSetId=10 ORDER BY StartTime DESC LIMIT 1;

work when invoked via the console's sql command?

__Martin

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users