SearchFAQMemberlist Log in
Reply to topic Page 1 of 1
Bacula fatal Error [SEC=UNCLASSIFIED]
Author Message
Post Bacula fatal Error [SEC=UNCLASSIFIED] 
UNCLASSIFIED
Hi,

I still haven't been able to resolve this fatal Error -

After 4 days of waiting for a backup to finish I get the following
errors - The first could be caused by a user being inpatient and
deleting a file before Bacula was finished with it - the second is a
problem report previously but with no solution - I've tried to change
the /tmp file location in bacula but mysql? Still seems to be reading
/tmp ..... How do I change this for mysql? The error 28 - What does this
mean?

I hope somebody can help me with this as I haven't been able to get a
clean backup for a while now.

The following is an excerpt from my log messages.

10-Jan 01:50 preqf-sd JobId 94: Recycled volume "AHW847L3" on device
"ULT3580-TD3" (/dev/nst0), all previous data lost.
10-Jan 01:50 preqf-sd JobId 94: New volume "AHW847L3" mounted on device
"ULT3580-TD3" (/dev/nst0) at 10-Jan-2012 01:50.

First error - Could be caused by items in this directory being deleted
before the backup is finished?

10-Jan 02:33 preqf-fd JobId 94: Could not stat
/var/flexshare/shares/transfers/ITEMS REQUIRING PERMANENT DELETION:
ERR=No such file or directory



Second error with no reported solution - I have read that this means the
/tmp file hasn't enough space so I've moved my /tmp file to a drive with
more space but haven't been able to find where to change it within
bacula? Can someone advise?

10-Jan 02:36 preqf-dir JobId 94: Fatal error: sql_create.c:731
sql_create.c:731 insert INSERT INTO batch VALUES
(9508874,94,'/var/flexshare/shares/transfers/__Not transfer material -
REFERENCE/Cole Inquiry - metadata test/Individual metadata
files/','AWB.0095.0297.metadata provided by agency.txt','kA GUoiE IH/ B
A PYY A sT BAA I BMFESK BIcwLY BOSuqL A A C','slgOqIiwpQqS3ze0Z71hPg')
failed:
Incorrect key file for table '/tmp/#sqlff2_4_0.MYI'; try to repair it

10-Jan 02:36 preqf-dir JobId 94: Fatal error: catreq.c:490 Attribute
create error. sql_update.c:453 Update failed: affected_rows=0 for UPDATE
Media SET InChanger=0, Slot=0 WHERE Slot=18 AND StorageId=1 AND
MediaId!=18 10-Jan 02:36 preqf-sd JobId 94: Job
Transfers-Backup.2012-01-06_14.45.00.02 marked to be canceled.
10-Jan 02:36 preqf-sd JobId 94: Job write elapsed time = 25:26:36,
Transfer rate = 23.37 M bytes/second 10-Jan 02:36 preqf-sd JobId 94: Job
Transfers-Backup.2012-01-06_14.45.00.02 marked to be canceled.
10-Jan 02:36 preqf-sd JobId 94: Job Transfers-Backup.2012-01-06_ 10-Jan
02:36 preqf-sd JobId 94: Job Transfers-Backup.2012-01-06_14.45.00.02
marked to be canceled.



Third Error - What does error 28 from storage engine mean? Did SD or FD
fail ?

10-Jan 02:36 preqf-fd JobId 94: Fatal error: backup.c:892 Network send
error to SD. ERR=Connection reset by peer

10-Jan 02:36 preqf-dir JobId 94: Fatal error: sql_get.c:359
sql_get.c:359 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media
WHERE JobMedia.JobId=94 AND JobMedia.MediaId=Media.MediaId GROUP BY
VolumeName ORDER BY 2 ASC failed:
Got error 28 from storage engine


10-Jan 02:36 preqf-dir JobId 94: Error: Bacula preqf-dir 2.4.4
(28Dec08): 10-Jan-2012 02:36:33
Build OS: i686-redhat-linux-gnu redhat
JobId: 94
Job: Transfers-Backup.2012-01-06_14.45.00.02
Backup Level: Full
Client: "preqf-fd" 2.4.4 (28Dec08)
i686-redhat-linux-gnu,redhat,
FileSet: "Full Set" 2011-07-15 14:45:00
Pool: "Default" (From Job resource)
Storage: "ULT3580-TD3" (From Job resource)
Scheduled time: 06-Jan-2012 14:45:00
Start time: 06-Jan-2012 14:45:02
End time: 10-Jan-2012 02:36:33
Elapsed time: 3 days 11 hours 51 mins 31 secs
Priority: 10
FD Files Written: 9,510,181
SD Files Written: 9,508,907
FD Bytes Written: 2,139,558,309,608 (2.139 TB)
SD Bytes Written: 2,141,328,362,137 (2.141 TB)
Rate: 7087.2 KB/s
Software Compression: None
VSS: no
Storage Encryption: no
Volume name(s):
Volume Session Id: 1
Volume Session Time: 1325627890
Last Volume Bytes: 121,432,227,840 (121.4 GB)
Non-fatal FD errors: 3
SD Errors: 0
FD termination status: Error
SD termination status: Canceled
Termination: *** Backup Error ***



Alan Langley




UNCLASSIFIED

------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Post Bacula fatal Error [SEC=UNCLASSIFIED] 
On Tue, 10 Jan 2012 15:00:39 +1100, Alan Langley said:

First error - Could be caused by items in this directory being deleted
before the backup is finished?

10-Jan 02:33 preqf-fd JobId 94: Could not stat
/var/flexshare/shares/transfers/ITEMS REQUIRING PERMANENT DELETION:
ERR=No such file or directory

Yes, that's usually what it means.


Second error with no reported solution - I have read that this means the
/tmp file hasn't enough space so I've moved my /tmp file to a drive with
more space but haven't been able to find where to change it within
bacula? Can someone advise?

10-Jan 02:36 preqf-dir JobId 94: Fatal error: sql_create.c:731
sql_create.c:731 insert INSERT INTO batch VALUES
(9508874,94,'/var/flexshare/shares/transfers/__Not transfer material -
REFERENCE/Cole Inquiry - metadata test/Individual metadata
files/','AWB.0095.0297.metadata provided by agency.txt','kA GUoiE IH/ B
A PYY A sT BAA I BMFESK BIcwLY BOSuqL A A C','slgOqIiwpQqS3ze0Z71hPg')
failed:
Incorrect key file for table '/tmp/#sqlff2_4_0.MYI'; try to repair it

You shouldn't need to change it within bacula -- the change needs to be done
on the computer that is running mysqld. You could also try setting the tmpdir
mysql system variable.


Third Error - What does error 28 from storage engine mean? Did SD or FD
fail ?

10-Jan 02:36 preqf-fd JobId 94: Fatal error: backup.c:892 Network send
error to SD. ERR=Connection reset by peer

10-Jan 02:36 preqf-dir JobId 94: Fatal error: sql_get.c:359
sql_get.c:359 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media
WHERE JobMedia.JobId=94 AND JobMedia.MediaId=Media.MediaId GROUP BY
VolumeName ORDER BY 2 ASC failed:
Got error 28 from storage engine

Error 28 is also "No space left on device" and it comes from mysqld.

__Martin

------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create
new or port existing apps to sell to consumers worldwide. Explore the
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Bacula-users mailing list
Bacula-users < at > lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Display posts from previous:
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Magic SEO URL for phpBB