>>>>> 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
-------------------------------------------------------------------------
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
|