On Wednesday 05 April 2006 00:32, Wolfgang Denk wrote: > Hello, > > is anybody running Bacula 1.38.6 (28 March 2006) under Fedora Core 5?
I am not running it under FC5, but I have tested it under FC5, but not in a production environment. > Since updating from FC4 to FC5 and from Bacula 1.38.5 to 1.38.6 (in > one step, probably this was not a good idea), each run of our nightly > backup jobs will fail like this: > > Subject: Bacula: Backup Fatal Error of atlas-fd Incremental > ... > 05-Apr 00:20 diddl-dir: Atlas-Other.2006-04-05_00.20.01 Fatal error: > sql_create.c:85 sql_create.c:85 insert INSERT INTO Job > (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES > ('Atlas-Other.2006-04-05_00.20.01','Atlas-Other','B','I','C','2006-04-05 > 00:20:00',1144189200) failed: MySQL server has gone away > 05-Apr 00:20 diddl-dir: Atlas-Other.2006-04-05_00.20.01 Fatal error: > sql_create.c:87 Create DB Job record INSERT INTO Job > (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES > ('Atlas-Other.2006-04-05_00.20.01','Atlas-Other','B','I','C','2006-04-05 > 00:20:00',1144189200) failed. ERR=MySQL server has gone away > > I'm using mysql (mysql-server-5.0.18-2.1 from FC5), and mysqld seems > to be running fine. Actually restarting mysqld does not help - the > problem persists. > > However, restarting the bacula DIR *does* solve the problem, for one > day or so - I can run my backups manually, but the next scheduled run > will fail with the same errors. > > Any ideas? > It sounds to me like you have a version conflict between the Bacula build and the MySQL version. For example: you upgraded MySQL, but are using a Bacula built with a prior MySQL; or you upgraded MySQL, but not the development libriaries, then rebuilt Bacula, which would of course expect an older (probably version 4) MySQL. Suggestion: ensure that you have *all* the new MySQL libraries loaded and that there are no older ones in some other directory. Rebuild Bacula from scratch, re-install. Above all do not install Bacula from an rpm until there is a FC5 rpm. The other possibility is that MySQL version 5 times out the connection with Bacula. There may be some new SQL command and/or config parameter that resolves this. -- 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