From: Flavio F. <ff...@dr...> - 2004-11-30 19:33:35
|
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) |