--On Samstag, 9. Dezember 2006 10:18 +0100 Guy Corbaz <[EMAIL PROTECTED]>
wrote:
> Hello,
>
> I'm using Bacula since several days on Ubunto 6.06. Suddenly, after
> everything worked fine, I'm getting the following messages:
>
> 09-Dec 01:05 saturne-dir: Pbx.2006-12-09_01.05.00 Fatal error:
> sql_create.c:91 sql_create.c:91 insert INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
> ('Pbx.2006-12-09_01.05.00','Pbx','B','I','C','2006-12-09
> 01:05:00',1165622700) failed:
> MySQL server has gone away
> 09-Dec 01:05 saturne-dir: Pbx.2006-12-09_01.05.00 Fatal error:
> sql_create.c:93 Create DB Job record INSERT INTO Job
> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
> ('Pbx.2006-12-09_01.05.00','Pbx','B','I','C','2006-12-09
> 01:05:00',1165622700) failed. ERR=MySQL server has gone away
>
> If I restart the server and re-launch manually the backup, it works, but
> crash again during the night. Manually restarting MySQL is not enough.
Please supply version information of bacula and mysql if asking questions.
Also your configuration files of bacula-dir and mysql might be useful.
Now to the problem: The log looks like you are running a job and bacula
fails to insert the job into the databse because the connection dropped or
mysqld died.
This problem repeatetly been reported for mysql version 5. If you run mysql
version 5 try downgrading to version 4.
What do you mean by "restart the server"? Reboot the machine or restart the
deamon process(es) of mysql/bacula? Please give more detauled information
here.
What does the mysqld log say?
Try running mysqld with debugging enabled to find out why it dies (if it
does actually) or why the connection is dropped.
Do you run other applications using the mysql server?
Is the mysql server on the same machine? If not, this might boil down to
networking problems.
And BTW, google is your friend:
<http://www.google.de/search?q=bacula+MySQL+server+has+gone+away>
<http://dev.mysql.com/doc/refman/4.1/en/gone-away.html>
This is what I can think of currently. Any other ideas?
Regards,
Georg
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
