-----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
