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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.