On Wed, Sep 03, 2008 at 06:04:04PM -0400, Jason Dixon wrote:
> 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

A little more information and hopefully a resolution.  More googling
revealed some possible bugs with Solaris 10 64-bit.  I shut everything
down again, fixed up the Media table, and restarted everything in 32-bit
mode.  Although I noticed that the "Terminated Jobs" output is hosed
(except for the most recent job), the rest of the output looks ok.
I should probably chalk this up to experience and destroy/rebuild the
catalog and just use 32-bit moving forward.

*llist media
Pool: Default
          MediaId: 1
       VolumeName: WAL001
             Slot: 0
           PoolId: 1
        MediaType: File
     FirstWritten: 2008-09-03 13:15:36
      LastWritten: 2008-09-03 18:20:06
        LabelDate: 2008-09-03 13:15:36
          VolJobs: 15
         VolFiles: 0
        VolBlocks: 633
        VolMounts: 15
         VolBytes: 40036835
        VolErrors: 0
        VolWrites: 634
 VolCapacityBytes: 0
        VolStatus: Append
          Enabled: 1
          Recycle: 1
     VolRetention: 31536000
   VolUseDuration: 0
       MaxVolJobs: 0
      MaxVolFiles: 0
      MaxVolBytes: 0
        InChanger: 0
          EndFile: 0
         EndBlock: 40036834
         VolParts: 0
        LabelType: 0
        StorageId: 1
         DeviceId: 0
       LocationId: 0
     RecycleCount: 0
     InitialWrite: 0
    ScratchPoolId: 0
    RecyclePoolId: 0
          Comment: NULL


*st dir
backup-va-1-dir Version: 2.4.2 (26 July 2008) sparc-sun-solaris2.10
solaris 5.10
Daemon started 03-Sep-08 18:15, 1 Job run since started.
 Heap: heap=245,760 smbytes=50,187 max_bytes=54,224 bufs=340
max_bufs=379
No Scheduled Jobs.
====

Running Jobs:
Console connected at 03-Sep-08 18:15
No Jobs running.
====

Terminated Jobs:
 JobId  Level    Files      Bytes   Status   Finished        Name 
====================================================================
    84  Base          6    5.241 E  Other    31-Dec-69 19:00 
     1  ? (2         66    360.7 G  Other    31-Dec-69 19:00 H??6
758133599  9 (9          0         0   Other    31-Dec-69 19:00 
1098015592  e (1   942,485,561    3.256 E  Other    31-Dec-69 19:00 
    16  Incr          1    5.067 M  OK       03-Sep-08 18:20
DatabaseArchives

====


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