Backup Central

After upgrading from 1.34.6 to 1.36.1 i have deleted the database because=20
bacula-dir refused to start. As someone suggested on this list I recover th=
e=20
old database and applied the update script.
Nao when I start a job this comes out.

In fact there's no client-id 0
| 1 | oracle-fd | 5,184,000 | 15,552,000 |
| 2 | johnnybravo-fd | 5,184,000 | 15,552,000 |
| 3 | panoramix-fd | 5,184,000 | 15,552,000 |
| 4 | ideiafix-fd | 5,184,000 | 15,552,000 |
| 5 | zecolmeia-fd | 5,184,000 | 15,552,000 |
| 6 | doodle-fd | 5,184,000 | 15,552,000 |
| 7 | gargamel-fd | 5,184,000 | 15,552,000 |

how to fix it?

thanks for your attention.

=2D--------- Forwarded Message ----------

Subject: Bacula: Backup Fatal Error of zecolmeia-fd Full
Date: Monday 29 November 2004 10:43
=46rom: Bacula <ff < at > fu...>
To: ff < at > fu...

29-Nov 10:43 zecolmeia-dir: BackupCatalog.2004-11-29_10.43.53 Error:
sql_update.c:111 sql_update.c:111 update UPDATE Job SET
JobStatus=3D'R',Level=3D'F',StartTime=3D'2004-11-29
10:43:55',ClientId=3D0,JobTDate=3D1101732235 WHERE JobId=3D1532 failed: ER=
ROR:=20
insert or update on table "job" violates foreign key constraint "$3" DETAI=
L:
Key (clientid)=3D(0) is not present in table "client".

29-Nov 10:43 zecolmeia-dir: sql_update.c:111 UPDATE Job SET
JobStatus=3D'R',Level=3D'F',StartTime=3D'2004-11-29
10:43:55',ClientId=3D0,JobTDate=3D1101732235 WHERE JobId=3D1532 29-Nov 10:=
43
zecolmeia-dir: BackupCatalog.2004-11-29_10.43.53 Fatal error:
sql_update.c:111 update UPDATE Job SET
JobStatus=3D'R',Level=3D'F',StartTime=3D'2004-11-29
10:43:55',ClientId=3D0,JobTDate=3D1101732235 WHERE JobId=3D1532 failed: ER=
ROR:=20
insert or update on table "job" violates foreign key constraint "$3" DETAI=
L:
Key (clientid)=3D(0) is not present in table "client".

=2D------------------------------------------------------

=2D-=20
Att.,

=46l=E1vio Fonseca
Equipe Divis=E3o de Redes (DR)
Diretoria de Processamento de Dados (DirPD)
Universidade Federal de Uberlandia (UFU)

Hello,

I am with bacula installed in one linux opensuse 10,0 functioning well…
but I am with one doubts: Backup is made in disk, each server that I
make backup has a own volume . Backup FULL is made a time for month and
the Incremental one is made daily. The problem is that backup FULL is
not overlapping the previous and the archive of backup is growing very.
Which the ideal configuration to decide this? It follows below my
archive of configuration, thanks for help:

Director { # define myself
Name = backup-dir
DIRport = 9101 # where we listen for UA connections
QueryFile = "/etc/bacula/query.sql"
WorkingDirectory = "/var/bacula/working"
PidDirectory = "/var/run"
Maximum Concurrent Jobs = 1
Password = "prolinx" # Console password
Messages = Standard
}

# Define the backup Job (Speculu)
Job {
Name = "speculu"
Type = Backup
Level = Incremental # default
Client=speculu-fd
FileSet="speculu"
Schedule = "WeeklyCycle"
Storage = backup-sd
Messages = Standard
Pool = speculu
}
Job {
Name = "portlinux"
Type = Backup
Level = Incremental # default
Client=portlinux-fd
FileSet="portlinux"
Schedule = "WeeklyCycle"
Storage = backup-sd
Messages = Standard
Pool = portlinux
}
Job {
Name = "Restore_portlinux"
Type = Restore
Client=portlinux-fd
FileSet="portlinux"
Where = /tmp/bacula-restores
Storage = backup-sd
Messages = Standard
Pool = portlinux
}
FileSet {
Name = "speculu"
Include {
Options { signature=SHA1 compression=GZIP }
File = /etc
File = /var/named
File = /usr/local/squid/etc
File = /boot
File = /home
}
Exclude {}
}

FileSet {
Name = "portlinux"
Include {
Options { signature=SHA1 compression=GZIP }
File = /etc
File = /boot
File = /home
File = /dominios
File = /usr/local/sbin
File = /var/backupbases
}
Exclude {}
}
Schedule {
Name = "WeeklyCycle"
Run = Full 1st sun at 08:00
Run = Incremental mon-sat at 20:00
}

Schedule {
Name = "WeeklyCycleAfterBackup"
Run = Level=Full sun-sat at 2:00
}
# Client (File Services) to backup
Client {
Name = speculu-fd
Address = 172.16.10.250
Catalog = speculu
Password = "prolinx"
File Retention = 60d # sixty day file retention
Job Retention = 180d # 1 year Job retention
AutoPrune = yes # Auto apply retention periods
}

Client {
Name = portlinux-fd
Address = 172.16.10.253
Catalog = portlinux
Password = "prolinx"
File Retention = 60d # sixty day file retention
Job Retention = 180d # 1 year Job retention
AutoPrune = yes # Auto apply retention periods
}

Storage {
Name = backup-sd
Address = 172.16.10.252 # N.B. Use a fully qualified name here
SDPort = 9103
Password = "prolinx"
Device = Disco
Media Type = File
}

Pool {
Name = portlinux
Pool Type = Backup
AutoPrune = yes
Recycle = yes
Label Format = portlinux
}

Pool {
Name = mateus
Pool Type = Backup
AutoPrune = yes
Recycle = yes
Label Format = mateus
}

--
Angelo Braga
Prolinx Informatica
http://www.prolinx.com.br
Skype: prolinxinformatica
(31)3234-2931
(31)8415-6896