-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jason Dixon wrote:
> 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.
Is there an easy way to reproduce this kind of a thing, and do you have
a Sun support contract to be able to raise this issue?
- --
---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II
|$&| |__| | | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFIwEAVmb+gadEcsb4RAs9rAKCmw8mFc/xtDa8mDlQATx4RZOneLwCg4AVg
U+RiH1GE5Ix4fJwe2J5pVoc=
=6hM+
-----END PGP SIGNATURE-----
novosirj.vcf
Description: Vcard
-------------------------------------------------------------------------
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
| 