Installing MariaDB/MySQL system tables in '/tmp/mysql-data/10.4' ... OK (lldb) target create "./mysqld" Current executable set to './mysqld' (x86_64). (lldb) settings set -- target.run-args "--defaults-file=../../my.cnf" "-u" "mysql" "--basedir=/home/cwilliams/src/tm p/mariadb-server/10.4/sql" "--datadir=/tmp/mysql-data/10.4" "--socket=/var/run/mysql/.sock" "--debug" (lldb) r Process 85794 launching Process 85794 launched: '/mariadb-server/10.4/sql/mysqld' (x86_64) 2019-05-30 12:58:48 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release. 2019-05-30 12:58:48 0 [Note] /mariadb-server/10.4/sql/mysqld (mysqld 10.4.6-MariaDB-debug-log) starting as process 85794 ... 2019-05-30 12:58:48 0 [Warning] Although a path was specified for the --log-slow-queries option, log tables are used. To enable logging to files use the --log-output=file option. 2019-05-30 12:58:48 0 [ERROR] mysqld: Can't open shared library '/mariadb-server/10.4/sql/lib/ plugin/auth_socket.so' (errno: 0, Cannot open "/mariadb-server/10.4/sql/lib/plugin/auth_socket .so") 2019-05-30 12:58:48 0 [ERROR] Couldn't load plugin 'auth_socket' from 'auth_socket.so'. 2019-05-30 12:58:48 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2019-05-30 12:58:48 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-30 12:58:48 0 [Note] InnoDB: Uses event mutexes 2019-05-30 12:58:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-30 12:58:48 0 [Note] InnoDB: Number of pools: 1 2019-05-30 12:58:48 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-05-30 12:58:48 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 2, chunk size = 128M 2019-05-30 12:58:49 0 [Note] InnoDB: Completed initialization of buffer pool 2019-05-30 12:58:49 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*268435456 bytes; LSN=139836 2019-05-30 12:58:49 0 [Note] InnoDB: Starting to delete and rewrite log files. 2019-05-30 12:58:49 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 268435456 bytes 2019-05-30 12:58:50 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 268435456 bytes 2019-05-30 12:58:50 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2019-05-30 12:58:50 0 [Note] InnoDB: New log files created, LSN=139836 2019-05-30 12:58:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-05-30 12:58:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-05-30 12:58:50 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-05-30 12:58:50 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-05-30 12:58:50 0 [Note] InnoDB: Waiting for purge to start 2019-05-30 12:58:50 0 [Note] InnoDB: 10.4.6 started; log sequence number 139836; transaction id 21 2019-05-30 12:58:50 0 [Note] InnoDB: Loading buffer pool(s) from /tmp/mysql-data/10.4/ib_buffer_pool 2019-05-30 12:58:50 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-05-30 12:58:50 0 [Note] InnoDB: Buffer pool(s) load completed at 190530 12:58:50 2019-05-30 12:58:50 0 [Note] Server socket created on IP: '::'. 2019-05-30 12:58:50 0 [Note] Reading of all Master_info entries succeded 2019-05-30 12:58:50 0 [Note] Added new Master_info '' to hash table 2019-05-30 12:58:50 0 [Note] /mariadb-server/10.4/sql/mysqld: ready for connections. Version: '10.4.6-MariaDB-debug-log' socket: '/var/run/mysql/.sock' port: 3306 Source distribution Process 85794 stopped * thread #41, name = 'mysqld', stop reason = signal SIGBUS: hardware error frame #0: 0x00000000008c25d1 mysqld`optimize_keyuse(join=0x00000008b7c52f28, keyuse_array=0x00000008b7c53218) at sql_select.cc:6880:35 6877 DBUG_ASSERT(tablenr != Table_map_iterator::BITMAP_END); 6878 TABLE *tmp_table=join->table[tablenr]; 6879 if (tmp_table) // already created -> 6880 keyuse->ref_table_rows= MY_MAX(tmp_table->file->stats.records, 100); 6881 } 6882 } 6883 /* (lldb) v (JOIN *) join = 0x00000008b7c52f28 (DYNAMIC_ARRAY *) keyuse_array = 0x00000008b7c53218 (KEYUSE *) end = 0x00000008bc88e790 (KEYUSE *) keyuse = 0x00000008bc88e6e0 (table_map) map = 2305843009213693952 (uint) n_tables = 1 (Table_map_iterator) it = (bmp = 0, no = 60) (int) tablenr = 61 (TABLE *) tmp_table = 0xa5a5a5a5a5a5a5a5 (lldb) bt * thread #41, name = 'mysqld', stop reason = signal SIGBUS: hardware error * frame #0: 0x00000000008c25d1 mysqld`optimize_keyuse(join=0x00000008b7c52f28, keyuse_array=0x00000008b7c53218) at sql_select.cc:6880:35 frame #1: 0x00000000008a4f7b mysqld`make_join_statistics(join=0x00000008b7c52f28, tables_list=0x00000008bc9db218, keyuse_array=0x00000008b7c53218) at sql_select.cc:5455:5 frame #2: 0x000000000089e3c6 mysqld`JOIN::optimize_inner(this=0x00000008b7c52f28) at sql_select.cc:2192:7 frame #3: 0x0000000000898ed6 mysqld`JOIN::optimize(this=0x00000008b7c52f28) at sql_select.cc:1562:10 frame #4: 0x00000000007d6dae mysqld`mysql_derived_optimize(thd=0x00000008b7c17ab0, lex=0x00000008bc9e20c8, derive d=0x00000008bc835c40) at sql_derived.cc:993:23 frame #5: 0x00000000007d97b9 mysqld`mysql_handle_single_derived(lex=0x00000008bc9e20c8, derived=0x00000008bc835c4 0, phases=4) at sql_derived.cc:206:15 frame #6: 0x000000000089d8ed mysqld`JOIN::optimize_inner(this=0x00000008b7c528d0) at sql_select.cc:2028:6 frame #7: 0x0000000000898ed6 mysqld`JOIN::optimize(this=0x00000008b7c528d0) at sql_select.cc:1562:10 frame #8: 0x00000000009795c8 mysqld`st_select_lex_unit::optimize(this=0x00000008b7ca3200) at sql_union.cc:1402:25 frame #9: 0x00000000007d6c2b mysqld`mysql_derived_optimize(thd=0x00000008b7c17ab0, lex=0x00000008bc9e20c8, derive d=0x00000008b7cb9250) at sql_derived.cc:962:16 frame #10: 0x00000000007d97b9 mysqld`mysql_handle_single_derived(lex=0x00000008bc9e20c8, derived=0x00000008b7cb92 50, phases=4) at sql_derived.cc:206:15 frame #11: 0x000000000089d8ed mysqld`JOIN::optimize_inner(this=0x00000008b7c4f6f0) at sql_select.cc:2028:6 frame #12: 0x0000000000898ed6 mysqld`JOIN::optimize(this=0x00000008b7c4f6f0) at sql_select.cc:1562:10 frame #13: 0x0000000000890bf9 mysqld`mysql_select(thd=0x00000008b7c17ab0, tables=0x00000008b7cb9250, wild_num=0, fields=0x00000008b7ca4098, conds=0x0000000000000000, og_num=1, order=0x00000008bc9d8bb0, group=0x0000000000000000, ha ving=0x0000000000000000, proc_param=0x0000000000000000, select_options=2416184064, result=0x00000008bc9d9470, unit=0x 00000008bc9e2190, select_lex=0x00000008b7ca3f50) at sql_select.cc:4590:19 frame #14: 0x0000000000890391 mysqld`handle_select(thd=0x00000008b7c17ab0, lex=0x00000008bc9e20c8, result=0x00000 008bc9d9470, setup_tables_done_option=0) at sql_select.cc:412:10 frame #15: 0x000000000084d988 mysqld`execute_sqlcom_select(thd=0x00000008b7c17ab0, all_tables=0x00000008b7cb9250) at sql_parse.cc:6612:12 frame #16: 0x000000000083ef63 mysqld`mysql_execute_command(thd=0x00000008b7c17ab0) at sql_parse.cc:3884:12 frame #17: 0x00000000008726c4 mysqld`Prepared_statement::execute(this=0x00000008bc76f170, expanded_query=0x00007f ffdc2ec2c0, open_cursor=false) at sql_prepare.cc:4760:14 frame #18: 0x000000000086de54 mysqld`Prepared_statement::execute_loop(this=0x00000008bc76f170, expanded_query=0x0 0007fffdc2ec2c0, open_cursor=false, packet="", packet_end="") at sql_prepare.cc:4246:10 frame #19: 0x000000000086d3e1 mysqld`mysql_stmt_execute_common(thd=0x00000008b7c17ab0, stmt_id=1, packet="", pack et_end="", cursor_flags=0, bulk_op=false, read_types=false) at sql_prepare.cc:3255:11 frame #20: 0x000000000086d04a mysqld`mysqld_stmt_execute(thd=0x00000008b7c17ab0, packet_arg="\x01", packet_length =66) at sql_prepare.cc:3152:3 frame #21: 0x000000000083203f mysqld`dispatch_command(command=COM_STMT_EXECUTE, thd=0x00000008b7c17ab0, packet="\ x01", packet_length=66, is_com_multi=false, is_next_command=false) at sql_parse.cc:1751:5 frame #22: 0x0000000000837320 mysqld`do_command(thd=0x00000008b7c17ab0) at sql_parse.cc:1361:17 frame #23: 0x0000000000a048ca mysqld`do_handle_one_connection(connect=0x0000000804a29970) at sql_connect.cc:1403: 11 frame #24: 0x0000000000a0469a mysqld`::handle_one_connection(arg=0x0000000804a29970) at sql_connect.cc:1306:3 frame #25: 0x00000000015433a3 mysqld`::pfs_spawn_thread(arg=0x00000008af4fc3f0) at pfs.cc:1862:3 frame #26: 0x0000000802100036 libthr.so.3`___lldb_unnamed_symbol1$$libthr.so.3 + 326 (lldb) c Process 85794 resuming 190530 13:05:38 [ERROR] mysqld got signal 10 ; 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.4.6-MariaDB-debug-log key_buffer_size=268435456 read_buffer_size=4194304 max_used_connections=8 max_threads=153 thread_count=15 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1049229 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x8b7c17ab0 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 = 0x7fffdc2eef18 thread_stack 0x49000 0x15c5dc7 at /mariadb-server/10.4/sql/mysqld 0xc3a111 at /mariadb-server/10.4/sql/mysqld 0x802105cf0 at /lib/libthr.so.3 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x8b7c4e488): is an invalid pointer Connection ID (thread ID): 27 Status: NOT_KILLED Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_mer ge_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_ma tch_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_wi th_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimi nation=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materia lized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=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. We think the query pointer is invalid, but we will try to print it anyway. Query: with recursive g as (select distinct gid from auth_user_group where uid=1), cte as ( select f.uuid, f.parent, f.type, f.uid, f.gid, f.access, f.name, f.flags, f.created, f.modified, 0 as level, cast('' as varchar(128)) path from feature f inner join g on f.gid = g.gid or 1 where uuid=0x8c954007c5c749c9a4af10b23efd2ebf and (1 or f.uid = 1 or (f.access & 273)) union select f.uuid, f.parent, f.type, f.uid, f.gid, f.access, f.name, f.flags, f.created, f.modified, r.level + 1, concat(r.path, '/', (select @rn := @rn + 1 from ( select @rn := 0 ) _rn)) path from feature f inner join cte r inner join g on f.gid = g.gid or 1 where f.parent = r.uuid and 0=f.flags&4 and (1 or f.uid = 1 or (f.access & 273)) ) select cte.uuid, cte.parent, cte.type, cte.uid owner, g.authority `group`, cte.access, cte.name, cte.flags, timestampdiff(microsecond, '1970-01-01', cte.created), timestampdiff(microsecond, '1970-01-01', cte.modified), fs.value properties, fp.value gdmsprop, prj.value projection, cte.level from cte inner join customer g on g.id=cte.gid left join prop fs on fs.uuid = cte.uuid and fs.name = 'properties' left join prop fp on fp.uuid = cte.uuid and fp.name = 'gdmsprop' left join prop prj on cte.type='Workspace' and prj.uuid = cte.uuid and prj.name = 'crs-proj4' order by cte.path Process 85794 stopped * thread #41, name = 'mysqld', stop reason = signal SIGBUS frame #0: 0x000000080426d4fa libc.so.7`kill + 10 libc.so.7`kill: -> 0x80426d4fa <+10>: jb 0x8042dd564 0x80426d500 <+16>: retq 0x80426d501: int3 0x80426d502: int3 (lldb) c Process 85794 resuming Process 85794 exited with status = -1 (0xffffffff) (lldb) q