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
15-Jun 01:03 backup-dir: sql_create.c:851 INSERT INTO Filename (Name)
VALUES ('MUMS on DVD.pdf')
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
sql_create.c:853 Create db Filename record INSERT INTO Filename (Name)
VALUES ('MUMS on DVD.pdf') failed. ERR=Duplicate entry '1601844' for
key 1
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
catreq.c:428 Attribute create error. sql_create.c:853 Create db
Filename record INSERT INTO Filename (Name) VALUES ('MUMS on DVD.pdf')
failed. ERR=Duplicate entry '1601844' for key 1
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 ('MIS.tex') failed:
Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: sql_create.c:851 INSERT INTO Filename (Name)
VALUES ('MIS.tex')
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
sql_create.c:853 Create db Filename record INSERT INTO Filename (Name)
VALUES ('MIS.tex') failed. ERR=Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
catreq.c:428 Attribute create error. sql_create.c:853 Create db
Filename record INSERT INTO Filename (Name) VALUES ('MIS.tex') failed.
ERR=Duplicate entry '1601844' for key 1
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 ('MIS.tex.backup') failed:
Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: sql_create.c:851 INSERT INTO Filename (Name)
VALUES ('MIS.tex.backup')
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
sql_create.c:853 Create db Filename record INSERT INTO Filename (Name)
VALUES ('MIS.tex.backup') failed. ERR=Duplicate entry '1601844' for
key 1
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
catreq.c:428 Attribute create error. sql_create.c:853 Create db
Filename record INSERT INTO Filename (Name) VALUES ('MIS.tex.backup')
failed. ERR=Duplicate entry '1601844' for key 1
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 ('MIS.tex~') failed:
Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: sql_create.c:851 INSERT INTO Filename (Name)
VALUES ('MIS.tex~')
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
sql_create.c:853 Create db Filename record INSERT INTO Filename (Name)
VALUES ('MIS.tex~') failed. ERR=Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
catreq.c:428 Attribute create error. sql_create.c:853 Create db
Filename record INSERT INTO Filename (Name) VALUES ('MIS.tex~')
failed. ERR=Duplicate entry '1601844' for key 1
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 ('res_xsmall_7_1_0_0_0_0_0_0_0_0_2_2_5.0') failed:
Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: sql_create.c:851 INSERT INTO Filename (Name)
VALUES ('res_xsmall_7_1_0_0_0_0_0_0_0_0_2_2_5.0')
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
sql_create.c:853 Create db Filename record INSERT INTO Filename (Name)
VALUES ('res_xsmall_7_1_0_0_0_0_0_0_0_0_2_2_5.0') failed.
ERR=Duplicate entry '1601844' for key 1
15-Jun 01:03 backup-dir: fs2Backup.2007-06-15_01.00.02 Fatal error:
catreq.c:428 Attribute create error. sql_create.c:853 Create db
Filename record INSERT INTO Filename (Name) VALUES
('res_xsmall_7_1_0_0_0_0_0_0_0_0_2_2_5.0') failed. ERR=Duplicate entry
'1601844' for key 1
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 ('xsmall_7_200_1_0_0_0_0_0_0_0_0_2_2_500.mmp') failed:
Duplicate entry '1601844' for key 1
...
Any sugestions?
Thanks,
Pedro Mazzoni
-------------------------------------------------------------------------
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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
