Re: [Bacula-users] no full backup found

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.

strange indeed. its almost like bacula isn't/cant record the job results in the 
database. if that is indeed the case, shouldn't an error be thrown?


16-Jun 11:05 jenna-dir: Start Backup JobId 1511, Job=heather.2008-06-16_11.05.03
16-Jun 11:30 heather: DIR and FD clocks differ by 1486 seconds, FD 
automatically adjusting.
16-Jun 11:05 jenna-sd: Volume "Vol0050" previously written, moving to end of 
data.
heather:      Filesystem change prohibited. Will not descend into /dev
heather:      Filesystem change prohibited. Will not descend into /lib/init/rw
heather:      Filesystem change prohibited. Will not descend into /sys
16-Jun 11:06 jenna-dir: Bacula 1.38.11 (28Jun06): 16-Jun-2008 11:06:05
  JobId:                  1511
  Job:                    heather.2008-06-16_11.05.03
  Backup Level:           Incremental, since=2008-06-15 11:25:36
  Client:                 "heather" i486-pc-linux-gnu,debian,4.0
  FileSet:                "Full Set" 2007-09-21 11:05:01
  Pool:                   "Default"
  Storage:                "fs_device1"
  Scheduled time:         16-Jun-2008 11:05:02
  Start time:             16-Jun-2008 11:05:28
  End time:               16-Jun-2008 11:06:05
  Elapsed time:           37 secs
  Priority:               10
  FD Files Written:       62
  SD Files Written:       62
  FD Bytes Written:       14,344,478 (14.34 MB)
  SD Bytes Written:       14,350,643 (14.35 MB)
  Rate:                   387.7 KB/s
  Software Compression:   92.0 %
  Volume name(s):         Vol0050
  Volume Session Id:      7
  Volume Session Time:    1213548982
  Last Volume Bytes:      352,330,513 (352.3 MB)
  Non-fatal FD errors:    0
  SD Errors:              0
  FD termination status:  OK
  SD termination status:  OK
  Termination:            Backup OK

16-Jun 11:06 jenna-dir: Begin pruning Jobs.
16-Jun 11:06 jenna-dir: No Jobs found to prune.
16-Jun 11:06 jenna-dir: Begin pruning Files.
16-Jun 11:06 jenna-dir: No Files found to prune.
16-Jun 11:06 jenna-dir: End auto prune.




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