Bug #74823 MySQL Enterprise Backup - ERROR: Opening of sbt file bkpsbtNB failed with error
Submitted: 12 Nov 2014 17:49 Modified: 16 Jan 2015 19:49
Reporter: Carlos Renato Silva dos Santos Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Enterprise Backup Severity:S3 (Non-critical)
Version:3.11.0 OS:Linux
Assigned to: CPU Architecture:Any
Tags: bkpsbtNB, meb, NetBackup

[12 Nov 2014 17:49] Carlos Renato Silva dos Santos
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
[16 Jan 2015 19:49] Sveta Smirnova
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Please ensure you are followed all instructions from https://blogs.oracle.com/mysqlenterprisebackup/entry/meb_support_to_netbackup_mms (I see you missed at least ORACLE_HOME environment variable and you did not follow this rule: "But please make sure that policy type is "Oracle"."), then check NetBackup error logs. If you still have issues, please, open Support ticket.
[16 Jan 2015 19:50] Sveta Smirnova
Support ticket can be opened at https://support.oracle.com