Martin Simmons wrote:
>>>>>> 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
sorry, i forgot to reply to the list:
the querey runs fine, but doesn't return any results:
OS = debian
bacula version = 1.38.11-8
SQL backend = mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using
readline 5.2
regards,
_Terry
-------------------------------------------------------------------------
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
|
