Hello, This looks like a configuration error -- probably with the definition of lld and llu. Have you run btape? It tests if those values are correct.
If they are correct, then it would point to a possible bug in the library strftime() function. Bacula has been in use on a good number of 64 bit machines, so if it is configured correctly, there should be no problems. On Thursday 07 July 2005 17:01, Mark Bober wrote: > 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,VolErro >rs=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,VolErro >rs=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 -- Best regards, Kern ("> /\ V_V ------------------------------------------------------- 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
