I'm seeing: 06-Jul 12:32 duct-sd: Committing spooled data to Volume. Despooling 57,150,118,869 bytes ... 06-Jul 12:33 duct-dir: arlfs.A.2005-07-06_10.29.36 Error: sql_update.c:327 sql_update.c:327 update UPDATE Media SET VolJobs=0,VolFiles=1,VolBlocks=15499,VolBytes=999871366,VolMounts=1,VolErrors=0,VolWrites=15500,MaxVolBytes=0,Last Written=''.-+-05-29 17:38:40',VolStatus='Append',Slot=0,InChanger=1,VolReadTime=0,VolWriteTime=0 WHERE VolumeName= 'ARL-Base-0001' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.-+-05-29 17:38:40',VolStatus='Append',Slot=0,InChanger=1,VolReadTime=0,VolWrite' at line 1 06-Jul 12:33 duct-dir: arlfs.A.2005-07-06_10.29.36 Error: Catalog error updating Media record. sql_update.c:327 upd ate UPDATE Media SET VolJobs=0,VolFiles=1,VolBlocks=15499,VolBytes=999871366,VolMounts=1,VolErrors=0,VolWrites=1550 0,MaxVolBytes=0,LastWritten=''.-+-05-29 17:38:40',VolStatus='Append',Slot=0,InChanger=1,VolReadTime=0,VolWriteTime= 0 WHERE VolumeName='ARL-Base-0001' failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.-+-05-29 17:38:40',VolStatus='Append',Slot=0,InChanger=1,VolReadTime=0,VolWrite' at line 1
The LastWritten=''.-+-05-29 17:38:40' is the problem. Not the right date. Now that I go back through the logs, all of the LastWrittens are wrong. I have dates like: 1791-01-23 3326-08-06 6454-10-15 It's just now it's producing a date that's not numerical. This is on a Solaris 10 server (on Sparc), Sol10's default gcc (3.4.3 with Sun mods). It was compiled 64bit, if that makes a difference for Bacula. Thanks! mark ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
