Bacula-users

[Bacula-users] Fatal Error doing Full Backup

2008-11-11 04:02:15
Subject: [Bacula-users] Fatal Error doing Full Backup
From: "Isabel Bermejo" <ibermejo AT inmoecheverria DOT com>
To: <bacula-users AT lists.sourceforge DOT net>
Date: Tue, 11 Nov 2008 10:00:46 +0100
Hi,
I'm using Bacula to backup servers into files (not tapes). One of the
servers has to backup 30GB of information. It has been working fine for 2
years but 3 weeks ago I received a Fatal Error message.

Here I post a little bit of the message (it's too large):
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Fatal error:
sql_create.c:564 sql_create.c:564 insert INSERT INTO File
(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES
(42322,10216,14961,17509,'MK EgAR IH0 B IM IM A SXHu BAA CTY BJEhK1 BCNzD+
BFE418 A A E','0') failed:
database is locked
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Fatal error:
sql_create.c:566 Create db File record INSERT INTO File
(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES
(42322,10216,14961,17509,'MK EgAR IH0 B IM IM A SXHu BAA CTY BJEhK1 BCNzD+
BFE418 A A E','0') failed. ERR=database is locked10-Nov 22:40 iesa8-dir:
BackupIESA4.2008-11-10_21.30.00 Fatal error: catreq.c:346 Attribute create
error. sql_create.c:566 Create db File record INSERT INTO File
(FileIndex,JobId,PathId,FilenameId
LStat,MD5) VALUES (42322,10216,14961,17509,'MK EgAR IH0 B IM IM A SXHu BAA
CTY BJEhK1 BCNzD+ BFE418 A A E','0') failed. ERR=database is locked10-Nov
22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: sql_update.c:65
sql_update.c:65 update UPDATE File SET MD5='9+U+v++at+/7+hddu/+SNC' WHERE
FileId=0 failed:
database is locked

10-Nov 22:40 iesa8-sd: BackupIESA4.2008-11-10_21.30.00 Fatal error: Could
not create JobMedia record for Volume="iesa4-0003"
Job=BackupIESA4.2008-11-10_21.30.00
10-Nov 22:40 iesa8-dir: Max Volume jobs exceeded. Marking Volume
"iesa4-0003" as Used.
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error:
sql_update.c:276 sql_update.c:276 update UPDATE Media SET
FirstWritten='2008-11-10 21:30:02' WHERE VolumeName='iesa4-0003' failed:
database is locked
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error:
sql_update.c:327 sql_update.c:327 update UPDATE Media SET
VolJobs=1,VolFiles=0,VolBlocks=258801,VolBytes=16695744573,VolMounts=88,VolE
rrors=0,VolWrites=4719577,MaxVolBytes=0,LastWritten='2008-11-10
22:40:56',VolStatus='Used',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0
WHERE VolumeName='iesa4-0003' failed:
database is locked
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: Catalog error
updating volume "iesa4-0003". ERR=sql_update.c:327 update UPDATE Media SET
VolJobs=1,VolFiles=0,VolBlocks=258801,VolBytes=16695744573,VolMounts=88,VolE
rrors=0,VolWrites=4719577,MaxVolBytes=0,LastWritten='2008-11-10
22:40:56',VolStatus='Used',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0
WHERE VolumeName='iesa4-0003' failed:
database is locked
10-Nov 22:40 iesa4-fd: BackupIESA4.2008-11-10_21.30.00 Fatal error: Bad
status 102 returned from Storage Daemon.
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error:
sql_update.c:166 sql_update.c:166 update UPDATE Job SET JobStatus='f',
EndTime='2008-11-10 22:40:56', ClientId=23, JobBytes=16666528723,
JobFiles=43815, JobErrors=0, VolSessionId=25, VolSessionTime=1226321423,
PoolId=41, FileSetId=50, JobTDate=1226353256 WHERE JobId=10216 failed:
database is locked
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Warning: Error
updating job record. sql_update.c:166 update UPDATE Job SET JobStatus='f',
EndTime='2008-11-10 22:40:56', ClientId=23, JobBytes=16666528723,
JobFiles=43815, JobErrors=0, VolSessionId=25, VolSessionTime=1226321423,
PoolId=41, FileSetId=50, JobTDate=1226353256 WHERE JobId=10216 failed:
database is locked
10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: Bacula 1.36.3
(22Apr05): 10-Nov-2008 22:40:56
  JobId:                  10216
  Job:                    BackupIESA4.2008-11-10_21.30.00
  Backup Level:           Full
  Client:                 iesa4-fd
  FileSet:                "iesa4" 2008-10-21 21:30:02
  Pool:                   "iesa4Pool"
  Storage:                "iesa4FileStorage"
  Start time:             10-Nov-2008 21:30:02
  End time:               10-Nov-2008 22:40:56
  FD Files Written:       0
  SD Files Written:       43,815
  FD Bytes Written:       0
  SD Bytes Written:       16,674,228,256
  Rate:                   0.0 KB/s
  Software Compression:   44.4 %
  Volume name(s):         iesa4-0003
  Volume Session Id:      25
  Volume Session Time:    1226321423
  Last Volume Bytes:      15,998,975,041
  Non-fatal FD errors:    2
  SD Errors:              0
  FD termination status:  Error
  SD termination status:  Error
  Termination:            *** Backup Error ***

This message appears only when doing Full Backup. Does anyone know what is
the problem? I've read it could be the amount of data I'm backing up but
this has been working fine till 3 weeks ago. I'm using Bacula 1.38 and I
haven't modified nothing at all because it was working fine.

Thank you
ISABEL


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>