Martin Simmons wrote:
>>>>>> On Mon, 16 Jun 2008 14:56:34 -0500, Terry L Inzauro said:
>> Terry L. Inzauro wrote:
>>> 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
>>>
>>>
>> the jobid and a bunch more jobid's don't show up in the output of "list
>> jobs" in bconsole. in fact, "list jobs" only shows one backup having any
>> size and completing successfully. furthermore, i had two incrementals
>> complete fine today. so i looked for those jobid's and they don't show up
>> either. see attached email for jobid 1511.
>>
>> strange indeed. its almost like bacula isn't/cant record the job results in
>> the database.
>
> Maybe the disk is full or your db is corrupted? Mysql has some tools for
> checking this.
>
> __Martin
i thought about the DB being corrupt as well. so i ran mysqlcheck on all the
tables.....the results were good. i think i have an issue with the
settings of data retention. is it possible the jobs/volumes are being recycled
prematurely thus removing the record of the previous backup?
-------------------------------------------------------------------------
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
|