Pedro Henrique Morsch Mazzoni wrote:
> Hi everyone,
>
> I´m having some problems with the mysql db and bacula.
> The scheduleds jobs keeps failing, it seems I have a inconsistency in
> the tables.
> I don´t know if the problem is related, but some of my incremental
> volumes(disk backup) keep growing abnormally.
> The output of the jobs is huge, here´s a example:
>
> ...
> 15-Jun 01:02 backup-dir: Start Backup JobId 4929,
> Job=fs2Backup.2007-06-15_01.00.02
> 15-Jun 00:52 fs2-fd: DIR and FD clocks differ by -612 seconds, FD
> automatically adjusting.
> 15-Jun 01:02 backup-sd: Volume "fs2Inc-0002" previously written,
> moving to end of data.
> 15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
> sql_create.c:851 sql_create.c:851 insert INSERT INTO Filename (Name)
> VALUES ('MUMS on DVD.pdf') failed:
> Duplicate entry '1601844' for key 1
It looks like your catalog database got mucked up somehow. First thing I'd
try is to shut down the director, and have mysql check the tables to make sure
they're not corrupt on a low level.
http://dev.mysql.com/doc/refman/5.0/en/repair.html
Once that's done, use the dbcheck program to make sure the data contained are
consistent.
http://bacula.org/rel-manual/Volume_Utility_Tools.html#SECTION0039120000000000000000
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
