[Bacula-users] backup fails

[Flavio F. <ff...@dr...>]

Everything is very messed up.

Let me start from zero:

1. I upgraded bacula from 1.34.6 to 1.36.1 and bacula-dir refused to start=
=20
because of database incompatibility.=20
2. I deleted bacula database and tried to rebuild it with bscan.
3. someone told me on the list to use de update script
4. I stopped rebuilding the database and restored the last Bacula Catalog
5. Deleted the database, created a new one, recover the database with the=20
restored Catalog (version 1.34.6)=20
6. applied the update script which came out with NO errors
7. When I try to make any backup it does not work with messages below:

=2D------------------------------------------------------------------------=
=2D---------
30-Nov 12:00 zecolmeia-dir: OracleExport.2004-11-30_12.00.00 Error:=20
sql_update.c:111 sql_update.c:111 update UPDATE Job SET=20
JobStatus=3D'R',Level=3D'F',StartTime=3D'2004-11-30=20
12:00:02',ClientId=3D0,JobTDate=3D1101823202 WHERE JobId=3D1556 failed:
ERROR:  insert or update on table "job" violates foreign key constraint "$3"
DETAIL:  Key (clientid)=3D(0) is not present in table "client".

30-Nov 12:00 zecolmeia-dir: sql_update.c:111 UPDATE Job SET=20
JobStatus=3D'R',Level=3D'F',StartTime=3D'2004-11-30=20
12:00:02',ClientId=3D0,JobTDate=3D1101823202 WHERE JobId=3D1556
30-Nov 12:00 zecolmeia-dir: OracleExport.2004-11-30_12.00.00 Fatal error:=20
sql_update.c:111 update UPDATE Job SET=20
JobStatus=3D'R',Level=3D'F',StartTime=3D'2004-11-30=20
12:00:02',ClientId=3D0,JobTDate=3D1101823202 WHERE JobId=3D1556 failed:
ERROR:  insert or update on table "job" violates foreign key constraint "$3"
DETAIL:  Key (clientid)=3D(0) is not present in table "client".
=2D------------------------------------------------------------------------=
=2D----------

8. the list clients command in bacula console returns:

=2D------------------------------------------------------------------------=
=2D-------
|         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 |
=2D------------------------------------------------------------------------=
=2D--------

if no solution is available I going to reset the database. and restart back=
up=20
from zero, only keep actual files in case I have to recover any old backup.


I wish to know where bacula is getting this clientid =3D 0.



=2D-=20
Att.,

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