MySQL Forums
Forum List  »  Backup

MEB 3.10 exception looking for INNODB symbols
Posted by: Michael Dyer
Date: April 18, 2014 10:36AM

Hello:

We have a MyISAM based database with the INNODB engine disbled (skio-innodb). The full backup fails looking for INNODB variables. Do I have to have INNODB enabled to run MEB?

Regards,
Mike Dyer


mysqlbackup: INFO: Starting with following command line ...
/opt/mysql/meb-3.10/bin/mysqlbackup --defaults-file=/etc/my.cnf
--user=root --password=xxxxxxxxxx --backup-dir=/backup/mysql_full
--with-timestamp --debug --trace=3 backup

mysqlbackup: INFO:
140417 21:19:14 mysqlbackup: INFO: Checking ulimit values:
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 151551
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 95000
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
140417 21:19:14 mysqlbackup: INFO: Checking ids:
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)
140417 21:19:14 mysqlbackup: INFO: Checking run directory:
/home/ajeadmin/jenkins-agent/workspace/ajeedw01_mysql_full_backup
mysqlbackup: TRACE_2: Value for Server Variable version_compile_os is: Linux
mysqlbackup: TRACE_2: Value for Server Variable datadir is: /db1/dbdata/
mysqlbackup: ERROR: Problem in retrieving system variable from server. The SELECT @@GLOBAL. query for innodb_data_home_dir failed with error 1193: Unknown system variable 'innodb_data_home_dir'
mysqlbackup: ERROR: Problem in retrieving system variable from server. The SELECT @@GLOBAL. query for innodb_data_file_path failed with error 1193: Unknown system variable 'innodb_data_file_path'
mysqlbackup: ERROR: Problem in retrieving system variable from server. The SELECT @@GLOBAL. query for innodb_log_group_home_dir failed with error 1193: Unknown system variable 'innodb_log_group_home_dir'
mysqlbackup: ERROR: Problem in retrieving system variable from server. The SELECT @@GLOBAL. query for innodb_log_files_in_group failed with error 1193: Unknown system variable 'innodb_log_files_in_group'
mysqlbackup: ERROR: Problem in retrieving system variable from server. The SELECT @@GLOBAL. query for innodb_log_file_size failed with error 1193: Unknown system variable 'innodb_log_file_size'
stack_bottom = 0 thread_stack 0x10000
/opt/mysql/meb-3.10/bin/mysqlbackup(my_print_stacktrace+0x32)[0x5916d8]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb9ExceptionC1ENS_18enum_error_numbersEPKcS3_i+0x83)[0x46bb93]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Server_util13get_repo_infoEv+0x45b)[0x54cdeb]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Server_util28initialize_server_connectionEv+0x7a)[0x54e4ca]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Server_utilC1Ev+0xa5)[0x54e6c5]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Config_util4initEv+0x23)[0x465623]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Config_util11init_configEv+0xb9)[0x466159]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Meb_session12init_sessionEiPPc+0xc9)[0x4762a9]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb20mysqlbackup_parallelEiPPc+0x1a)[0x53a46a]
/opt/mysql/meb-3.10/bin/mysqlbackup(main+0xa6)[0x53a646]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x34ab41d994]
/opt/mysql/meb-3.10/bin/mysqlbackup(__gxx_personality_v0+0x239)[0x454b69]
140417 21:19:14 mysqlbackup: INFO: Created path '/backup/mysql_full/2014-04-17_21-19-14'
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup' run mysqlbackup
prints "mysqlbackup completed OK!".

mysqlbackup: ERROR: innodb_data_file_path parameter missing. No chance to make a good guess, what the server uses.
mysqlbackup: ERROR: Server repository configuration problem found.
stack_bottom = 0 thread_stack 0x10000
/opt/mysql/meb-3.10/bin/mysqlbackup(my_print_stacktrace+0x32)[0x5916d8]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb9ExceptionC1ENS_18enum_error_numbersEPKcS3_i+0x83)[0x46bb93]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb7Options23normalize_server_configEv+0x8c)[0x53fe5c]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb7Options24setup_all_config_optionsEv+0x6fc)[0x5440cc]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Config_util4initEv+0x8b)[0x46568b]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Config_util11init_configEv+0xb9)[0x466159]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb11Meb_session12init_sessionEiPPc+0xc9)[0x4762a9]
/opt/mysql/meb-3.10/bin/mysqlbackup(_ZN3meb20mysqlbackup_parallelEiPPc+0x1a)[0x53a46a]
/opt/mysql/meb-3.10/bin/mysqlbackup(main+0xa6)[0x53a646]
/lib64/libc.so.6(__libc_start_main+0xf4)[0x34ab41d994]
/opt/mysql/meb-3.10/bin/mysqlbackup(__gxx_personality_v0+0x239)[0x454b69]
mysqlbackup: TRACE_1: Error occurred and closing threads.
mysqlbackup: TRACE_1: Inserting to history table.
mysqlbackup: TRACE_1: Inserting to progress table.

mysqlbackup failed with errors!

Options: ReplyQuote


Subject
Views
Written By
Posted
MEB 3.10 exception looking for INNODB symbols
3213
April 18, 2014 10:36AM


Sorry, you can't reply to this topic. It has been closed.

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.