Hi,
I've got a problem between bacula and mysql and would appreciate any
help. Output below.
Thanks.
Dave.
24-Apr 05:51 zeus-dir: Start Backup JobId 70,
Job=backup_wserv.2007-04-24_05.51.00
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Fatal error:
sql_find.c:320 sql_find.c:320 query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,VolStatus,InChanger,VolParts,LabelType
FROM Media WHERE PoolId=13 AND MediaType='File' AND Enabled=1 AND
VolStatus='Append' ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId
LIMI
1 failed:
Table 'Media' is marked as crashed and should be repaired
24-Apr 05:51 zeus-dir: sql_find.c:320 SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,VolStatus,InChanger,VolParts,LabelType
FROM Media WHERE PoolId=13 AND MediaType='File' AND Enabled=1 AND
VolStatus='Append' ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId
LIMIT 1
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Fatal error:
sql_find.c:320 sql_find.c:320 query SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,VolStatus,InChanger,VolParts,LabelType
FROM Media WHERE PoolId=13 AND MediaType='File' AND Enabled=1 AND
VolStatus='Recycle' ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId
LIM
T 1 failed:
Table 'Media' is marked as crashed and should be repaired
24-Apr 05:51 zeus-dir: sql_find.c:320 SELECT
MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,VolStatus,InChanger,VolParts,LabelType
FROM Media WHERE PoolId=13 AND MediaType='File' AND Enabled=1 AND
VolStatus='Recycle' ORDER BY LastWritten IS NULL,LastWritten DESC,MediaId
LIMIT 1
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Error: Query failed:
SELECT MediaId,LastWritten FROM Media WHERE PoolId=13 AND Recycle=1 AND
VolStatus='Purged' AND Enabled=1 AND MediaType='File' ORDER BY LastWritten
ASC,MediaId LIMIT 1: ERR=Table 'Media' is marked as crashed and should be
repaired
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Error: Media id
select failed: ERR=Table 'Media' is marked as crashed and should be repaired
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Error: Media id
select failed: ERR=Table 'Media' is marked as crashed and should be repaired
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Error: Query failed:
SELECT MediaId,LastWritten FROM Media WHERE PoolId=13 AND Recycle=1 AND
VolStatus='Purged' AND Enabled=1 AND MediaType='File' ORDER BY LastWritten
ASC,MediaId LIMIT 1: ERR=Table 'Media' is marked as crashed and should be
repaired
24-Apr 05:51 zeus-dir: Created new Volume "wserv-incremental0006" in
catalog.
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Warning: Error
getting Media record for Volume "wserv-incremental0006": ERR=Media record
for Vol=wserv-incremental0006 not found in Catalog.
24-Apr 05:51 zeus-dir: backup_wserv.2007-04-24_05.51.00 Error: Bacula 2.0.3
(06Mar07): 24-Apr-2007 05:51:04
JobId: 70
Job: backup_wserv.2007-04-24_05.51.00
Backup Level: Incremental, since=2007-04-21 05:51:06
Client: "wserv-fd" 2.0.3 (06Mar07)
i686-redhat-linux-gnu,redhat,
FileSet: "fbsd_wserv" 2007-04-15 11:11:06
Pool: "Wserv_Incremental" (From Job IncPool override)
Storage: "WservStorage" (From Job resource)
Scheduled time: 24-Apr-2007 05:51:00
Start time: 24-Apr-2007 05:51:02
End time: 24-Apr-2007 05:51:04
Elapsed time: 2 secs
Priority: 10
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS: no
Encryption: no
Volume name(s):
Volume Session Id: 5
Volume Session Time: 1177357669
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors: 4
SD Errors: 0
FD termination status:
SD termination status:
Termination: *** Backup Error ***
-------------------------------------------------------------------------
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
