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.Client OK
cat_x.Counters OK
cat_x.Device OK
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.Status OK
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]
