Thx Arno. I am going to upgrade Bacula but i have noticed another thing. In trying to figure this out, i ran the dbcheck utility to see if the database was reporting any problems. When i tried looking for Orphaned Path entries using the dbcheck tool, mysql went bonkers. I thought this was just an expensive query but after running for 1 hour it was not coming back. I ran the mysql commands to optimize the various tables in the bacula database, but still this particular query never returns. Even after i kill the dbcheck tool, mysql keeps chewing up the CPU. The only thing that works at that point is restarting mysql. The database size is not that big, the backup file for the database is about 134 Mb and the mysql directory for the bacula database is about 500 MB. I am going to investigate this further and may be upgrade mysql aswell. However it would be nice to know for debugging purposes what query is getting executed against the mysql database. May i can trace that query and figure out why its getting stuck.
thx for the help --- Arno Lehmann <[EMAIL PROTECTED]> wrote: > Hi. > > Ali Zaidi wrote: > > > I have been using bacula for the past 3 or 4 > months > > without any problems. > > However for the last two Friday nights the bacula > > director has been freezing after backing up the > first > > seven clients. > > The system and bacula log files do not report > > anything. > > When the director freezes, i can no longer get the > > bconsole to connect to the director. > > I did experience the same, couldn't find any reason, > but after the > upgrade to 1.36.2 that didn't happen again. So, I > suggest you do an > upgrade to that version or the current release > version 1.36.3. > > Upgrading should not be a problem - ./ configure > with the same options > as before, make, and make make install (or simply > copy the binaries). > > > Another peculiar thing i saw was that the number > of > > bacula-dir processes on the system increases from > 4 to > > around 21. > > That's normal - that's all the "worker threads" for > the different jobs > and bookkeeping. I don't know how many I had, but > when the director > crashed I usually had four jobs running and saw > about 10-20 jobs / threads. > > > From the schedule, bacula is doing the exact same > kind > > of backups monday to saturday. > > I am clueless as to where to look and what might > be > > wrong. Any hints would be appreciated. > > > > I am on bacula version 1.36.2. > > Try upgrading - there are no configuration changes > or database schema > modifications necessary, and I at least never saw > such problems again. > > Arno > > > > thx > > > > > > > > __________________________________ > > Do you Yahoo!? > > Read only the mail you want - Yahoo! Mail > SpamGuard. > > http://promotions.yahoo.com/new_mail > > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by Oracle Space > Sweepstakes > > Want to be the first software developer in space? > > Enter now for the Oracle Space Sweepstakes! > > > http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click > > _______________________________________________ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- > IT-Service Lehmann > [EMAIL PROTECTED] > Arno Lehmann > http://www.its-lehmann.de > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
