Bacula-users
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

Re: [Bacula-users] Error on Bacula job

2008-11-16 19:15:14
Subject: Re: [Bacula-users] Error on Bacula job
From: Daniel Bareiro <daniel-listas AT gmx DOT net>
To: bacula-users AT lists.sourceforge DOT net
Date: Sun, 16 Nov 2008 22:11:57 -0200 
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

Attachment: 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  Re: [Bacula-users] Looking for a better setup, John Drescher
Next by Date:  Re: [Bacula-users] Error on Bacula job, Arno Lehmann
Previous by Thread:  Re: [Bacula-users] Error on Bacula job, Arno Lehmann
Next by Thread:  Re: [Bacula-users] Error on Bacula job, Arno Lehmann
Indexes:  [Date] [Thread] [Top] [All Lists]