Error connecting to database after restore accounts automatically.

mywhm

Active Member
Jan 15, 2014
39
2
58
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.
 

cPanelPeter

Senior Technical Analyst
Staff member
Sep 23, 2013
586
25
153
cPanel Access Level
Root Administrator
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.
 

mywhm

Active Member
Jan 15, 2014
39
2
58
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)
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.
 

mywhm

Active Member
Jan 15, 2014
39
2
58
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
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.