Mani's Blog

January 7, 2013

InnoDB: table %s/%s: unknown table type 33

Filed under: MySQL,Xtrabackup — mani @ 11:21 pm

Ran into issue while restoring and recovering using xtrabackup.  innobackupex-1.5.1 –apply-log ./

130107 20:32:49 InnoDB: table bac002/_user: unknown table type 33
130107 20:32:49 InnoDB: table bac002/_user: unknown table type 33
130107 20:32:49InnoDB: Assertion failure in thread 1230002496 in file ibuf0ibuf.c line 1309
InnoDB: Failing assertion: len % DATA_NEW_ORDER_NULL_TYPE_BUF_SIZE <= 1
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.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
innobackupex-1.5.1: Error:
innobackupex-1.5.1: ibbackup failed at /usr/bin/innobackupex-1.5.1 line 464.
root@@xnomdb912n2:/local/mysql/data#

Solution:

I was using incorrect my.cnf file,  in my case I had incorrect binlog-format, and few other parameter.  Once I fixed them then restore/recovery worked just fine.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: