140721 17:30:49 mysqld_safe mysqld from pid file /var/lib/mysql/fabricsrv.pid ended 140721 17:31:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-21 17:31:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:31:54 4300 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:31:54 4300 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:31:54 4300 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:31:54 4300 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:31:54 4300 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:31:54 4300 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:31:54 7f4555f1f720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:31:54 7f4555f1f720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:31:54 4300 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:31:54 4300 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:31:54 4300 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:31:54 4300 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:31:54 4300 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:31:54 4300 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:31:54 4300 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:31:56 4300 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:31:56 4300 [Note] InnoDB: Waiting for purge to start 2014-07-21 17:31:56 4300 [Note] InnoDB: 5.6.19 started; log sequence number 2188694 2014-07-21 17:31:56 4300 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2014-07-21 17:31:56 4300 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:31:56 4300 [Note] IPv6 is available. 2014-07-21 17:31:56 4300 [Note] - '::' resolves to '::'; 2014-07-21 17:31:56 4300 [Note] Server socket created on IP: '::'. 2014-07-21 17:31:56 4300 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:31:56 4300 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:31:56 4300 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:31:56 4300 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:31:56 4300 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 12:32:44 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x38ff900 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 = 7f45540c2de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld(_ZNK5Field7is_nullEx+0x30)[0x677138] /usr/local/mysql/bin/mysqld(_ZN13Protocol_text5storeEP5Field+0x32)[0x72f872] /usr/local/mysql/bin/mysqld(_ZN10Item_field4sendEP8ProtocolP6String+0x3b)[0x66db97] /usr/local/mysql/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xb5)[0x72eaf7] /usr/local/mysql/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xc5)[0x79e4d3] /usr/local/mysql/bin/mysqld[0x7b99b2] /usr/local/mysql/bin/mysqld[0x7b6e07] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2d5)[0x7b633d] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f450c006e30): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:32:51 mysqld_safe Number of processes running now: 0 140721 17:32:51 mysqld_safe mysqld restarted 2014-07-21 17:32:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:32:52 4346 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:32:52 4346 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:32:52 4346 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:32:52 4346 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:32:52 4346 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:32:52 4346 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:32:52 7f42dabfd720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:32:52 7f42dabfd720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:32:52 4346 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:32:52 4346 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:32:52 4346 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:32:52 4346 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:32:52 4346 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:32:52 4346 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:32:52 4346 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:32:52 4346 [Note] InnoDB: The log sequence numbers 2188694 and 2188694 in ibdata files do not match the log sequence number 2188704 in the ib_logfiles! 2014-07-21 17:32:52 4346 [Note] InnoDB: Database was not shutdown normally! 2014-07-21 17:32:52 4346 [Note] InnoDB: Starting crash recovery. 2014-07-21 17:32:52 4346 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-21 17:32:52 4346 [Note] InnoDB: Restoring possible half-written data pages 2014-07-21 17:32:52 4346 [Note] InnoDB: from the doublewrite buffer... 2014-07-21 17:32:54 4346 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:32:54 4346 [Note] InnoDB: Waiting for purge to start 2014-07-21 17:32:54 4346 [Note] InnoDB: 5.6.19 started; log sequence number 2188704 2014-07-21 17:32:54 4346 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!! 2014-07-21 17:32:54 4346 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:32:54 4346 [Note] Starting crash recovery... 2014-07-21 17:32:54 4346 [Note] Crash recovery finished. 2014-07-21 17:32:54 4346 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:32:54 4346 [Note] IPv6 is available. 2014-07-21 17:32:54 4346 [Note] - '::' resolves to '::'; 2014-07-21 17:32:54 4346 [Note] Server socket created on IP: '::'. 2014-07-21 17:32:54 4346 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:32:54 4346 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:32:54 4346 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:32:54 4346 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:32:54 4346 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 17:35:39 4346 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 2014-07-21 17:35:39 4346 [Note] Giving 0 client threads a chance to die gracefully 2014-07-21 17:35:39 4346 [Note] Event Scheduler: Purging the queue. 0 events 2014-07-21 17:35:39 4346 [Note] Shutting down slave threads 2014-07-21 17:35:39 4346 [Note] Forcefully disconnecting 0 remaining clients 2014-07-21 17:35:39 4346 [Note] Binlog end 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'partition' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'ARCHIVE' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'CSV' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'MEMORY' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'MyISAM' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'sha256_password' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'mysql_old_password' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'mysql_native_password' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'binlog' 2014-07-21 17:35:39 4346 [Note] Shutting down plugin 'InnoDB' 2014-07-21 17:35:39 4346 [Note] InnoDB: FTS optimize thread exiting. 2014-07-21 17:35:39 4346 [Note] InnoDB: Starting shutdown... 2014-07-21 17:35:40 4346 [Note] InnoDB: Shutdown completed; log sequence number 2188714 2014-07-21 17:35:40 4346 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140721 17:35:40 mysqld_safe mysqld from pid file /var/lib/mysql/fabricsrv.pid ended 140721 17:35:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-21 17:35:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:35:49 5174 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:35:49 5174 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:35:49 5174 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:35:49 5174 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:35:49 5174 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:35:49 5174 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:35:49 7ffb1c7c6720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:35:49 7ffb1c7c6720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:35:49 5174 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:35:49 5174 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:35:49 5174 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:35:49 5174 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:35:49 5174 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:35:49 5174 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:35:49 5174 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:35:51 5174 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:35:51 5174 [Note] InnoDB: 5.6.19 started; log sequence number 2188714 2014-07-21 17:35:51 5174 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!! 2014-07-21 17:35:51 5174 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:35:51 5174 [Note] IPv6 is available. 2014-07-21 17:35:51 5174 [Note] - '::' resolves to '::'; 2014-07-21 17:35:51 5174 [Note] Server socket created on IP: '::'. 2014-07-21 17:35:51 5174 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:35:51 5174 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:35:51 5174 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:35:51 5174 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:35:51 5174 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 12:36:31 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x32b46a0 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 = 7ffaef90ade0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld(_ZNK5Field7is_nullEx+0x30)[0x677138] /usr/local/mysql/bin/mysqld(_ZN13Protocol_text5storeEP5Field+0x32)[0x72f872] /usr/local/mysql/bin/mysqld(_ZN10Item_field4sendEP8ProtocolP6String+0x3b)[0x66db97] /usr/local/mysql/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xb5)[0x72eaf7] /usr/local/mysql/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xc5)[0x79e4d3] /usr/local/mysql/bin/mysqld[0x7b99b2] /usr/local/mysql/bin/mysqld[0x7b6e07] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2d5)[0x7b633d] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7ffac8005010): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:36:37 mysqld_safe Number of processes running now: 0 140721 17:36:37 mysqld_safe mysqld restarted 2014-07-21 17:36:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:36:38 5219 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:36:38 5219 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:36:38 5219 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:36:38 5219 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:36:38 5219 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:36:38 5219 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:36:38 7f4258057720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:36:38 7f4258057720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:36:38 5219 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:36:38 5219 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:36:38 5219 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:36:38 5219 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:36:38 5219 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:36:38 5219 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:36:38 5219 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:36:38 5219 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2188714 2014-07-21 17:36:38 5219 [Note] InnoDB: Database was not shutdown normally! 2014-07-21 17:36:38 5219 [Note] InnoDB: Starting crash recovery. 2014-07-21 17:36:38 5219 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-21 17:36:38 5219 [Note] InnoDB: Restoring possible half-written data pages 2014-07-21 17:36:38 5219 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 2188724 2014-07-21 17:36:40 5219 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:36:40 5219 [Note] InnoDB: 5.6.19 started; log sequence number 2188724 2014-07-21 17:36:40 5219 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!! 2014-07-21 17:36:40 5219 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:36:40 5219 [Note] Starting crash recovery... 2014-07-21 17:36:40 5219 [Note] Crash recovery finished. 2014-07-21 17:36:40 5219 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:36:40 5219 [Note] IPv6 is available. 2014-07-21 17:36:40 5219 [Note] - '::' resolves to '::'; 2014-07-21 17:36:40 5219 [Note] Server socket created on IP: '::'. 2014-07-21 17:36:40 5219 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:36:40 5219 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:36:40 5219 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:36:40 5219 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:36:40 5219 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 12:37:33 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x23cba80 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 = 7f4254065de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld(_ZNK5Field7is_nullEx+0x30)[0x677138] /usr/local/mysql/bin/mysqld(_ZN13Protocol_text5storeEP5Field+0x32)[0x72f872] /usr/local/mysql/bin/mysqld(_ZN10Item_field4sendEP8ProtocolP6String+0x3b)[0x66db97] /usr/local/mysql/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xb5)[0x72eaf7] /usr/local/mysql/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xc5)[0x79e4d3] /usr/local/mysql/bin/mysqld[0x7b99b2] /usr/local/mysql/bin/mysqld[0x7b6e07] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2d5)[0x7b633d] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (24aeb30): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:37:39 mysqld_safe Number of processes running now: 0 140721 17:37:39 mysqld_safe mysqld restarted 2014-07-21 17:37:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:37:39 5262 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:37:39 5262 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:37:39 5262 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:37:39 5262 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:37:39 5262 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:37:39 5262 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:37:39 7f6ac3d63720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:37:39 7f6ac3d63720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:37:39 5262 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:37:39 5262 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:37:39 5262 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:37:39 5262 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:37:39 5262 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:37:39 5262 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:37:39 5262 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:37:39 5262 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2188714 2014-07-21 17:37:39 5262 [Note] InnoDB: Database was not shutdown normally! 2014-07-21 17:37:39 5262 [Note] InnoDB: Starting crash recovery. 2014-07-21 17:37:39 5262 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-21 17:37:39 5262 [Note] InnoDB: Restoring possible half-written data pages 2014-07-21 17:37:39 5262 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 2188734 2014-07-21 17:37:41 5262 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:37:41 5262 [Note] InnoDB: 5.6.19 started; log sequence number 2188734 2014-07-21 17:37:41 5262 [Note] InnoDB: !!! innodb_force_recovery is set to 2 !!! 2014-07-21 17:37:41 5262 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:37:41 5262 [Note] Starting crash recovery... 2014-07-21 17:37:41 5262 [Note] Crash recovery finished. 2014-07-21 17:37:41 5262 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:37:41 5262 [Note] IPv6 is available. 2014-07-21 17:37:41 5262 [Note] - '::' resolves to '::'; 2014-07-21 17:37:41 5262 [Note] Server socket created on IP: '::'. 2014-07-21 17:37:41 5262 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:37:41 5262 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:37:41 5262 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:37:42 5262 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:37:42 5262 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 17:40:48 5262 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 2014-07-21 17:40:48 5262 [Note] Giving 0 client threads a chance to die gracefully 2014-07-21 17:40:48 5262 [Note] Event Scheduler: Purging the queue. 0 events 2014-07-21 17:40:48 5262 [Note] Shutting down slave threads 2014-07-21 17:40:48 5262 [Note] Forcefully disconnecting 0 remaining clients 2014-07-21 17:40:48 5262 [Note] Binlog end 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'partition' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'ARCHIVE' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'CSV' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'MEMORY' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'MyISAM' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'sha256_password' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'mysql_old_password' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'mysql_native_password' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'binlog' 2014-07-21 17:40:48 5262 [Note] Shutting down plugin 'InnoDB' 2014-07-21 17:40:48 5262 [Note] InnoDB: FTS optimize thread exiting. 2014-07-21 17:40:48 5262 [Note] InnoDB: Starting shutdown... 2014-07-21 17:40:49 5262 [Note] InnoDB: Shutdown completed; log sequence number 2188744 2014-07-21 17:40:49 5262 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140721 17:40:49 mysqld_safe mysqld from pid file /var/lib/mysql/fabricsrv.pid ended 140721 17:41:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-21 17:41:01 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:41:01 6094 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:41:01 6094 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:41:01 6094 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:41:01 6094 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:41:01 6094 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:41:01 6094 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:41:01 7f20d9045720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:41:01 7f20d9045720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:41:01 6094 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:41:01 6094 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:41:01 6094 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:41:01 6094 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:41:01 6094 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:41:01 6094 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:41:01 6094 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:41:03 6094 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:41:03 6094 [Note] InnoDB: 5.6.19 started; log sequence number 2188744 2014-07-21 17:41:03 6094 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! 2014-07-21 17:41:03 6094 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:41:03 6094 [Note] IPv6 is available. 2014-07-21 17:41:03 6094 [Note] - '::' resolves to '::'; 2014-07-21 17:41:03 6094 [Note] Server socket created on IP: '::'. 2014-07-21 17:41:03 6094 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:41:03 6094 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:41:03 6094 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:41:03 6094 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:41:03 6094 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 12:41:38 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x36035e0 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 = 7f20d80d6de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld(_ZNK5Field7is_nullEx+0x30)[0x677138] /usr/local/mysql/bin/mysqld(_ZN13Protocol_text5storeEP5Field+0x32)[0x72f872] /usr/local/mysql/bin/mysqld(_ZN10Item_field4sendEP8ProtocolP6String+0x3b)[0x66db97] /usr/local/mysql/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xb5)[0x72eaf7] /usr/local/mysql/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xc5)[0x79e4d3] /usr/local/mysql/bin/mysqld[0x7b99b2] /usr/local/mysql/bin/mysqld[0x7b6e07] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2d5)[0x7b633d] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f2088005010): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:41:44 mysqld_safe Number of processes running now: 0 140721 17:41:44 mysqld_safe mysqld restarted 2014-07-21 17:41:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:41:45 6136 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:41:45 6136 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:41:45 6136 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:41:45 6136 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:41:45 6136 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:41:45 6136 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:41:45 7f4e65603720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:41:45 7f4e65603720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:41:45 6136 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:41:45 6136 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:41:45 6136 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:41:45 6136 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:41:45 6136 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:41:45 6136 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:41:45 6136 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:41:45 6136 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2188744 2014-07-21 17:41:45 6136 [Note] InnoDB: Database was not shutdown normally! 2014-07-21 17:41:45 6136 [Note] InnoDB: Starting crash recovery. 2014-07-21 17:41:45 6136 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-21 17:41:45 6136 [Note] InnoDB: Restoring possible half-written data pages 2014-07-21 17:41:45 6136 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 2188754 2014-07-21 17:41:46 6136 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:41:46 6136 [Note] InnoDB: 5.6.19 started; log sequence number 2188754 2014-07-21 17:41:46 6136 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! 2014-07-21 17:41:46 6136 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:41:46 6136 [Note] Starting crash recovery... 2014-07-21 17:41:46 6136 [Note] Crash recovery finished. 2014-07-21 17:41:46 6136 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:41:46 6136 [Note] IPv6 is available. 2014-07-21 17:41:46 6136 [Note] - '::' resolves to '::'; 2014-07-21 17:41:46 6136 [Note] Server socket created on IP: '::'. 2014-07-21 17:41:46 6136 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:41:46 6136 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:41:46 6136 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:41:46 6136 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:41:46 6136 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 12:46:22 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2e425a0 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 = 7f4e640f0de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld(_ZNK5Field7is_nullEx+0x30)[0x677138] /usr/local/mysql/bin/mysqld(_ZN13Protocol_text5storeEP5Field+0x32)[0x72f872] /usr/local/mysql/bin/mysqld(_ZN10Item_field4sendEP8ProtocolP6String+0x3b)[0x66db97] /usr/local/mysql/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xb5)[0x72eaf7] /usr/local/mysql/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xc5)[0x79e4d3] /usr/local/mysql/bin/mysqld[0x7b99b2] /usr/local/mysql/bin/mysqld[0x7b6e07] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2d5)[0x7b633d] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (2f25790): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:46:29 mysqld_safe Number of processes running now: 0 140721 17:46:29 mysqld_safe mysqld restarted 2014-07-21 17:46:29 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:46:29 6186 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:46:29 6186 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:46:29 6186 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:46:29 6186 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:46:29 6186 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:46:29 6186 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:46:29 7f1c9690a720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:46:29 7f1c9690a720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:46:29 6186 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:46:29 6186 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:46:29 6186 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:46:29 6186 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:46:29 6186 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:46:29 6186 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:46:29 6186 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:46:29 6186 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2188744 2014-07-21 17:46:29 6186 [Note] InnoDB: Database was not shutdown normally! 2014-07-21 17:46:29 6186 [Note] InnoDB: Starting crash recovery. 2014-07-21 17:46:29 6186 [Note] InnoDB: Reading tablespace information from the .ibd files... 2014-07-21 17:46:29 6186 [Note] InnoDB: Restoring possible half-written data pages 2014-07-21 17:46:29 6186 [Note] InnoDB: from the doublewrite buffer... InnoDB: Doing recovery: scanned up to log sequence number 2188764 2014-07-21 17:46:31 6186 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-21 17:46:31 6186 [Note] InnoDB: 5.6.19 started; log sequence number 2188764 2014-07-21 17:46:31 6186 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!! 2014-07-21 17:46:31 6186 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:46:31 6186 [Note] Starting crash recovery... 2014-07-21 17:46:31 6186 [Note] Crash recovery finished. 2014-07-21 17:46:31 6186 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:46:31 6186 [Note] IPv6 is available. 2014-07-21 17:46:31 6186 [Note] - '::' resolves to '::'; 2014-07-21 17:46:31 6186 [Note] Server socket created on IP: '::'. 2014-07-21 17:46:31 6186 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:46:31 6186 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:46:31 6186 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:46:31 6186 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:46:31 6186 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 17:47:23 6186 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 2014-07-21 17:47:23 6186 [Note] Giving 0 client threads a chance to die gracefully 2014-07-21 17:47:23 6186 [Note] Event Scheduler: Purging the queue. 0 events 2014-07-21 17:47:23 6186 [Note] Shutting down slave threads 2014-07-21 17:47:23 6186 [Note] Forcefully disconnecting 0 remaining clients 2014-07-21 17:47:23 6186 [Note] Binlog end 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'partition' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'ARCHIVE' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'CSV' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'MEMORY' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'MyISAM' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'sha256_password' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'mysql_old_password' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'mysql_native_password' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'binlog' 2014-07-21 17:47:23 6186 [Note] Shutting down plugin 'InnoDB' 2014-07-21 17:47:23 6186 [Note] InnoDB: FTS optimize thread exiting. 2014-07-21 17:47:23 6186 [Note] InnoDB: Starting shutdown... 2014-07-21 17:47:24 6186 [Note] InnoDB: Shutdown completed; log sequence number 2188774 2014-07-21 17:47:24 6186 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140721 17:47:24 mysqld_safe mysqld from pid file /var/lib/mysql/fabricsrv.pid ended 140721 17:47:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-21 17:47:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:47:30 7006 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:47:30 7006 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:47:30 7006 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:47:30 7006 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:47:30 7006 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:47:30 7006 [Note] InnoDB: Started in read only mode 2014-07-21 17:47:30 7006 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:47:30 7f88feed3720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:47:30 7f88feed3720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:47:30 7006 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:47:30 7006 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:47:30 7006 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:47:30 7006 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:47:30 7006 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 17:47:30 7006 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:47:30 7006 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:47:30 7006 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:47:31 7006 [Note] InnoDB: 5.6.19 started; log sequence number 2188774 2014-07-21 17:47:31 7006 [Note] InnoDB: !!! innodb_force_recovery is set to 4 !!! 2014-07-21 17:47:31 7006 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:47:31 7006 [Note] IPv6 is available. 2014-07-21 17:47:31 7006 [Note] - '::' resolves to '::'; 2014-07-21 17:47:31 7006 [Note] Server socket created on IP: '::'. 2014-07-21 17:47:31 7006 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:47:31 7006 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:47:31 7006 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:47:31 7006 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 17:47:31 7006 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 17:47:31 7006 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 17:47:31 7006 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 17:47:31 7006 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:47:31 7006 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."admin_fav_list"' in the cache. Attempting to load the tablespace with space id 6. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."ads"' in the cache. Attempting to load the tablespace with space id 7. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."fav_list"' in the cache. Attempting to load the tablespace with space id 8. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_order"' in the cache. Attempting to load the tablespace with space id 9. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_user"' in the cache. Attempting to load the tablespace with space id 10. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."profile_completeness"' in the cache. Attempting to load the tablespace with space id 11. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."translation"' in the cache. Attempting to load the tablespace with space id 12. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities"' in the cache. Attempting to load the tablespace with space id 13. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities_relationship"' in the cache. Attempting to load the tablespace with space id 14. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_accounts"' in the cache. Attempting to load the tablespace with space id 15. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_admins"' in the cache. Attempting to load the tablespace with space id 16. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_bakutel_users"' in the cache. Attempting to load the tablespace with space id 17. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_calendar"' in the cache. Attempting to load the tablespace with space id 18. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_cities"' in the cache. Attempting to load the tablespace with space id 19. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_comp_abilities"' in the cache. Attempting to load the tablespace with space id 20. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies"' in the cache. Attempting to load the tablespace with space id 2073902. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies_relationship"' in the cache. Attempting to load the tablespace with space id 22. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_contacts"' in the cache. Attempting to load the tablespace with space id 23. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_countries"' in the cache. Attempting to load the tablespace with space id 24. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_educations"' in the cache. Attempting to load the tablespace with space id 25. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_experiences"' in the cache. Attempting to load the tablespace with space id 26. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_featured_comps"' in the cache. Attempting to load the tablespace with space id 27. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoice_vacancy"' in the cache. Attempting to load the tablespace with space id 28. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoices"' in the cache. Attempting to load the tablespace with space id 29. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages"' in the cache. Attempting to load the tablespace with space id 30. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages_relatiosnhip"' in the cache. Attempting to load the tablespace with space id 31. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_messages"' in the cache. Attempting to load the tablespace with space id 32. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_order_usage"' in the cache. Attempting to load the tablespace with space id 33. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_orders"' in the cache. Attempting to load the tablespace with space id 34. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_packages"' in the cache. Attempting to load the tablespace with space id 35. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_phones"' in the cache. Attempting to load the tablespace with space id 36. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_positions"' in the cache. Attempting to load the tablespace with space id 37. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_referrals"' in the cache. Attempting to load the tablespace with space id 38. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_successes"' in the cache. Attempting to load the tablespace with space id 39. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_templates"' in the cache. Attempting to load the tablespace with space id 40. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_universities"' in the cache. Attempting to load the tablespace with space id 41. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_users"' in the cache. Attempting to load the tablespace with space id 2073901. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies"' in the cache. Attempting to load the tablespace with space id 43. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies_relationship"' in the cache. Attempting to load the tablespace with space id 44. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_videos"' in the cache. Attempting to load the tablespace with space id 45. 2014-07-21 17:49:09 7006 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_views"' in the cache. Attempting to load the tablespace with space id 46. 12:49:09 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x283cc30 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 = 7f88fc095de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld[0xc3c571] /usr/local/mysql/bin/mysqld[0xc40343] /usr/local/mysql/bin/mysqld[0xb20193] /usr/local/mysql/bin/mysqld[0xb20705] /usr/local/mysql/bin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x137)[0x647e99] /usr/local/mysql/bin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x6d)[0x9965be] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1cf)[0x7b6237] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f88d0006e30): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:49:14 mysqld_safe Number of processes running now: 0 140721 17:49:14 mysqld_safe mysqld restarted 2014-07-21 17:49:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:49:14 7035 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:49:14 7035 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:49:14 7035 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:49:14 7035 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:49:14 7035 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:49:14 7035 [Note] InnoDB: Started in read only mode 2014-07-21 17:49:14 7035 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:49:14 7fa043c8d720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:49:14 7fa043c8d720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:49:14 7035 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:49:14 7035 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:49:14 7035 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:49:14 7035 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:49:14 7035 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 17:49:14 7035 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:49:14 7035 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:49:14 7035 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:49:15 7035 [Note] InnoDB: 5.6.19 started; log sequence number 2188774 2014-07-21 17:49:15 7035 [Note] InnoDB: !!! innodb_force_recovery is set to 4 !!! 2014-07-21 17:49:15 7035 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:49:15 7035 [Note] Starting crash recovery... 2014-07-21 17:49:15 7035 [Note] Crash recovery finished. 2014-07-21 17:49:15 7035 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:49:15 7035 [Note] IPv6 is available. 2014-07-21 17:49:15 7035 [Note] - '::' resolves to '::'; 2014-07-21 17:49:15 7035 [Note] Server socket created on IP: '::'. 2014-07-21 17:49:15 7035 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:49:15 7035 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:49:15 7035 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:49:15 7035 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 17:49:15 7035 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 17:49:15 7035 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 17:49:15 7035 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 17:49:15 7035 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:49:15 7035 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."admin_fav_list"' in the cache. Attempting to load the tablespace with space id 6. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."ads"' in the cache. Attempting to load the tablespace with space id 7. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."fav_list"' in the cache. Attempting to load the tablespace with space id 8. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_order"' in the cache. Attempting to load the tablespace with space id 9. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_user"' in the cache. Attempting to load the tablespace with space id 10. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."profile_completeness"' in the cache. Attempting to load the tablespace with space id 11. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."translation"' in the cache. Attempting to load the tablespace with space id 12. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities"' in the cache. Attempting to load the tablespace with space id 13. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities_relationship"' in the cache. Attempting to load the tablespace with space id 14. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_accounts"' in the cache. Attempting to load the tablespace with space id 15. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_admins"' in the cache. Attempting to load the tablespace with space id 16. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_bakutel_users"' in the cache. Attempting to load the tablespace with space id 17. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_calendar"' in the cache. Attempting to load the tablespace with space id 18. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_cities"' in the cache. Attempting to load the tablespace with space id 19. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_comp_abilities"' in the cache. Attempting to load the tablespace with space id 20. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies"' in the cache. Attempting to load the tablespace with space id 2073902. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies_relationship"' in the cache. Attempting to load the tablespace with space id 22. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_contacts"' in the cache. Attempting to load the tablespace with space id 23. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_countries"' in the cache. Attempting to load the tablespace with space id 24. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_educations"' in the cache. Attempting to load the tablespace with space id 25. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_experiences"' in the cache. Attempting to load the tablespace with space id 26. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_featured_comps"' in the cache. Attempting to load the tablespace with space id 27. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoice_vacancy"' in the cache. Attempting to load the tablespace with space id 28. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoices"' in the cache. Attempting to load the tablespace with space id 29. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages"' in the cache. Attempting to load the tablespace with space id 30. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages_relatiosnhip"' in the cache. Attempting to load the tablespace with space id 31. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_messages"' in the cache. Attempting to load the tablespace with space id 32. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_order_usage"' in the cache. Attempting to load the tablespace with space id 33. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_orders"' in the cache. Attempting to load the tablespace with space id 34. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_packages"' in the cache. Attempting to load the tablespace with space id 35. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_phones"' in the cache. Attempting to load the tablespace with space id 36. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_positions"' in the cache. Attempting to load the tablespace with space id 37. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_referrals"' in the cache. Attempting to load the tablespace with space id 38. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_successes"' in the cache. Attempting to load the tablespace with space id 39. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_templates"' in the cache. Attempting to load the tablespace with space id 40. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_universities"' in the cache. Attempting to load the tablespace with space id 41. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_users"' in the cache. Attempting to load the tablespace with space id 2073901. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies"' in the cache. Attempting to load the tablespace with space id 43. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies_relationship"' in the cache. Attempting to load the tablespace with space id 44. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_videos"' in the cache. Attempting to load the tablespace with space id 45. 2014-07-21 17:51:13 7035 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_views"' in the cache. Attempting to load the tablespace with space id 46. 12:51:31 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x352cc20 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 = 7fa01a9f1de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld(_ZNK5Field7is_nullEx+0x30)[0x677138] /usr/local/mysql/bin/mysqld(_ZN13Protocol_text5storeEP5Field+0x32)[0x72f872] /usr/local/mysql/bin/mysqld(_ZN10Item_field4sendEP8ProtocolP6String+0x3b)[0x66db97] /usr/local/mysql/bin/mysqld(_ZN8Protocol19send_result_set_rowEP4ListI4ItemE+0xb5)[0x72eaf7] /usr/local/mysql/bin/mysqld(_ZN11select_send9send_dataER4ListI4ItemE+0xc5)[0x79e4d3] /usr/local/mysql/bin/mysqld[0x7b99b2] /usr/local/mysql/bin/mysqld[0x7b6e07] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x2d5)[0x7b633d] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fa014006e30): select * from wd_users Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 17:51:37 mysqld_safe Number of processes running now: 0 140721 17:51:37 mysqld_safe mysqld restarted 2014-07-21 17:51:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 17:51:38 9487 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 17:51:38 9487 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 17:51:38 9487 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 17:51:38 9487 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 17:51:38 9487 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 17:51:38 9487 [Note] InnoDB: Started in read only mode 2014-07-21 17:51:38 9487 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 17:51:38 7f4bb9b90720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 17:51:38 7f4bb9b90720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 17:51:38 9487 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 17:51:38 9487 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 17:51:38 9487 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 17:51:38 9487 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 17:51:38 9487 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 17:51:38 9487 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 17:51:38 9487 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 17:51:38 9487 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 17:51:39 9487 [Note] InnoDB: 5.6.19 started; log sequence number 2188774 2014-07-21 17:51:39 9487 [Note] InnoDB: !!! innodb_force_recovery is set to 4 !!! 2014-07-21 17:51:39 9487 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 17:51:39 9487 [Note] Starting crash recovery... 2014-07-21 17:51:39 9487 [Note] Crash recovery finished. 2014-07-21 17:51:39 9487 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 17:51:39 9487 [Note] IPv6 is available. 2014-07-21 17:51:39 9487 [Note] - '::' resolves to '::'; 2014-07-21 17:51:39 9487 [Note] Server socket created on IP: '::'. 2014-07-21 17:51:39 9487 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:51:39 9487 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:51:39 9487 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 17:51:39 9487 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 17:51:39 9487 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 17:51:39 9487 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 17:51:39 9487 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 17:51:39 9487 [Note] Event Scheduler: Loaded 0 events 2014-07-21 17:51:39 9487 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."admin_fav_list"' in the cache. Attempting to load the tablespace with space id 6. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."ads"' in the cache. Attempting to load the tablespace with space id 7. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."fav_list"' in the cache. Attempting to load the tablespace with space id 8. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_order"' in the cache. Attempting to load the tablespace with space id 9. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_user"' in the cache. Attempting to load the tablespace with space id 10. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."profile_completeness"' in the cache. Attempting to load the tablespace with space id 11. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."translation"' in the cache. Attempting to load the tablespace with space id 12. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities"' in the cache. Attempting to load the tablespace with space id 13. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities_relationship"' in the cache. Attempting to load the tablespace with space id 14. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_accounts"' in the cache. Attempting to load the tablespace with space id 15. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_admins"' in the cache. Attempting to load the tablespace with space id 16. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_bakutel_users"' in the cache. Attempting to load the tablespace with space id 17. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_calendar"' in the cache. Attempting to load the tablespace with space id 18. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_cities"' in the cache. Attempting to load the tablespace with space id 19. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_comp_abilities"' in the cache. Attempting to load the tablespace with space id 20. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies"' in the cache. Attempting to load the tablespace with space id 2073902. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies_relationship"' in the cache. Attempting to load the tablespace with space id 22. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_contacts"' in the cache. Attempting to load the tablespace with space id 23. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_countries"' in the cache. Attempting to load the tablespace with space id 24. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_educations"' in the cache. Attempting to load the tablespace with space id 25. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_experiences"' in the cache. Attempting to load the tablespace with space id 26. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_featured_comps"' in the cache. Attempting to load the tablespace with space id 27. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoice_vacancy"' in the cache. Attempting to load the tablespace with space id 28. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoices"' in the cache. Attempting to load the tablespace with space id 29. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages"' in the cache. Attempting to load the tablespace with space id 30. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages_relatiosnhip"' in the cache. Attempting to load the tablespace with space id 31. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_messages"' in the cache. Attempting to load the tablespace with space id 32. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_order_usage"' in the cache. Attempting to load the tablespace with space id 33. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_orders"' in the cache. Attempting to load the tablespace with space id 34. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_packages"' in the cache. Attempting to load the tablespace with space id 35. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_phones"' in the cache. Attempting to load the tablespace with space id 36. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_positions"' in the cache. Attempting to load the tablespace with space id 37. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_referrals"' in the cache. Attempting to load the tablespace with space id 38. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_successes"' in the cache. Attempting to load the tablespace with space id 39. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_templates"' in the cache. Attempting to load the tablespace with space id 40. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_universities"' in the cache. Attempting to load the tablespace with space id 41. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_users"' in the cache. Attempting to load the tablespace with space id 2073901. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies"' in the cache. Attempting to load the tablespace with space id 43. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies_relationship"' in the cache. Attempting to load the tablespace with space id 44. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_videos"' in the cache. Attempting to load the tablespace with space id 45. 2014-07-21 18:02:00 9487 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_views"' in the cache. Attempting to load the tablespace with space id 46. 13:02:00 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x3e89b00 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 = 7f4b908c9de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld[0xc3c571] /usr/local/mysql/bin/mysqld[0xc40343] /usr/local/mysql/bin/mysqld[0xb20193] /usr/local/mysql/bin/mysqld[0xb20705] /usr/local/mysql/bin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x137)[0x647e99] /usr/local/mysql/bin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x6d)[0x9965be] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1cf)[0x7b6237] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f4b8c006e30): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 18:02:06 mysqld_safe Number of processes running now: 0 140721 18:02:06 mysqld_safe mysqld restarted 2014-07-21 18:02:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 18:02:07 9559 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 18:02:07 9559 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 18:02:07 9559 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 18:02:07 9559 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 18:02:07 9559 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 18:02:07 9559 [Note] InnoDB: Started in read only mode 2014-07-21 18:02:07 9559 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 18:02:07 7f5c02924720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 18:02:07 7f5c02924720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 18:02:07 9559 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 18:02:07 9559 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 18:02:07 9559 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 18:02:07 9559 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 18:02:07 9559 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 18:02:07 9559 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 18:02:07 9559 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 18:02:07 9559 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 18:02:08 9559 [Note] InnoDB: 5.6.19 started; log sequence number 2188774 2014-07-21 18:02:08 9559 [Note] InnoDB: !!! innodb_force_recovery is set to 4 !!! 2014-07-21 18:02:08 9559 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 18:02:08 9559 [Note] Starting crash recovery... 2014-07-21 18:02:08 9559 [Note] Crash recovery finished. 2014-07-21 18:02:08 9559 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 18:02:08 9559 [Note] IPv6 is available. 2014-07-21 18:02:08 9559 [Note] - '::' resolves to '::'; 2014-07-21 18:02:08 9559 [Note] Server socket created on IP: '::'. 2014-07-21 18:02:08 9559 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:02:08 9559 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:02:08 9559 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:02:08 9559 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 18:02:08 9559 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 18:02:08 9559 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 18:02:08 9559 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 18:02:08 9559 [Note] Event Scheduler: Loaded 0 events 2014-07-21 18:02:08 9559 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 18:03:27 9559 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 2014-07-21 18:03:27 9559 [Note] Giving 0 client threads a chance to die gracefully 2014-07-21 18:03:27 9559 [Note] Event Scheduler: Purging the queue. 0 events 2014-07-21 18:03:27 9559 [Note] Shutting down slave threads 2014-07-21 18:03:27 9559 [Note] Forcefully disconnecting 0 remaining clients 2014-07-21 18:03:27 9559 [Note] Binlog end 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'partition' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'ARCHIVE' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'CSV' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'MEMORY' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'MyISAM' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'sha256_password' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'mysql_old_password' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'mysql_native_password' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'binlog' 2014-07-21 18:03:27 9559 [Note] Shutting down plugin 'InnoDB' 2014-07-21 18:03:27 9559 [Note] InnoDB: Starting shutdown... 2014-07-21 18:03:27 9559 [Note] InnoDB: Shutdown completed; log sequence number 2188774 2014-07-21 18:03:27 9559 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140721 18:03:27 mysqld_safe mysqld from pid file /var/lib/mysql/fabricsrv.pid ended 140721 18:03:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-21 18:03:40 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 18:03:40 10366 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 18:03:40 10366 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 18:03:40 10366 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 18:03:40 10366 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 18:03:40 10366 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 18:03:40 10366 [Note] InnoDB: Started in read only mode 2014-07-21 18:03:40 10366 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 18:03:40 7fa4ee029720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 18:03:40 7fa4ee029720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 18:03:40 10366 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 18:03:40 10366 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 18:03:40 10366 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 18:03:40 10366 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 18:03:40 10366 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 18:03:40 10366 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 18:03:40 10366 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 18:03:40 10366 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 18:03:41 10366 [Note] InnoDB: 5.6.19 started; log sequence number 2188774 2014-07-21 18:03:41 10366 [Note] InnoDB: !!! innodb_force_recovery is set to 5 !!! 2014-07-21 18:03:41 10366 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 18:03:41 10366 [Note] IPv6 is available. 2014-07-21 18:03:41 10366 [Note] - '::' resolves to '::'; 2014-07-21 18:03:41 10366 [Note] Server socket created on IP: '::'. 2014-07-21 18:03:41 10366 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:03:41 10366 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:03:41 10366 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:03:41 10366 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 18:03:41 10366 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 18:03:41 10366 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 18:03:41 10366 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 18:03:41 10366 [Note] Event Scheduler: Loaded 0 events 2014-07-21 18:03:41 10366 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."admin_fav_list"' in the cache. Attempting to load the tablespace with space id 6. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."ads"' in the cache. Attempting to load the tablespace with space id 7. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."fav_list"' in the cache. Attempting to load the tablespace with space id 8. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_order"' in the cache. Attempting to load the tablespace with space id 9. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_user"' in the cache. Attempting to load the tablespace with space id 10. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."profile_completeness"' in the cache. Attempting to load the tablespace with space id 11. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."translation"' in the cache. Attempting to load the tablespace with space id 12. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities"' in the cache. Attempting to load the tablespace with space id 13. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities_relationship"' in the cache. Attempting to load the tablespace with space id 14. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_accounts"' in the cache. Attempting to load the tablespace with space id 15. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_admins"' in the cache. Attempting to load the tablespace with space id 16. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_bakutel_users"' in the cache. Attempting to load the tablespace with space id 17. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_calendar"' in the cache. Attempting to load the tablespace with space id 18. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_cities"' in the cache. Attempting to load the tablespace with space id 19. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_comp_abilities"' in the cache. Attempting to load the tablespace with space id 20. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies"' in the cache. Attempting to load the tablespace with space id 2073902. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies_relationship"' in the cache. Attempting to load the tablespace with space id 22. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_contacts"' in the cache. Attempting to load the tablespace with space id 23. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_countries"' in the cache. Attempting to load the tablespace with space id 24. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_educations"' in the cache. Attempting to load the tablespace with space id 25. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_experiences"' in the cache. Attempting to load the tablespace with space id 26. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_featured_comps"' in the cache. Attempting to load the tablespace with space id 27. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoice_vacancy"' in the cache. Attempting to load the tablespace with space id 28. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoices"' in the cache. Attempting to load the tablespace with space id 29. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages"' in the cache. Attempting to load the tablespace with space id 30. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages_relatiosnhip"' in the cache. Attempting to load the tablespace with space id 31. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_messages"' in the cache. Attempting to load the tablespace with space id 32. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_order_usage"' in the cache. Attempting to load the tablespace with space id 33. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_orders"' in the cache. Attempting to load the tablespace with space id 34. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_packages"' in the cache. Attempting to load the tablespace with space id 35. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_phones"' in the cache. Attempting to load the tablespace with space id 36. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_positions"' in the cache. Attempting to load the tablespace with space id 37. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_referrals"' in the cache. Attempting to load the tablespace with space id 38. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_successes"' in the cache. Attempting to load the tablespace with space id 39. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_templates"' in the cache. Attempting to load the tablespace with space id 40. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_universities"' in the cache. Attempting to load the tablespace with space id 41. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_users"' in the cache. Attempting to load the tablespace with space id 2073901. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies"' in the cache. Attempting to load the tablespace with space id 43. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies_relationship"' in the cache. Attempting to load the tablespace with space id 44. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_videos"' in the cache. Attempting to load the tablespace with space id 45. 2014-07-21 18:04:08 10366 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_views"' in the cache. Attempting to load the tablespace with space id 46. 13:04:08 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x2514260 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 = 7fa4ec1cfde0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld[0xc3c571] /usr/local/mysql/bin/mysqld[0xc40343] /usr/local/mysql/bin/mysqld[0xb20193] /usr/local/mysql/bin/mysqld[0xb20705] /usr/local/mysql/bin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x137)[0x647e99] /usr/local/mysql/bin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x6d)[0x9965be] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1cf)[0x7b6237] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fa4c0006e30): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 18:04:13 mysqld_safe Number of processes running now: 0 140721 18:04:13 mysqld_safe mysqld restarted 2014-07-21 18:04:13 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 18:04:13 10393 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 18:04:13 10393 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 18:04:13 10393 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 18:04:13 10393 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 18:04:13 10393 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 18:04:13 10393 [Note] InnoDB: Started in read only mode 2014-07-21 18:04:13 10393 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 18:04:13 7fba816a4720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 18:04:13 7fba816a4720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 18:04:13 10393 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 18:04:13 10393 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 18:04:13 10393 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 18:04:13 10393 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 18:04:13 10393 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 18:04:13 10393 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 18:04:13 10393 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 18:04:13 10393 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 18:04:14 10393 [Note] InnoDB: 5.6.19 started; log sequence number 2188774 2014-07-21 18:04:14 10393 [Note] InnoDB: !!! innodb_force_recovery is set to 5 !!! 2014-07-21 18:04:14 10393 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 18:04:14 10393 [Note] Starting crash recovery... 2014-07-21 18:04:14 10393 [Note] Crash recovery finished. 2014-07-21 18:04:14 10393 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 18:04:14 10393 [Note] IPv6 is available. 2014-07-21 18:04:14 10393 [Note] - '::' resolves to '::'; 2014-07-21 18:04:14 10393 [Note] Server socket created on IP: '::'. 2014-07-21 18:04:14 10393 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:04:14 10393 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:04:14 10393 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:04:14 10393 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 18:04:14 10393 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 18:04:14 10393 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 18:04:14 10393 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 18:04:14 10393 [Note] Event Scheduler: Loaded 0 events 2014-07-21 18:04:14 10393 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 18:05:52 10393 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 2014-07-21 18:05:52 10393 [Note] Giving 0 client threads a chance to die gracefully 2014-07-21 18:05:52 10393 [Note] Event Scheduler: Purging the queue. 0 events 2014-07-21 18:05:52 10393 [Note] Shutting down slave threads 2014-07-21 18:05:52 10393 [Note] Forcefully disconnecting 0 remaining clients 2014-07-21 18:05:52 10393 [Note] Binlog end 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'partition' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'ARCHIVE' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'CSV' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'MEMORY' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'MyISAM' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'sha256_password' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'mysql_old_password' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'mysql_native_password' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'binlog' 2014-07-21 18:05:52 10393 [Note] Shutting down plugin 'InnoDB' 2014-07-21 18:05:52 10393 [Note] InnoDB: Starting shutdown... 2014-07-21 18:05:52 10393 [Note] InnoDB: Shutdown completed; log sequence number 2188774 2014-07-21 18:05:52 10393 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 140721 18:05:52 mysqld_safe mysqld from pid file /var/lib/mysql/fabricsrv.pid ended 140721 18:06:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2014-07-21 18:06:22 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 18:06:22 11203 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 18:06:22 11203 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 18:06:22 11203 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 18:06:22 11203 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 18:06:22 11203 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 18:06:22 11203 [Note] InnoDB: Started in read only mode 2014-07-21 18:06:22 11203 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 18:06:22 7f9c06aae720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 18:06:22 7f9c06aae720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 18:06:22 11203 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 18:06:22 11203 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 18:06:22 11203 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 18:06:22 11203 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 18:06:22 11203 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 18:06:22 11203 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 18:06:22 11203 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 18:06:22 11203 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 18:06:22 11203 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo 2014-07-21 18:06:23 11203 [Note] InnoDB: 5.6.19 started; log sequence number 0 2014-07-21 18:06:23 11203 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!! 2014-07-21 18:06:23 11203 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 18:06:23 11203 [Note] IPv6 is available. 2014-07-21 18:06:23 11203 [Note] - '::' resolves to '::'; 2014-07-21 18:06:23 11203 [Note] Server socket created on IP: '::'. 2014-07-21 18:06:23 11203 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:06:23 11203 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:06:23 11203 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:06:23 11203 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 18:06:23 11203 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 18:06:23 11203 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 18:06:23 11203 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 18:06:23 11203 [Note] Event Scheduler: Loaded 0 events 2014-07-21 18:06:23 11203 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."admin_fav_list"' in the cache. Attempting to load the tablespace with space id 6. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."ads"' in the cache. Attempting to load the tablespace with space id 7. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."fav_list"' in the cache. Attempting to load the tablespace with space id 8. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_order"' in the cache. Attempting to load the tablespace with space id 9. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."package_user"' in the cache. Attempting to load the tablespace with space id 10. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."profile_completeness"' in the cache. Attempting to load the tablespace with space id 11. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."translation"' in the cache. Attempting to load the tablespace with space id 12. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities"' in the cache. Attempting to load the tablespace with space id 13. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_abilities_relationship"' in the cache. Attempting to load the tablespace with space id 14. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_accounts"' in the cache. Attempting to load the tablespace with space id 15. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_admins"' in the cache. Attempting to load the tablespace with space id 16. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_bakutel_users"' in the cache. Attempting to load the tablespace with space id 17. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_calendar"' in the cache. Attempting to load the tablespace with space id 18. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_cities"' in the cache. Attempting to load the tablespace with space id 19. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_comp_abilities"' in the cache. Attempting to load the tablespace with space id 20. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies"' in the cache. Attempting to load the tablespace with space id 2073902. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_companies_relationship"' in the cache. Attempting to load the tablespace with space id 22. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_contacts"' in the cache. Attempting to load the tablespace with space id 23. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_countries"' in the cache. Attempting to load the tablespace with space id 24. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_educations"' in the cache. Attempting to load the tablespace with space id 25. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_experiences"' in the cache. Attempting to load the tablespace with space id 26. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_featured_comps"' in the cache. Attempting to load the tablespace with space id 27. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoice_vacancy"' in the cache. Attempting to load the tablespace with space id 28. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_invoices"' in the cache. Attempting to load the tablespace with space id 29. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages"' in the cache. Attempting to load the tablespace with space id 30. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_languages_relatiosnhip"' in the cache. Attempting to load the tablespace with space id 31. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_messages"' in the cache. Attempting to load the tablespace with space id 32. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_order_usage"' in the cache. Attempting to load the tablespace with space id 33. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_orders"' in the cache. Attempting to load the tablespace with space id 34. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_packages"' in the cache. Attempting to load the tablespace with space id 35. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_phones"' in the cache. Attempting to load the tablespace with space id 36. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_positions"' in the cache. Attempting to load the tablespace with space id 37. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_referrals"' in the cache. Attempting to load the tablespace with space id 38. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_successes"' in the cache. Attempting to load the tablespace with space id 39. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_templates"' in the cache. Attempting to load the tablespace with space id 40. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_universities"' in the cache. Attempting to load the tablespace with space id 41. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_users"' in the cache. Attempting to load the tablespace with space id 2073901. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies"' in the cache. Attempting to load the tablespace with space id 43. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_vacancies_relationship"' in the cache. Attempting to load the tablespace with space id 44. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_videos"' in the cache. Attempting to load the tablespace with space id 45. 2014-07-21 18:07:33 11203 [ERROR] InnoDB: Failed to find tablespace for table '"testing"."wd_views"' in the cache. Attempting to load the tablespace with space id 46. 13:07:33 UTC - 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. 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. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=214 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 93348 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x35ba0d0 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 = 7f9bdd800de0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x35)[0xab6ead] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x404)[0x736ee0] /lib64/libpthread.so.0[0x35df20f710] /usr/local/mysql/bin/mysqld[0xc3c571] /usr/local/mysql/bin/mysqld[0xc40343] /usr/local/mysql/bin/mysqld[0xb20193] /usr/local/mysql/bin/mysqld[0xb20705] /usr/local/mysql/bin/mysqld(_ZN7handler11ha_rnd_nextEPh+0x137)[0x647e99] /usr/local/mysql/bin/mysqld(_Z13rr_sequentialP11READ_RECORD+0x6d)[0x9965be] /usr/local/mysql/bin/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x1cf)[0x7b6237] /usr/local/mysql/bin/mysqld[0x7b5c1a] /usr/local/mysql/bin/mysqld(_ZN4JOIN4execEv+0x6a7)[0x7b3acb] /usr/local/mysql/bin/mysqld[0x81599a] /usr/local/mysql/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_P10SQL_I_ListI8st_orderESB_S7_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x25f)[0x815cb1] /usr/local/mysql/bin/mysqld(_Z13handle_selectP3THDP13select_resultm+0x1c5)[0x813cd7] /usr/local/mysql/bin/mysqld[0x7ed9f1] /usr/local/mysql/bin/mysqld(_Z21mysql_execute_commandP3THD+0xd14)[0x7e62c0] /usr/local/mysql/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x428)[0x7f013a] /usr/local/mysql/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0xc94)[0x7e31f4] /usr/local/mysql/bin/mysqld(_Z10do_commandP3THD+0x340)[0x7e231e] /usr/local/mysql/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x1be)[0x7a9281] /usr/local/mysql/bin/mysqld(handle_one_connection+0x33)[0x7a8d89] /usr/local/mysql/bin/mysqld(pfs_spawn_thread+0x159)[0xafd879] /lib64/libpthread.so.0[0x35df2079d1] /lib64/libc.so.6(clone+0x6d)[0x35deee8b5d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f9bd8006e30): select * from wd_companies Connection ID (thread ID): 1 Status: NOT_KILLED 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. Writing a core file 140721 18:07:38 mysqld_safe Number of processes running now: 0 140721 18:07:38 mysqld_safe mysqld restarted 2014-07-21 18:07:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2014-07-21 18:07:39 11232 [Warning] Buffered warning: Could not increase number of max_open_files to more than 1024 (request: 65535) 2014-07-21 18:07:39 11232 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 10000) 2014-07-21 18:07:39 11232 [Warning] Buffered warning: Changed limits: table_cache: 400 (requested 4000) 2014-07-21 18:07:39 11232 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. 2014-07-21 18:07:39 11232 [Note] Plugin 'FEDERATED' is disabled. 2014-07-21 18:07:39 11232 [Note] InnoDB: Started in read only mode 2014-07-21 18:07:39 11232 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-21 18:07:39 7f7b63bc8720 InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!! 2014-07-21 18:07:39 7f7b63bc8720 InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!! 2014-07-21 18:07:39 11232 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-21 18:07:39 11232 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2014-07-21 18:07:39 11232 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-21 18:07:39 11232 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-21 18:07:39 11232 [Note] InnoDB: Disabling background IO write threads. 2014-07-21 18:07:39 11232 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-07-21 18:07:39 11232 [Note] InnoDB: Completed initialization of buffer pool 2014-07-21 18:07:39 11232 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-21 18:07:39 11232 [Note] InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on, skipping log redo 2014-07-21 18:07:40 11232 [Note] InnoDB: 5.6.19 started; log sequence number 0 2014-07-21 18:07:40 11232 [Note] InnoDB: !!! innodb_force_recovery is set to 6 !!! 2014-07-21 18:07:40 11232 [Note] Recovering after a crash using /var/lib/mysql/mysql-bin 2014-07-21 18:07:40 11232 [Note] Starting crash recovery... 2014-07-21 18:07:40 11232 [Note] Crash recovery finished. 2014-07-21 18:07:40 11232 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-21 18:07:40 11232 [Note] IPv6 is available. 2014-07-21 18:07:40 11232 [Note] - '::' resolves to '::'; 2014-07-21 18:07:40 11232 [Note] Server socket created on IP: '::'. 2014-07-21 18:07:40 11232 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:07:40 11232 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:07:40 11232 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:07:40 11232 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_master_info"' in the cache. Attempting to load the tablespace with space id 4. 2014-07-21 18:07:40 11232 [Warning] InnoDB: Allocated tablespace 4, old maximum was 0 2014-07-21 18:07:40 11232 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_worker_info"' in the cache. Attempting to load the tablespace with space id 5. 2014-07-21 18:07:40 11232 [ERROR] InnoDB: Failed to find tablespace for table '"mysql"."slave_relay_log_info"' in the cache. Attempting to load the tablespace with space id 3. 2014-07-21 18:07:40 11232 [Note] Event Scheduler: Loaded 0 events 2014-07-21 18:07:40 11232 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.19-debug-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution Status information: Current dir: /var/lib/mysql/ Running threads: 0 Stack size: 262144 Current locks: lock: 0x3bddd70: lock: 0x3af7f50: lock: 0x3ae1dc0: lock: 0x3a83d60: lock: 0x3addcc0: lock: 0x3ad1850: lock: 0x3ac6430: lock: 0x3ac0e00: lock: 0x3a9db40: lock: 0x3a959c0: lock: 0x3a8c290: lock: 0x1833e40: lock: 0x1833d40: lock: 0x1832b40: lock: 0x1832a40: lock: 0x1832940: lock: 0x1832d40: lock: 0x1830b40: lock: 0x1833c40: lock: 0x1831340: lock: 0x1831640: lock: 0x1831240: lock: 0x1831540: lock: 0x1831140: lock: 0x1831440: lock: 0x1831c40: lock: 0x1831b40: lock: 0x1831a40: lock: 0x1831040: lock: 0x1830d40: lock: 0x1830f40: lock: 0x1830c40: lock: 0x1830e40: lock: 0x1831940: lock: 0x1831840: lock: 0x1831740: lock: 0x1833840: lock: 0x1833b40: lock: 0x1833a40: lock: 0x1833940: lock: 0x1833440: lock: 0x1833340: lock: 0x1833240: lock: 0x1833140: lock: 0x1833040: lock: 0x1833640: lock: 0x1832f40: lock: 0x1832e40: lock: 0x1833540: lock: 0x1832c40: lock: 0x1832740: lock: 0x1832840: lock: 0x1832640: lock: 0x1832540: lock: 0x1832140: lock: 0x1832440: lock: 0x1832340: lock: 0x1832040: lock: 0x1832240: lock: 0x1831f40: lock: 0x1831e40: lock: 0x1831d40: lock: 0x1833740: DB Table Version Thread Open Lock mysql slave_master_info 1 0 1 Not in use performance_sc events_waits_summary_global_by_event_name 1 0 1 Not in use performance_sc setup_timers 1 0 1 Not in use performance_sc events_waits_history_long 1 0 1 Not in use performance_sc events_waits_summary_by_thread_by_event_name 1 0 1 Not in use performance_sc events_waits_summary_by_host_by_event_name 1 0 1 Not in use performance_sc events_waits_summary_by_instance 1 0 1 Not in use performance_sc events_stages_history 1 0 1 Not in use performance_sc host_cache 1 0 1 Not in use performance_sc performance_timers 1 0 1 Not in use performance_sc setup_consumers 1 0 1 Not in use performance_sc events_statements_history 1 0 1 Not in use performance_sc accounts 1 0 1 Not in use performance_sc events_waits_summary_by_user_by_event_name 1 0 1 Not in use performance_sc file_instances 1 0 1 Not in use performance_sc events_stages_summary_by_host_by_event_name 1 0 1 Not in use performance_sc events_stages_history_long 1 0 1 Not in use performance_sc events_stages_current 1 0 1 Not in use mysql columns_priv 1 0 1 Not in use mysql db 1 0 1 Not in use performance_sc socket_summary_by_instance 1 0 1 Not in use performance_sc events_statements_current 1 0 1 Not in use mysql event 1 0 1 Not in use performance_sc session_connect_attrs 1 0 1 Not in use performance_sc users 1 0 1 Not in use performance_sc threads 1 0 1 Not in use mysql user 1 0 1 Not in use performance_sc events_stages_summary_by_account_by_event_name 1 0 1 Not in use performance_sc file_summary_by_event_name 1 0 1 Not in use performance_sc events_waits_summary_by_account_by_event_name 1 0 1 Not in use performance_sc socket_summary_by_event_name 1 0 1 Not in use performance_sc hosts 1 0 1 Not in use mysql servers 1 0 1 Not in use performance_sc mutex_instances 1 0 1 Not in use performance_sc events_waits_history 1 0 1 Not in use performance_sc events_statements_summary_by_host_by_event_name 1 0 1 Not in use performance_sc events_statements_summary_by_account_by_event_name 1 0 1 Not in use performance_sc table_io_waits_summary_by_index_usage 1 0 1 Not in use performance_sc events_waits_current 1 0 1 Not in use mysql tables_priv 1 0 1 Not in use mysql procs_priv 1 0 1 Not in use performance_sc events_statements_summary_by_thread_by_event_name 1 0 1 Not in use performance_sc setup_actors 1 0 1 Not in use performance_sc events_stages_summary_by_user_by_event_name 1 0 1 Not in use performance_sc events_stages_summary_global_by_event_name 1 0 1 Not in use performance_sc events_stages_summary_by_thread_by_event_name 1 0 1 Not in use performance_sc file_summary_by_instance 1 0 1 Not in use performance_sc session_account_connect_attrs 1 0 1 Not in use performance_sc table_lock_waits_summary_by_table 1 0 1 Not in use performance_sc rwlock_instances 1 0 1 Not in use performance_sc table_io_waits_summary_by_table 1 0 1 Not in use performance_sc events_statements_summary_by_user_by_event_name 1 0 1 Not in use performance_sc socket_instances 1 0 1 Not in use mysql proxies_priv 1 0 1 Not in use performance_sc setup_instruments 1 0 1 Not in use performance_sc events_statements_history_long 1 0 1 Not in use performance_sc events_statements_summary_global_by_event_name 1 0 1 Not in use mysql slave_relay_log_info 1 0 1 Not in use mysql slave_worker_info 1 0 1 Not in use performance_sc cond_instances 1 0 1 Not in use performance_sc setup_objects 1 0 1 Not in use performance_sc objects_summary_global_by_type 1 0 1 Not in use performance_sc events_statements_summary_by_digest 1 0 1 Not in use Current refresh version: 1 Key caches: default Buffer_size: 8388608 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 5 read_next: 0 read_rnd 0 read_first: 6 write: 0 delete 0 update: 0 Table status: Opened tables: 70 Open tables: 63 Open files: 19 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 0 Next alarm time: 0 Memory status: Events status: LLA = Last Locked At LUA = Last Unlocked At WOC = Waiting On Condition DL = Data Locked Event scheduler status: State : INITIALIZED Thread id : 0 LLA : n/a:0 LUA : n/a:0 WOC : NO Workers : 0 Executed : 0 Data locked: NO Event queue status: Element count : 0 Data locked : NO Attempting lock : NO LLA : init_queue:139 LUA : init_queue:149 WOC : NO Next activation : never 2014-07-21 18:14:12 11232 [Warning] 'user' entry 'root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:14:12 11232 [Warning] 'user' entry '@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:14:12 11232 [Warning] 'proxies_priv' entry '@ root@fabricsrv' ignored in --skip-name-resolve mode. 2014-07-21 18:14:19 11232 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 2014-07-21 18:14:19 11232 [Note] Giving 0 client threads a chance to die gracefully 2014-07-21 18:14:19 11232 [Note] Event Scheduler: Purging the queue. 0 events 2014-07-21 18:14:19 11232 [Note] Shutting down slave threads 2014-07-21 18:14:19 11232 [Note] Forcefully disconnecting 0 remaining clients 2014-07-21 18:14:19 11232 [Note] Binlog end 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'partition' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'BLACKHOLE' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'ARCHIVE' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_METRICS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_CMPMEM' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_CMP' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_LOCKS' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'INNODB_TRX' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'MRG_MYISAM' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'CSV' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'MEMORY' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'MyISAM' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'sha256_password' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'mysql_old_password' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'mysql_native_password' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'binlog' 2014-07-21 18:14:19 11232 [Note] Shutting down plugin 'InnoDB' 2014-07-21 18:14:19 11232 [Note] InnoDB: Starting shutdown...