The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Server crashed.

Discussion in 'Database Discussions' started by Motamedi, Sep 21, 2015.

  1. Motamedi

    Motamedi Well-Known Member

    Joined:
    Mar 14, 2015
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Iran , Tehran
    cPanel Access Level:
    Root Administrator
    Hello sir,

    Please check the logs :

    Code:
    2015-09-21 08:16:17 759323 [Warning] Checking table:   './onliners_marketdb/wp_options'
    2015-09-21 08:16:17 759323 [ERROR] /usr/sbin/mysqld: Table './nazilchw_wp/wp_options' is marked as crashed and should be repaired
    2015-09-21 08:16:17 759323 [Warning] Checking table:   './nazilchw_wp/wp_options'
    2015-09-21 08:16:17 759323 [ERROR] /usr/sbin/mysqld: Table './nazilchw_wp/wp_TABLE_STATISTICS' is marked as crashed and should be repaired
    2015-09-21 08:16:17 759323 [Warning] Checking table:   './nazilchw_wp/wp_TABLE_STATISTICS'
    2015-09-21 08:16:17 759323 [ERROR] /usr/sbin/mysqld: Table './nazilchw_wp/wp_TABLE_STATISTICS_RAW' is marked as crashed and should be repaired
    2015-09-21 08:16:17 759323 [Warning] Checking table:   './nazilchw_wp/wp_TABLE_STATISTICS_RAW'
    2015-09-21 08:17:30 759323 [ERROR] /usr/sbin/mysqld: Table './salmanca_asli/e107_online' is marked as crashed and should be repaired
    2015-09-21 08:17:30 759323 [Warning] Checking table:   './salmanca_asli/e107_online'
    2015-09-21 08:22:54 759323 [ERROR] /usr/sbin/mysqld: Table './mosavi_mivdl/wp_options' is marked as crashed and should be repaired
    2015-09-21 08:22:54 759323 [Warning] Checking table:   './mosavi_mivdl/wp_options'
    2015-09-21 08:22:55 759323 [ERROR] /usr/sbin/mysqld: Table './mosavi_mivdl/wp_TABLE_STATISTICS' is marked as crashed and should be repaired
    2015-09-21 08:22:55 759323 [Warning] Checking table:   './mosavi_mivdl/wp_TABLE_STATISTICS'
    2015-09-21 08:22:55 759323 [ERROR] /usr/sbin/mysqld: Table './mosavi_mivdl/wp_TABLE_STATISTICS_RAW' is marked as crashed and should be repaired
    2015-09-21 08:22:55 759323 [Warning] Checking table:   './mosavi_mivdl/wp_TABLE_STATISTICS_RAW'
    2015-09-21 08:23:38 759323 [ERROR] /usr/sbin/mysqld: Table './almascar_db/state_visit' is marked as crashed and should be repaired
    2015-09-21 08:23:38 759323 [Warning] Checking table:   './almascar_db/state_visit'
    2015-09-21 08:26:30 759323 [ERROR] /usr/sbin/mysqld: Table './buyprope_buyprope/wp_server_name' is marked as crashed and should be repaired
    2015-09-21 08:26:30 759323 [Warning] Checking table:   './buyprope_buyprope/wp_server_name'
    2015-09-21 08:29:53 759323 [ERROR] /usr/sbin/mysqld: Table './asanyadb_sitedb/wp_TABLE_STATISTICS' is marked as crashed and should be repaired
    2015-09-21 08:29:53 759323 [Warning] Checking table:   './asanyadb_sitedb/wp_TABLE_STATISTICS'
    2015-09-21 08:29:53 759323 [ERROR] /usr/sbin/mysqld: Table './asanyadb_sitedb/wp_TABLE_STATISTICS_RAW' is marked as crashed and should be repaired
    2015-09-21 08:29:53 759323 [Warning] Checking table:   './asanyadb_sitedb/wp_TABLE_STATISTICS_RAW'
    2015-09-21 08:29:53 759323 [ERROR] /usr/sbin/mysqld: Table './asanyadb_sitedb/wp_wfHits' is marked as crashed and should be repaired
    2015-09-21 08:29:53 759323 [Warning] Checking table:   './asanyadb_sitedb/wp_wfHits'
    2015-09-21 08:30:04 759323 [ERROR] /usr/sbin/mysqld: Table './abite_b/news_tmp' is marked as crashed and last (automatic?) repair failed
    2015-09-21 08:33:36 759323 [ERROR] /usr/sbin/mysqld: Table './dokan_shop/wp_options' is marked as crashed and should be repaired
    2015-09-21 08:33:36 759323 [Warning] Checking table:   './dokan_shop/wp_options'
    2015-09-21 12:30:04 759323 [ERROR] /usr/sbin/mysqld: Table './abite_b/news_tmp' is marked as crashed and last (automatic?) repair failed
    2015-09-21 16:30:03 759323 [ERROR] /usr/sbin/mysqld: Table './abite_b/news_tmp' is marked as crashed and last (automatic?) repair failed
    14:10:02 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=33554432
    read_buffer_size=131072
    max_used_connections=222
    max_threads=4000
    thread_count=56
    connection_count=55
    It is possible that mysqld could use up to
    key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1620143 K  bytes of memory
    Hope that's ok; if not, decrease some variables in the equation.
    
    Thread pointer: 0x4818c5c0
    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 = 7fa17d7b7e18 thread_stack 0x40000
    /usr/sbin/mysqld(my_print_stacktrace+0x35)[0x8e0985]
    /usr/sbin/mysqld(handle_fatal_signal+0x494)[0x6670c4]
    /lib64/libpthread.so.0(+0xf790)[0x7faeb3e96790]
    /usr/sbin/mysqld[0xab73c0]
    /usr/sbin/mysqld(_ZN17Query_cache_query16unlock_n_destroyEv+0x2c)[0x6a424c]
    /usr/sbin/mysqld(_ZN11Query_cache12move_by_typeEPPhPP17Query_cache_blockPmS3_+0x407)[0x6a7a67]
    /usr/sbin/mysqld(_ZN11Query_cache10pack_cacheEv+0x5d)[0x6a7fcd]
    /usr/sbin/mysqld(_ZN11Query_cache4packEmj+0x60)[0x6a80a0]
    /usr/sbin/mysqld(_Z20reload_acl_and_cacheP3THDmP10TABLE_LISTPi+0x445)[0x6fe705]
    /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x78a)[0x6e47ca]
    /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x443)[0x6e93e3]
    /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x149a)[0x6ea94a]
    /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0xcf)[0x6b589f]
    /usr/sbin/mysqld(handle_one_connection+0x52)[0x6b59d2]
    /usr/sbin/mysqld(pfs_spawn_thread+0x12a)[0xab92ca]
    /lib64/libpthread.so.0(+0x7a51)[0x7faeb3e8ea51]
    /lib64/libc.so.6(clone+0x6d)[0x7faeb2bf798d]
    
    Trying to get some variables.
    Some pointers may be invalid and cause the dump to abort.
    Query (7f9f5c0eacf0): FLUSH QUERY CACHE
    Connection ID (thread ID): 1521975
    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
    150921 18:41:08 mysqld_safe Number of processes running now: 0
    150921 18:41:08 mysqld_safe mysqld restarted
    2015-09-21 18:41:09 0 [Note] libgovernor.so found
    2015-09-21 18:41:09 0 [Note] All governors functions found too
    2015-09-21 18:41:09 0 [Note] Governor connected
    2015-09-21 18:41:09 0 [Note] All governors lve functions found too
    2015-09-21 18:41:09 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
    2015-09-21 18:41:09 0 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set
    2015-09-21 18:41:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-09-21 18:41:09 0 [Note] /usr/sbin/mysqld (mysqld 5.6.26-cll-lve) starting as process 868528 ...
    2015-09-21 18:41:10 868528 [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.
    2015-09-21 18:41:10 868528 [Note] Plugin 'FEDERATED' is disabled.
    2015-09-21 18:41:10 868528 [Warning] option 'innodb-buffer-pool-instances': signed value 36507222016 adjusted to 64
    2015-09-21 18:41:10 868528 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-09-21 18:41:10 868528 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-09-21 18:41:10 868528 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-09-21 18:41:10 868528 [Note] InnoDB: Memory barrier is not used
    2015-09-21 18:41:10 868528 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2015-09-21 18:41:10 868528 [Note] InnoDB: Using Linux native AIO
    2015-09-21 18:41:10 868528 [Note] InnoDB: Using CPU crc32 instructions
    2015-09-21 18:41:10 868528 [Note] InnoDB: Initializing buffer pool, size = 34.0G
    2015-09-21 18:41:12 868528 [Note] InnoDB: Completed initialization of buffer pool
    2015-09-21 18:41:13 868528 [Note] InnoDB: Highest supported file format is Barracuda.
    2015-09-21 18:41:13 868528 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1023787269208
    2015-09-21 18:41:13 868528 [Note] InnoDB: Database was not shutdown normally!
    2015-09-21 18:41:13 868528 [Note] InnoDB: Starting crash recovery.
    2015-09-21 18:41:13 868528 [Note] InnoDB: Reading tablespace information from the .ibd files...
    150921 18:41:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/
    2015-09-21 18:41:17 0 [Note] libgovernor.so found
    2015-09-21 18:41:17 0 [Note] All governors functions found too
    2015-09-21 18:41:17 0 [Note] Governor connected
    2015-09-21 18:41:17 0 [Note] All governors lve functions found too
    2015-09-21 18:41:17 0 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
    2015-09-21 18:41:17 0 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set
    2015-09-21 18:41:17 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2015-09-21 18:41:17 0 [Note] /usr/sbin/mysqld (mysqld 5.6.26-cll-lve) starting as process 869318 ...
    2015-09-21 18:41:17 869318 [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.
    2015-09-21 18:41:17 869318 [Note] Plugin 'FEDERATED' is disabled.
    2015-09-21 18:41:17 869318 [Warning] option 'innodb-buffer-pool-instances': signed value 36507222016 adjusted to 64
    2015-09-21 18:41:17 869318 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2015-09-21 18:41:17 869318 [Note] InnoDB: The InnoDB memory heap is disabled
    2015-09-21 18:41:17 869318 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2015-09-21 18:41:17 869318 [Note] InnoDB: Memory barrier is not used
    2015-09-21 18:41:17 869318 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2015-09-21 18:41:17 869318 [Note] InnoDB: Using Linux native AIO
    2015-09-21 18:41:17 869318 [Note] InnoDB: Using CPU crc32 instructions
    2015-09-21 18:41:17 869318 [Note] InnoDB: Initializing buffer pool, size = 34.0G
    2015-09-21 18:41:19 869318 [Note] InnoDB: Completed initialization of buffer pool
    2015-09-21 18:41:19 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:19 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:19 869318 [Note] InnoDB: Retrying to lock the first data file
    2015-09-21 18:41:20 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:20 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:21 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:21 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:22 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:22 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:23 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:23 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:24 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:24 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:25 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:25 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:26 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:26 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:27 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:27 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:28 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:28 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:29 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:29 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:30 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:30 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:31 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:31 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:32 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:32 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:33 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:33 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:34 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:34 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:35 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:35 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:36 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:36 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:37 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:37 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:38 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:38 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:39 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:39 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:40 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:40 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:41 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:41 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:42 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:42 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:44 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:44 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:45 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:45 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:46 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:46 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:47 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:47 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:48 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:48 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:49 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:49 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:50 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:50 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:51 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:51 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:52 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:52 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:53 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:53 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:54 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:54 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:55 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:55 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:56 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:56 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:57 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:57 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:58 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:58 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:41:59 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:41:59 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:00 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:00 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:01 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:01 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:02 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:02 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:03 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:03 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:04 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:04 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:05 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:05 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:06 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:06 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:07 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:07 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:08 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:08 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:09 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:09 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:10 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:10 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:11 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:11 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:12 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:12 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:13 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:13 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:14 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:14 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:15 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:15 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:16 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:16 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:17 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:17 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:18 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:18 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:20 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:20 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:21 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:21 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:22 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:22 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:23 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:23 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:24 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:24 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:25 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:25 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:26 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:26 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:27 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:27 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:28 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:28 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:29 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:29 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:30 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:30 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:31 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:31 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:32 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:32 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:33 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:33 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:34 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:34 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:35 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:35 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:36 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:36 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:37 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:37 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:38 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:38 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:39 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:39 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:40 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:40 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:41 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:41 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:42 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:42 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:43 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:43 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:44 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:45 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:46 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:46 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:47 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:47 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:48 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:48 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:49 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:49 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:50 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:50 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:51 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:51 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:52 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:52 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:53 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:53 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:54 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:54 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:55 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:55 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:56 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:56 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:57 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:57 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:58 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:58 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:42:59 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:42:59 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:43:00 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:43:00 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:43:01 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:43:01 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:43:02 869318 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
    2015-09-21 18:43:02 869318 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
    2015-09-21 18:43:02 869318 [Note] InnoDB: Unable to open the first data file
    2015-09-21 18:43:02 7f58017fc720  InnoDB: Operating system error number 11 in a file operation.
    InnoDB: Error number 11 means 'Resource temporarily unavailable'.
    InnoDB: Some operating system error numbers are described at
    InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
    2015-09-21 18:43:02 869318 [ERROR] InnoDB: Can't open './ibdata1'
    2015-09-21 18:43:02 869318 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
    2015-09-21 18:43:02 869318 [ERROR] Plugin 'InnoDB' init function returned error.
    2015-09-21 18:43:02 869318 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2015-09-21 18:43:02 869318 [ERROR] Unknown/unsupported storage engine: InnoDB
    2015-09-21 18:43:02 869318 [ERROR] Aborting
    
    MySQL Configuration :

    Code:
    [mysql]
    #port                           = 3306
    #socket                         = /var/lib/mysql/mysql.sock
    [mysqld]
    core-file
    #user                           = mysql
    innodb_lock_wait_timeout=2000
    default-storage-engine=InnoDB
    #socket                         = /var/lib/mysql/mysql.sock
    key-buffer-size=32M
    myisam-recover="FORCE,BACKUP"
    thread_concurrency=16
    max-allowed-packet=16M
    max-connect-errors=1000000
    datadir="/var/lib/mysql/"
    expire-logs-days=14
    sync-binlog=1
    tmp-table-size=32M
    max-heap-table-size=32M
    query-cache-type=1
    query-cache-size=16G
    max-connections=4000
    thread-cache-size=150
    open-files-limit=65535
    table-definition-cache=4096
    table-open-cache=1000
    innodb-flush-method=O_DIRECT
    innodb-log-files-in-group=2
    innodb-log-file-size           = 1G
    innodb-flush-log-at-trx-commit=1
    innodb-file-per-table=1
    innodb-buffer-pool-size=34G
    innodb_buffer_pool_instances=34G
    log-queries-not-using-indexes=1
    innodb_file_per_table=1
    max_allowed_packet=536870912
    open_files_limit=50000
    #max_user_connections=30
    [mysqld_safe]
    core-file-size = unlimited
    
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Do you have free space and inodes on this system? EX:

    Code:
    df -h
    df -i
    If so, you will need to review the following thread for information about repairing InnoDB:

    InnoDB Recovery Guide

    Thank you.
     
Loading...

Share This Page