180106 09:47:03 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2018-01-06 9:47:04 34399125696 [Note] /usr/local/libexec/mysqld (mysqld 10.1.30-MariaDB) starting as process 907 ... 2018-01-06 9:47:04 34399125696 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB. 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2018-01-06 9:47:04 34399125696 [Note] InnoDB: The InnoDB memory heap is disabled 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-01-06 9:47:04 34399125696 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Compressed tables use zlib 1.2.8 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Using generic crc32 instructions 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Completed initialization of buffer pool 2018-01-06 9:47:04 34399125696 [Note] InnoDB: Highest supported file format is Barracuda. 2018-01-06 9:47:04 34399125696 [Note] InnoDB: 128 rollback segment(s) are active. 2018-01-06 9:47:06 34399125696 [Note] InnoDB: Waiting for purge to start 2018-01-06 9:47:06 34399125696 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 1672135 2018-01-06 9:47:06 34399138368 [Note] InnoDB: Dumping buffer pool(s) not yet started 2018-01-06 9:47:06 34399125696 [Note] Plugin 'FEEDBACK' is disabled. 2018-01-06 9:47:06 34399125696 [Note] Server socket created on IP: '0.0.0.0'. 2018-01-06 9:47:06 34399125696 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '10.1.30-MariaDB' socket: '/tmp/mysql.sock' port: 3306 FreeBSD Ports ... 180123 21:04:47 [ERROR] mysqld got signal 11 ; 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 https://mariadb.com/kb/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.30-MariaDB key_buffer_size=134217728 read_buffer_size=131072 max_used_connections=84 max_threads=153 thread_count=52 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467099 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x824d99008 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 = 0x7ffffb6db348 thread_stack 0x48400 0x1998e49 at /usr/local/libexec/mysqld 0x158bcc5 at /usr/local/libexec/mysqld 0x7fffffdfe003 at ??? 0x158c487 <_ZN7handler26get_dynamic_partition_infoEP15PARTITION_STATSj+0xc7> at /usr/local/libexec/mysqld 0x198bd0b at /usr/local/libexec/mysqld 0x1471688 <_Z21fill_key_cache_tablesP3THDP10TABLE_LISTP4Item+0x368> at /usr/local/libexec/mysqld 0x14854cb <_Z14get_all_tablesP3THDP10TABLE_LISTP4Item+0x9ab> at /usr/local/libexec/mysqld 0x1486cd3 <_Z24get_schema_tables_resultP4JOIN23enum_schema_table_state+0x283> at /usr/local/libexec/mysqld 0x146d5fe <_ZN4JOIN10exec_innerEv+0x6de> at /usr/local/libexec/mysqld 0x146f69b <_ZN4JOIN4execEv+0x4b> at /usr/local/libexec/mysqld 0x146c137 <_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe7> at /usr/local/libexec/mysqld 0x146cb50 <_Z13handle_selectP3THDP3LEXP13select_resultm+0x130> at /usr/local/libexec/mysqld 0x1376471 <_init+0x21e1> at /usr/local/libexec/mysqld 0x142075a <_Z21mysql_execute_commandP3THD+0x6b4a> at /usr/local/libexec/mysqld 0x14227ff <_Z11mysql_parseP3THDPcjP12Parser_state+0x2ff> at /usr/local/libexec/mysqld 0x1425bee <_Z16dispatch_command19enum_server_commandP3THDPcj+0x238e> at /usr/local/libexec/mysqld 0x14263a4 <_Z10do_commandP3THD+0x134> at /usr/local/libexec/mysqld 0x14e18c9 <_Z24do_handle_one_connectionP3THD+0x189> at /usr/local/libexec/mysqld 0x14e1a77 at /usr/local/libexec/mysqld 0x80235cdf9 at /usr/lib/libpthread.so.0 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x81ef39020): is an invalid pointer Connection ID (thread ID): 2388760 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,orderby_uses_equalities=off 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. We think the query pointer is invalid, but we will try to print it anyway. Query: SELECT * FROM REFERENTIAL_CONSTRAINTS LIMIT 1 180124 07:46:30 mysqld_safe mysqld restarted