Robert Leche wrote:
Dear Bacula community,
I have a problem with a Bacula server producing the following error
every 24-48 hours:MySQL server has gone away". After such time, Bacula
can be restarted and all is well for a day or so.
Some Hardware/software info:
Platform: Dell 2850 Dual 3.0GHZ Xeon, 2G RAM
Redhat el4
Kernel: 2.6.9-11.ELsmp
Bacula: bacula-1.38.5 compiled from source
Mysql: mysql-5.0.16 compiled from source
This is my second Bacula system. On a nearly identical Dell system, I
am running the version bacula-1.36.3 and mysql-4.1.12, with no
problems. In the beginning, I was running bacula-1.36.3 and
mysql-4.1.12 on the second system, but this combination was producing
the 'MySQL server has gone away' error. So I have tried other Bacula
versions. I have also tried other versions of Mysql, but in every
case the outcome is the same: 'MySQL server has gone away' after some
period of random time usually 1-2 days but sometimes overnight.
All data that Bacula saves are saved to local disk resources on both
systems. No NFS resources are used with Bacula. No tape resources.
Here is an example log of a failure:
29-Jan 09:10 storm-dir: BackupCatalog.2006-01-29_09.10.00 Fatal error:
sql_create.c:85 sql_create.c:85 insert INSERT INTO
Job(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('BackupCatalog.2006-01-29_09.10.00','BackupCatalog','B','F','C','2006-01-2909:10:00',1138547400)
failed:
MySQL server has gone away
29-Jan 09:10 storm-dir: sql_create.c:85 INSERT INTO
Job(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('BackupCatalog.2006-01-29_09.10.00','BackupCatalog','B','F','C','2006-01-2909:10:00',1138547400)
29-Jan 09:10 storm-dir: BackupCatalog.2006-01-29_09.10.00 Fatal error:
sql_create.c:87 Create DB Job record INSERT INTO
Job(Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES
('BackupCatalog.2006-01-29_09.10.00','BackupCatalog','B','F','C','2006-01-2909:10:00',1138547400)
failed. ERR=MySQL server has gone away
I've searched the Bacula list servers ,and the web for that matter,
and have not found a definite explanation or any guidance. It is
strange that one system works and one system doesn't. The main
difference in these systems is the operating system. The system that
works is a Fedora Core 3 system and the system with the error is the
Redhat EL4.
Both system are designed to back up around 250-300 gig-a-bytes weekly
from local network hosts. I've experimented with non-overlapping
schedules on the odd chance that Bacula was overloading the Mysql
database server. No change. As far as I can tell, there seems to be no
rhythm or reason in the Bacula/Mysql loading: The error will occur
regardless if small backup job(s) are performed or large backup jobs
are performed.
Any ideas on how to fix this would be appreciated.
My Bacula configure:
./configure \
--sbindir=/usr/local/bacula/bin \
--sysconfdir=/etc/bacula/ \
--with-pid-dir=/usr/local/bacula/working \
--with-scriptdir=/etc/bacula \
--with-subsys-dir=/usr/local/bacula/working \
--with-working-dir=/usr/local/bacula/bin/working \
[EMAIL PROTECTED] \
[EMAIL PROTECTED] \
--with-smtp-host=mailhost.mydomain.edu \
--with-tcp-wrappers=/usr/lib \
--with-libwrap \
--with-x \
--enable-conio \
--with-mysql=/usr/local/mysql \
--with-dir-user=root \
--with-dir-group=bacula \
--with-sd-user=root \
--with-sd-group=bacula \
--with-fd-user=root \
--with-fd-group=bacula \
--with-baseport=9101 \
--enable-tray-monitor \
--enable-smartalloc \
--disable-readline
Mysql configure:
./configure --with-unix-socket-path=/tmp/mysql.sock
--enable-thread-safe-client --prefix=/usr/local/mysql
My /etc/bacula/bacula-dir.conf is 725 lines long, but if it is needed
I will be happy to provide it.
Bob
Hi Robert,
You may like to look here :
http://dev.mysql.com/doc/refman/4.1/en/gone-away.html
It may not give the solution but might be able to put you on the right
track. There maybe a timeout on the tcp connection to mysql or a number
of different problems.
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
