GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Backup restore error on Ubuntu 11.04

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Backup restore error on Ubuntu 11.04

    Hello,

    I am trying to restore a backup from our production server(Redhat- Mysql-5.1.56) to a local server(Ubuntu-Mysql-5.1.54).

    The backup is done using -
    ------------------------------------------------------------ ---
    innobackupex --ibbackup=xtrabackup_51 --slave-info --no-timestamp $
    {backupdir}/data 2>&1 | tee xtrabackup.output &&
    innobackupex --ibbackup=xtrabackup_51 --apply-log $
    {backupdir}/data 2>&1 | tee xtrabackup.prepare &&
    gzip -r ${backupdir}/data/'''
    ------------------------------------------------------------ ----

    I copied the data directory to the local server and moved the mysql directory and created a new one. The data directory was copied and the ownership was corrected. The my.cnf is the same as the production server.

    I am able to start mysql, But mysql crashes and this what I see in the error logs.
    ================================================== =======
    InnoDB: The InnoDB memory heap is disabled
    InnoDB: Mutexes and rw_locks use GCC atomic builtins
    InnoDB: Compressed tables use zlib 1.2.3.4
    110912 17:13:49 InnoDB: Initializing buffer pool, size = 2.0G
    110912 17:13:49 InnoDB: Completed initialization of buffer pool
    110912 17:13:49 InnoDB: highest supported file format is Barracuda.
    110912 17:13:49 InnoDB Plugin 1.0.14 started; log sequence number 34325519037
    110912 17:13:49 [ERROR] Incorrect definition of table mysql.db: expected column 'Event_priv' at position 20 to have type enum('N','Y') but the column is not found.
    110912 17:13:49 [ERROR] Incorrect definition of table mysql.db: expected column 'Trigger_priv' at position 21 to have type enum('N','Y') but the column is not found.
    110912 17:13:49 [ERROR] mysql.user has no `Event_priv` column at position 29
    110912 17:13:49 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
    110912 17:13:49 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.1.54-1ubuntu4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)


    InnoDB: Dump of the tablespace extent descriptor: len 40; hex 00000000000000020000800009860000400018d600000004fa ffffffffea affaaaaafafffffeebaa; asc @ ;
    InnoDB: Serious error! InnoDB is trying to free page 36482
    InnoDB: though it is already marked as free in the tablespace!
    InnoDB: The tablespace free space info is corrupt.
    InnoDB: You may need to dump your InnoDB tables and recreate the whole
    InnoDB: database!
    InnoDB: Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
    InnoDB: about forcing recovery.
    110912 17:14:04 InnoDB: Assertion failure in thread 139887492855552 in file ../../../storage/innodb_plugin/fsp/fsp0fsp.c line 3331
    InnoDB: We intentionally generate a memory trap.
    InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
    InnoDB: If you get repeated assertion failures or crashes, even
    InnoDB: immediately after the mysqld startup, there may be
    InnoDB: corruption in the InnoDB tablespace. Please refer to
    InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
    InnoDB: about forcing recovery.
    110912 17:14:04 - mysqld got signal 6 ;
    This could be because you hit a bug. It is also possible that this binary
    or one of the libraries it was linked against is corrupt, improperly built,
    or misconfigured. This error can also be caused by malfunctioning hardware.
    We will try our best to scrape up some info that will hopefully help diagnose
    the problem, but since we have already crashed, something is definitely wrong
    and this may fail.


    key_buffer_size=67108864
    read_buffer_size=131072
    max_used_connections=1
    max_threads=151
    threads_connected=0
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 395673 K
    bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.

    thd: 0x0
    Attempting backtrace. You can use the following information to find out
    where mysqld died. If you see no messages after this, something went
    terribly wrong...
    stack_bottom = (nil) thread_stack 0x30000
    /usr/sbin/mysqld(my_print_stacktrace+0x26) [0x7f3aaea4c846]
    /usr/sbin/mysqld(handle_segfault+0x410) [0x7f3aae7435d0]
    /lib/x86_64-linux-gnu/libpthread.so.0(+0xfc60) [0x7f3aadfbec60]
    /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35) [0x7f3aace63d05]
    /lib/x86_64-linux-gnu/libc.so.6(abort+0x186) [0x7f3aace67ab6]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0x6197d) [0x7f3aa38ea97d]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0x64e49) [0x7f3aa38ede49]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0x1fb01) [0x7f3aa38a8b01]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0xd781c) [0x7f3aa396081c]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0xd7d60) [0x7f3aa3960d60]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0xbf945) [0x7f3aa3948945]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0xf7756) [0x7f3aa3980756]
    /usr/lib/mysql/plugin/ha_innodb_plugin.so(+0xeda5c) [0x7f3aa3976a5c]
    /lib/x86_64-linux-gnu/libpthread.so.0(+0x6d8c) [0x7f3aadfb5d8c]
    /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f3aacf1604d]
    The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
    information that should help you find out what is causing the crash.


    ================================================== =======

    Please do advice me how to fix this, As I am struggling for days on this.

    Many Thanks.

  • #2
    What XtraBackup version? Can you paste the output of backup and prepare phases.
    Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

    Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/

    Comment

    Working...
    X