(didn't copy original reply to Kern to list) I'd run btape back when I originally installed; I don't have the output but I didn't note any errors.
I've recompiled 32-bit, and ran a test job - worked. I'm re-running the job specified below to make sure, although since *all* my jobs had been doing it, I'm thinking it will be fine. My recompile was with the exact same configure options, same config files. The only two differences were that I did not have the various 64-bit options to gcc, and I compiled against Sun's 32-bit MySQL 4.0 rather than MySQL's 64-bit 4.1 for Sparc. Best I can tell, it started on July 1st - that's when the 'wrong date' rolled over into characters MySQL wouldn't accept. Additionally on 7/1, the Storage Daemon started crashing out - some 'No Data Available' errors, a couple of 'Bad Status 102's, and eventually later clients wouldn't be able to connect. I'd be interested to know if anyone else has tried Solaris 10 (Sparc), especially with 64-bit. I'll update when this job I'm running now is done, and let you know what happened. Is there anything specific I can do to narrow down what may be wrong in Solaris that Bacula's hitting? Thanks! Mark On Thu, Jul 07, 2005 at 07:01:50PM +0200, Kern Sibbald wrote: > 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 ------------------------------------------------------- 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
