Dec 13 21:02:39 eroster mysqld[1914]: 2016-12-13 21:02:39 140490425345792 [Note] /usr/sbin/mysqld: Normal shutdown Dec 13 21:02:39 eroster mysqld[1914]: 2016-12-13 21:02:39 140490425345792 [Note] Event Scheduler: Purging the queue. 0 events Dec 13 21:02:39 eroster mysqld[1914]: 2016-12-13 21:02:39 140486559889152 [Note] InnoDB: FTS optimize thread exiting. Dec 13 21:02:39 eroster mysqld[1914]: 2016-12-13 21:02:39 140490425345792 [Note] InnoDB: Starting shutdown... Dec 13 21:02:39 eroster mysqld[1914]: 2016-12-13 21:02:39 140490425345792 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool Dec 13 21:02:41 eroster mysqld[1914]: 2016-12-13 21:02:41 140490425345792 [Note] InnoDB: Shutdown completed; log sequence number 584666163254 Dec 13 21:02:41 eroster mysqld[1914]: 2016-12-13 21:02:41 140490425345792 [Note] /usr/sbin/mysqld: Shutdown complete Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB-1~jessie) starting as process 3088 ... Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Using mutexes to ref count buffer pool pages Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: The InnoDB memory heap is disabled Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Compressed tables use zlib 1.2.8 Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Using Linux native AIO Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Using SSE crc32 instructions Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Initializing buffer pool, size = 3.0G Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Completed initialization of buffer pool Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Highest supported file format is Barracuda. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: 128 rollback segment(s) are active. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Waiting for purge to start Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [Note] InnoDB: Page 4 in tablespace 3229 encryption error key_version 1. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [ERROR] InnoDB: Block in space_id 3229 in file eroster/sessions encrypted. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [ERROR] InnoDB: However key management plugin or used key_id 1 is not found or used encryption algorithm or method does not match. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [ERROR] InnoDB: Marking tablespace as missing. You may drop this table or install correct key management plugin and key file. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [ERROR] InnoDB: Block in space_id 3229 in file eroster/sessions encrypted. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [ERROR] InnoDB: However key management plugin or used key_id 1 is not found or used encryption algorithm or method does not match. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618561275648 [ERROR] InnoDB: Marking tablespace as missing. You may drop this table or install correct key management plugin and key file. [Above repeated for every table in database eroster] Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 584666163254 Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Creating #1 thread id 139618510919424 total threads 4. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Creating #2 thread id 139618502526720 total threads 4. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Creating #3 thread id 139618494134016 total threads 4. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] InnoDB: Creating #4 thread id 139618485741312 total threads 4. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139618536097536 [Note] InnoDB: Dumping buffer pool(s) not yet started Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] Plugin 'FEEDBACK' is disabled. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] Using encryption key id 1 for temporary files Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] Server socket created on IP: '::'. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Warning] Found an entry in the 'db' table with empty database name; Skipped Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622398711744 [Note] /usr/sbin/mysqld: ready for connections. Dec 13 21:02:44 eroster mysqld[3088]: Version: '10.1.19-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Dec 13 21:02:44 eroster mysqld[3120]: Checking for corrupt, not cleanly closed and upgrade needing tables. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [Note] InnoDB: Page 3 in tablespace 3458 encryption error key_version 1. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [ERROR] InnoDB: Block in space_id 3458 in file eroster/group_list encrypted. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [ERROR] InnoDB: However key management plugin or used key_id 1 is not found or used encryption algorithm or method does not match. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [ERROR] InnoDB: Marking tablespace as missing. You may drop this table or install correct key management plugin and key file. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [ERROR] InnoDB: Block in space_id 3458 in file eroster/group_list encrypted. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [ERROR] InnoDB: However key management plugin or used key_id 1 is not found or used encryption algorithm or method does not match. Dec 13 21:02:44 eroster mysqld[3088]: 2016-12-13 21:02:44 139622380893952 [ERROR] InnoDB: Marking tablespace as missing. You may drop this table or install correct key management plugin and key file. Dec 13 21:02:44 eroster mysqld[3088]: 161213 21:02:44 [ERROR] mysqld got signal 11 ; Dec 13 21:02:44 eroster mysqld[3088]: This could be because you hit a bug. It is also possible that this binary Dec 13 21:02:44 eroster mysqld[3088]: or one of the libraries it was linked against is corrupt, improperly built, Dec 13 21:02:44 eroster mysqld[3088]: or misconfigured. This error can also be caused by malfunctioning hardware. Dec 13 21:02:44 eroster mysqld[3088]: To report this bug, see https://mariadb.com/kb/en/reporting-bugs Dec 13 21:02:44 eroster mysqld[3088]: We will try our best to scrape up some info that will hopefully help Dec 13 21:02:44 eroster mysqld[3088]: diagnose the problem, but since we have already crashed, Dec 13 21:02:44 eroster mysqld[3088]: something is definitely wrong and this may fail. Dec 13 21:02:44 eroster mysqld[3088]: Server version: 10.1.19-MariaDB-1~jessie Dec 13 21:02:44 eroster mysqld[3088]: key_buffer_size=25165824 Dec 13 21:02:44 eroster mysqld[3088]: read_buffer_size=131072 Dec 13 21:02:44 eroster mysqld[3088]: max_used_connections=2 Dec 13 21:02:44 eroster mysqld[3088]: max_threads=153 Dec 13 21:02:44 eroster mysqld[3088]: thread_count=2 Dec 13 21:02:44 eroster mysqld[3088]: It is possible that mysqld could use up to Dec 13 21:02:44 eroster mysqld[3088]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 360625 K bytes of memory Dec 13 21:02:44 eroster mysqld[3088]: Hope that's ok; if not, decrease some variables in the equation. Dec 13 21:02:44 eroster mysqld[3088]: Thread pointer: 0x0x7efb8c7e1008 Dec 13 21:02:44 eroster mysqld[3088]: Attempting backtrace. You can use the following information to find out Dec 13 21:02:44 eroster mysqld[3088]: where mysqld died. If you see no messages after this, something went Dec 13 21:02:44 eroster mysqld[3088]: terribly wrong... Dec 13 21:02:44 eroster mysqld[3088]: stack_bottom = 0x7efc5e6a6df8 thread_stack 0x80000 Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7efc5f117d0e] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(handle_fatal_signal+0x2d5)[0x7efc5ec50fc5] Dec 13 21:02:44 eroster mysqld[3088]: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7efc5e27a8d0] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(+0x785c89)[0x7efc5ee30c89] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(+0x7da2cb)[0x7efc5ee852cb] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(+0x708837)[0x7efc5edb3837] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(+0x714a70)[0x7efc5edbfa70] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_ZN7handler7ha_openEP5TABLEPKcij+0x33)[0x7efc5ec55473] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP11TABLE_SHAREPKcjjjP5TABLEb+0xb88)[0x7efc5eb73a98] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0xa1b)[0x7efc5ea821db] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjjP19Prelocking_strategy+0xa67)[0x7efc5ea85fd7] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z20open_and_lock_tablesP3THDRK14DDL_options_stP10TABLE_LISTbjP19Prelocking_strategy+0x33)[0x7efc5ea86993] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(+0x41390d)[0x7efc5eabe90d] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x60b8)[0x7efc5eacaab8] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x285)[0x7efc5eacde65] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1ce9)[0x7efc5ead09f9] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z10do_commandP3THD+0x16e)[0x7efc5ead113e] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x182)[0x7efc5eb9b7f2] Dec 13 21:02:44 eroster mysqld[3088]: /usr/sbin/mysqld(handle_one_connection+0x40)[0x7efc5eb9b9b0] Dec 13 21:02:44 eroster mysqld[3088]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7efc5e2730a4] Dec 13 21:02:44 eroster mysqld[3088]: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7efc5c41d62d] Dec 13 21:02:44 eroster mysqld[3088]: Trying to get some variables. Dec 13 21:02:44 eroster mysqld[3088]: Some pointers may be invalid and cause the dump to abort. Dec 13 21:02:44 eroster mysqld[3088]: Query (0x7efb80824020): select grp_const, grp_id from group_list where grp_const!='' Dec 13 21:02:44 eroster mysqld[3088]: Connection ID (thread ID): 3 Dec 13 21:02:44 eroster mysqld[3088]: Status: NOT_KILLED Dec 13 21:02:44 eroster mysqld[3088]: 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 Dec 13 21:02:44 eroster mysqld[3088]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains Dec 13 21:02:44 eroster mysqld[3088]: information that should help you find out what is causing the crash. Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] /usr/sbin/mysqld (mysqld 10.1.19-MariaDB-1~jessie) starting as process 3366 ... Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] Using unique option prefix 'myisam-recover' is error-prone and can break in the future. Please use the full name 'myisam-recover-options' instead. Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Using mutexes to ref count buffer pool pages Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: The InnoDB memory heap is disabled Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Compressed tables use zlib 1.2.8 Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Using Linux native AIO Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Using SSE crc32 instructions Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Initializing buffer pool, size = 3.0G Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Completed initialization of buffer pool Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Highest supported file format is Barracuda. Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: The log sequence numbers 584666163254 and 584666163254 in ibdata files do not match the log sequence number 584666163264 in the ib_logfiles! Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Database was not shutdown normally! Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Starting crash recovery. Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Reading tablespace information from the .ibd files... Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: Restoring possible half-written data pages Dec 13 21:02:55 eroster mysqld[3366]: 2016-12-13 21:02:55 140245278762944 [Note] InnoDB: from the doublewrite buffer... Dec 13 21:02:55 eroster mysqld[3366]: InnoDB: Last MySQL binlog file position 0 10331251, file name /var/log/mysql/mysql-bin.008566 Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: 128 rollback segment(s) are active. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: Waiting for purge to start Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.32-79.0 started; log sequence number 584666163264 Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: Creating #1 thread id 140241386039040 total threads 4. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: Creating #2 thread id 140241377646336 total threads 4. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140241411217152 [Note] InnoDB: Dumping buffer pool(s) not yet started Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: Creating #3 thread id 140241369253632 total threads 4. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] InnoDB: Creating #4 thread id 140241360860928 total threads 4. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] Plugin 'FEEDBACK' is disabled. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] Using encryption key id 1 for temporary files Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] Recovering after a crash using /var/log/mysql/mysql-bin Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] Starting crash recovery... Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] Crash recovery finished. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] Server socket created on IP: '::'. Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Warning] Found an entry in the 'db' table with empty database name; Skipped Dec 13 21:02:56 eroster mysqld[3366]: 2016-12-13 21:02:56 140245278762944 [Note] /usr/sbin/mysqld: ready for connections. Dec 13 21:02:56 eroster mysqld[3366]: Version: '10.1.19-MariaDB-1~jessie' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution Dec 13 21:02:56 eroster mysqld[3399]: Checking for corrupt, not cleanly closed and upgrade needing tables.