-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martin Simmons wrote: >>>>>> On Fri, 20 Jul 2007 00:01:19 -0400, Ryan Novosielski said: >> This has gotten a bit more peculiar. Someone please offer up an opinion >> - -- I'd really appreciate it. :) >> >> If you read below (or the subject line), you'd see the error that I got >> when one of my backup jobs ran. Look what happened this time with a >> different job: >> >> - --- >> *run >> A job name must be specified. >> The defined Job resources are: >> 1: Catalog >> 2: RestoreFiles >> 3: NJMSCatalyst >> 4: SystemArchive >> 5: Webmail >> 6: CFMX-dev >> 7: sopris-WEBMAIL >> 8: BigBrother-Display >> 9: SVNrepos >> 10: VistaBKsave >> 11: BigBrother-NET >> Select Job resource (1-11): 9 >> Run Backup job >> JobName: SVNrepos >> Level: Incremental >> Client: lethe-fd >> FileSet: SVNrepos >> Pool: combined_DELTA (From Job resource) >> Storage: helios_DDS (From Pool resource) >> When: 2007-07-19 23:46:37 >> Priority: 10 >> OK to run? (yes/mod/no): yes >> Job queued. JobId=3270 >> You have messages. >> *me >> 19-Jul 23:46 helios-dir: No prior Full backup Job record found. >> 19-Jul 23:46 helios-dir: No prior or suitable Full backup found in >> catalog. Doing FULL backup. >> *me >> 19-Jul 23:46 helios-dir: Start Backup JobId 3270, >> Job=SVNrepos.2007-07-19_23.46.39 >> - --- >> >> However, if you look at my job listing, you will see that this >> (theoretically) is not true: >> >> *list jobname=SVNrepos >> +-------+----------+---------------------+------+-------+----------+-------------+-----------+ >> | JobId | Name | StartTime | Type | Level | JobFiles | >> JobBytes | JobStatus | >> +-------+----------+---------------------+------+-------+----------+-------------+-----------+ >> | 2,967 | SVNrepos | 2007-06-01 23:00:08 | B | I | 0 | >> 0 | A | >> | 3,029 | SVNrepos | 2007-06-12 21:00:07 | B | F | 13,663 | >> 414,107,280 | T | >> | 3,115 | SVNrepos | 2007-06-26 21:00:06 | B | F | 13,718 | >> 414,196,431 | T | >> | 3,166 | SVNrepos | 2007-07-04 23:00:05 | B | I | 0 | >> 0 | f | >> | 3,174 | SVNrepos | 2007-07-05 23:00:09 | B | I | 27 | >> 203,023 | T | >> | 3,183 | SVNrepos | 2007-07-06 23:00:09 | B | I | 87 | >> 92,951 | f | >> | 3,190 | SVNrepos | 2007-07-06 23:18:31 | B | I | 153 | >> 185,703 | T | >> | 3,200 | SVNrepos | 2007-07-09 23:00:12 | B | I | 241 | >> 212,662 | T | >> | 3,207 | SVNrepos | 2007-07-10 21:00:06 | B | F | 14,328 | >> 415,000,246 | T | >> | 3,216 | SVNrepos | 2007-07-11 23:00:09 | B | I | 165 | >> 152,084 | T | >> | 3,224 | SVNrepos | 2007-07-12 23:00:19 | B | I | 59 | >> 43,704 | T | >> | 3,232 | SVNrepos | 2007-07-13 23:00:19 | B | I | 110 | >> 100,620 | T | >> | 3,242 | SVNrepos | 2007-07-16 23:00:11 | B | I | 217 | >> 178,725 | T | >> | 3,250 | SVNrepos | 2007-07-17 23:00:07 | B | I | 173 | >> 168,380 | T | >> | 3,258 | SVNrepos | 2007-07-18 23:00:08 | B | I | 138 | >> 267,183 | T | >> | 3,266 | SVNrepos | 2007-07-19 23:00:07 | B | F | 0 | >> 0 | A | >> | 3,269 | SVNrepos | 2007-07-19 23:44:46 | B | F | 0 | >> 0 | R | >> | 3,270 | SVNrepos | 2007-07-19 23:46:52 | B | F | 0 | >> 0 | R | >> +-------+----------+---------------------+------+-------+----------+-------------+-----------+ >> >> ...a full job just ran on 7/10, and is still in the database. I'm going >> to try a dbcheck or something, but it appears that something is royally >> screwed here. >> >> One other thing I'm not mentioning is that my bacula-sd is >> semi-consistently crashing. I am fine-tuning the btraceback program so >> that I actually get what I need to report this (originally I did not >> have 'dbx' installed, next the user that spawned the 'dbx' was the >> bacula user, but the crashing daemon ran as root -- I fixed this with >> the addition of sudo). >> >> Any help? Something funny is going on. > > Not sure what is happening, but it might be useful to turn on sql query > logging in the database server. > > Look for queries starting with > > SELECT StartTime FROM Job...
Martin, Turned on query logging. Found the following: 1 Query SELECT ClientId,Uname FROM Client WHERE Name='lethe-fd' 1 Query SELECT FileSetId,CreateTime FROM FileSet WHERE FileSet='SVNrepos' AND MD5='1T5Pgm+iPz/ak7JcTj/oFC' 1 Query SELECT StartTime FROM Job WHERE JobStatus='T' AND Type='B' AND Level='F' AND Name='SVNrepos' AND ClientId=7 AND FileSetId=28 ORDER BY StartTime DESC LIMIT 1 ...discovered that the FileSet used in the last backup is 15, not 28. I must have flipped "Ignore FileSet Changes" to Off at some point last week and forgot about it. Doh. Thanks for the help! =R >> Ryan Novosielski wrote: >>> I'm somewhat mystified by this problem. I don't know whether to check the >>> database or what. I see that this particular job does not appear to have >>> NEEDED a volume, and so that might be the issue, but I've seen that before >>> and it did not cause this. The only thing special that happened right >>> before this was that the tape was mistakenly marked full when the first >>> backup job attempted to run. I set this to Append and ran the jobs. 7 jobs >>> ran in all, and all others had no problems. >>> >>> ...... Forwarded Message ....... >>> From: "Bacula" <[EMAIL PROTECTED]> >>> To: <[EMAIL PROTECTED]> >>> Date: Wed, 18 Jul 2007 09:54:43 +0000 (%z) >>> Subj: Bacula: Backup Error of vistaadm-fd Incremental >>> >>> 17-Jul 23:00 helios-dir: Start Backup JobId 3251, >>> Job=VistaBKsave.2007-07-17_23.00.04 >>> 17-Jul 23:00 helios-sd: Spooling data ... >>> 17-Jul 23:00 helios-sd: Job write elapsed time = 00:00:02, Transfer rate = >>> 537 bytes/second >>> 17-Jul 23:00 helios-sd: Committing spooled data to Volume "Delta_B". >>> Despooling 0 bytes ... >>> 18-Jul 09:54 helios-sd: Despooling elapsed time = 00:00:01, Transfer rate = >>> 0 bytes/second >>> 18-Jul 09:54 helios-sd: Alert: smartctl version 5.36 [sparc-sun-solaris2.8] >>> Copyright (C) 2002-6 Bruce Allen >>> 18-Jul 09:54 helios-sd: Alert: Home page is >>> http://smartmontools.sourceforge.net/ >>> 18-Jul 09:54 helios-sd: Alert: >>> 18-Jul 09:54 helios-sd: Alert: Smartctl open device: /dev/rmt/0 failed: >>> Device busy >>> 18-Jul 09:54 helios-sd: 3997 Bad alert command: sh -c >>> '/opt/csw/sbin/smartctl -H -l error /dev/rmt/0': ERR=Child exited with code >>> 2. >>> 18-Jul 09:54 helios-sd: Sending spooled attrs to the Director. Despooling >>> 644 bytes ... >>> 18-Jul 09:54 helios-dir: VistaBKsave.2007-07-17_23.00.04 Error: Could not >>> get Job Volume Parameters to update Bootstrap file. ERR=sql_get.c:411 No >>> volumes found for JobId=3251 >>> >>> 18-Jul 09:54 helios-dir: VistaBKsave.2007-07-17_23.00.04 Error: Bacula >>> 2.0.2 (28Jan07): 18-Jul-2007 09:54:43 >>> JobId: 3251 >>> Job: VistaBKsave.2007-07-17_23.00.04 >>> Backup Level: Incremental, since=2007-07-16 23:00:10 >>> Client: "vistaadm-fd" 2.0.2 (28Jan07) >>> sparc-sun-solaris2.8,solaris,5.8 >>> FileSet: "VistaBK" 2006-09-21 23:00:53 >>> Pool: "combined_DELTA" (From Job IncPool override) >>> Storage: "helios_DDS" (From Pool resource) >>> Scheduled time: 17-Jul-2007 23:00:03 >>> Start time: 17-Jul-2007 23:00:07 >>> End time: 18-Jul-2007 09:54:43 >>> Elapsed time: 10 hours 54 mins 36 secs >>> Priority: 10 >>> FD Files Written: 4 >>> SD Files Written: 4 >>> FD Bytes Written: 758 (758 B) >>> SD Bytes Written: 1,074 (1.074 KB) >>> Rate: 0.0 KB/s >>> Software Compression: None >>> VSS: no >>> Encryption: no >>> Volume name(s): >>> Volume Session Id: 74 >>> Volume Session Time: 1183696494 >>> Last Volume Bytes: 121,411,584 (121.4 MB) >>> Non-fatal FD errors: 1 >>> SD Errors: 0 >>> FD termination status: OK >>> SD termination status: OK >>> Termination: *** Backup Error *** >>> >>> 18-Jul 09:54 helios-dir: Begin pruning Jobs. >>> 18-Jul 09:54 helios-dir: No Jobs found to prune. >>> 18-Jul 09:54 helios-dir: Begin pruning Files. >>> 18-Jul 09:54 helios-dir: No Files found to prune. >>> 18-Jul 09:54 helios-dir: End auto prune. >>> >>> >>> >>> ------------------------------------------------------------------------- >>> 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 >> >> - -- >> ---- _ _ _ _ ___ _ _ _ >> |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II >> |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) >> \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 - -- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II |$&| |__| | | |__/ | \| _| |[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 iD8DBQFGpRdrmb+gadEcsb4RAlx6AKCj2JTxbMxeBhb0rqFtwufuonoDkACffGtd lQ17adatV2OG7DESUEZHGbo= =zHuk -----END PGP SIGNATURE----- ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users