I am having an issue with bpipe and error handling and would request
that the bpipe error handling be improved in future versions.
I have a backup setup with bpipe that is able to backup just fine if the
mysqldump doesn't have an issue. When the mysql dump has an issue
bacula doesn't seem to know.
Attached is an example of a backup that should have been reported as
failed or an error.
I think that bpipe is a great function and I would love to see it be
improved going forward!
10-Nov 09:37 bacula-dir JobId 87570: Start Backup JobId 87570,
Job=ve-dev1-mysql-export.2009-11-10_09.37.24_02
10-Nov 09:37 bacula-dir JobId 87570: Using Device "nst0"
10-Nov 09:37 bacula-sd JobId 87570: Job write elapsed time = 00:00:23,
Transfer rate = 9.115 M Bytes/second
10-Nov 09:37 bacula-sd JobId 87570: Sending spooled attrs to the
Director. Despooling 320 bytes ...
10-Nov 09:37 bacula-dir JobId 87570: Bacula bacula-dir 3.1.4 (18Oct09):
10-Nov-2009 09:37:51
Build OS: x86_64-unknown-linux-gnu redhat Enterprise
release
JobId: 87570
Job: ve-dev1-mysql-export.2009-11-10_09.37.24_02
Backup Level: Full
Client: "ve-dev1" 3.1.4 (01Nov09)
i686-pc-linux-gnu,redhat,Enterprise release
FileSet: "MYSQL-BPIPE-DUMP-ALL" 2009-02-24 11:41:36
Pool: "Daily" (From Job resource)
Catalog: "MyCatalog" (From Client resource)
Storage: "Autochanger" (From Job resource)
Scheduled time: 10-Nov-2009 09:37:24
Start time: 10-Nov-2009 09:37:26
End time: 10-Nov-2009 09:37:51
Elapsed time: 25 secs
Priority: 20
FD Files Written: 1
SD Files Written: 1
FD Bytes Written: 209,663,857 (209.6 MB)
SD Bytes Written: 209,664,087 (209.6 MB)
Rate: 8386.6 KB/s
Software Compression: None
VSS: no
Encryption: no
Accurate: no
Volume name(s): CA3414L4
Volume Session Id: 2587
Volume Session Time: 1256084409
Last Volume Bytes: 1,005,336,433,664 (1.005 TB)
Non-fatal FD errors: 0
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: Backup OK
10-Nov 09:37 bacula-dir JobId 87570: Begin pruning Jobs.
10-Nov 09:37 bacula-dir JobId 87570: No Jobs found to prune.
10-Nov 09:37 bacula-dir JobId 87570: Begin pruning Files.
10-Nov 09:37 bacula-dir JobId 87570: No Files found to prune.
10-Nov 09:37 bacula-dir JobId 87570: End auto prune.
sudo /sbin/bacula-fd -d9 -f -v -c /etc/bacula/bacula-fd.conf
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'message_obs' (Can't open file: 'message_obs.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'awards' (Can't open file: 'awards.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'boardroom' (Can't open file: 'boardroom.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'company_logos' (Can't open file: 'company_logos.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'company_master' (Can't open file: 'company_master.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'company_profile' (Can't open file: 'company_profile.InnoDB'. (errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'event_master' (Can't open file: 'event_master.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'golf' (Can't open file: 'golf.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'meeting' (Can't open file: 'meeting.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'message' (Can't open file: 'message.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'message_obs' (Can't open file: 'message_obs.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'nv_raffle_form' (Can't open file: 'nv_raffle_form.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'nv_vendor_pre_event_survey' (Can't open file:
'nv_vendor_pre_event_survey.In
noDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'participant' (Can't open file: 'participant.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'participant_profile' (Can't open file: 'participant_profile.InnoDB'.
(errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'participant_reseller' (Can't open file: 'participant_reseller.InnoDB'.
(errn
o: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'reseller_event_interest' (Can't open file:
'reseller_event_interest.InnoDB'.
(errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'reseller_profile' (Can't open file: 'reseller_profile.InnoDB'. (errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'vendor_profile' (Can't open file: 'vendor_profile.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'analyst' (Can't open file: 'analyst.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'analyst_meeting' (Can't open file: 'analyst_meeting.InnoDB'. (errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'analyst_mi_participant_note' (Can't open file:
'analyst_mi_participant_note.
InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'boardroom_matrix' (Can't open file: 'boardroom_matrix.InnoDB'. (errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'boardroom_matrix_config' (Can't open file:
'boardroom_matrix_config.InnoDB'.
(errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'boardroom_matrix_view' (Can't open file:
'boardroom_matrix_view.InnoDB'. (er
rno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'boardroom_tracks' (Can't open file: 'boardroom_tracks.InnoDB'. (errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'boardroom_vendor' (Can't open file: 'boardroom_vendor.InnoDB'. (errno:
1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'company_logos' (Can't open file: 'company_logos.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'company_master' (Can't open file: 'company_master.InnoDB'. (errno: 1))
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
'company_product_category' (Can't open file:
'company_product_category.InnoDB
Thanks -Jason
--
----------------------------------------------------------------------------
Jason A. Kates ([email protected])
Fax: 208-975-1514
Phone: 660-960-0070
============================================================================
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel
