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
