mysql - Innobackupex hot backup not working with MDB - 


140308 17:15:43 [error] mysqld got signal 6 ; because hit bug. possible binary or 1 of libraries linked against corrupt, improperly built, or misconfigured. error can caused malfunctioning hardware.  report bug, see   try our best scrape info diagnose problem, since have crashed, wrong , may fail.  server version: 5.5.36-mariadb-1~precise-log key_buffer_size=67108864 read_buffer_size=131072 max_used_connections=0 max_threads=1002 thread_count=0 possible mysqld use key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2263780 k bytes of memory hope that's ok; if not, decrease variables in equation.  thread pointer: 0x0x0 attempting backtrace. can use following information find out mysqld died. if see no messages after this, went terribly wrong... stack_bottom = 0x0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7f230db5f37b] /usr/sbin/mysqld(handle_fatal_signal+0x471)[0x7f230d785ca1] /lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f230c617cb0] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f230b63e425] /lib/x86_64-linux-gnu/libc.so.6(abort+0x17b)[0x7f230b641b8b] /usr/sbin/mysqld(+0x70cc4d)[0x7f230d9c4c4d] /usr/sbin/mysqld(+0x711cd3)[0x7f230d9c9cd3] /usr/sbin/mysqld(+0x69b8cf)[0x7f230d9538cf] /usr/sbin/mysqld(+0x6d7e41)[0x7f230d98fe41] /usr/sbin/mysqld(+0x6d8b98)[0x7f230d990b98] /usr/sbin/mysqld(+0x6727bc)[0x7f230d92a7bc] /usr/sbin/mysqld(+0x62ccb0)[0x7f230d8e4cb0] /usr/sbin/mysqld(_z24ha_initialize_handlertonp13st_plugin_in t+0x48)[0x7f230d788bc8] /usr/sbin/mysqld(+0x39722b)[0x7f230d64f22b] /usr/sbin/mysqld(_z11plugin_initpippci+0x689)[0x7f230d651839] /usr/sbin/mysqld(+0x3035a9)[0x7f230d5bb5a9] /usr/sbin/mysqld(_z11mysqld_mainippc+0x514)[0x7f230d5c0774] /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f230b62976d] /usr/sbin/mysqld(+0x2fe6e9)[0x7f230d5b66e9] manual page @  contains information should find out causing crash. 140308 17:15:43 mysqld_safe mysqld pid file /var/run/mysqld/mysqld.pid ended

hi all, created backup: innobackupex --defaults-extra-file=/etc/mysql/my.cnf --host=localhost --password= --socket=/var/run/mysqld/mysqld.sock /mnt/tempbackup/

rsynced replication box: rsync -avz --progress

restoring: innobackupex --copy-back /mnt/tempdisk/

innobackupex: starting copy innodb system tablespace innobackupex: in '/mnt/tempdisk' innobackupex: original innodb data directory '/var/lib/mysql' innobackupex: copying '/mnt/tempdisk/ibdata1' '/var/lib/mysql/ibdata1'

innobackupex: starting copy innodb undo tablespaces innobackupex: in '/mnt/tempdisk' innobackupex: '/var/lib/mysql'

innobackupex: starting copy innodb log files innobackupex: in '/mnt/tempdisk' innobackupex: original innodb log directory '/var/lib/mysql' innobackupex: finished copying files.

140308 17:47:40 innobackupex: completed ok!

chown mysql:mysql -r /var/lib/mysql

master box: innobackupex --version innodb backup utility v1.5.1-xtrabackup; copyright 2003, 2009 innobase oy

mysql --version mysql ver 14.14 distrib 5.5.35, debian-linux-gnu (x86_64) using readline 6.2

slave box: innobackupex --version innodb backup utility v1.5.1-xtrabackup; copyright 2003, 2009 innobase oy

mysql --version mysql ver 15.1 distrib 5.5.36-mariadb, debian-linux-gnu (x86_64) using readline 5.1

did miss something?

regards, andrew


Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more