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 00000000000000020000800009860000400018d600000004faffffffffea 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: [URL=“http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html”] http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html[/URL]
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: [URL=“http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html”] http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html[/URL]
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 [URL]http://dev.mysql.com/doc/mysql/en/crashing.html[/URL] 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.