My Oracle Support Banner

Crash on Startup With Signal 6 - File Fails ; InnoDB: Failing Assertion: ret || !assert_on_error (Doc ID 1586243.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.


On startup, or restart of an otherwise working installation, mysqld fails with the following error in the logs:

[Note] Plugin 'FEDERATED' is disabled.
[Note] InnoDB: The InnoDB memory heap is disabled
[Note] InnoDB: Mutexes and rw_locks use Solaris atomic functions
[Note] InnoDB: Compressed tables use zlib 1.2.3
[Note] InnoDB: Not using CPU crc32 instructions
[Note] InnoDB: Initializing buffer pool, size = 32.0G
InnoDB: Assertion failure in thread 1 in file line 105
InnoDB: Failing assertion: ret || !assert_on_error
InnoDB: We intentionally generate a memory trap.

mysqld got signal 6 ;

terribly wrong...
/usr/sbin/mysqld'my_print_stacktrace+0x1e [0xf23a02]
/usr/sbin/mysqld'handle_fatal_signal+0x3e7 [0xba64a3]
/lib/amd64/'__sighndlr+0x6 [0xfffffd7fff232616]
/lib/amd64/'call_user_handler+0x2aa [0xfffffd7fff225de6]
/lib/amd64/'_lwp_kill+0xa [0xfffffd7fff23b82a] [Signal 6 (ABRT)]
/lib/amd64/'raise+0x19 [0xfffffd7fff1e1169]
/lib/amd64/'abort+0x5d [0xfffffd7fff1b7b65]
/usr/sbin/mysqld'void*ut_malloc_low(unsigned long,unsigned long)+0x2e8 [0x115e22c]
/usr/sbin/mysqld'os_event*os_event_create()+0x20 [0x10b2af0]
/usr/sbin/mysqld'void mutex_create_func(ib_mutex_t*,const char*,unsigned long)+0x2a [0x113a7b2]
/usr/sbin/mysqld'void buf_block_init(buf_pool_t*,buf_block_t*,unsigned char*)+0xba [0x118ef0e]
/usr/sbin/mysqld'buf_chunk_t*buf_chunk_init(buf_pool_t*,buf_chunk_t*,unsigned long)+0x12e [0x118f07e]
/usr/sbin/mysqld'unsigned long buf_pool_init_instance(buf_pool_t*,unsigned long,unsigned long)+0x198 [0x118f530]
/usr/sbin/mysqld'dberr_t buf_pool_init(unsigned long,unsigned long)+0x8b [0x118f97b]
/usr/sbin/mysqld'dberr_t innobase_start_or_create_for_mysql()+0x758 [0x1135684]
/usr/sbin/mysqld'int innobase_init(void*)+0x8cb [0x105063b]
/usr/sbin/mysqld'int ha_initialize_handlerton(st_plugin_int*)+0x4f [0xaaf333]
/usr/sbin/mysqld'int plugin_initialize(st_plugin_int*)+0x68 [0xc45b60]
/usr/sbin/mysqld'int plugin_init(int*,char**,int)+0xa5f [0xc46833]
/usr/sbin/mysqld'int init_server_components()+0x5cc [0xa9e57c]
/usr/sbin/mysqld'int mysqld_main(int,char**)+0x3e0 [0xa9f118]
/usr/sbin/mysqld'main+0x9 [0xa9664d]
/usr/sbin/mysqld'0x6964dc [0xa964dc]


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.