Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)

2006-09-25 Thread Bailey, Scott 
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)

2006-09-24 Thread Lupe Christoph 
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]

Bug#388027: Acknowledgement (bacula-director-mysql fails after restart of MySQL)

2006-09-24 Thread Emmanuel DECAEN 
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)

2006-09-24 Thread John Goerzen 
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)

2006-09-24 Thread Emmanuel DECAEN 
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]