Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)
I coincidentally just saw this issue with PostgreSQL over the weekend. In my case, I had updated the postgresql packages (using aptitude) which caused a database shutdown and restart. The bacula director process was brain-damaged and spewed these errors until I recycled it too, after which everything was fine. Speaking as a lazy SA :-) it would be nice if the director attempted to re-open its database connection when it encounters an error, before punting entirely. In the alternative, I don't think there is any infrastructure to support a forced restart of the director any time the database is cycled, so I guess we'll just have to remember to notice and do this step ourselves, manually. Cheers, Scott [EMAIL PROTECTED]
Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)
Hi, John Goerzen wrote : > On Sun, Sep 24, 2006 at 12:58:10PM +0200, Emmanuel DECAEN wrote: > >> I've reproduced the problem on bacula 1.38.11-5, last week with mysql >> 5.0.24a and yesterday with mysql 5.0.22-4. >> >> 20-Sep 00:14 backup01-dir: Bak_x_mail.2006-09-20_00.14.09 Fatal error: >> sql_create.c:87 Create DB Job record INSERT INTO Job >> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES >> ('Bak_x_mail.2006-09-20_00.14.09','Bak_x_mail','B','I','C','2006-09-20 >> 00:14:08',1158704048) failed. ERR=MySQL server has gone away >> > > This would be a MySQL issue -- the "MySQL server has gone away" means > that the system couldn't maintain a working connection to MySQL. > Perhaps your disk is full? > I've created a 40 GB dedicated space for catalogs (mysql) and only 15 GB are used. And the problem has occured only for this catalog over 14 catalogs. As a result, the backups of this catalog were in ERROR, but all the others (from others catalogs) were OK. If it can help, Bacula is used to backup, every day, 60 servers on a 5.5 TB dedicated backup system. This is the result of a mysqlcheck on catalog cat_x : $ mysqlcheck -p cat_x cat_x.BaseFiles OK cat_x.CDImages OK cat_x.ClientOK cat_x.Counters OK cat_x.DeviceOK cat_x.File OK cat_x.FileSet OK cat_x.Filename OK cat_x.Job OK cat_x.JobMedia OK cat_x.Media OK cat_x.MediaType OK cat_x.Path OK cat_x.Pool OK cat_x.StatusOK cat_x.Storage OK cat_x.UnsavedFiles OK cat_x.Version OK Bacula-director and mysql-server are on the same server. Thanks. -- Emmanuel DECAEN -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)
On Sun, Sep 24, 2006 at 12:58:10PM +0200, Emmanuel DECAEN wrote: > Hello, > > I've reproduced the problem on bacula 1.38.11-5, last week with mysql > 5.0.24a and yesterday with mysql 5.0.22-4. > > 20-Sep 00:14 backup01-dir: Bak_x_mail.2006-09-20_00.14.09 Fatal error: > sql_create.c:87 Create DB Job record INSERT INTO Job > (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES > ('Bak_x_mail.2006-09-20_00.14.09','Bak_x_mail','B','I','C','2006-09-20 > 00:14:08',1158704048) failed. ERR=MySQL server has gone away This would be a MySQL issue -- the "MySQL server has gone away" means that the system couldn't maintain a working connection to MySQL. Perhaps your disk is full? -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)
Hello, I've reproduced the problem on bacula 1.38.11-5, last week with mysql 5.0.24a and yesterday with mysql 5.0.22-4. 20-Sep 00:14 backup01-dir: Bak_x_mail.2006-09-20_00.14.09 Fatal error: sql_create.c:87 Create DB Job record INSERT INTO Job (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES ('Bak_x_mail.2006-09-20_00.14.09','Bak_x_mail','B','I','C','2006-09-20 00:14:08',1158704048) failed. ERR=MySQL server has gone away I will try with older Debian version of bacula 1.38.11-1 and mysql 5.0.22-4. Thanks. -- Emmanuel DECAEN -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)
For reasons unknown it is back to working now. Please close this bug. Thank you, Lupe Christoph -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]