MEB 3.10 exception looking for INNODB symbols
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!