Bug #74187 InnoDB: Assertion failure in thread 140575349729088 in file fsp0fsp.c line 2102
Submitted: 2 Oct 2014 7:55 Modified: 22 Aug 2015 11:50
Reporter: Lutz Boldt Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.5.38-0 OS:Linux (Ubuntu)
Assigned to: CPU Architecture:Any

[2 Oct 2014 7:55] Lutz Boldt
Description:
Our Server crashs with this error-message:
141002  9:04:33 [Note] Plugin 'FEDERATED' is disabled.
141002  9:04:33 InnoDB: The InnoDB memory heap is disabled
141002  9:04:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141002  9:04:33 InnoDB: Compressed tables use zlib 1.2.3.4
141002  9:04:33 InnoDB: Initializing buffer pool, size = 256.0M
141002  9:04:33 InnoDB: Completed initialization of buffer pool
141002  9:04:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141002  9:04:33  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
141002  9:04:33  InnoDB: Assertion failure in thread 140575349729088 in file fsp0fsp.c line 2102
InnoDB: Failing assertion: inode
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.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
07:04:33 UTC - 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=16777216
read_buffer_size=131072
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 346700 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 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 = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x7f2103b34b09]
/usr/sbin/mysqld(handle_fatal_signal+0x483)[0x7f21039f9e23]
/lib/x86_64-linux-gnu/libpthread.so.0(+0xfcb0)[0x7f2102743cb0]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x35)[0x7f2101daf0d5]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x17b)[0x7f2101db283b]
/usr/sbin/mysqld(+0x67bc80)[0x7f2103c56c80]
/usr/sbin/mysqld(+0x681602)[0x7f2103c5c602]
/usr/sbin/mysqld(+0x68da1e)[0x7f2103c68a1e]
/usr/sbin/mysqld(+0x658a85)[0x7f2103c33a85]
/usr/sbin/mysqld(+0x605675)[0x7f2103be0675]
/usr/sbin/mysqld(+0x5cf339)[0x7f2103baa339]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x7f21039fc4f1]
/usr/sbin/mysqld(+0x30dc41)[0x7f21038e8c41]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0xa94)[0x7f21038ec284]
/usr/sbin/mysqld(+0x284e76)[0x7f210385fe76]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x624)[0x7f2103863734]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f2101d9a76d]
/usr/sbin/mysqld(+0x27e775)[0x7f2103859775]

How to repeat:
First, our Server crashs with this error:

[Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Initializing buffer pool, size = 16.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting

After a search, we found this: http://superuser.com/questions/653953/cant-start-mysql-xampp-after-installing-on-external-... (Answer 1).
[22 Aug 2015 11:50] MySQL Verification Team
this crash is due to improperly creating innodb tablespace/subsystem from the start.  you need to recreate it from scratch (innodb log files and ibdata).