Announcement

Announcement Module
Collapse
No announcement yet.

Can't open file (errno: 24)

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Can't open file (errno: 24)

    Anyone knows what is going on with this error below.

    Thanks


    100625 8:21:26 [ERROR] /usr/sbin/mysqld: Can't open file: './search_20100625.frm' (errno: 24)
    100625 10:20:31 [ERROR] /usr/sbin/mysqld: Can't open file: './search_20100625.frm' (errno: 24)


    ulimit -n
    65536


    show global variables like '%open%';
    +------------------+----------+
    | Variable_name | Value |
    +------------------+----------+
    | have_openssl | DISABLED |
    | open_files_limit | 65536 |
    | table_open_cache | 4000 |
    +------------------+----------+


    [mysqld]
    skip-name-resolve
    safe-show-database
    back_log = 75
    skip-innodb
    max_connections = 8192
    key_buffer_size = 4096M
    myisam_sort_buffer_size = 128M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 4000
    thread_cache_size = 768
    wait_timeout = 20
    connect_timeout = 10
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max_allowed_packet = 64M
    net_buffer_length = 16384
    max_connect_errors = 10
    thread_concurrency = 8
    concurrent_insert = 2
    table_lock_wait_timeout = 30
    read_rnd_buffer_size = 1M
    bulk_insert_buffer_size = 8M
    query_cache_limit = 7M
    query_cache_size = 16M
    query_cache_type = 1
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = MyISAM
    max_write_lock_count = 16

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 64M

    [myisamchk]
    key_buffer = 4096M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M

  • #2
    Error 24 is too many open files -- you need to increase open_files_limit. You can find the meaning of error numbers with the 'perror' utility.

    Comment

    Working...
    X