>>>>> On Tue, 17 Jun 2008 06:37:39 -0500, Terry L Inzauro said:
>
> 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?
It is possible. The bacula log/bconsole messages should show something about
prune/pruning/recycling.
Have you tried setting Mysql to log all queries? That will show what bacula
is doing to the db.
__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
|