Hi, I seem to run into trouble when I try to backup my mysql database servers and the dump takes longer then 2 hours. I dont have a lot of large databases, but a couple with some large tables. This is the case on every single backup attempt i've had. (For the job status/run report please see the end of the email).
Seems that because mysqldump doesnt output anything while dumping those tables, that it just times out. I wrote the mysql_backup.sh wrapper script to mysqldump Note that I do have: Heartbeat Interval = 300 # 5 min set in the director (both in director and storage directives), file and storage daemons. Is there something that I'm missing? Should I consider doing the dumps on cron a 3-4 hours before beginning the backup with bacula? Are there any other suggestions out there? Thanks for the help! Regards, Renato Ah, and here is a sample output/report from bacula I get on email: 17-May 23:05 backupsrv-dir JobId 12726: No prior Full backup Job record found. 17-May 23:05 backupsrv-dir JobId 12726: No prior or suitable Full backup found in catalog. Doing FULL backup. 18-May 09:07 backupsrv-dir JobId 12726: Start Backup JobId 12726, Job=dbserver-mysql.2010-05-17_23.05.02_42 18-May 09:07 backupsrv-dir JobId 12726: Using Device "MySTORAGE" 18-May 09:07 dbserver-fd JobId 12726: shell command: run ClientBeforeJob "/usr/local/sbin/mysql_backup.sh" 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: 20100518.090720>> Will flush binary log when dumping data 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: 20100518.090720>> Removing files older then +1 days: (...) 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: 20100518.090720>> Backing up: cdr_db 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: mysql 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: 20100518.090759>> mysqldump struct of cdr_db 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: -- Connecting to localhost... 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving table structure for table buc_buckets... 18-May 09:07 dbserver-fd JobId 12726: ClientBeforeJob: -- Skipping dump data for table 'buc_buckets', --no-data was used 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving table structure for table calls... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Skipping dump data for table 'calls', --no-data was used (...) 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Disconnecting from localhost... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: 20100518.090822>> mysqldump data of cdr_db 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Connecting to localhost... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving table structure for table buc_buckets... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Sending SELECT query... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving rows... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving table structure for table calls... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Sending SELECT query... 18-May 09:08 dbserver-fd JobId 12726: ClientBeforeJob: -- Retrieving rows... 18-May 11:08 backupsrv-dir JobId 12726: Fatal error: Socket error on RunBeforeNow command: ERR=Connection reset by peer 18-May 11:08 backupsrv-dir JobId 12726: Fatal error: Client "dbserver-fd" RunScript failed. 18-May 11:08 backupsrv-dir JobId 12726: Fatal error: Network error with FD during Backup: ERR=Connection reset by peer 18-May 11:08 backupsrv-dir JobId 12726: Fatal error: No Job status returned from FD. 18-May 11:08 backupsrv-dir JobId 12726: Error: Bacula backupsrv-dir 3.0.3 (18Oct09): 18-May-2010 11:08:38 Build OS: x86_64-redhat-linux-gnu redhat Enterprise release JobId: 12726 Job: dbserver-mysql.2010-05-17_23.05.02_42 Backup Level: Full (upgraded from Incremental) Client: "dbserver-fd" 3.0.2 (18Jul09) x86_64-redhat-linux-gnu,redhat,Enterprise release FileSet: "MySQLDumpFiles" 2010-02-09 21:23:58 Pool: "MySQL-Full" (From Job FullPool override) Catalog: "MyCatalog" (From Client resource) Storage: "MySTORAGE" (From Job resource) Scheduled time: 17-May-2010 23:05:02 Start time: 18-May-2010 09:07:20 End time: 18-May-2010 11:08:38 Elapsed time: 2 hours 1 min 18 secs Priority: 40 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: 656 Volume Session Time: 1273435024 Last Volume Bytes: 465,870,484 (465.8 MB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: Error SD termination status: Error Termination: *** Backup Error *** ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
