Jan 17 21:07:15 DEV-DB mysqld[2768]: 180117 21:07:15 [ERROR] mysqld got signal 11 ;
Jan 17 21:07:15 DEV-DB mysqld[2768]: This could be because you hit a bug. It is also possible that this binary
Jan 17 21:07:15 DEV-DB mysqld[2768]: or one of the libraries it was linked against is corrupt, improperly built,
Jan 17 21:07:15 DEV-DB mysqld[2768]: or misconfigured. This error can also be caused by malfunctioning hardware.
Jan 17 21:07:15 DEV-DB mysqld[2768]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
Jan 17 21:07:15 DEV-DB mysqld[2768]: We will try our best to scrape up some info that will hopefully help
Jan 17 21:07:15 DEV-DB mysqld[2768]: diagnose the problem, but since we have already crashed,
Jan 17 21:07:15 DEV-DB mysqld[2768]: something is definitely wrong and this may fail.
Jan 17 21:07:15 DEV-DB mysqld[2768]: Server version: 10.2.6-MariaDB-10.2.6+maria~xenial-log
Jan 17 21:07:15 DEV-DB mysqld[2768]: key_buffer_size=209715200
Jan 17 21:07:15 DEV-DB mysqld[2768]: read_buffer_size=32768
Jan 17 21:07:15 DEV-DB mysqld[2768]: max_used_connections=111
Jan 17 21:07:15 DEV-DB mysqld[2768]: max_threads=202
Jan 17 21:07:15 DEV-DB mysqld[2768]: thread_count=103
Jan 17 21:07:15 DEV-DB mysqld[2768]: It is possible that mysqld could use up to
Jan 17 21:07:15 DEV-DB mysqld[2768]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 3525065 K  bytes of memory
Jan 17 21:07:15 DEV-DB mysqld[2768]: Hope that's ok; if not, decrease some variables in the equation.
Jan 17 21:07:15 DEV-DB mysqld[2768]: Thread pointer: 0x7f1ad08c6168
Jan 17 21:07:15 DEV-DB mysqld[2768]: Attempting backtrace. You can use the following information to find out
Jan 17 21:07:15 DEV-DB mysqld[2768]: where mysqld died. If you see no messages after this, something went
Jan 17 21:07:15 DEV-DB mysqld[2768]: terribly wrong...
Jan 17 21:07:15 DEV-DB mysqld[2768]: stack_bottom = 0x7f1b0505ecc8 thread_stack 0x49000
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5647d2dc338e]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(handle_fatal_signal+0x305)[0x5647d28243c5]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f1cb0ba3390]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(+0x4e502b)[0x5647d26ba02b]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z11setup_groupP3THD20Bounds_checked_arrayIP4ItemEP10TABLE_LISTR4ListIS2_ES9_P8st_orderPbb+0x94)[0x5647d26d0d74]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z13setup_windowsP3THD20Bounds_checked_arrayIP4ItemEP10TABLE_LISTR4ListIS2_ES9_RS7_I11Window_specERS7_I16Item_window_funcE+0x17d)[0x5647d27ade5d]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN4JOIN7prepareEP10TABLE_LISTjP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0x625)[0x5647d26d2f55]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN18st_select_lex_unit7prepareEP3THDP13select_resultm+0x94c)[0x5647d2721d6c]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z21mysql_derived_prepareP3THDP3LEXP10TABLE_LIST+0x21c)[0x5647d26670dc]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x188)[0x5647d2667cc8]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z28mysql_handle_list_of_derivedP3LEXP10TABLE_LISTj+0x3f)[0x5647d2667e5f]
Jan 17 21:07:17 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z20mysql_prepare_insertP3THDP10TABLE_LISTP5TABLER4ListI4ItemEPS7_S8_S8_15enum_duplicatesPPS6_b+0x98)[0x5647d266e588]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z27mysql_insert_select_prepareP3THD+0x52)[0x5647d2672ce2]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x78cf)[0x5647d269268f]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x5647d29363c5]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5647d293c549]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x5647d293cb75]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x796)[0x5647d2939386]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x3b8)[0x5647d293a558]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(+0x4aecd6)[0x5647d2683cd6]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2622)[0x5647d268d3e2]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x5647d29363c5]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5647d293c549]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x5647d293cb75]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x796)[0x5647d2939386]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x3b8)[0x5647d293a558]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(+0x4aecd6)[0x5647d2683cd6]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2622)[0x5647d268d3e2]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_instr_stmt9exec_coreEP3THDPj+0x15)[0x5647d29363c5]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_lex_keeper23reset_lex_and_exec_coreEP3THDPjbP8sp_instr+0x99)[0x5647d293c549]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN13sp_instr_stmt7executeEP3THDPj+0x205)[0x5647d293cb75]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN7sp_head7executeEP3THDb+0x796)[0x5647d2939386]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN7sp_head17execute_procedureEP3THDP4ListI4ItemE+0x745)[0x5647d293a8e5]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(+0x4aecd6)[0x5647d2683cd6]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x2622)[0x5647d268d3e2]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4f5)[0x5647d26a7ee5]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(+0x4d3865)[0x5647d26a8865]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x156)[0x5647d26a91f6]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xcd4)[0x5647d26955b4]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x15e)[0x5647d26970ae]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x24a)[0x5647d275c61a]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(handle_one_connection+0x3d)[0x5647d275c78d]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /usr/sbin/mysqld(+0x7e44b1)[0x5647d29b94b1]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f1cb0b996ba]
Jan 17 21:07:18 DEV-DB mysqld[2768]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f1cb02443dd]
Jan 17 21:07:18 DEV-DB mysqld[2768]: Trying to get some variables.
Jan 17 21:07:18 DEV-DB mysqld[2768]: Some pointers may be invalid and cause the dump to abort.
Jan 17 21:07:18 DEV-DB mysqld[2768]: Query (0x7f1ad04f7f90): 
-- Query snipnet --
INSERT INTO TABLE1 (FIELDS ....)
SELECT ...
FROM (
SELECT ...
ORDER BY .....
FROM (
SELECT ....
FROM (
SELECT ....
FROM TABLE2 AAA
JOIN TABLE3 BBB ON B
 ....
JOIN TABLE4 SHM ON ...
LEFT JOIN TABLE 5 BIC ON ...
JOIN TABLE5 BRM ON ...
JOIN TABLE6 CPM ON ...
JOIN TABLE7 COD ON ...
WHERE ... 'WHERE-CONDITION') STL) X1) X2

