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.
Sample Shell Script:
--------------------
!/bin/sh
cd /etc/bacula
/usr/bin/bconsole << EOF
run job=BackupCatalog pool=Daily-File level=Full yes
run job=Migrate-Daily level=Full yes
EOF
--------------------
Background: The catalog backup failed last night because I did not
change the config file correctly from 1.39 to 2.0.3.
I fixed the problem and ran the above script, thinking that since I have
the "Maximum Concurrent Jobs" set to 1, it would first run the backup
then the migrate. But the Migrate job failed immediately (like it didn't
wait at all) with the "Database locked" error while the BackupCatalog
Job completed successfully sometime after that.
After the Backup finished I was able to run the Migrate Job and it
completed successfully as well.
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?
Question2: (Just to make things tougher) If I change "Max Concurrent
Jobs" to 4, is the scheduler smart enough to know that I don't want it
to look at the jobs for migration until everything else is done, or
should I do something like a "wait" command to force it?
Example:
---------------------------------------------------
if [ $backup_type = "daily" ]
then
/usr/bin/bconsole << EOF
run job=Ex1 SpoolData=yes pool=Daily-File level=Incremental yes
run job=TermServ pool=Daily-File level=Incremental yes
run job=Famous pool=Daily-File level=Incremental yes
run job=Famous-Oracle pool=Daily-File level=Incremental yes
run job=BackupCatalog pool=Daily-File yes
wait <------ Insert this line??
run job=Migrate-Daily yes
EOF
---------------------------------------------------
The above script snippet is what gets run (with the exception of the
"wait" command) at 1am for my daily backups.
Thanks for any help/insight you can provide.
Doug
-------------------------------------------------------------------------
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
