Hi,
On 6/1/2007 6:28 PM, Doug Breshears wrote:
> Arno Lehmann wrote:
>> Hi,
>>
>> On 5/31/2007 8:26 PM, Doug Breshears wrote:
>>
>>> I decided to create a new thread since it was different enough from the
>>> last one (Migration almost complete).
>>>
>>> ------------------------------------
>>> Version: 2.0.3
>>> Platform: Ubuntu Dapper (BTW, if anybody needs help creating debs for
>>> this I think I can help out)
>>> Problem: Migrate job failed with error ("database locked") when
>>> 'batched' with catalog backup run.
>>>
>> I never saw that message in my installations, I believe...
...
>>> Question: Did this happen just because the backup catalog job was
>>> running when bconsole tried to schedule the Migration Job? If that is
>>> the case then it would not happen normally, right?
>>>
>> I thnk youre right regarding both points. The process that locked the
>> catalog database was most probably the catalog dump. In my experience,
>> though, Bacula doesn't fail jobs you start, but the job setup is stalled
>> until the catalog can be accessed again.
One possible reason I just thought of: Which database are you using?
It's possible that MySQL, PostgreSQL and SQLite behave differently in
such a case.
>>
> Here is one of many messages with the same ending....
> 31-May 08:06 Ex1-dir: TermServ.2007-05-31_08.06.26 Fatal error:
> sql_create.c:91 sql_create.c:91 insert INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
> ('TermServ.2007-05-31_08.06.26','TermServ','B','I','C','2007-05-31
> 08:06:25',1180623985) failed:
> database is locked
>
>> There might be version differences, though, as I'm currently running 2.0.2.
>>
>>
>>> Question2: (Just to make things tougher)
...
>> Is there a special reason why you don't use the internal scheduler?
>>
>>
> When I first began, I could not figure out a way to do the
> daily/weekly/monthly (Incremental/Differential/Full) setup with the
> scheduler. Has something changed to make it easier? (Or is this another
> "Read the Manual again stupid" lesson?)
Probably :-)
As long as I know Bacula it supports schedules similar to what you give
below.
> If I remember correctly I had a hard time figuring out how to make one
> job replace another job depending on the date. It would be cool if a
> second version of the priority number could be used in this fashion to
> say, "If Multiple jobs are valid at any one time, then pick the one with
> the highest priority and do not schedule the others".
I admit I don't full understand what you're aiming at...
> In searching for a way to do this, I found a perl script that was
> "scheduled" with cron to fulfill this very purpose
> (http://www.georglutz.de/wiki/Bacula). I hacked it to meet my needs and
> it works.
> I just saw this on this
> (http://www.fosdem.org/2007/slides/maintracks/bacula.pdf) page.
> Schedule {
> Name = “Weekly Cycle”
> Run = Level=Full 1st sun at 2:05
> Run = Level=Differential 2nd-5st sun at 2:05
> Run = Level=Incremental mon-sat at 2:05
> }
> And that is close to what I wanted. Not sure if I am just less picky now
> or if I did not know about it back then...
> Is there any "First/Last day of month" tags?
Unfortunately not.
> Of course then we would
> have the conflict that would have to be resolved with some type of
> priority flag so multiple runs did not happen at once.
Yes... or Bacula would have to be clever enough to not consider lines
like "Run=Level=Incremental mon-fri at 20:00" if a line like
"Run=Level=Full 1st jan-dec at 20:00" matched. Something like precedence
of time statements. I don't even know if that doesn't exist already :-)
Arno
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
