Well, everything went swimmingly with the 32-bit compiled Bacula, so my assumption is there's something amiss in Sol10's 64bit libraries.
That was with still going to the 64-bit MySQL, as an aside, which shouldn't matter. Mark On Thu, Jul 07, 2005 at 08:42:37PM +0200, Kern Sibbald wrote: > On Thursday 07 July 2005 19:58, Mark Bober wrote: > > 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? > > I suspect that MySQL code is not 32/64 bit clean, so if you compile for 32 > bits and then use a 64 bit Bacula you will be out of luck -- the size of int > will not match. Bacula never uses "int" or "long" in structures so as to > avoid this problem, but other programmers simply require you to compile one > way or another. > > The only place you get 32/64 bit problems with Bacula is in the state files > where it does not expect your Bacula to change from 32/64 bits. If you do so, > you must delete all your working directories or risk problems. > > > > > 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,Vol > > > >Erro rs=0,VolWrites=15500,MaxVolBytes=0,Last Written=''.-+-05-29 > > > > 17:38:40',VolStatus='Append',Slot=0,InChanger=1,VolReadTime=0,VolWriteT > > > >ime= 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,Vol > > > >Erro rs=0,VolWrites=1550 0,MaxVolBytes=0,LastWritten=''.-+-05-29 > > > > 17:38:40',VolStatus='Append',Slot=0,InChanger=1,VolReadTime=0,VolWriteT > > > >ime= 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 > > -- > 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 ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
