On Sunday, 16 November 2008 21:09:22 +0100, Arno Lehmann wrote: > Hi,
Hi Arno
> > I am using a JobDefs with three Jobs (servers) and although with two of
> > them I am not having problems, I am experiencing troubles with one of them.
> Are tho jobs set up identically, except for the client name?
Yes.
> > After the execution of the job, I receive a email with the following errors:
> >
> > -----------------------------------------------------------------------------
> > 16-Nov 01:13 backup1-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='Sdp2' AND ClientId=21 AND FileSetId=31 +ORDER BY
> > StartTime DESC LIMIT 1
> > 16-Nov 01:13 backup1-dir: No prior or suitable Full backup found. Doing
> > FULL backup.
> > 16-Nov 01:13 backup1-dir: Start Backup JobId 5231,
> > Job=Sdp2.2008-11-16_00.00.18
> > 16-Nov 01:17 sdp2-fd: Sdp2.2008-11-16_00.00.18 Fatal error: Error running
> > program: bash -c "find
> > +/space/backup/$HOSTNAME/*_etc.tar.gz ". RtnStat=268435457 ERR=Conseguido
> This seems to be a broken programm call... probably the file set
> definition is done with a program, and that programm isn't executed
> properly.
> What is shown in the output is definitely not a useful 'find'
> invocation.
> Can you post the relevant configuration setting, and also the result
> of the *identical* program call from the shell?
Of course.
bacula-dir.conf:
#################### Listado de JobDefs ###########################
JobDefs {
Name = "Bases"
Type = Backup
FileSet = "Bases"
Schedule = "CicloSemanal"
Storage = DLTDrive
Messages = Standard
Max Start Delay = 15h
Pool = Default
}
[...]
#################### Listado de Jobs ###########################
[...]
Job {
Name = "Sdp"
Client = sdp-fd
JobDefs = "Bases"
Priority = 14
Write Bootstrap = "/var/lib/bacula/sdp.bsr"
}
Job {
Name = "Sdpbkp"
Client = sdpbkp-fd
JobDefs = "Bases"
Priority = 15
Write Bootstrap = "/var/lib/bacula/sdpbkp.bsr"
}
[...]
Job {
Name = "Sdp2"
Client = sdp2-fd
JobDefs = "Bases"
Priority = 28
Write Bootstrap = "/var/lib/bacula/sdp2.bsr"
}
#################### Archivos a backupear ###########################
FileSet {
Name = "Bases"
Include {
Options {
signature = SHA1
wildfile = "*.bz2"
}
Options {
Exclude = yes
RegexFile = ".*"
}
# File = /space/backup/sdpbkp/oracle/export
File = "\\|bash -c \"echo /space/backup/$HOSTNAME/oracle/export/ \""
}
Include {
Options {
signature = SHA1
}
File = /etc
File = "\\|bash -c \"find /space/backup/$HOSTNAME/*_etc.tar.gz \""
File = "\\|bash -c \"find /space/backup/$HOSTNAME/oracle/controlfile/ \""
File = "\\|bash -c \"find /space/backup/$HOSTNAME/oracle/pfile/ \""
File = "\\|bash -c \"find /space/backup/$HOSTNAME/oracle/scripts/ \""
File = "\\|bash -c \"echo /space/backup/$HOSTNAME/pkg_list/ \""
File = "\\|bash -c \"echo /space/backup/$HOSTNAME/home/ \""
File = "\\|bash -c \"echo /space/log/$HOSTNAME/oracle/ \""
}
}
Notifications:
I sent the sdpd2 notification for november 14 in the previous mail, so I
will send only the one of the other two clients:
-----------------------------------------------------------------------------
15-Nov 00:07 backup1-dir: Start Backup JobId 5198,
Job=Sdpbkp.2008-11-15_00.00.05
15-Nov 00:12 sdpbkp-fd: DIR and FD clocks differ by 310 seconds, FD
automatically adjusting.
15-Nov 00:07 backup1-dir: Bacula 1.38.11 (28Jun06): 15-Nov-2008 00:07:39
JobId: 5198
Job: Sdpbkp.2008-11-15_00.00.05
Backup Level: Incremental, since=2008-11-14 00:09:38
Client: "sdpbkp-fd" i486-pc-linux-gnu,debian,4.0
FileSet: "Bases" 2008-07-08 22:10:11
Pool: "Incremental"
Storage: "DLTDrive"
Scheduled time: 15-Nov-2008 00:00:04
Start time: 15-Nov-2008 00:07:36
End time: 15-Nov-2008 00:07:39
Elapsed time: 3 secs
Priority: 15
FD Files Written: 5
SD Files Written: 5
FD Bytes Written: 13,094 (13.09 KB)
SD Bytes Written: 13,675 (13.67 KB)
Rate: 4.4 KB/s
Software Compression: None
Volume name(s): EducarIncremental0003
Volume Session Id: 6
Volume Session Time: 1226689534
Last Volume Bytes: 36,691,813,014 (36.69 GB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK
15-Nov 00:07 backup1-dir: Begin pruning Jobs.
15-Nov 00:07 backup1-dir: Pruned 0 Jobs for client sdpbkp-fd from
catalog.
15-Nov 00:07 backup1-dir: Begin pruning Files.
15-Nov 00:07 backup1-dir: No Files found to prune.
15-Nov 00:07 backup1-dir: End auto prune.
-----------------------------------------------------------------------------
15-Nov 00:07 backup1-dir: Start Backup JobId 5197,
Job=Sdp.2008-11-15_00.00.04
15-Nov 00:10 sdp-fd: DIR and FD clocks differ by 199 seconds, FD
automatically adjusting.
15-Nov 00:10 sdp-fd: Could not stat /space/log/sdp/oracle/: ERR=No
such file or directory
15-Nov 00:07 backup1-dir: Bacula 1.38.11 (28Jun06): 15-Nov-2008 00:07:32
JobId: 5197
Job: Sdp.2008-11-15_00.00.04
Backup Level: Incremental, since=2008-11-14 00:09:31
Client: "sdp-fd" i486-pc-linux-gnu,debian,4.0
FileSet: "Bases" 2008-07-08 22:10:11
Pool: "Incremental"
Storage: "DLTDrive"
Scheduled time: 15-Nov-2008 00:00:03
Start time: 15-Nov-2008 00:07:29
End time: 15-Nov-2008 00:07:32
Elapsed time: 3 secs
Priority: 14
FD Files Written: 2
SD Files Written: 2
FD Bytes Written: 3,010 (3.010 KB)
SD Bytes Written: 3,228 (3.228 KB)
Rate: 1.0 KB/s
Software Compression: None
Volume name(s): EducarIncremental0003
Volume Session Id: 5
Volume Session Time: 1226689534
Last Volume Bytes: 36,691,798,833 (36.69 GB)
Non-fatal FD errors: 1
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK -- with warnings
15-Nov 00:07 backup1-dir: Begin pruning Jobs.
15-Nov 00:07 backup1-dir: Pruned 0 Jobs for client sdp-fd from catalog.
15-Nov 00:07 backup1-dir: Begin pruning Files.
15-Nov 00:07 backup1-dir: No Files found to prune.
15-Nov 00:07 backup1-dir: End auto prune.
-----------------------------------------------------------------------------
As you see, the backup of sdp finishes OK but with warnings not having a
directory.
The reason by which I use "find" is because I wanted to have a unique
definition to use with all the installation of databases having common
directories among them whereas other directories are not.
Output of the program called from the shell:
1) sdp:
$bash -c "echo /space/backup/$HOSTNAME/oracle/export/ "
/space/backup/sdp/oracle/export/
$bash -c "find /space/backup/$HOSTNAME/*_etc.tar.gz "
/space/backup/sdp/20071121_etc.tar.gz
$bash -c "find /space/backup/$HOSTNAME/oracle/controlfile/ "
/space/backup/sdp/oracle/controlfile/
/space/backup/sdp/oracle/controlfile/controlfile.20080305
/space/backup/sdp/oracle/controlfile/controlfile.trace.20080609
/space/backup/sdp/oracle/controlfile/controlfile.20080206.updated
/space/backup/sdp/oracle/controlfile/controlfile.20080317
/space/backup/sdp/oracle/controlfile/controlfile.bin.20080609
/space/backup/sdp/oracle/controlfile/controlfile.20080206
/space/backup/sdp/oracle/controlfile/controlfile.20080305.updated
$bash -c "find /space/backup/$HOSTNAME/oracle/pfile/ "
/space/backup/sdp/oracle/pfile/
/space/backup/sdp/oracle/pfile/pfile.20080317
/space/backup/sdp/oracle/pfile/pfile.20080206
/space/backup/sdp/oracle/pfile/pfile.20080626
/space/backup/sdp/oracle/pfile/pfile.20080206.updated
/space/backup/sdp/oracle/pfile/pfile.20080609
/space/backup/sdp/oracle/pfile/pfile.20080305.updated
/space/backup/sdp/oracle/pfile/pfile.20080305
$bash -c "find /space/backup/$HOSTNAME/oracle/scripts/ "
/space/backup/sdp/oracle/scripts/
/space/backup/sdp/oracle/scripts/estadistica.sql
/space/backup/sdp/oracle/scripts/snap.ora
/space/backup/sdp/oracle/scripts/creau.sql
/space/backup/sdp/oracle/scripts/alert
/space/backup/sdp/oracle/scripts/alert/processes.sh
/space/backup/sdp/oracle/scripts/tamanio.sh
/space/backup/sdp/oracle/scripts/crontab
/space/backup/sdp/oracle/scripts/indices.sql
/space/backup/sdp/oracle/scripts/rman
/space/backup/sdp/oracle/scripts/rman/rman
/space/backup/sdp/oracle/scripts/rman/script.rcv
/space/backup/sdp/oracle/scripts/rman/rman.20070823
/space/backup/sdp/oracle/scripts/dbcache.sql
/space/backup/sdp/oracle/scripts/tam_act_max.sql
/space/backup/sdp/oracle/scripts/tamanio_tablas.sql
/space/backup/sdp/oracle/scripts/tamanio_ocupado.sql
/space/backup/sdp/oracle/scripts/mov_indices_users_indices.sql
/space/backup/sdp/oracle/scripts/listener.sh
/space/backup/sdp/oracle/scripts/tam_tablespace.sql
/space/backup/sdp/oracle/scripts/usuario_sql.sql
/space/backup/sdp/oracle/scripts/cont_script.sql
/space/backup/sdp/oracle/scripts/spool.sql
/space/backup/sdp/oracle/scripts/lis.sh
/space/backup/sdp/oracle/scripts/tamanio_TablasImportantes.sql
/space/backup/sdp/oracle/scripts/dealo.sql
/space/backup/sdp/oracle/scripts/sqlnet.log
/space/backup/sdp/oracle/scripts/export1.sql
/space/backup/sdp/oracle/scripts/comentados
/space/backup/sdp/oracle/scripts/comentados/estadistica.sql
/space/backup/sdp/oracle/scripts/comentados/snap.ora
/space/backup/sdp/oracle/scripts/comentados/creau.sql
/space/backup/sdp/oracle/scripts/comentados/crontab
/space/backup/sdp/oracle/scripts/comentados/indices.sql
/space/backup/sdp/oracle/scripts/comentados/dbcache.sql
/space/backup/sdp/oracle/scripts/comentados/tam_act_max.sql
/space/backup/sdp/oracle/scripts/comentados/tamanio_tablas.sql
/space/backup/sdp/oracle/scripts/comentados/mov_indices_users_indices.sql
/space/backup/sdp/oracle/scripts/comentados/tam_tablespace.sql
/space/backup/sdp/oracle/scripts/comentados/usuario_sql.sql
/space/backup/sdp/oracle/scripts/comentados/cont_script.sql
/space/backup/sdp/oracle/scripts/comentados/spool.sql
/space/backup/sdp/oracle/scripts/comentados/lis.sh
/space/backup/sdp/oracle/scripts/comentados/tamanio_TablasImportantes.sql
/space/backup/sdp/oracle/scripts/comentados/dealo.sql
/space/backup/sdp/oracle/scripts/comentados/analyze.sql
/space/backup/sdp/oracle/scripts/comentados/afiedt.buf
/space/backup/sdp/oracle/scripts/comentados/indi2.sql
/space/backup/sdp/oracle/scripts/comentados/iorep.sql
/space/backup/sdp/oracle/scripts/comentados/export.sql
/space/backup/sdp/oracle/scripts/tamanio.sh.20071012
/space/backup/sdp/oracle/scripts/analyze.sql
/space/backup/sdp/oracle/scripts/afiedt.buf
/space/backup/sdp/oracle/scripts/indi2.sql
/space/backup/sdp/oracle/scripts/iorep.sql
/space/backup/sdp/oracle/scripts/tamanio_ocupado_plus.sql
/space/backup/sdp/oracle/scripts/export.sql
$bash -c "echo /space/backup/$HOSTNAME/pkg_list/ "
/space/backup/sdp/pkg_list/
$bash -c "echo /space/backup/$HOSTNAME/home/ "
/space/backup/sdp/home/
$bash -c "echo /space/log/$HOSTNAME/oracle/ "
/space/log/sdp/oracle/
2) sdpbkp:
$bash -c "echo /space/backup/$HOSTNAME/oracle/export/ "
/space/backup/sdpbkp/oracle/export/
$bash -c "find /space/backup/$HOSTNAME/*_etc.tar.gz "
/space/backup/sdpbkp/20080707_etc.tar.gz
$bash -c "find /space/backup/$HOSTNAME/oracle/controlfile/ "
/space/backup/sdpbkp/oracle/controlfile/
/space/backup/sdpbkp/oracle/controlfile/controlfile.20080206.updated
/space/backup/sdpbkp/oracle/controlfile/controlfile.20080317
/space/backup/sdpbkp/oracle/controlfile/controlfile.bin.20080610
/space/backup/sdpbkp/oracle/controlfile/controlfile.20080206
/space/backup/sdpbkp/oracle/controlfile/controlfile.trace.20080610
$bash -c "find /space/backup/$HOSTNAME/oracle/pfile/ "
/space/backup/sdpbkp/oracle/pfile/
/space/backup/sdpbkp/oracle/pfile/pfile.20080317
/space/backup/sdpbkp/oracle/pfile/pfile.20080206
/space/backup/sdpbkp/oracle/pfile/pfile.20080610
/space/backup/sdpbkp/oracle/pfile/pfile.20080206.updated
$bash -c "find /space/backup/$HOSTNAME/oracle/scripts/ "
/space/backup/sdpbkp/oracle/scripts/
/space/backup/sdpbkp/oracle/scripts/estadistica.sql
/space/backup/sdpbkp/oracle/scripts/run_rebuild_INDEXES.sql
/space/backup/sdpbkp/oracle/scripts/tamanio.sh
/space/backup/sdpbkp/oracle/scripts/rman
/space/backup/sdpbkp/oracle/scripts/rman/rman
/space/backup/sdpbkp/oracle/scripts/rman/script.rcv
/space/backup/sdpbkp/oracle/scripts/rman/rman.20070823
/space/backup/sdpbkp/oracle/scripts/rman/rman.log
/space/backup/sdpbkp/oracle/scripts/dbcache.sql
/space/backup/sdpbkp/oracle/scripts/listener.sh
/space/backup/sdpbkp/oracle/scripts/indexmonitor_start.sql
/space/backup/sdpbkp/oracle/scripts/tamaño.sql
/space/backup/sdpbkp/oracle/scripts/spool.sql
/space/backup/sdpbkp/oracle/scripts/run_rebuild_INDEXES_CRASH-KBEE.sql
/space/backup/sdpbkp/oracle/scripts/crea_user.sql
/space/backup/sdpbkp/oracle/scripts/run_rebuild_INDEXES.sh
/space/backup/sdpbkp/oracle/scripts/kbee
/space/backup/sdpbkp/oracle/scripts/kbee/ora-kbee_index_buffer_log.sh
/space/backup/sdpbkp/oracle/scripts/run_update_STATISTIC.sh
/space/backup/sdpbkp/oracle/scripts/indexmonitor_stop.sql
/space/backup/sdpbkp/oracle/scripts/export1.sql
/space/backup/sdpbkp/oracle/scripts/mon
/space/backup/sdpbkp/oracle/scripts/mon/ora-so_proccess_mon.sh
/space/backup/sdpbkp/oracle/scripts/mon/ora-dbf_report_use.sh
/space/backup/sdpbkp/oracle/scripts/IndexMonitoring_startGenerator.sql
/space/backup/sdpbkp/oracle/scripts/IndexMonitoring_stopGenerator.sql
/space/backup/sdpbkp/oracle/scripts/afiedt.buf
/space/backup/sdpbkp/oracle/scripts/export.sql
/space/backup/sdpbkp/oracle/scripts/run_update_STATISTIC.sql
$bash -c "echo /space/backup/$HOSTNAME/pkg_list/ "
/space/backup/sdpbkp/pkg_list/
$bash -c "echo /space/backup/$HOSTNAME/home/ "
/space/backup/sdpbkp/home/
$bash -c "echo /space/log/$HOSTNAME/oracle/ "
/space/log/sdpbkp/oracle/
3) sdp2
$bash -c "echo /space/backup/$HOSTNAME/oracle/export/ "
/space/backup/sdp2/oracle/export/
$bash -c "find /space/backup/$HOSTNAME/*_etc.tar.gz "
find: /space/backup/sdp2/*_etc.tar.gz: No existe el fichero o el directorio
$bash -c "find /space/backup/$HOSTNAME/oracle/controlfile/ "
find: /space/backup/sdp2/oracle/controlfile/: No existe el fichero o el
directorio
$bash -c "find /space/backup/$HOSTNAME/oracle/pfile/ "
find: /space/backup/sdp2/oracle/pfile/: No existe el fichero o el directorio
$bash -c "find /space/backup/$HOSTNAME/oracle/scripts/ "
find: /space/backup/sdp2/oracle/scripts/: No existe el fichero o el directorio
$bash -c "echo /space/backup/$HOSTNAME/pkg_list/ "
/space/backup/sdp2/pkg_list/
$bash -c "echo /space/backup/$HOSTNAME/home/ "
/space/backup/sdp2/home/
$bash -c "echo /space/log/$HOSTNAME/oracle/ "
/space/log/sdp2/oracle/
These seem to be the four errors informed in the mail for sdp2 due to
the nonexistent directories. What I do not understand is why these are
fatal errors whereas the one of sdp is not it.
Thanks for your reply.
Regards,
Daniel
--
Daniel Bareiro - System Administrator
Fingerprint: BFB3 08D6 B4D1 31B2 72B9 29CE 6696 BF1B 14E6 1D37
Powered by Debian GNU/Linux Lenny - Linux user #188.598
signature.asc
Description: Digital signature
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
