Erro Backup Catálogo (mysql error 2013 and 2006)
299 views
Skip to first unread message
Filipe Araujo
Jun 20, 2015, 11:27:16 AM6/20/15
to bacula-ba...@googlegroups.com
Bom dia Pessoal,
Recentemente meu bacula começou à apresentar erro ao efetuar o backup do catalogo, mais somente do catalogo. Nos logs de backup o erro é no mysql já tentei algumas soluções como por exemplo alterar algumas configurações no my.cnf como por exemplo:
[Mysqld]
wait_timeout = 86400
max_allowed_packet = 32M
innodb_buffer_pool_size = 1G
E o erro continua, alguém já passou por esse problema? A versão do meu Mysql é a 5.5.43, estou postando o log do erro:
9-Jun 23:10 backupserver-dir JobId 400: shell command: run BeforeJob "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog"
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `File` at row: 142146
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'FileSet'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'FileSet'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Filename'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Filename'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Job'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Job'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'JobHisto'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'JobHisto'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'JobMedia'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'JobMedia'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Location'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Location'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'LocationLog'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'LocationLog'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Log'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Log'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Media'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Media'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'MediaType'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'MediaType'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Path'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Path'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'PathHierarchy'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'PathHierarchy'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'PathVisibility'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'PathVisibility'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Pool'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Pool'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'RestoreObject'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'RestoreObject'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Status'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Status'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Storage'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Storage'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'UnsavedFiles'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'UnsavedFiles'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Version'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Version'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'UNLOCK TABLES': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: Error: Runscript: BeforeJob returned non-zero status=3. ERR=Child exited with code 3
19-Jun 23:10 backupserver-dir JobId 400: Error: sql_update.c:111 sql_update.c:111 update UPDATE Job SET JobStatus='E',Level='F',StartTime='2015-06-19 23:10:03',ClientId=1,JobTDate=1434766203,PoolId=2,FileSetId=2 WHERE JobId=400 failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (400,'2015-06-19 23:10:03','backupserver-dir JobId 400: Error: sql_update.c:111 sql_update.c:111 update UPDATE Job SET JobStatus=\'E\',Level=\'F\',StartTime=\'2015-06-19 23:10:03\',ClientId=1,JobTDate=1434766203,PoolId=2,FileSetId=2 WHERE JobId=400 failed:\nCan\'t connect to local MySQL server through socket \'/var/run/mysqld/mysqld.sock\' (111)\n\0'): ERR=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Error: sql_update.c:190 sql_update.c:190 update UPDATE Job SET JobStatus='E',EndTime='2015-06-19 23:10:03',ClientId=1,JobBytes=0,ReadBytes=0,JobFiles=0,JobErrors=2,VolSessionId=0,VolSessionTime=0,PoolId=2,FileSetId=2,JobTDate=1434766203,RealEndTime='2015-06-19 23:10:03',PriorJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=400 failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Warning: Error updating job record. Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (400,'2015-06-19 23:10:03','backupserver-dir JobId 400: Error: sql_update.c:190 sql_update.c:190 update UPDATE Job SET JobStatus=\'E\',EndTime=\'2015-06-19 23:10:03\',ClientId=1,JobBytes=0,ReadBytes=0,JobFiles=0,JobErrors=2,VolSessionId=0,VolSessionTime=0,PoolId=2,FileSetId=2,JobTDate=1434766203,RealEndTime=\'2015-06-19 23:10:03\',PriorJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=400 failed:\nCan\'t connect to local MySQL server through socket \'/var/run/mysqld/mysqld.sock\' (111)\n\0'): ERR=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql_get.c:301 sql_get.c:301 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=400 failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Warning: Error getting Job record for Job report: ERR=Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (400,'2015-06-19 23:10:03','backupserver-dir JobId 400: Fatal error: sql_get.c:301 sql_get.c:301 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=400 failed:\nCan\'t connect to local MySQL server through socket \'/var/run/mysqld/mysqld.sock\' (111)\n\0'): ERR=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql_get.c:716 sql_get.c:716 query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.Name='backupserver-fd' failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Warning: Error getting Client record for Job report: ERR=Client record not found in Catalog.
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql.c:339 sql.c:339 query SELECT count(*) from Media failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql_get.c:375 sql_get.c:375 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media WHERE JobMedia.JobId=400 AND JobMedia.MediaId=Media.MediaId GROUP BY VolumeName ORDER BY 2 ASC failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Error: Bacula backupserver-dir 7.0.5 (28Jul14):
Build OS: x86_64-unknown-linux-gnu debian
JobId: 400
Job: BackupCatalog.2015-06-19_23.10.00_19
Backup Level: Full
Client: "backupserver-fd"
FileSet: "Catalog" 2015-04-23 23:10:00
Pool: "File" (From Job resource)
Catalog: "MyCatalog" (From Client resource)
Storage: "File" (From Job resource)
Scheduled time: 19-Jun-2015 23:10:00
Start time: 19-Jun-2015 23:10:03
End time: 19-Jun-2015 23:10:03
Elapsed time: 0 secs
Priority: 11
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s):
Volume Session Id: 0
Volume Session Time: 0
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors: 3
SD Errors: 0
FD termination status:
SD termination status:
Termination: *** Backup Error ***
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `File` at row: 142146
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'FileSet'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'FileSet'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Filename'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Filename'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Job'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Job'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'JobHisto'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'JobHisto'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'JobMedia'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'JobMedia'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Location'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Location'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'LocationLog'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'LocationLog'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Log'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Log'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Media'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Media'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'MediaType'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'MediaType'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Path'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Path'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'PathHierarchy'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'PathHierarchy'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'PathVisibility'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'PathVisibility'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Pool'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Pool'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'RestoreObject'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'RestoreObject'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Status'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Status'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Storage'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Storage'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'UnsavedFiles'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'UnsavedFiles'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'show table status like 'Version'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SET SQL_QUOTE_SHOW_CREATE=1': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'SELECT `COLUMN_NAME` AS `Field`, `COLUMN_TYPE` AS `Type`, `IS_NULLABLE` AS `Null`, `COLUMN_KEY` AS `Key`, `COLUMN_DEFAULT` AS `Default`, `EXTRA` AS `Extra`, `COLUMN_COMMENT` AS `Comment` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE TABLE_SCHEMA = 'bacula' AND TABLE_NAME = 'Version'': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: BeforeJob: mysqldump: Couldn't execute 'UNLOCK TABLES': MySQL server has gone away (2006)
19-Jun 23:10 backupserver-dir JobId 400: Error: Runscript: BeforeJob returned non-zero status=3. ERR=Child exited with code 3
19-Jun 23:10 backupserver-dir JobId 400: Error: sql_update.c:111 sql_update.c:111 update UPDATE Job SET JobStatus='E',Level='F',StartTime='2015-06-19 23:10:03',ClientId=1,JobTDate=1434766203,PoolId=2,FileSetId=2 WHERE JobId=400 failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (400,'2015-06-19 23:10:03','backupserver-dir JobId 400: Error: sql_update.c:111 sql_update.c:111 update UPDATE Job SET JobStatus=\'E\',Level=\'F\',StartTime=\'2015-06-19 23:10:03\',ClientId=1,JobTDate=1434766203,PoolId=2,FileSetId=2 WHERE JobId=400 failed:\nCan\'t connect to local MySQL server through socket \'/var/run/mysqld/mysqld.sock\' (111)\n\0'): ERR=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Error: sql_update.c:190 sql_update.c:190 update UPDATE Job SET JobStatus='E',EndTime='2015-06-19 23:10:03',ClientId=1,JobBytes=0,ReadBytes=0,JobFiles=0,JobErrors=2,VolSessionId=0,VolSessionTime=0,PoolId=2,FileSetId=2,JobTDate=1434766203,RealEndTime='2015-06-19 23:10:03',PriorJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=400 failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Warning: Error updating job record. Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (400,'2015-06-19 23:10:03','backupserver-dir JobId 400: Error: sql_update.c:190 sql_update.c:190 update UPDATE Job SET JobStatus=\'E\',EndTime=\'2015-06-19 23:10:03\',ClientId=1,JobBytes=0,ReadBytes=0,JobFiles=0,JobErrors=2,VolSessionId=0,VolSessionTime=0,PoolId=2,FileSetId=2,JobTDate=1434766203,RealEndTime=\'2015-06-19 23:10:03\',PriorJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=400 failed:\nCan\'t connect to local MySQL server through socket \'/var/run/mysqld/mysqld.sock\' (111)\n\0'): ERR=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql_get.c:301 sql_get.c:301 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=400 failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Warning: Error getting Job record for Job report: ERR=Query failed: INSERT INTO Log (JobId, Time, LogText) VALUES (400,'2015-06-19 23:10:03','backupserver-dir JobId 400: Fatal error: sql_get.c:301 sql_get.c:301 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime,ReadBytes,HasBase,PurgedFiles FROM Job WHERE JobId=400 failed:\nCan\'t connect to local MySQL server through socket \'/var/run/mysqld/mysqld.sock\' (111)\n\0'): ERR=Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql_get.c:716 sql_get.c:716 query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.Name='backupserver-fd' failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Warning: Error getting Client record for Job report: ERR=Client record not found in Catalog.
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql.c:339 sql.c:339 query SELECT count(*) from Media failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Fatal error: sql_get.c:375 sql_get.c:375 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media WHERE JobMedia.JobId=400 AND JobMedia.MediaId=Media.MediaId GROUP BY VolumeName ORDER BY 2 ASC failed:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
19-Jun 23:10 backupserver-dir JobId 400: Error: Bacula backupserver-dir 7.0.5 (28Jul14):
Build OS: x86_64-unknown-linux-gnu debian
JobId: 400
Job: BackupCatalog.2015-06-19_23.10.00_19
Backup Level: Full
Client: "backupserver-fd"
FileSet: "Catalog" 2015-04-23 23:10:00
Pool: "File" (From Job resource)
Catalog: "MyCatalog" (From Client resource)
Storage: "File" (From Job resource)
Scheduled time: 19-Jun-2015 23:10:00
Start time: 19-Jun-2015 23:10:03
End time: 19-Jun-2015 23:10:03
Elapsed time: 0 secs
Priority: 11
FD Files Written: 0
SD Files Written: 0
FD Bytes Written: 0 (0 B)
SD Bytes Written: 0 (0 B)
Rate: 0.0 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s):
Volume Session Id: 0
Volume Session Time: 0
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors: 3
SD Errors: 0
FD termination status:
SD termination status:
Termination: *** Backup Error ***
Heitor Faria
Jun 20, 2015, 2:19:42 PM6/20/15
to bacula-ba...@googlegroups.com
Oi Filipe,
Parece ser um problema do Mysql.
Pode alterar essa configuração ou setar antes do dump:
mysql -e "SET GLOBAL net_write_timeout=30; SET GLOBAL max_allowed_packet=1024*1024*1024;"
Abraços,
=======================================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F | Bacula Systems Certified Administrator II
Heitor Medrado de Faria - LPIC-III | ITIL-F | Bacula Systems Certified Administrator II
29 de junho a 13 de julho: Treinamento Telepresencial Bacula: http://www.bacula.com.br/?p=2174
Site: www.bacula.com.br | Facebook: heitor.faria
========================================================================
--
Você recebeu essa mensagem porque está inscrito no grupo "Bacula Backup-Pt-Br" dos Grupos do Google.
Para cancelar inscrição nesse grupo e parar de receber e-mails dele, envie um e-mail para bacula-backup-p...@googlegroups.com.
Para postar nesse grupo, envie um e-mail para bacula-ba...@googlegroups.com.
Acesse esse grupo em http://groups.google.com/group/bacula-backup-pt-br.
Para ver essa discussão na Web, acesse https://groups.google.com/d/msgid/bacula-backup-pt-br/bebb4867-aa7b-43cd-9d49-63341cad9991%40googlegroups.com.
Para mais opções, acesse https://groups.google.com/d/optout.
Filipe Araujo
Jun 22, 2015, 2:48:44 PM6/22/15
to bacula-ba...@googlegroups.com
Eu setei no my.cnf essa configuração em [Mysqld], após a mudança o Mysql nem sobe..
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
net_write_timeout = 30
max_allowed_packet = 1024*1024*1024...
Wanderlei
Jun 22, 2015, 3:04:46 PM6/22/15
to bacula-ba...@googlegroups.com
Ola Filipe,
Pelo que entendi, esse comando deve ser executado na linha de comando.
Att Wanderlei
Filipe Araujo
Jun 22, 2015, 3:23:34 PM6/22/15
to bacula-ba...@googlegroups.com
Olá Wanderlei,
Mais o backup do catalogo é efetuado automaticamente, esse comando é para ser executado apenas 1 unica vez? Ou toda vez que o backup do catalogo for executado ?
Wanderlei
Jun 22, 2015, 4:12:14 PM6/22/15
to bacula-ba...@googlegroups.com
Fala Felipe
Fiz um teste aqui no meu mysql no my.cnf.
Em vez de 1024*1024*1024, coloca o valor = 1073741824
#################################
net_write_timeout = 30
max_allowed_packet = 1073741824
#################################
Parei e iniciei o mysql normalmente
Att Wanderlei
Filipe Araujo
Jun 24, 2015, 1:45:27 PM6/24/15
to bacula-ba...@googlegroups.com
Boa tarde Wanderlei,
Desculpa a demora na resposta e também minha ignorância rsrs, fiz o teste com as variáveis no [Mysqld] e o problema ainda persiste no erro do backup do catálogo =(..
Wanderlei
Jun 24, 2015, 2:02:39 PM6/24/15
to bacula-ba...@googlegroups.com
Tua base é muito grande Filipe?
Vi num site que está para setar para "set max_allowed_packet = 128M
Você tentou fazer um dump manual:
mysqldump -u root bacula > bacula.sql
Você já tentou reinciar o servidor também?
Att Wanderlei
Filipe Araujo
Jun 24, 2015, 3:10:09 PM6/24/15
to bacula-ba...@googlegroups.com
Wanderlei minha base é pequena 265 MB, só utilizo ela para o Bacula.
Setei a variavel max_allowed_packet = 128M em [Mysqld] restartei o mysql e o servidor, e o backup concluiu sem erros MARAVILHA:
Agradeço sua ajuda e o compartilhamento de seus conhecimentos Wanderlei
24-Jun 16:01 backupserver-dir JobId 426: shell command: run BeforeJob "/etc/bacula/scripts/make_catalog_backup.pl MyCatalog"
24-Jun 16:01 backupserver-dir JobId 426: Start Backup JobId 426, Job=BackupCatalog.2015-06-24_16.01.05_03
24-Jun 16:01 backupserver-dir JobId 426: Using Device "FileStorage" to write.
24-Jun 16:01 backupserver-sd JobId 426: Volume "vol0113" previously written, moving to end of data.
24-Jun 16:01 backupserver-sd JobId 426: Ready to append to end of Volume "vol0113" size=968,417,775
24-Jun 16:01 backupserver-sd JobId 426: Elapsed time=00:00:11, Transfer rate=12.18 M Bytes/second
24-Jun 16:01 backupserver-sd JobId 426: Sending spooled attrs to the Director. Despooling 287 bytes ...
24-Jun 16:01 backupserver-dir JobId 426: Bacula backupserver-dir 7.0.5 (28Jul14):
Build OS: x86_64-unknown-linux-gnu debian
JobId: 426
Job: BackupCatalog.2015-06-24_16.01.05_03
Backup Level: Full
Client: "backupserver-fd" 7.0.5 (28Jul14) x86_64-unknown-linux-gnu,debian,
24-Jun 16:01 backupserver-dir JobId 426: Start Backup JobId 426, Job=BackupCatalog.2015-06-24_16.01.05_03
24-Jun 16:01 backupserver-dir JobId 426: Using Device "FileStorage" to write.
24-Jun 16:01 backupserver-sd JobId 426: Volume "vol0113" previously written, moving to end of data.
24-Jun 16:01 backupserver-sd JobId 426: Ready to append to end of Volume "vol0113" size=968,417,775
24-Jun 16:01 backupserver-sd JobId 426: Elapsed time=00:00:11, Transfer rate=12.18 M Bytes/second
24-Jun 16:01 backupserver-sd JobId 426: Sending spooled attrs to the Director. Despooling 287 bytes ...
24-Jun 16:01 backupserver-dir JobId 426: Bacula backupserver-dir 7.0.5 (28Jul14):
Build OS: x86_64-unknown-linux-gnu debian
JobId: 426
Job: BackupCatalog.2015-06-24_16.01.05_03
Backup Level: Full
Client: "backupserver-fd" 7.0.5 (28Jul14) x86_64-unknown-linux-gnu,debian,
FileSet: "Catalog" 2015-04-23 23:10:00
Pool: "File" (From Job resource)
Catalog: "MyCatalog" (From Client resource)
Storage: "File" (From Job resource)
Scheduled time: 24-Jun-2015 16:01:03
Start time: 24-Jun-2015 16:01:17
End time: 24-Jun-2015 16:01:30
Elapsed time: 13 secs
Priority: 11
FD Files Written: 1
SD Files Written: 1
FD Bytes Written: 134,022,975 (134.0 MB)
SD Bytes Written: 134,023,088 (134.0 MB)
Rate: 10309.5 KB/s
Start time: 24-Jun-2015 16:01:17
End time: 24-Jun-2015 16:01:30
Elapsed time: 13 secs
Priority: 11
FD Files Written: 1
SD Files Written: 1
FD Bytes Written: 134,022,975 (134.0 MB)
SD Bytes Written: 134,023,088 (134.0 MB)
Rate: 10309.5 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s): vol0113
Volume Session Id: 1
Volume Session Time: 1435172367
Last Volume Bytes: 1,102,540,693 (1.102 GB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK
24-Jun 16:01 backupserver-dir JobId 426: Begin pruning Jobs older than 6 months .
24-Jun 16:01 backupserver-dir JobId 426: No Jobs found to prune.
24-Jun 16:01 backupserver-dir JobId 426: Begin pruning Files.
24-Jun 16:01 backupserver-dir JobId 426: Pruned Files from 1 Jobs for client backupserver-fd from catalog.
24-Jun 16:01 backupserver-dir JobId 426: End auto prune.
24-Jun 16:01 backupserver-dir JobId 426: shell command: run AfterJob "/etc/bacula/scripts/delete_catalog_backup"
Volume Session Id: 1
Volume Session Time: 1435172367
Last Volume Bytes: 1,102,540,693 (1.102 GB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK
24-Jun 16:01 backupserver-dir JobId 426: Begin pruning Jobs older than 6 months .
24-Jun 16:01 backupserver-dir JobId 426: No Jobs found to prune.
24-Jun 16:01 backupserver-dir JobId 426: Begin pruning Files.
24-Jun 16:01 backupserver-dir JobId 426: Pruned Files from 1 Jobs for client backupserver-fd from catalog.
24-Jun 16:01 backupserver-dir JobId 426: End auto prune.
24-Jun 16:01 backupserver-dir JobId 426: shell command: run AfterJob "/etc/bacula/scripts/delete_catalog_backup"
Wanderlei
Jun 25, 2015, 9:12:07 AM6/25/15
to bacula-ba...@googlegroups.com
Bom Dia Filipe
Que bom que conseguiu resolver!
Qualquer coisa estamos ai!
Abraço
Wanderlei
Reply all
Reply to author
Forward
0 new messages