Description:
Dear support,
I have a problem to integrated MySQL Enterprise Backup with Netbackup and I have configurated a policy on Netbackup and executed backup on MEB, but during executing the MEB presented this error:
mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
141106 15:42:25 mysqlbackup: ERROR: meb_sbt_session_open: sbtinit() failed with error -1, oerror -1, verror 7501
mysqlbackup: ERROR: Opening of sbt file bkpsbtNB failed with error code: 1.
mysqlbackup failed with errors!
I used this command line :
[root@XXX~]# mysqlbackup --datadir=/home/database/ --port=3306 --protocol=tcp --user=backup --password=backup --backup-image=sbt:bkpsbtNB --sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64 --sbt-environment="NB_ORA_SERV=BX, NB_ORA_CLIENT=XNEW, NB_ORA_POLICY=MK-CX-PX-MEB" --backup-dir=/home/backupdir/ backup-to-image
And this command presented this output:
MySQL Enterprise Backup version 3.11.0 Linux-2.6.18-194.el5-x86_64 [2014/08/26]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.
mysqlbackup: INFO: Starting with following command line ...
mysqlbackup --datadir=/home/database/ --port=3306 --protocol=tcp
--user=backup --password=xxxxxx --backup-image=sbt:bkpsbtNB
--sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64
--sbt-environment=NB_ORA_SERV=X, NB_ORA_CLIENT=BX, NB_ORA_POLICY=MK-CX-PX-MEB
--backup-dir=/home/backupdir/ backup-to-image
mysqlbackup: INFO:
mysqlbackup: INFO: MySQL server version is '5.6.20-enterprise-commercial-advanced-log'.
mysqlbackup: INFO: Got some server configuration information from running server.
mysqlbackup: INFO: sbt-environment: 'NB_ORA_SERV=BX, NB_ORA_CLIENT=BX, NB_ORA_POLICY=MK-CX-PX-MEB'
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-to-image' run mysqlbackup
prints "mysqlbackup completed OK!".
141106 15:42:23 mysqlbackup: INFO: MEB logfile created at /home/backupdir/meta/MEB_2014-11-06.15-42-23_image_backup.log
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /home/database/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /home/database/
innodb_log_files_in_group = 2
innodb_log_file_size = 268435456
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
innodb_undo_directory = /home/database/
innodb_undo_tablespaces = 0
innodb_undo_logs = 128
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /home/backupdir/datadir
innodb_data_home_dir = /home/backupdir/datadir
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /home/backupdir/datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 268435456
innodb_page_size = 16384
innodb_checksum_algorithm = innodb
innodb_undo_directory = /home/backupdir/datadir
innodb_undo_tablespaces = 0
innodb_undo_logs = 128
Backup Image Path = bkpsbtNB
mysqlbackup: INFO: Unique generated backup id for this is 14152957433599170
mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
141106 15:42:25 mysqlbackup: ERROR: meb_sbt_session_open: sbtinit() failed with error -1, oerror -1, verror 7501
mysqlbackup: ERROR: Opening of sbt file bkpsbtNB failed with error code: 1.
mysqlbackup failed with errors!
Can you analyze this error and report a solution or a work around,
Thanks,
How to repeat:
mysqlbackup --datadir=/home/database/ --port=3306 --protocol=tcp --user=backup --password=backup --backup-image=sbt:bkpsbtNB --sbt-lib-path=/usr/openv/netbackup/bin/libobk.so64 --sbt-environment="NB_ORA_SERV=BX, NB_ORA_CLIENT=BX, NB_ORA_POLICY=MK-CX-PX-MEB" --backup-dir=/home/backupdir/ backup-to-image