>> I running bacula server on a Debian Etch.
>> 
>> I upgraded via www.backports.org and now...
>> 
> 
> Is it normal, that MySQL runs at 100% processor "hours"
> after a backup? Maybe 1st time after an upgrade from
> 1.38?  
> 
> Image: http://www.localnet.fi/jarif/images/bacula_100.png
> 


Everything seems to work now. I had to download latest bacula source tarball,
edit src/config.h so that 

    #define HAVE_BATCH_FILE_INSERT 1

comes

    /* #define HAVE_BATCH_FILE_INSERT 1 */

(You have to comment it out, defining it as 0 does not work!)

And voila! My MySQL is happy and back up works.

HAVE_BATCH_FILE_INSERT seems to be so wrong in so many levels, that it's best 
to disable.

My setup:

# mysql --version
mysql  Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2

# uname -a
Linux wellington 2.6.22-4-686 #1 SMP Tue Feb 12 16:29:32 UTC 2008 i686 GNU/Linux

# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/hda3             298G   93G  206G  32% /
tmpfs                 125M     0  125M   0% /lib/init/rw
udev                   10M   56K   10M   1% /dev
tmpfs                 125M     0  125M   0% /dev/shm
/dev/hda1              30M   14M   15M  48% /boot

# free -m
             total       used       free     shared    buffers     cached
Mem:           249        215         34          0         49         45
-/+ buffers/cache:        119        129
Swap:          243         44        198


All went wrong when I upgraded from Bacula 1.38 to 2.2.8 (www.backports.org), 
but now that I did it with source and that "unsetting" of the BATCH handling, 
my system works.

You can find some more comments (although not all constructive) on that BATCH 
SQL handling in this thread of mine, have a look or not.

I have noticed positive things in Bacula in this upgrade as well. My tape 
sometimes mounts as READ-ONLY, and bacula used to fail jobs when that happened. 
2.2.x seems to handle that, altought not perfecktly. It seems to mount the 
tape, and says "Thank You" but nothing happens. Unmounting and remounting after 
"mt status" it's happy and the backup continues. That is much better than in 
1.38 where a 10 tape backup failed because #11 tape was read only!!

Thanks for all participants for this great software!


Regards, jarif (Happy camper now!)

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft 
Defy all challenges. Microsoft(R) Visual Studio 2008. 
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users