Bug #74823 MySQL Enterprise Backup - ERROR: Opening of sbt file bkpsbtNB failed with error
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
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.
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