I've deployed a new Bacula installation on Solaris 10.  It's currently
only backing up some PostgreSQL transaction logs to disk.  All of the
jobs have run fine, but an error just came in for one of the jobs.

03-Sep 17:30 backup-va-1-dir JobId 11: Error: sql_update.c:350 sql_update.c:350 
update UPDATE Media Set LastWritten='0,*'-05-19 22:24:48' WHERE 
VolumeName='WAL001' 
failed: near "22": syntax error

Indeed, the LastWritten value was "*)-(-03-16 07:09:36".  I shut down
the bacula processes, updated the catalog, and restarted everything.
Unfortunately, it happened again.  It doesn't seem to be affecting the
backups from running correctly, but I'm concerned about what could be
causing this.  Here is the most recent status of the media.  Any ideas?

*llist media
Pool: Default
          MediaId: 1
       VolumeName: WAL001
             Slot: 0
           PoolId: 1
        MediaType: File
     FirstWritten: 2008-09-03 13:15:36
      LastWritten: +*./-01-19 23:56:32
        LabelDate: 2008-09-03 13:15:36
          VolJobs: 13
         VolFiles: 0
        VolBlocks: 553
        VolMounts: 13
         VolBytes: 34962538
        VolErrors: 0
        VolWrites: 554
 VolCapacityBytes: 0
        VolStatus: Append
          Enabled: 1
          Recycle: 1
     VolRetention: 31536000
   VolUseDuration: 0
       MaxVolJobs: 0
      MaxVolFiles: 0
      MaxVolBytes: 0
        InChanger: 0
          EndFile: 0
         EndBlock: 34962537
         VolParts: 0
        LabelType: 0
        StorageId: 1
         DeviceId: 0
       LocationId: 0
     RecycleCount: 0
     InitialWrite: 0
    ScratchPoolId: 0
    RecyclePoolId: 0
          Comment: NULL


Thanks,

-- 
Jason Dixon
OmniTI Computer Consulting, Inc.
jdixon AT omniti DOT com
443.325.1357 x.241 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users