an 17 21:07:18 DEV-DB mysqld[2768]: Connection ID (thread ID): 48173
Jan 17 21:07:18 DEV-DB mysqld[2768]: Status: NOT_KILLED
Jan 17 21:07:18 DEV-DB mysqld[2768]: 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=on,condition_pushdown_for_derived=on
Jan 17 21:07:18 DEV-DB mysqld[2768]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
Jan 17 21:07:18 DEV-DB mysqld[2768]: information that should help you find out what is causing the crash.
Jan 17 21:07:18 DEV-DB systemd[1]: mariadb.service: Main process exited, code=killed, status=11/SEGV
Jan 17 21:07:18 DEV-DB systemd[1]: mariadb.service: Unit entered failed state.
Jan 17 21:07:18 DEV-DB systemd[1]: mariadb.service: Failed with result 'signal'.
Jan 17 21:07:23 DEV-DB systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Jan 17 21:07:23 DEV-DB systemd[1]: Stopped MariaDB database server.
Jan 17 21:07:23 DEV-DB systemd[1]: Starting MariaDB database server...
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Warning] option 'table_definition_cache': unsigned value 200 adjusted to 400
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Warning] option 'table_definition_cache': unsigned value 200 adjusted to 400
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] /usr/sbin/mysqld (mysqld 10.2.6-MariaDB-10.2.6+maria~xenial-log) starting as process 30862 ...
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Warning] You need to use --log-bin to make --binlog-format work.
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Uses event mutexes
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Compressed tables use zlib 1.2.8
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Using Linux native AIO
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Number of pools: 1
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Using SSE2 crc32 instructions
Jan 17 21:07:26 DEV-DB mysqld[30862]: 2018-01-17 21:07:26 140066627328192 [Note] InnoDB: Initializing buffer pool, total size = 5G, instances = 2, chunk size = 128M
Jan 17 21:07:27 DEV-DB mysqld[30862]: 2018-01-17 21:07:27 140066627328192 [Note] InnoDB: Completed initialization of buffer pool
Jan 17 21:07:27 DEV-DB mysqld[30862]: 2018-01-17 21:07:27 140060125345536 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Jan 17 21:07:27 DEV-DB mysqld[30862]: 2018-01-17 21:07:27 140066627328192 [Note] InnoDB: Highest supported file format is Barracuda.
Jan 17 21:07:27 DEV-DB mysqld[30862]: 2018-01-17 21:07:27 140066627328192 [Note] InnoDB: Starting crash recovery from checkpoint LSN=595440678939
Jan 17 21:07:27 DEV-DB mysqld[30862]: 2018-01-17 21:07:27 140066627328192 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.
Jan 17 21:07:28 DEV-DB mysqld[30862]: InnoDB: Last MySQL binlog file position 0 57761168, file name /var/log/mysql/mariadb-bin.000350
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] InnoDB: 128 out of 128 rollback segments are active.
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] InnoDB: Creating shared tablespace for temporary tables
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140060125345536 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13569ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] InnoDB: 5.7.14 started; log sequence number 595440679013
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] Recovering after a crash using tc.log
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] Starting crash recovery...
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] Crash recovery finished.
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] Server socket created on IP: '::'.
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066400024320 [Note] Event Scheduler: scheduler thread started with id 6
Jan 17 21:07:40 DEV-DB mysqld[30862]: 2018-01-17 21:07:40 140066627328192 [Note] /usr/sbin/mysqld: ready for connections.
Jan 17 21:07:40 DEV-DB mysqld[30862]: Version: '10.2.6-MariaDB-10.2.6+maria~xenial-log'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
Jan 17 21:07:41 DEV-DB systemd[1]: Started MariaDB database server.