Initializing database PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands: '/usr/bin/mysqladmin' -u root password 'new-password' '/usr/bin/mysqladmin' -u root -h password 'new-password' Alternatively you can run: '/usr/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions. Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ Database initialized MySQL init process in progress... 2019-04-30 9:54:22 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 106 ... 2019-04-30 9:54:22 0 [Note] InnoDB: Using Linux native AIO 2019-04-30 9:54:22 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-30 9:54:22 0 [Note] InnoDB: Uses event mutexes 2019-04-30 9:54:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-04-30 9:54:22 0 [Note] InnoDB: Number of pools: 1 2019-04-30 9:54:22 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-04-30 9:54:22 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-04-30 9:54:22 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-04-30 9:54:22 0 [Note] InnoDB: Completed initialization of buffer pool 2019-04-30 9:54:22 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-04-30 9:54:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-04-30 9:54:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-04-30 9:54:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-04-30 9:54:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-04-30 9:54:22 0 [Note] InnoDB: Waiting for purge to start 2019-04-30 9:54:22 0 [Note] InnoDB: 10.4.4 started; log sequence number 139827; transaction id 21 2019-04-30 9:54:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-04-30 9:54:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-04-30 9:54:22 0 [Warning] 'user' entry 'root@default' ignored in --skip-name-resolve mode. 2019-04-30 9:54:22 0 [Warning] 'user' entry '@default' ignored in --skip-name-resolve mode. 2019-04-30 9:54:22 0 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 9:54:22 0 [Note] InnoDB: Buffer pool(s) load completed at 190430 9:54:22 2019-04-30 9:54:22 0 [Note] Reading of all Master_info entries succeded 2019-04-30 9:54:22 0 [Note] Added new Master_info '' to hash table 2019-04-30 9:54:22 0 [Note] mysqld: ready for connections. Version: '10.4.4-MariaDB-1:10.4.4+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. 2019-04-30 9:54:35 10 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 9:54:35 0 [Note] mysqld (initiated by: unknown): Normal shutdown 2019-04-30 9:54:35 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-04-30 9:54:35 0 [Note] InnoDB: FTS optimize thread exiting. 2019-04-30 9:54:35 0 [Note] InnoDB: Starting shutdown... 2019-04-30 9:54:35 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2019-04-30 9:54:35 0 [Note] InnoDB: Buffer pool(s) dump completed at 190430 9:54:35 2019-04-30 9:54:36 0 [Note] InnoDB: Shutdown completed; log sequence number 139836; transaction id 24 2019-04-30 9:54:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-04-30 9:54:36 0 [Note] mysqld: Shutdown complete MySQL init process done. Ready for start up. 2019-04-30 9:54:36 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ... 2019-04-30 9:54:36 0 [Note] InnoDB: Using Linux native AIO 2019-04-30 9:54:36 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-30 9:54:36 0 [Note] InnoDB: Uses event mutexes 2019-04-30 9:54:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-04-30 9:54:36 0 [Note] InnoDB: Number of pools: 1 2019-04-30 9:54:36 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-04-30 9:54:36 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-04-30 9:54:36 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-04-30 9:54:36 0 [Note] InnoDB: Completed initialization of buffer pool 2019-04-30 9:54:36 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-04-30 9:54:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-04-30 9:54:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-04-30 9:54:36 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-04-30 9:54:36 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-04-30 9:54:36 0 [Note] InnoDB: Waiting for purge to start 2019-04-30 9:54:37 0 [Note] InnoDB: 10.4.4 started; log sequence number 139836; transaction id 21 2019-04-30 9:54:37 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-04-30 9:54:37 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-04-30 9:54:37 0 [Note] Server socket created on IP: '::'. 2019-04-30 9:54:37 0 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 9:54:37 0 [Note] InnoDB: Buffer pool(s) load completed at 190430 9:54:37 2019-04-30 9:54:37 0 [Note] Reading of all Master_info entries succeded 2019-04-30 9:54:37 0 [Note] Added new Master_info '' to hash table 2019-04-30 9:54:37 0 [Note] mysqld: ready for connections. Version: '10.4.4-MariaDB-1:10.4.4+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2019-04-30 9:55:12 0 [Note] mysqld (initiated by: unknown): Normal shutdown 2019-04-30 9:55:12 0 [Note] Event Scheduler: Purging the queue. 0 events 2019-04-30 9:55:12 0 [Note] InnoDB: FTS optimize thread exiting. 2019-04-30 9:55:12 0 [Note] InnoDB: Starting shutdown... 2019-04-30 9:55:12 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2019-04-30 9:55:12 0 [Note] InnoDB: Buffer pool(s) dump completed at 190430 9:55:12 2019-04-30 9:55:13 0 [Note] InnoDB: Shutdown completed; log sequence number 139845; transaction id 22 2019-04-30 9:55:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-04-30 9:55:13 0 [Note] mysqld: Shutdown complete 2019-04-30 9:55:15 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ... 2019-04-30 9:55:15 0 [Warning] lower_case_table_names was set to 2, even though your the file system '/var/lib/mysql/' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems. 2019-04-30 9:55:15 0 [Note] InnoDB: Using Linux native AIO 2019-04-30 9:55:15 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-30 9:55:15 0 [Note] InnoDB: Uses event mutexes 2019-04-30 9:55:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-04-30 9:55:15 0 [Note] InnoDB: Number of pools: 1 2019-04-30 9:55:15 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-04-30 9:55:15 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-04-30 9:55:15 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-04-30 9:55:15 0 [Note] InnoDB: Completed initialization of buffer pool 2019-04-30 9:55:15 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-04-30 9:55:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-04-30 9:55:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-04-30 9:55:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-04-30 9:55:15 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-04-30 9:55:15 0 [Note] InnoDB: Waiting for purge to start 2019-04-30 9:55:15 0 [Note] InnoDB: 10.4.4 started; log sequence number 139845; transaction id 21 2019-04-30 9:55:15 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-04-30 9:55:15 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-04-30 9:55:15 0 [Note] Server socket created on IP: '0.0.0.0'. 2019-04-30 9:55:15 0 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 9:55:15 0 [Note] InnoDB: Buffer pool(s) load completed at 190430 9:55:15 2019-04-30 9:55:15 0 [Note] Reading of all Master_info entries succeded 2019-04-30 9:55:15 0 [Note] Added new Master_info '' to hash table 2019-04-30 9:55:15 0 [Note] mysqld: ready for connections. Version: '10.4.4-MariaDB-1:10.4.4+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3307 mariadb.org binary distribution 190430 9:56:23 [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.4.4-MariaDB-1:10.4.4+maria~bionic key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=2 max_threads=102 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760221 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f8058000f38 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 = 0x7f8070eebdd8 thread_stack 0x49000 mysqld(my_print_stacktrace+0x2e)[0x55853a9f3a4e] mysqld(handle_fatal_signal+0x5a5)[0x55853a476a95] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f8081221890] mysqld(+0x73bb13)[0x55853a3bdb13] mysqld(_ZN24Window_funcs_computation5setupEP3THDP4ListI16Item_window_funcEP13st_join_table+0x1bd)[0x55853a3c0d4d] mysqld(_ZN4JOIN21make_aggr_tables_infoEv+0x15a3)[0x55853a2b7c33] mysqld(_ZN4JOIN15optimize_stage2Ev+0x1b7d)[0x55853a2bf33d] mysqld(_ZN4JOIN14optimize_innerEv+0xdf1)[0x55853a2c0a01] mysqld(_ZN4JOIN8optimizeEv+0x9b)[0x55853a2c32ab] mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe0)[0x55853a2c3df0] mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x141)[0x55853a2c47f1] mysqld(+0x5e04d1)[0x55853a2624d1] mysqld(_Z21mysql_execute_commandP3THD+0x16b5)[0x55853a26a805] mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x55853a27229a] mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x166d)[0x55853a274a5d] mysqld(_Z10do_commandP3THD+0x148)[0x55853a275ec8] mysqld(_Z24do_handle_one_connectionP7CONNECT+0x2c2)[0x55853a34f612] mysqld(handle_one_connection+0x3d)[0x55853a34f6dd] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f80812166db] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f808061488f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f80580125e0): select i, max(i) over (partition by (select 1)), max(i) over (partition by j) from t order by i asc LIMIT 0, 200 Connection ID (thread ID): 13 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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=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. 2019-04-30 9:57:27 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ... 2019-04-30 9:57:27 0 [Warning] lower_case_table_names was set to 2, even though your the file system '/var/lib/mysql/' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems. 2019-04-30 9:57:27 0 [Note] InnoDB: Using Linux native AIO 2019-04-30 9:57:27 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-30 9:57:27 0 [Note] InnoDB: Uses event mutexes 2019-04-30 9:57:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-04-30 9:57:27 0 [Note] InnoDB: Number of pools: 1 2019-04-30 9:57:27 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-04-30 9:57:27 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-04-30 9:57:27 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-04-30 9:57:27 0 [Note] InnoDB: Completed initialization of buffer pool 2019-04-30 9:57:27 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-04-30 9:57:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150211 2019-04-30 9:57:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-04-30 9:57:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-04-30 9:57:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-04-30 9:57:28 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-04-30 9:57:28 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-04-30 9:57:28 0 [Note] InnoDB: Waiting for purge to start 2019-04-30 9:57:28 0 [Note] InnoDB: 10.4.4 started; log sequence number 150220; transaction id 41 2019-04-30 9:57:28 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-04-30 9:57:28 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-04-30 9:57:28 0 [Note] Server socket created on IP: '0.0.0.0'. 2019-04-30 9:57:28 0 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 9:57:28 0 [Note] InnoDB: Buffer pool(s) load completed at 190430 9:57:28 2019-04-30 9:57:28 0 [Note] Reading of all Master_info entries succeded 2019-04-30 9:57:28 0 [Note] Added new Master_info '' to hash table 2019-04-30 9:57:28 0 [Note] mysqld: ready for connections. Version: '10.4.4-MariaDB-1:10.4.4+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3307 mariadb.org binary distribution 190430 9:57:42 [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.4.4-MariaDB-1:10.4.4+maria~bionic key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=2 max_threads=102 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760221 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f9a58000f38 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 = 0x7f9a6d570dd8 thread_stack 0x49000 mysqld(my_print_stacktrace+0x2e)[0x5569f97eba4e] mysqld(handle_fatal_signal+0x5a5)[0x5569f926ea95] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f9a8535b890] mysqld(+0x73bb13)[0x5569f91b5b13] mysqld(_ZN24Window_funcs_computation5setupEP3THDP4ListI16Item_window_funcEP13st_join_table+0x1bd)[0x5569f91b8d4d] mysqld(_ZN4JOIN21make_aggr_tables_infoEv+0x15a3)[0x5569f90afc33] mysqld(_ZN4JOIN15optimize_stage2Ev+0x1b7d)[0x5569f90b733d] mysqld(_ZN4JOIN14optimize_innerEv+0xdf1)[0x5569f90b8a01] mysqld(_ZN4JOIN8optimizeEv+0x9b)[0x5569f90bb2ab] mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe0)[0x5569f90bbdf0] mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x141)[0x5569f90bc7f1] mysqld(+0x5e04d1)[0x5569f905a4d1] mysqld(_Z21mysql_execute_commandP3THD+0x16b5)[0x5569f9062805] mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x5569f906a29a] mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x166d)[0x5569f906ca5d] mysqld(_Z10do_commandP3THD+0x148)[0x5569f906dec8] mysqld(_Z24do_handle_one_connectionP7CONNECT+0x2c2)[0x5569f9147612] mysqld(handle_one_connection+0x3d)[0x5569f91476dd] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f9a853506db] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f9a8474e88f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f9a58014520): select i, max(i) over (partition by (select 1)) --max(i) over (partition by j) from t order by i asc LIMIT 0, 200 Connection ID (thread ID): 8 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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=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. 2019-04-30 11:44:14 0 [Note] mysqld (mysqld 10.4.4-MariaDB-1:10.4.4+maria~bionic) starting as process 1 ... 2019-04-30 11:44:14 0 [Warning] lower_case_table_names was set to 2, even though your the file system '/var/lib/mysql/' is case sensitive. Now setting lower_case_table_names to 0 to avoid future problems. 2019-04-30 11:44:14 0 [Note] InnoDB: Using Linux native AIO 2019-04-30 11:44:14 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-04-30 11:44:14 0 [Note] InnoDB: Uses event mutexes 2019-04-30 11:44:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-04-30 11:44:14 0 [Note] InnoDB: Number of pools: 1 2019-04-30 11:44:14 0 [Note] InnoDB: Using SSE2 crc32 instructions 2019-04-30 11:44:14 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2019-04-30 11:44:14 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2019-04-30 11:44:14 0 [Note] InnoDB: Completed initialization of buffer pool 2019-04-30 11:44:14 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-04-30 11:44:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150229 2019-04-30 11:44:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2019-04-30 11:44:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-04-30 11:44:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-04-30 11:44:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-04-30 11:44:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-04-30 11:44:14 0 [Note] InnoDB: Waiting for purge to start 2019-04-30 11:44:14 0 [Note] InnoDB: 10.4.4 started; log sequence number 150238; transaction id 41 2019-04-30 11:44:14 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-04-30 11:44:14 0 [Note] Plugin 'FEEDBACK' is disabled. 2019-04-30 11:44:14 0 [Note] Server socket created on IP: '0.0.0.0'. 2019-04-30 11:44:14 0 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 11:44:14 0 [Note] InnoDB: Buffer pool(s) load completed at 190430 11:44:14 2019-04-30 11:44:14 0 [Note] Reading of all Master_info entries succeded 2019-04-30 11:44:14 0 [Note] Added new Master_info '' to hash table 2019-04-30 11:44:14 0 [Note] mysqld: ready for connections. Version: '10.4.4-MariaDB-1:10.4.4+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3307 mariadb.org binary distribution 2019-04-30 11:44:52 8 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 11:46:57 13 [Warning] Aborted connection 13 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 11:53:17 34 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 11:55:59 43 [Warning] Aborted connection 43 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:19:54 64 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:21:29 88 [Warning] Aborted connection 88 to db: 'test' user: 'root' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:21:29 69 [Warning] Aborted connection 69 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:27:44 89 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:29:19 94 [Warning] Aborted connection 94 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:29:19 113 [Warning] Aborted connection 113 to db: 'test' user: 'root' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:30:22 114 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:32:21 119 [Warning] Aborted connection 119 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:34:55 144 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:36:36 149 [Warning] Aborted connection 149 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:39:31 174 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:40:33 175 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:42:17 180 [Warning] Aborted connection 180 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:45:19 205 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:46:26 209 [Warning] Aborted connection 209 to db: 'test' user: 'root' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:46:26 210 [Warning] Aborted connection 210 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:53:18 212 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:53:19 212 [Warning] Aborted connection 212 to db: 'test' user: 'root' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 12:53:55 213 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:56:33 216 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:57:20 217 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 12:59:43 222 [Warning] Aborted connection 222 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 13:01:06 247 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 13:03:00 252 [Warning] Aborted connection 252 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 13:05:35 214 [Warning] Aborted connection 214 to db: 'test' user: 'root' host: '192.168.99.1' (Got timeout reading communication packets) 2019-04-30 13:05:44 215 [Warning] Aborted connection 215 to db: 'test' user: 'root' host: '192.168.99.1' (Got timeout reading communication packets) 2019-04-30 13:06:36 277 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 13:08:18 278 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 13:18:07 281 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 13:20:34 286 [Warning] Aborted connection 286 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 2019-04-30 13:22:16 279 [Warning] Aborted connection 279 to db: 'test' user: 'root' host: '192.168.99.1' (Got timeout reading communication packets) 2019-04-30 13:22:20 280 [Warning] Aborted connection 280 to db: 'test' user: 'root' host: '192.168.99.1' (Got timeout reading communication packets) 2019-04-30 15:46:04 312 [Warning] 'proxies_priv' entry '@% root@default' ignored in --skip-name-resolve mode. 2019-04-30 15:47:57 317 [Warning] Aborted connection 317 to db: 'test' user: 'NO_RIGHTS' host: '192.168.99.1' (Got an error reading communication packets) 190501 9:54:14 [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.4.4-MariaDB-1:10.4.4+maria~bionic key_buffer_size=134217728 read_buffer_size=2097152 max_used_connections=6 max_threads=102 thread_count=8 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 760221 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f41bc01b8a8 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 = 0x7f4200204dd8 thread_stack 0x49000 mysqld(my_print_stacktrace+0x2e)[0x56398fc21a4e] mysqld(handle_fatal_signal+0x5a5)[0x56398f6a4a95] /lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f420f265890] mysqld(+0x73bb1a)[0x56398f5ebb1a] mysqld(_ZN24Window_funcs_computation5setupEP3THDP4ListI16Item_window_funcEP13st_join_table+0x1bd)[0x56398f5eed4d] mysqld(_ZN4JOIN21make_aggr_tables_infoEv+0x15a3)[0x56398f4e5c33] mysqld(_ZN4JOIN15optimize_stage2Ev+0x1b7d)[0x56398f4ed33d] mysqld(_ZN4JOIN14optimize_innerEv+0xdf1)[0x56398f4eea01] mysqld(_ZN4JOIN8optimizeEv+0x9b)[0x56398f4f12ab] mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0xe0)[0x56398f4f1df0] mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x141)[0x56398f4f27f1] mysqld(+0x5e04d1)[0x56398f4904d1] mysqld(_Z21mysql_execute_commandP3THD+0x16b5)[0x56398f498805] mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x22a)[0x56398f4a029a] mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x166d)[0x56398f4a2a5d] mysqld(_Z10do_commandP3THD+0x148)[0x56398f4a3ec8] mysqld(_Z24do_handle_one_connectionP7CONNECT+0x2c2)[0x56398f57d612] mysqld(handle_one_connection+0x3d)[0x56398f57d6dd] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f420f25a6db] /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f420e65888f] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x7f41bc014a50): select i, max(i) over (partition by 1), max(i) over (partition by (select 1)) from t order by i asc LIMIT 0, 200 Connection ID (thread ID): 334 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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=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.