On Thursday 06 April 2006 20:04, Heinz Ulrich Stille wrote:
> On Thursday 06 April 2006 17:49, Kern Sibbald wrote:
> > This has nothing to do with you, Eric, but since we are on the subject of
> > MySQL timeouts: one user troubled by this problem was aserting that
> > Bacula remains connected at all times to the MySQL database. Nothing
> > could be farther from the truth (or at least the intention), unless it is
> > a new bug,
>
> I had this error twice in the last two weeks. It hasn't happened during
> "regular" use, but - as far as I can tell at the moment - when a backup
> required more than one tape (or a different than currently inserted)
> and had to wait a long time (like a weekend).
>
> Is it possible that bacula stays connected to the DB while a job is
> running?
Yes, of course, Bacula remains connected to the DB while a job is running.
How could it update the catalog otherwise? I couldn't imagine opening and
closing the catalog on every access.
On MySQL databases, Bacula *specifically* requests that MySQL not timeout the
connection.
If this is only a problem with MySQL 5, then most likely MySQL has changed
something concerning timeouts, or has a bug. Bacula has not "officially"
been tested with MySQL 5, which I still consider immature (unstable if you
will).
If you are using FC5, please be aware that Fedora (which I use) does not do a
very good job of thouroughly testing software before releasing it (IMO). I
don't intend to switch from my current FC4 to FC5 on any production machine
for *at least* 3 months. Just the fact that they are running gcc 4.1 makes me
nervous. However, I do have one spare machine "testing" it ...
I wish I could find some distribution that is serious about security updates
as Fedora (RedHat) but pays more attention to stability than Fedora. One FC4
update caused all OpenOffice compents to crash randomly every 5 minutes. I
had to back up to a previous version when I was counting the project votes!
In addition, Fedora really massacres KDE (at least compared to the nice
Debian implementation of KDE).
In looking at Debian, I find for me personally I wouldn't want to run on
"stable" as it is too old. I don't really need that much stability.
"testing" is not my piece of cake either (at the moment) because it doesn't
have timely security updates (though this appears to be changing). Who knows
perhaps SuSE is a reasonable contender.
If users are having this "MySQL went away" problem on MySQL 4, no one has
explicitly said so, and in that case then it is a lot less clear what is
going on.
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
