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

Just a final update for the archives.  It does appear to be related to
64-bit Solaris.  I've rebuilt the catalog and restarted the Director and
File Daemon(s) in 32-bit mode (our packages include both via ISALIST).
We've encountered no further corruption issues.

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