-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Dave wrote: > 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 ***
Can you include the output from when you ran dbcheck and mysqlcheck? - -- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGLiismb+gadEcsb4RAv+sAJ9poodeo0GDWHXHz/ELq5ZJcICGKACfaILr 6vFtJ0EgVvq2wER1cJHi9DU= =1bPX -----END PGP SIGNATURE----- ------------------------------------------------------------------------- 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
