Error connecting to database after restore accounts automatically.
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:
My mysqltuner:
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.
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:
[--] 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.
-
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. 0 -
thanks for your reply. I got this message on my myhostaname.err file: 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)
0 -
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: 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.0 -
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. 0 -
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. 0
Please sign in to leave a comment.
Comments
5 comments