[Bacula-users] Base Level Backup
Hi
Using Bacula V 7.2.0 and fairly new to bacula
I have a job definition as below, the backups themselves are working
However the base job, shows a level of full in the console (should it show a
level of base ??) and the full job is about the same size as the base job.
So to me it looks like the "base" functionality isn't working.
The underlying storage snapshot size is minimal, so there is very little file
change in the target.
The logs dont seem to tell me anything about the base functionallity being
active
Can anyone see what I have got wrong ?
How do I debug this ?
Thanks in advance
Mark
#
# ITC-CLG Backup Definition
#
JobDefs {
Name = "ITC-CLG"
Type = Backup
Level = Full
Client = peg-backup2015-fd
Storage = BackupFile
Messages = Standard
FileSet = ITC-CLG-Fileset
RunScript {
RunsWhen = Before
FailJobOnError = Yes
Command = "net use w: 10.151.254.220\\CLG-DATA /user:bacula
C0smicR*y"
RunsOnClient = yes
}
RunScript {
RunsWhen = After
FailJobOnError = No
Command = "net use w: /delete"
RunsOnClient = yes
}
}
Job {
Name = "ITC-CLG-Base"
Level = Base
JobDefs = "ITC-CLG"
Pool = ITC-CLG-DR-Base
Schedule = "BaseQuarterly-ITC-CLG"
}
Job {
Name = ITC-CLG-Full
Base = ITC-CLG-Base
Accurate = yes
JobDefs = "ITC-CLG"
Pool = ITC-CLG-DR-Backup
Schedule = "WeeklyFull-ITC-CLG"
}
--
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Catalog backup failing after system restore
thanks for the suggestion. Checked the database, bacula has all permissions granted. Ran that script before starting bacula. I do have another server that is running the same configuration. It shows the same table in the database and you can not access it as well. The difference being the catalog backup works on this system. thanks On Sun, May 15, 2016 at 11:38 PM, Davide Franco wrote: > Hi, > > Have you tried to to run the grant permission script on your database ? > > If the table does exist, it sounds to me a permissions issue. > > Good luck with recovering your catalog. > > Regards > > Davide > > On May 16, 2016 05:45, "Jerry Lowry" wrote: > > > > Hi all, > > > > I am just finished recovering a system disk boot failure on one of my > backup servers. It is running Centos (6.6/6.7 now); Mysql 5.6.28/5.6.30 > (now) and Bacula 5.2.13. > > Fortunately the system disk did not die, just some boot problem and I > could tell that it was not spinning like it should. So I was able to pull > the Bacula database directory from the old disk. I went ahead and > reinstalled all of the products and then was able get Mysql configured the > same way for Bacula. All of the system backups are working without any > problems, but the catalog backup is failing with the following errors: > > 15-May 13:25 kilchis-dir JobId 30402: shell command: run BeforeJob > "/usr/bacula/bin/make_catalog_backup.pl MyCatalog" > > 15-May 13:25 kilchis-dir JobId 30402: BeforeJob: Warning: Using unique > option prefix database instead of databases is deprecated and will be > removed in a future release. Please use the full name instead. > > 15-May 13:25 kilchis-dir JobId 30402: BeforeJob: Warning: mysqldump: > ignoring option '--databases' due to invalid value 'bacula' > > 15-May 13:25 kilchis-dir JobId 30402: BeforeJob: mysqldump: Got error: > 1146: Table 'bacula.RestoreObject' doesn't exist when using LOCK TABLES > > 15-May 13:41 kilchis-dir JobId 30402: BeforeJob: Error: Couldn't read > status information for table RestoreObject () > > 15-May 13:41 kilchis-dir JobId 30402: BeforeJob: mysqldump: Couldn't > execute 'show create table `RestoreObject`': Table 'bacula.RestoreObject' > doesn't exist (1146) > > 15-May 13:41 kilchis-dir JobId 30402: Error: Runscript: BeforeJob > returned non-zero status=2. ERR=Child exited with code 2 > > 15-May 13:41 kilchis-dir JobId 30402: Error: Bacula kilchis-dir 5.2.13 > (19Jan13) > > > > When I look at the database and try to select from that table, I get an > error saying the table does not exist. But it shows up when I do a 'show > tables;' in mysql. > > > > Does any one have any words or thoughts as to why this is failing? I > have not looked at the perl script yet, but it did not change as I am > running the same version as before. > > > > thanks for the help! > > > > jerry > > > > > > > -- > > Mobile security can be enabling, not merely restricting. Employees who > > bring their own devices (BYOD) to work are irked by the imposition of MDM > > restrictions. Mobile Device Manager Plus allows you to control only the > > apps on BYO-devices by containerizing them, leaving personal data > untouched! > > https://ad.doubleclick.net/ddm/clk/304595813;131938128;j > > ___ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > > -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Catalog backup failing after system restore
Hi, Have you tried to to run the grant permission script on your database ? If the table does exist, it sounds to me a permissions issue. Good luck with recovering your catalog. Regards Davide On May 16, 2016 05:45, "Jerry Lowry" wrote: > > Hi all, > > I am just finished recovering a system disk boot failure on one of my backup servers. It is running Centos (6.6/6.7 now); Mysql 5.6.28/5.6.30 (now) and Bacula 5.2.13. > Fortunately the system disk did not die, just some boot problem and I could tell that it was not spinning like it should. So I was able to pull the Bacula database directory from the old disk. I went ahead and reinstalled all of the products and then was able get Mysql configured the same way for Bacula. All of the system backups are working without any problems, but the catalog backup is failing with the following errors: > 15-May 13:25 kilchis-dir JobId 30402: shell command: run BeforeJob "/usr/bacula/bin/make_catalog_backup.pl MyCatalog" > 15-May 13:25 kilchis-dir JobId 30402: BeforeJob: Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. > 15-May 13:25 kilchis-dir JobId 30402: BeforeJob: Warning: mysqldump: ignoring option '--databases' due to invalid value 'bacula' > 15-May 13:25 kilchis-dir JobId 30402: BeforeJob: mysqldump: Got error: 1146: Table 'bacula.RestoreObject' doesn't exist when using LOCK TABLES > 15-May 13:41 kilchis-dir JobId 30402: BeforeJob: Error: Couldn't read status information for table RestoreObject () > 15-May 13:41 kilchis-dir JobId 30402: BeforeJob: mysqldump: Couldn't execute 'show create table `RestoreObject`': Table 'bacula.RestoreObject' doesn't exist (1146) > 15-May 13:41 kilchis-dir JobId 30402: Error: Runscript: BeforeJob returned non-zero status=2. ERR=Child exited with code 2 > 15-May 13:41 kilchis-dir JobId 30402: Error: Bacula kilchis-dir 5.2.13 (19Jan13) > > When I look at the database and try to select from that table, I get an error saying the table does not exist. But it shows up when I do a 'show tables;' in mysql. > > Does any one have any words or thoughts as to why this is failing? I have not looked at the perl script yet, but it did not change as I am running the same version as before. > > thanks for the help! > > jerry > > > -- > Mobile security can be enabling, not merely restricting. Employees who > bring their own devices (BYOD) to work are irked by the imposition of MDM > restrictions. Mobile Device Manager Plus allows you to control only the > apps on BYO-devices by containerizing them, leaving personal data untouched! > https://ad.doubleclick.net/ddm/clk/304595813;131938128;j > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
