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.

Error connecting to database after restore accounts automatically.

Discussion in 'Database Discussions' started by mywhm, Jan 15, 2014.

  1. mywhm

    mywhm Active Member

    Joined:
    Jan 15, 2014
    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hi everyone.

    I searched about my problem in cpanel forums, I could not find the solution.

    My vps features are:

    VPS 2 - Xen
    Disk: 60 GB RAID Protected
    Bandwidth : 500 GB
    RAM / Memory: 2048 MB (+2048 MB Burst)
    CPU Cores: 2
    Operating System Centos.
    Company: Namecheap

    This is my.cnf configuration:

    Code:
    query_cache_size=50M
    query_cache_limit=1M
    
    innodb_buffer_pool_size=400M
    
    tmp_table_size=50M
    max_heap_table_size=50M
    join_buffer_size=1M
    read_rnd_buffer_size=2M
    
    slow_query_log=1
    slow_query_log_file=mysql-slow.log
    long_query_time=0.1
    My mysqltuner:
    Code:
    [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
    ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/#sql_5860_0.MYD' (Errcode: 24)
    ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/#sql_5860_0.MYD' (Errcode: 24)
    [!!] InnoDB is enabled but isn't being used
    Argument "" isn't numeric in numeric gt (>) at /usr/local/cpanel/bin/mysqltuner.pl line 698.
    [OK] Total fragmented tables:
    ERROR 23 (HY000) at line 1: Out of resources when opening file '/tmp/#sql_5860_0.MYD' (Errcode: 24)
    Argument "" isn't numeric in numeric eq (==) at /usr/local/cpanel/bin/mysqltuner.pl line 763.
    
    -------- Performance Metrics -------------------------------------------------
    [--] Up for: 4m 46s (179 q [0.626 qps], 15 conn, TX: 289K, RX: 41K)
    [--] Reads / Writes: 74% / 26%
    [--] Total buffers: 524.0M global + 5.4M per thread (151 max threads)
    [OK] Maximum possible memory usage: 1.3G (71% of installed RAM)
    [OK] Slow queries: 0% (1/179)
    [OK] Highest usage of available connections: 1% (2/151)
    [!!] Cannot calculate MyISAM index size - re-run script as root user
    [!!] Query cache efficiency: 15.6% (12 cached / 77 selects)
    [OK] Query cache prunes per day: 0
    [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 27 sorts)
    [!!] Joins performed without indexes: 3
    [OK] Temporary tables created on disk: 3% (2 on disk / 59 total)
    [!!] Thread cache is disabled
    [OK] Table cache hit rate: 93% (93 open / 100 opened)
    [OK] Open file limit used: 14% (148/1K)
    [OK] Table locks acquired immediately: 100% (263 immediate / 263 locks)
    [!!] Connections aborted: 6%
    
    The problem is, I have 35 small joomlas has very little traffic. When entering the website of one of my clients, I get this error:

    Can't open file: './databctaxi_aleport/zlmzn_session.frm' (errno: 24) SQL=INSERT INTO `zlmzn_session` (`session_id`, `client_id`, `time`) VALUES ('9aaca5ce05738ccaae8766be7bf6b069', 0, '1388065914')

    Other:

    Can't open file: './legadbdez_zetafin/hqjc8_session.frm' (errno: 24) SQL=INSERT INTO `hqjc8_session` (`session_id`, `client_id`, `time`) VALUES ('ab79945b37e6f3584152aff208fa2c15', 0, '1389727890')

    The momentary solution is to restore the mysql server.

    After 30 minutes or an hour, I get the error again, I have to restart mysql another time.


    Important: I use siteautobackup.com for backup my accounts, then download my backups on my vps and all my backup restored automatically with this command:

    for i in `ls /home/*.tar.gz`;do /scripts/restorepkg --force $i;done

    What could be done to fix this problem, I hope your answer.

    I'm grateful for your assistance.

    Sorry for my bad English.
     
  2. cPanelPeter

    cPanelPeter Technical Analyst III
    Staff Member

    Joined:
    Sep 23, 2013
    Messages:
    569
    Likes Received:
    15
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Looking at the log file you provided, it looks like those are just corrupted databases and should not effect the operation of MySQL in general. I doubt restarting MySQL is fixing anything. You should see about getting those databases fixed.

    Review the rest of the MySQL error log file (/var/lib/mysql/$HOSTNAME.err) for other issues.
     
  3. mywhm

    mywhm Active Member

    Joined:
    Jan 15, 2014
    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    thanks for your reply.

    I got this message on my myhostaname.err file:

    Code:
    140115 16:31:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:31:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:31:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:31:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:31:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:32:31 [ERROR] /usr/sbin/mysqld: Can't open file: './derecho_fin/iyl0b_session.frm' (errno: 24)
    140115 16:32:31 [ERROR] /usr/sbin/mysqld: Can't open file: './derecho_fin/iyl0b_session.frm' (errno: 24)
    140115 16:32:31 [ERROR] /usr/sbin/mysqld: Can't open file: './derecho_fin/iyl0b_session.frm' (errno: 24)
    140115 16:32:31 [ERROR] /usr/sbin/mysqld: Can't open file: './derecho_fin/iyl0b_session.frm' (errno: 24)
    140115 16:32:31 [ERROR] /usr/sbin/mysqld: Can't open file: './derecho_fin/iyl0b_session.frm' (errno: 24)
    140115 16:32:32 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_fra/jos_session.frm' (errno: 24)
    140115 16:32:32 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_fra/jos_session.frm' (errno: 24)
    140115 16:32:32 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_fra/jos_session.frm' (errno: 24)
    140115 16:32:32 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_fra/jos_session.frm' (errno: 24)
    140115 16:32:32 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_fra/jos_session.frm' (errno: 24)
    140115 16:32:46 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24)
    140115 16:32:46 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.frm' (errno: 24)
    140115 16:35:00 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:35:00 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:35:00 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:35:00 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:35:00 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:35:23 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_es/jos_session.frm' (errno: 24)
    140115 16:35:23 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_es/jos_session.frm' (errno: 24)
    140115 16:35:23 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_es/jos_session.frm' (errno: 24)
    140115 16:35:23 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_es/jos_session.frm' (errno: 24)
    140115 16:35:23 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_es/jos_session.frm' (errno: 24)
    140115 16:36:32 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:36:32 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:36:32 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:36:32 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:36:32 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:37:03 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:37:03 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:37:03 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:37:03 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:37:03 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:37:04 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/user.frm' (errno: 24)
    140115 16:37:21 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:37:21 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:37:21 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:37:21 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:37:21 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:38:45 [ERROR] /usr/sbin/mysqld: Can't open file: './keroshos_ing/d5v9u_session.frm' (errno: 24)
    140115 16:38:45 [ERROR] /usr/sbin/mysqld: Can't open file: './keroshos_ing/d5v9u_session.frm' (errno: 24)
    140115 16:38:45 [ERROR] /usr/sbin/mysqld: Can't open file: './keroshos_ing/d5v9u_session.frm' (errno: 24)
    140115 16:38:45 [ERROR] /usr/sbin/mysqld: Can't open file: './keroshos_ing/d5v9u_session.frm' (errno: 24)
    140115 16:38:45 [ERROR] /usr/sbin/mysqld: Can't open file: './keroshos_ing/d5v9u_session.frm' (errno: 24)
    140115 16:39:10 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:39:10 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:39:10 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:39:10 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:40:31 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:40:31 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:40:31 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:40:31 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:40:31 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './proycons_silver/zz39l_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './proycons_silver/zz39l_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './proycons_silver/zz39l_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './proycons_silver/zz39l_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './proycons_silver/zz39l_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './choicepe_choice/jos_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './choicepe_choice/jos_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './choicepe_choice/jos_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './choicepe_choice/jos_session.frm' (errno: 24)
    140115 16:40:43 [ERROR] /usr/sbin/mysqld: Can't open file: './choicepe_choice/jos_session.frm' (errno: 24)
    140115 16:40:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:40:47 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:41:35 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/smtp.frm' (errno: 24)
    140115 16:41:35 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/smtp.frm' (errno: 24)
    140115 16:41:35 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24)
    140115 16:41:35 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.frm' (errno: 24)
    140115 16:41:35 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures.frm' (errno: 24)
    140115 16:42:14 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:42:14 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:42:14 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:42:14 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:42:14 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:42:58 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:42:58 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:42:58 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:42:58 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:42:58 [ERROR] /usr/sbin/mysqld: Can't open file: './yogalima_yogafin/jos_session.frm' (errno: 24)
    140115 16:43:03 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:43:03 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:43:03 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:43:03 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:43:03 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:43:06 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/user.frm' (errno: 24)
    140115 16:43:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:43:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:43:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:43:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:43:45 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:44:13 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:44:13 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:44:13 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:44:13 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:44:13 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:45:25 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:25 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:25 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:25 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:25 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:58 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:58 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:58 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:58 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:45:58 [ERROR] /usr/sbin/mysqld: Can't open file: './andesadv_andes/jos_session.frm' (errno: 24)
    140115 16:48:19 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:48:19 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:48:19 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:48:19 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:48:19 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:49:12 [ERROR] /usr/sbin/mysqld: Can't open file: './mysql/user.frm' (errno: 24)
    140115 16:49:49 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:49:49 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:49:49 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:49:49 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:49:49 [ERROR] /usr/sbin/mysqld: Can't open file: './munay_esp/jos_session.frm' (errno: 24)
    140115 16:49:58 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:49:58 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:49:58 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:49:58 [ERROR] /usr/sbin/mysqld: Can't open file: './south_corosfis/azfdt_session.frm' (errno: 24)
    140115 16:51:06 [ERROR] /usr/sbin/mysqld: Can't open file: './aparthot_sinvirus/jos_session.frm' (errno: 24)
    140115 16:51:06 [ERROR] /usr/sbin/mysqld: Can't open file: './aparthot_sinvirus/jos_session.frm' (errno: 24)
    140115 16:51:06 [ERROR] /usr/sbin/mysqld: Can't open file: './aparthot_sinvirus/jos_session.frm' (errno: 24)
    140115 16:51:06 [ERROR] /usr/sbin/mysqld: Can't open file: './aparthot_sinvirus/jos_session.frm' (errno: 24)
    140115 16:51:06 [ERROR] /usr/sbin/mysqld: Can't open file: './aparthot_sinvirus/jos_session.frm' (errno: 24)
    140115 16:52:25 [ERROR] /usr/sbin/mysqld: Can't open file: './veggiepe_avance/jos_session.frm' (errno: 24)
    140115 16:52:25 [ERROR] /usr/sbin/mysqld: Can't open file: './veggiepe_avance/jos_session.frm' (errno: 24)
    140115 16:52:25 [ERROR] /usr/sbin/mysqld: Can't open file: './veggiepe_avance/jos_session.frm' (errno: 24)
    140115 16:52:25 [ERROR] /usr/sbin/mysqld: Can't open file: './veggiepe_avance/jos_session.frm' (errno: 24)
    140115 16:52:25 [ERROR] /usr/sbin/mysqld: Can't open file: './veggiepe_avance/jos_session.frm' (errno: 24)
    140115 16:52:48 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:52:48 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:52:48 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:52:48 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:53:47 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:53:47 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:53:47 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:53:47 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:53:47 [ERROR] /usr/sbin/mysqld: Can't open file: './perezdez_zetafin/hqjc8_session.frm' (errno: 24)
    140115 16:54:04 [Note] /usr/sbin/mysqld: Normal shutdown
    
    140115 16:54:04 [Note] Event Scheduler: Purging the queue. 0 events
    140115 16:54:06 [Warning] /usr/sbin/mysqld: Forcing close of thread 821  user: 'leechprotect'
    
    140115 16:54:06 [Warning] /usr/sbin/mysqld: Forcing close of thread 3  user: 'eximstats'
    
    140115 16:54:06  InnoDB: Starting shutdown...
    140115 16:54:08  InnoDB: Shutdown completed; log sequence number 61523550
    140115 16:54:08 [Note] /usr/sbin/mysqld: Shutdown complete
    
    140115 16:54:08 mysqld_safe mysqld from pid file /var/lib/mysql/server1.mydomain.com.pid ended
    140115 16:54:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    140115 16:54:09 [Note] Plugin 'FEDERATED' is disabled.
    140115 16:54:09 InnoDB: The InnoDB memory heap is disabled
    140115 16:54:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    140115 16:54:09 InnoDB: Compressed tables use zlib 1.2.3
    140115 16:54:09 InnoDB: Using Linux native AIO
    140115 16:54:09 InnoDB: Initializing buffer pool, size = 400.0M
    140115 16:54:09 InnoDB: Completed initialization of buffer pool
    140115 16:54:09 InnoDB: highest supported file format is Barracuda.
    140115 16:54:09  InnoDB: Waiting for the background threads to start
    140115 16:54:10 InnoDB: 5.5.34 started; log sequence number 61523550
    140115 16:54:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    140115 16:54:10 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    140115 16:54:10 [Note] Server socket created on IP: '0.0.0.0'.
    140115 16:54:10 [Note] Event Scheduler: Loaded 0 events
    140115 16:54:10 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.34-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
    
     
  4. 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 :)

    The logs you provided indicate MySQL is reaching it's open files limit. Try increasing the open files limit by adding the following value to your /etc/my.cnf file:

    Code:
    open_files_limit = 100000
    Then, restart MySQL to ensure the changes are enabled. Note that I use the value "100000" in the example. You should likely modify this to a value suited to your server after verifying it resolves the issue.

    Thank you.
     
  5. mywhm

    mywhm Active Member

    Joined:
    Jan 15, 2014
    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hello.

    After 24 hours I'm back to confirm that I no get the error message from mysql.

    Questions, there is some script to monitor mysql connection, if falls the connection, then
    send an email notification .

    as does the service of host-tracker.com and pingdom.com, monitoring the http protocol.

    A million thanks, I Appreciate it

    You are the best.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You could enable monitoring for MySQL via:

    "WHM Home » Service Configuration » Service Manager"

    This will monitor MySQL and restart it automatically if it's determined to have failed.

    Thank you.
     
Loading...

Share This Page