>>>>> 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


> 
> 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

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to