Hi, Thanks for your reply. Yes i did check that site, and none of the causes of the error seem applicable to my situation. I haven't had a server crash, i don't have any large commits going in either from bacula or from other mysql apps. Thanks. Dave.
----- Original Message ----- From: "Ryan Novosielski" <[EMAIL PROTECTED]> To: "Dave" <[EMAIL PROTECTED]> Cc: <bacula-users@lists.sourceforge.net> Sent: Friday, September 22, 2006 2:25 PM Subject: Re: [Bacula-users] mysql server has gone away > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Just to double check, you HAVE already read this right? You didn't > really indicate, but I can't really see how you could have missed it if > you used Google. > > http://dev.mysql.com/doc/refman/5.0/en/gone-away.html > > Dave wrote: >> Hello, >> I just checked my nightly backups and have discovered that none of >> them >> worked. I'm getting an error that the mysql server has gone away, i've >> included one daemon message and one job failed message below. I'm running >> FreeBSD 6.1-p6 with bacula 1.38.11 director, storage, and file daemon on >> the >> same box, another client was backing up with a 1.38.10 client. My mysql >> version is mysql-5.0.24 client and server again same box. I've googled >> this >> error message, but that perplexes me even more, i haven't done any >> updates >> to bacula or mysql within at least the last two weeks probably more. Any >> help or pointers appreciated. >> Thanks. >> Dave. >> >> job error msg: >> 22-Sep 01:05 zeus-dir: backup_zeus.2006-09-22_01.05.00 Fatal error: >> sql_create.c:85 sql_create.c:85 insert INSERT INTO Job >> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES >> ('backup_zeus.2006-09-22_01.05.00','backup_zeus','B','I','C','2006-09-22 >> 01:05:00',1158901500) failed: >> MySQL server has gone away >> 22-Sep 01:05 zeus-dir: sql_create.c:85 INSERT INTO Job >> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES >> ('backup_zeus.2006-09-22_01.05.00','backup_zeus','B','I','C','2006-09-22 >> 01:05:00',1158901500) >> 22-Sep 01:05 zeus-dir: backup_zeus.2006-09-22_01.05.00 Fatal error: >> sql_create.c:87 Create DB Job record INSERT INTO Job >> (Job,Name,Type,Level,JobStatus,SchedTime,JobTDate) VALUES >> ('backup_zeus.2006-09-22_01.05.00','backup_zeus','B','I','C','2006-09-22 >> 01:05:00',1158901500) failed. ERR=MySQL server has gone away >> >> daemon msg: >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Catalogs' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Catalogs' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Catalogs' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Catalogs' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:168 sql_create.c:168 query SELECT PoolId,Name FROM Pool >> WHERE >> Name='Catalogs' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:168 SELECT PoolId,Name FROM Pool >> WHERE >> Name='Catalogs' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:196 sql_create.c:196 insert INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Catalogs',0,8,0,1,1,1,1,691200,0,0,0,0,'Backup',0,'catalog') >> failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:196 INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Catalogs',0,8,0,1,1,1,1,691200,0,0,0,0,'Backup',0,'catalog') >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: Pool >> Catalogs not in database. sql_create.c:198 Create db Pool record INSERT >> INTO >> Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Catalogs',0,8,0,1,1,1,1,691200,0,0,0,0,'Backup',0,'catalog') >> failed: ERR=MySQL server has gone away >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:168 sql_create.c:168 query SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:168 SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:196 sql_create.c:196 insert INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:196 INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: Pool >> Default not in database. sql_create.c:198 Create db Pool record INSERT >> INTO >> Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> ERR=MySQL server has gone away >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:168 sql_create.c:168 query SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:168 SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:196 sql_create.c:196 insert INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:196 INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: Pool >> Default not in database. sql_create.c:198 Create db Pool record INSERT >> INTO >> Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> ERR=MySQL server has gone away >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:168 sql_create.c:168 query SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:168 SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:196 sql_create.c:196 insert INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:196 INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: Pool >> Default not in database. sql_create.c:198 Create db Pool record INSERT >> INTO >> Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> ERR=MySQL server has gone away >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_get.c:555 sql_get.c:555 query SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_get.c:555 SELECT >> PoolId,Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat >> FROM Pool WHERE Pool.Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:168 sql_create.c:168 query SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:168 SELECT PoolId,Name FROM Pool >> WHERE >> Name='Default' >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: >> sql_create.c:196 sql_create.c:196 insert INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> MySQL server has gone away >> 22-Sep 13:47 zeus-dir: sql_create.c:196 INSERT INTO Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> 22-Sep 13:47 zeus-dir: *Console*.2006-09-22_13.47.11 Fatal error: Pool >> Default not in database. sql_create.c:198 Create db Pool record INSERT >> INTO >> Pool >> (Name,NumVols,MaxVols,UseOnce,UseCatalog,AcceptAnyVolume,AutoPrune,Recycle,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,MaxVolBytes,PoolType,LabelType,LabelFormat) >> VALUES ('Default',0,0,0,1,1,1,1,31536000,0,0,0,0,'Backup',0,'TAPE-') >> failed: >> ERR=MySQL server has gone away >> >> >> ------------------------------------------------------------------------- >> 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 > > - -- > ---- _ _ _ _ ___ _ _ _ > |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III > |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) > \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.5 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFFFCqLmb+gadEcsb4RAvJ3AJ0TLO6m6/1R7XRy/CpttQjX20UfswCfVHZS > mYV23U7qwSu/N2bZXHvkNZ4= > =r2D/ > -----END PGP SIGNATURE----- ------------------------------------------------------------------------- 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