-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Please copy the list in all correspondence. This list is not for one-on-one help, and to steal Arno's line, I only do one-on-one help for a consulting rate. ;)
You will need to use those programs to correct your database problems, as you clearly have some. Use the documentation for both programs to get this taken care of. Dave wrote: > Hello, > Here's dbcheck and mysqlcheck. I've got some corrupted tables media > crashed for sure. I've also noticed in output that clients were waiting > on jobs i got status of client connections and didn't see any open > connections to the director, but a lot of clients are having terminated > jobs. > Thanks. > Dave. > > #dbcheck -c bacula-dir.conf > Hello, this is the database check/correct program. > Modify database is off. Verbose is off. > Please select the fuction you want to perform. > > 1) Toggle modify database flag > 2) Toggle verbose flag > 3) Check for bad Filename records > 4) Check for bad Path records > 5) Check for duplicate Filename records > 6) Check for duplicate Path records > 7) Check for orphaned Jobmedia records > 8) Check for orphaned File records > 9) Check for orphaned Path records > 10) Check for orphaned Filename records > 11) Check for orphaned FileSet records > 12) Check for orphaned Client records > 13) Check for orphaned Job records > 14) Check for all Admin records > 15) Check for all Restore records > 16) All (3-15) > 17) Quit > Select function number: 16 > Checking for Filenames with a trailing slash > Found 0 bad Filename records. > Checking for Paths without a trailing slash > Found 0 bad Path records. > Checking for duplicate Filename entries. > Query failed: SELECT Name, count(Name) as Count FROM Filename GROUP BY > Name HAVING count(Name) > 1: ERR=Table 'Filename' is marked as crashed > and should be repaired > > #mysqlcheck --databases bacula -p > (password prompt) > bacula.BaseFiles OK > bacula.CDImages OK > bacula.Client OK > bacula.Counters OK > bacula.Device OK > bacula.File > warning : 1 client is using or hasn't closed the table properly > error : Size of indexfile is: 14236672 Should be: 14280704 > error : Size of datafile is: 36004308 Should be: 36108840 > error : Corrupt > bacula.FileSet OK > bacula.Filename > warning : 1 client is using or hasn't closed the table properly > error : Size of indexfile is: 4316160 Should be: 4334592 > error : Size of datafile is: 2840712 Should be: 2854804 > error : Corrupt > bacula.Job > warning : 2 clients are using or haven't closed the table properly > status : OK > bacula.JobMedia > warning : 1 client is using or hasn't closed the table properly > error : Size of datafile is: 1900 Should be: 2100 > error : Corrupt > bacula.Location OK > bacula.LocationLog OK > bacula.Log OK > bacula.Media > warning : 2 clients are using or haven't closed the table properly > error : Found wrong packed record at 3964 > error : Corrupt > bacula.MediaType > warning : 1 client is using or hasn't closed the table properly > status : OK > bacula.Path > warning : 1 client is using or hasn't closed the table properly > error : Size of datafile is: 2242132 Should be: 2242676 > error : Corrupt > bacula.Pool > warning : 3 clients are using or haven't closed the table properly > status : OK > bacula.Status > warning : 1 client is using or hasn't closed the table properly > status : OK > bacula.Storage > warning : 1 client is using or hasn't closed the table properly > status : OK > bacula.UnsavedFiles OK > bacula.Version > warning : 1 client is using or hasn't closed the table properly > status : OK - -- ---- _ _ _ _ ___ _ _ _ |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 iD8DBQFGLjwtmb+gadEcsb4RAuGCAKDErbWFfM2SLagbLShhLNn0YQ8hbgCg0mWm EhotJv4kHGsHUShtO9dFx9U= =0leC -----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
