/home/buildbot/buildbot/build/mariadb-10.1.11/storage/tokudb/PerconaFT/locktree/treenode.cc:74 destroy_root: Assertion `is_empty()' failed (errno=0) : Success Backtrace: (Note: toku_do_assert=0x0x7fe9c38e1cb0) /usr/lib/mysql/plugin/ha_tokudb.so(_Z19db_env_do_backtraceP8_IO_FILE+0x1b)[0x7fe9c394365b] /usr/lib/mysql/plugin/ha_tokudb.so(+0x11e7e3)[0x7fe9c39437e3] /usr/lib/mysql/plugin/ha_tokudb.so(+0xbc8d7)[0x7fe9c38e18d7] /usr/lib/mysql/plugin/ha_tokudb.so(+0x3f64d)[0x7fe9c386464d] /usr/lib/mysql/plugin/ha_tokudb.so(+0x10000c)[0x7fe9c392500c] /usr/lib/mysql/plugin/ha_tokudb.so(+0xb9981)[0x7fe9c38de981] /usr/lib/mysql/plugin/ha_tokudb.so(_Z13toku_db_closeP9__toku_db+0x59)[0x7fe9c3936049] /usr/lib/mysql/plugin/ha_tokudb.so(+0x1110a9)[0x7fe9c39360a9] /usr/lib/mysql/plugin/ha_tokudb.so(+0x4a6ad)[0x7fe9c386f6ad] /usr/lib/mysql/plugin/ha_tokudb.so(_ZN9ha_tokudb7__closeEv+0x10f)[0x7fe9c386fa3f] /usr/lib/mysql/plugin/ha_tokudb.so(_ZN9ha_tokudb5closeEv+0x26)[0x7fe9c386fb66] /usr/sbin/mysqld(+0xa4e0f8)[0x7fe9c80130f8] /usr/sbin/mysqld(+0x6df071)[0x7fe9c7ca4071] /usr/sbin/mysqld(_Z26fast_alter_partition_tableP3THDP5TABLEP10Alter_infoP14HA_CREATE_INFOP10TABLE_LISTPcPKc+0x8d0)[0x7fe9c7cad640] /usr/sbin/mysqld(_Z17mysql_alter_tableP3THDPcS1_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x1c9c)[0x7fe9c7a7fd6c] /usr/sbin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x62e)[0x7fe9c7ac602e] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1226)[0x7fe9c79f41f6] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20d)[0x7fe9c79fc6dd] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x2460)[0x7fe9c79ffa20] /usr/sbin/mysqld(_Z10do_commandP3THD+0x169)[0x7fe9c7a001c9] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x18a)[0x7fe9c7ac32ea] /usr/sbin/mysqld(handle_one_connection+0x40)[0x7fe9c7ac34c0] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7fe9c60c4182] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fe9c57e747d] Engine status: BUILD_ID = 0 Env panic code: 18446744073709551615 Env panic string: /home/buildbot/buildbot/build/mariadb-10.1.11/storage/tokudb/PerconaFT/locktree/treenode.cc:74 destroy_root: Assertion `is_empty()' failed (errno=0) time of environment creation: Wed Feb 3 15:33:11 2016 time of engine startup: Sat Feb 20 02:15:03 2016 time now: Thu Nov 3 00:15:05 2016 db opens: 101937 db closes: 101858 num open dbs now: 79 max open dbs: 195 period, in ms, that recovery log is automatically fsynced: 0 dictionary inserts: 12952987008 dictionary inserts fail: 0 dictionary deletes: 24782 dictionary deletes fail: 0 dictionary updates: 0 dictionary updates fail: 0 dictionary broadcast updates: 0 dictionary broadcast updates fail: 0 dictionary multi inserts: 52914432944 dictionary multi inserts fail: 24 dictionary multi deletes: 0 dictionary multi deletes fail: 0 dictionary updates multi: 0 dictionary updates multi fail: 0 le: max committed xr: 9 le: max provisional xr: 3 le: expanded: 0 le: max memsize: 307 le: size of leafentries before garbage collection (during message application): 574796060985 le: size of leafentries after garbage collection (during message application): 276550626863 le: size of leafentries before garbage collection (outside message application): 0 le: size of leafentries after garbage collection (outside message application): 0 checkpoint: period: 60 checkpoint: footprint: 0 checkpoint: last checkpoint began: Thu Nov 3 00:14:31 2016 checkpoint: last complete checkpoint began: Thu Nov 3 00:14:31 2016 checkpoint: last complete checkpoint ended: Thu Nov 3 00:14:33 2016 checkpoint: time spent during checkpoint (begin and end phases): 737777 checkpoint: time spent during last checkpoint (begin and end phases): 2 checkpoint: last complete checkpoint LSN: 112471980955 checkpoint: checkpoints taken : 369960 checkpoint: checkpoints failed: 0 checkpoint: waiters now: 0 checkpoint: waiters max: 0 checkpoint: non-checkpoint client wait on mo lock: 46792 checkpoint: non-checkpoint client wait on cs lock: 0 checkpoint: checkpoint begin time: 2440536548 checkpoint: long checkpoint begin time: 0 checkpoint: long checkpoint begin count: 0 checkpoint: checkpoint end time: 731110642574 checkpoint: long checkpoint end time: 93495267 checkpoint: long checkpoint end count: 1 cachetable: miss: 5753 cachetable: miss time: 132998115 cachetable: prefetches: 4068 cachetable: size current: 4291058166 cachetable: size limit: 4724464025 cachetable: size writing: 0 cachetable: size nonleaf: 77807842 cachetable: size leaf: 4213248036 cachetable: size rollback: 2288 cachetable: size cachepressure: 49617864 cachetable: size currently cloned data for checkpoint: 0 cachetable: evictions: 929803 cachetable: cleaner executions: 23672316 cachetable: cleaner period: 1 cachetable: cleaner iterations: 5 cachetable: number of waits on cache pressure: 0 cachetable: time waiting on cache pressure: 0 cachetable: number of long waits on cache pressure: 0 cachetable: long time waiting on cache pressure: 0 cachetable: number of threads in pool: 8 cachetable: number of currently active threads in pool: 0 cachetable: number of currently queued work items: 0 cachetable: largest number of queued work items: 2 cachetable: total number of work items processed: 481166 cachetable: total execution time of processing work items: 108102623 cachetable: number of threads in pool: 16 cachetable: number of currently active threads in pool: 0 cachetable: number of currently queued work items: 0 cachetable: largest number of queued work items: 1511 cachetable: total number of work items processed: 1539315 cachetable: total execution time of processing work items: 9775869 cachetable: number of threads in pool: 2 cachetable: number of currently active threads in pool: 0 cachetable: number of currently queued work items: 0 cachetable: largest number of queued work items: 22 cachetable: total number of work items processed: 1648502 cachetable: total execution time of processing work items: 203134196 locktree: memory size: 100548 locktree: memory size limit: 536870912 locktree: number of times lock escalation ran: 0 locktree: time spent running escalation (seconds): 0.000000 locktree: latest post-escalation memory size: 0 locktree: number of locktrees open now: 81 locktree: number of pending lock requests: 0 locktree: number of locktrees eligible for the STO: 0 locktree: number of times a locktree ended the STO early: 250 locktree: time spent ending the STO early (seconds): 8.381125 locktree: number of wait locks: 0 locktree: time waiting for locks: 0 locktree: number of long wait locks: 0 locktree: long time waiting for locks: 0 locktree: number of lock timeouts: 0 locktree: number of waits on lock escalation: 0 locktree: time waiting on lock escalation: 0 locktree: number of long waits on lock escalation: 0 locktree: long time waiting on lock escalation: 0 ft: dictionary updates: 0 ft: dictionary broadcast updates: 0 ft: descriptor set: 2044 ft: messages ignored by leaf due to msn: 8437746 ft: total search retries due to TRY_AGAIN: 742238 ft: searches requiring more tries than the height of the tree: 7 ft: searches requiring more tries than the height of the tree plus three: 5 ft: leaf nodes flushed to disk (not for checkpoint): 11077 ft: leaf nodes flushed to disk (not for checkpoint) (bytes): 230919680 ft: leaf nodes flushed to disk (not for checkpoint) (uncompressed bytes): 2618281899 ft: leaf nodes flushed to disk (not for checkpoint) (seconds): 216.797381 ft: nonleaf nodes flushed to disk (not for checkpoint): 376 ft: nonleaf nodes flushed to disk (not for checkpoint) (bytes): 44958720 ft: nonleaf nodes flushed to disk (not for checkpoint) (uncompressed bytes): 522555519 ft: nonleaf nodes flushed to disk (not for checkpoint) (seconds): 7.574571 ft: leaf nodes flushed to disk (for checkpoint): 2644389 ft: leaf nodes flushed to disk (for checkpoint) (bytes): 615077421056 ft: leaf nodes flushed to disk (for checkpoint) (uncompressed bytes): 7674675688191 ft: leaf nodes flushed to disk (for checkpoint) (seconds): 57697.178587 ft: nonleaf nodes flushed to disk (for checkpoint): 1849626 ft: nonleaf nodes flushed to disk (for checkpoint) (bytes): 269757828096 ft: nonleaf nodes flushed to disk (for checkpoint) (uncompressed bytes): 3044135888180 ft: nonleaf nodes flushed to disk (for checkpoint) (seconds): 35339.592370 ft: uncompressed / compressed bytes written (leaf): UNKNOWN STATUS TYPE: 6 ft: uncompressed / compressed bytes written (nonleaf): UNKNOWN STATUS TYPE: 6 ft: uncompressed / compressed bytes written (overall): UNKNOWN STATUS TYPE: 6 ft: nonleaf node partial evictions: 14172526 ft: nonleaf node partial evictions (bytes): 30792237490 ft: leaf node partial evictions: 59201464 ft: leaf node partial evictions (bytes): 5130705502134 ft: leaf node full evictions: 821463 ft: leaf node full evictions (bytes): 4607209244 ft: nonleaf node full evictions: 108340 ft: nonleaf node full evictions (bytes): 327372034 ft: leaf nodes created: 863665 ft: nonleaf nodes created: 118792 ft: leaf nodes destroyed: 0 ft: nonleaf nodes destroyed: 0 ft: bytes of messages injected at root (all trees): 1374439093008 ft: bytes of messages flushed from h1 nodes to leaves: 1374376820043 ft: bytes of messages currently in trees (estimate): 62272965 ft: messages injected at root: 23209231670 ft: broadcast messages injected at root: 0 ft: basements decompressed as a target of a query: 0 ft: basements decompressed for prelocked range: 0 ft: basements decompressed for prefetch: 0 ft: basements decompressed for write: 0 ft: buffers decompressed as a target of a query: 1430 ft: buffers decompressed for prelocked range: 1258 ft: buffers decompressed for prefetch: 0 ft: buffers decompressed for write: 14118794 ft: pivots fetched for query: 4584 ft: pivots fetched for query (bytes): 149849600 ft: pivots fetched for query (seconds): 26.615034 ft: pivots fetched for prefetch: 4068 ft: pivots fetched for prefetch (bytes): 133300224 ft: pivots fetched for prefetch (seconds): 15.791660 ft: pivots fetched for write: 51 ft: pivots fetched for write (bytes): 136704 ft: pivots fetched for write (seconds): 0.265308 ft: basements fetched as a target of a query: 737644 ft: basements fetched as a target of a query (bytes): 5894133248 ft: basements fetched as a target of a query (seconds): 1336.912260 ft: basements fetched for prelocked range: 68878 ft: basements fetched for prelocked range (bytes): 519206400 ft: basements fetched for prelocked range (seconds): 92.113701 ft: basements fetched for prefetch: 499486 ft: basements fetched for prefetch (bytes): 3758028800 ft: basements fetched for prefetch (seconds): 668.285470 ft: basements fetched for write: 564933 ft: basements fetched for write (bytes): 3668996096 ft: basements fetched for write (seconds): 1019.298457 ft: buffers fetched as a target of a query: 30 ft: buffers fetched as a target of a query (bytes): 21504 ft: buffers fetched as a target of a query (seconds): 0.181353 ft: buffers fetched for prelocked range: 0 ft: buffers fetched for prelocked range (bytes): 0 ft: buffers fetched for prelocked range (seconds): 0.000000 ft: buffers fetched for prefetch: 0 ft: buffers fetched for prefetch (bytes): 0 ft: buffers fetched for prefetch (seconds): 0.000000 ft: buffers fetched for write: 179 ft: buffers fetched for write (bytes): 766464 ft: buffers fetched for write (seconds): 0.240896 ft: leaf compression to memory (seconds): 420922.313558 ft: leaf serialization to memory (seconds): 13231.487302 ft: leaf decompression to memory (seconds): 1636.170565 ft: leaf deserialization to memory (seconds): 61.126969 ft: nonleaf compression to memory (seconds): 217709.801068 ft: nonleaf serialization to memory (seconds): 8340.082105 ft: nonleaf decompression to memory (seconds): 38.614889 ft: nonleaf deserialization to memory (seconds): 97.281689 ft: promotion: roots split: 2458 ft: promotion: leaf roots injected into: 13004750628 ft: promotion: h1 roots injected into: 197698558 ft: promotion: injections at depth 0: 1578533627 ft: promotion: injections at depth 1: 4999725621 ft: promotion: injections at depth 2: 17084173269 ft: promotion: injections at depth 3: 2239701430 ft: promotion: injections lower than depth 3: 155744086 ft: promotion: stopped because of a nonempty buffer: 5626253640 ft: promotion: stopped at height 1: 23610 ft: promotion: stopped because the child was locked or not at all in memory: 152181 ft: promotion: stopped because the child was not fully in memory: 2 ft: promotion: stopped anyway, after locking the child: 31970 ft: basement nodes deserialized with fixed-keysize: 1865412 ft: basement nodes deserialized with variable-keysize: 5633 ft: promotion: succeeded in using the rightmost leaf shortcut: 26608255894 ft: promotion: tried the rightmost leaf shorcut but failed (out-of-bounds): 112086 ft: promotion: tried the rightmost leaf shorcut but failed (child reactive): 3084230 ft: cursor skipped deleted leaf entries: 292588 ft flusher: total nodes potentially flushed by cleaner thread: 1537068 ft flusher: height-one nodes flushed by cleaner thread: 1483691 ft flusher: height-greater-than-one nodes flushed by cleaner thread: 53377 ft flusher: nodes cleaned which had empty buffers: 1489709 ft flusher: nodes dirtied by cleaner thread: 78779 ft flusher: max bytes in a buffer flushed by cleaner thread: 3935704 ft flusher: min bytes in a buffer flushed by cleaner thread: 57 ft flusher: total bytes in buffers flushed by cleaner thread: 62086083632 ft flusher: max workdone in a buffer flushed by cleaner thread: 3599949 ft flusher: min workdone in a buffer flushed by cleaner thread: 0 ft flusher: total workdone in buffers flushed by cleaner thread: 620598175 ft flusher: times cleaner thread tries to merge a leaf: 0 ft flusher: cleaner thread leaf merges in progress: 0 ft flusher: cleaner thread leaf merges successful: 0 ft flusher: nodes dirtied by cleaner thread leaf merges: 0 ft flusher: total number of flushes done by flusher threads or cleaner threads: 429496 ft flusher: number of in memory flushes: 429496 ft flusher: number of flushes that read something off disk: 0 ft flusher: number of flushes that triggered another flush in child: 8717 ft flusher: number of flushes that triggered 1 cascading flush: 8612 ft flusher: number of flushes that triggered 2 cascading flushes: 105 ft flusher: number of flushes that triggered 3 cascading flushes: 0 ft flusher: number of flushes that triggered 4 cascading flushes: 0 ft flusher: number of flushes that triggered 5 cascading flushes: 0 ft flusher: number of flushes that triggered over 5 cascading flushes: 0 ft flusher: leaf node splits: 861110 ft flusher: nonleaf node splits: 116334 ft flusher: leaf node merges: 0 ft flusher: nonleaf node merges: 0 ft flusher: leaf node balances: 0 hot: operations ever started: 0 hot: operations successfully completed: 0 hot: operations aborted: 0 hot: max number of flushes from root ever required to optimize a tree: 0 txn: begin: 37207997733 txn: begin read only: 2465 txn: successful commits: 37207962902 txn: aborts: 37296 logger: next LSN: 112472023269 logger: writes: 6358554 logger: writes (bytes): 5828996404859 logger: writes (uncompressed bytes): 5828996404859 logger: writes (seconds): 6053.100956 logger: number of long logger write operations: 92 indexer: number of indexers successfully created: 0 indexer: number of calls to toku_indexer_create_indexer() that failed: 0 indexer: number of calls to indexer->build() succeeded: 0 indexer: number of calls to indexer->build() failed: 0 indexer: number of calls to indexer->close() that succeeded: 0 indexer: number of calls to indexer->close() that failed: 0 indexer: number of calls to indexer->abort(): 0 indexer: number of indexers currently in existence: 0 indexer: max number of indexers that ever existed simultaneously: 0 loader: number of loaders successfully created: 0 loader: number of calls to toku_loader_create_loader() that failed: 0 loader: number of calls to loader->put() succeeded: 0 loader: number of calls to loader->put() failed: 0 loader: number of calls to loader->close() that succeeded: 0 loader: number of calls to loader->close() that failed: 0 loader: number of calls to loader->abort(): 0 loader: number of loaders currently in existence: 0 loader: max number of loaders that ever existed simultaneously: 0 memory: number of malloc operations: 0 memory: number of free operations: 0 memory: number of realloc operations: 0 memory: number of malloc operations that failed: 0 memory: number of realloc operations that failed: 16599 memory: number of bytes requested: 0 memory: number of bytes used (requested + overhead): 0 memory: number of bytes freed: 0 memory: largest attempted allocation size: 0 memory: size of the last failed allocation attempt: 0 memory: estimated maximum memory footprint: 0 memory: mallocator version: 3.5.1-0-g7709a64c59daf0b1f938be49472fcc499e1bd136 memory: mmap threshold: 4194304 filesystem: ENOSPC redzone state: 0 filesystem: threads currently blocked by full disk: 0 filesystem: number of operations rejected by enospc prevention (red zone): 0 filesystem: most recent disk full: Thu Jan 1 02:00:00 1970 filesystem: number of write operations that returned ENOSPC: 0 filesystem: fsync time: 385383730060 filesystem: fsync count: 10018602 filesystem: long fsync time: 2462554167 filesystem: long fsync count: 1167 context: tree traversals blocked by a full fetch: 0 context: tree traversals blocked by a partial fetch: 0 context: tree traversals blocked by a full eviction: 0 context: tree traversals blocked by a partial eviction: 4 context: tree traversals blocked by a message injection: 74096 context: tree traversals blocked by a message application: 19 context: tree traversals blocked by a flush: 3 context: tree traversals blocked by a the cleaner thread: 3 context: tree traversals blocked by something uninstrumented: 8514 context: promotion blocked by a full fetch (should never happen): 0 context: promotion blocked by a partial fetch (should never happen): 0 context: promotion blocked by a full eviction (should never happen): 0 context: promotion blocked by a partial eviction (should never happen): 21 context: promotion blocked by a message injection: 17500 context: promotion blocked by a message application: 0 context: promotion blocked by a flush: 2361 context: promotion blocked by the cleaner thread: 342 context: promotion blocked by something uninstrumented: 752 context: something uninstrumented blocked by something uninstrumented: 2 Memory usage: Arena 0: system bytes = 0 in use bytes = 0 Total (incl. mmap): system bytes = 0 in use bytes = 0 max mmap regions = 0 max mmap bytes = 0 161103 0:15:05 [ERROR] 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. To report this bug, see http://kb.askmonty.org/en/reporting-bugs 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. Server version: 10.1.11-MariaDB-1~trusty key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=21 max_threads=153 thread_count=7 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1248906 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0x7fe94efec008 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 = 0x7fe9c85fcdf0 thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fe9c80463fe] /usr/sbin/mysqld(handle_fatal_signal+0x38d)[0x7fe9c7b73f9d] /lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7fe9c60cc340] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0x39)[0x7fe9c5723cc9] /lib/x86_64-linux-gnu/libc.so.6(abort+0x148)[0x7fe9c57270d8] /usr/lib/mysql/plugin/ha_tokudb.so(+0x11e7e8)[0x7fe9c39437e8] /usr/lib/mysql/plugin/ha_tokudb.so(+0xbc8d7)[0x7fe9c38e18d7] /usr/lib/mysql/plugin/ha_tokudb.so(+0x3f64d)[0x7fe9c386464d] /usr/lib/mysql/plugin/ha_tokudb.so(+0x10000c)[0x7fe9c392500c] /usr/lib/mysql/plugin/ha_tokudb.so(+0xb9981)[0x7fe9c38de981] /usr/lib/mysql/plugin/ha_tokudb.so(_Z13toku_db_closeP9__toku_db+0x59)[0x7fe9c3936049] /usr/lib/mysql/plugin/ha_tokudb.so(+0x1110a9)[0x7fe9c39360a9] /usr/lib/mysql/plugin/ha_tokudb.so(+0x4a6ad)[0x7fe9c386f6ad] /usr/lib/mysql/plugin/ha_tokudb.so(_ZN9ha_tokudb7__closeEv+0x10f)[0x7fe9c386fa3f] /usr/lib/mysql/plugin/ha_tokudb.so(_ZN9ha_tokudb5closeEv+0x26)[0x7fe9c386fb66] /usr/sbin/mysqld(+0xa4e0f8)[0x7fe9c80130f8] /usr/sbin/mysqld(+0x6df071)[0x7fe9c7ca4071] /usr/sbin/mysqld(_Z26fast_alter_partition_tableP3THDP5TABLEP10Alter_infoP14HA_CREATE_INFOP10TABLE_LISTPcPKc+0x8d0)[0x7fe9c7cad640] /usr/sbin/mysqld(_Z17mysql_alter_tableP3THDPcS1_P14HA_CREATE_INFOP10TABLE_LISTP10Alter_infojP8st_orderb+0x1c9c)[0x7fe9c7a7fd6c] /usr/sbin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x62e)[0x7fe9c7ac602e] /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1226)[0x7fe9c79f41f6] /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20d)[0x7fe9c79fc6dd] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x2460)[0x7fe9c79ffa20] /usr/sbin/mysqld(_Z10do_commandP3THD+0x169)[0x7fe9c7a001c9] /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x18a)[0x7fe9c7ac32ea] /usr/sbin/mysqld(handle_one_connection+0x40)[0x7fe9c7ac34c0] /lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7fe9c60c4182] /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fe9c57e747d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7fe941020020): is an invalid pointer Connection ID (thread ID): 687376 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on 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.