MySql Status "ON", But All Website "DOWN"

SufaNet · Oct 23, 2014

[Help]
MySql Status "ON", But All Website "DOWN"
When I access my website, Error shows that MySqli Script CANNOT Established the DATABASE!
This can be resolved by restarting mysql from WHM. It makes me tired, anyway.
Would you tell me where can I access "ERROR_LOG" in my WHM cPanel, I can't find "LOG" File for the error.

cat /var/log/mysql.log
cat: /var/log/mysql.log: No such file or directory

GNU nano 2.0.9 File: /etc/my.cnf
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456

Please Help, thanks

cPanelMichael · Oct 23, 2014

Hello

The MySQL error log is located at:

/var/lib/mysql/$hostname.err

Replace "$hostname" with the actual hostname of your server. Note the error message you referenced shows "MySQLi". Have you verified that MySQLi was installed through EasyApache?

Thank you.

SufaNet · Oct 23, 2014

cPanelMichael said:
Hello

The MySQL error log is located at:

/var/lib/mysql/$hostname.err

Replace "$hostname" with the actual hostname of your server. Note the error message you referenced shows "MySQLi". Have you verified that MySQLi was installed through EasyApache?

Thank you.

How to check the error? And how to resolve?

cPanelMichael · Oct 23, 2014

Try reviewing that error log when MySQL restarts to see if you notice any particular error messages. Also, have you checked to see if MySQL is running (e.g. using the "mysql" command)?

Thank you.

SufaNet · Oct 23, 2014

hello, this is the error :

Code:

141024  0:55:35 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  0:55:36 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  0:55:37 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  0:55:40 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms1.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms2.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms3.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms4.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms5.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms6.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms7.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms8.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms9.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsa.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsb.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsc.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsd.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termse.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsf.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_taxonomy.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_taxonomy_map.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_terms.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_terms_common.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_tokens.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_tokens_aggregate.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_types.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_languages.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_menu.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_menu_types.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_messages.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_messages_cfg.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_modules.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_modules_menu.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_newsfeeds.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_overrider.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_redirect_links.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_schemas.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_session.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_solusvm_vps.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_template_styles.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_update_categories.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_update_sites.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_update_sites_extensions.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_updates.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_user_notes.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_user_profiles.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_user_usergroup_map.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_usergroups.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_users.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_viewlevels.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_weblinks.frm' (errno: 24)
141024  5:10:10 [ERROR] /usr/sbin/mysqld: Can't open file: './sdn02jiw_jiwan/f0bpti_jabatan.frm' (errno: 24)
141024  5:13:42 [ERROR] /usr/sbin/mysqld: Can't open file: './sdn02jiw_jiwan/f0bpti_pengumuman.frm' (errno: 24)
141024  5:13:42 [ERROR] /usr/sbin/mysqld: Can't open file: './sdn02jiw_jiwan/f0bpti_agenda.frm' (errno: 24)
141024  5:15:01 [ERROR] Error in accept: Too many open files
141024  5:19:17 [ERROR] Error in accept: Too many open files
141024  5:23:33 [ERROR] Error in accept: Too many open files
141024  5:27:49 [ERROR] Error in accept: Too many open files
141024  5:32:05 [ERROR] Error in accept: Too many open files
141024  5:36:21 [ERROR] Error in accept: Too many open files
141024  5:40:37 [ERROR] Error in accept: Too many open files
141024  5:44:53 [ERROR] Error in accept: Too many open files
141024  5:49:09 [ERROR] Error in accept: Too many open files
141024  5:53:25 [ERROR] Error in accept: Too many open files
141024  5:57:41 [ERROR] Error in accept: Too many open files
141024  6:01:57 [ERROR] Error in accept: Too many open files
141024  6:06:13 [ERROR] Error in accept: Too many open files
141024  6:10:29 [ERROR] Error in accept: Too many open files
141024  6:14:45 [ERROR] Error in accept: Too many open files
141024  6:19:01 [ERROR] Error in accept: Too many open files
141024  6:23:17 [ERROR] Error in accept: Too many open files
141024  6:27:33 [ERROR] Error in accept: Too many open files
141024  6:31:49 [ERROR] Error in accept: Too many open files
141024  6:36:05 [ERROR] Error in accept: Too many open files
141024  6:40:21 [ERROR] Error in accept: Too many open files
141024  6:44:38 [ERROR] Error in accept: Too many open files
141024  6:48:54 [ERROR] Error in accept: Too many open files
141024  6:53:10 [ERROR] Error in accept: Too many open files
141024  6:57:26 [ERROR] Error in accept: Too many open files
141024  7:01:42 [ERROR] Error in accept: Too many open files
141024  7:05:58 [ERROR] Error in accept: Too many open files
141024  7:10:14 [ERROR] Error in accept: Too many open files
141024  7:14:30 [ERROR] Error in accept: Too many open files
141024  7:18:46 [ERROR] Error in accept: Too many open files
141024  7:23:02 [ERROR] Error in accept: Too many open files
141024  7:27:18 [ERROR] Error in accept: Too many open files
141024  7:31:34 [ERROR] Error in accept: Too many open files
141024  7:35:50 [ERROR] Error in accept: Too many open files
141024  7:40:06 [ERROR] Error in accept: Too many open files
141024  7:44:22 [ERROR] Error in accept: Too many open files
141024  7:48:38 [ERROR] Error in accept: Too many open files
141024  7:52:54 [ERROR] Error in accept: Too many open files
141024  7:57:10 [ERROR] Error in accept: Too many open files
141024  8:01:26 [ERROR] Error in accept: Too many open files
141024  8:05:42 [ERROR] Error in accept: Too many open files
141024  8:09:58 [ERROR] Error in accept: Too many open files
141024  8:14:14 [ERROR] Error in accept: Too many open files
141024  8:18:30 [ERROR] Error in accept: Too many open files
141024  8:22:46 [ERROR] Error in accept: Too many open files
141024  8:27:02 [ERROR] Error in accept: Too many open files
141024  8:31:18 [ERROR] Error in accept: Too many open files
141024  8:35:34 [ERROR] Error in accept: Too many open files
141024  8:39:50 [ERROR] Error in accept: Too many open files
141024  8:44:06 [ERROR] Error in accept: Too many open files
141024  8:48:22 [ERROR] Error in accept: Too many open files
141024  8:52:38 [ERROR] Error in accept: Too many open files
141024  8:56:54 [ERROR] Error in accept: Too many open files
141024  9:01:10 [ERROR] Error in accept: Too many open files
141024  9:05:26 [ERROR] Error in accept: Too many open files
141024  9:09:42 [ERROR] Error in accept: Too many open files
[email protected] [~]#

i try to restart from console now up again, but it can down again some time.

this is log after i restart mysql :

Code:

141024  8:56:54 [ERROR] Error in accept: Too many open files
141024  9:01:10 [ERROR] Error in accept: Too many open files
141024  9:05:26 [ERROR] Error in accept: Too many open files
141024  9:09:42 [ERROR] Error in accept: Too many open files
141024  9:14:20 [Note] /usr/sbin/mysqld: Normal shutdown

141024  9:14:20 [Note] Event Scheduler: Purging the queue. 0 events
141024  9:14:22 [Warning] /usr/sbin/mysqld: Forcing close of thread 1672  user: 'leechprotect'

141024  9:14:22  InnoDB: Starting shutdown...
141024  9:14:24  InnoDB: Shutdown completed; log sequence number 62739999
141024  9:14:24 [Note] /usr/sbin/mysqld: Shutdown complete

141024 09:14:24 mysqld_safe mysqld from pid file /var/lib/mysql/iix1.sufanet.com.pid ended
141024 09:14:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141024  9:14:24 [Note] Plugin 'FEDERATED' is disabled.
141024  9:14:24 InnoDB: The InnoDB memory heap is disabled
141024  9:14:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141024  9:14:24 InnoDB: Compressed tables use zlib 1.2.3
141024  9:14:24 InnoDB: Using Linux native AIO
141024  9:14:24 InnoDB: Initializing buffer pool, size = 128.0M
141024  9:14:24 InnoDB: Completed initialization of buffer pool
141024  9:14:24 InnoDB: highest supported file format is Barracuda.
141024  9:14:25  InnoDB: Waiting for the background threads to start
141024  9:14:26 InnoDB: 5.5.37 started; log sequence number 62739999
141024  9:14:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141024  9:14:26 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141024  9:14:26 [Note] Server socket created on IP: '0.0.0.0'.
141024  9:14:26 [Note] /usr/sbin/mysqld: Normal shutdown

141024  9:14:26 [Note] Event Scheduler: Loaded 0 events
141024  9:14:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141024  9:14:26 [Note] Event Scheduler: Purging the queue. 0 events
141024  9:14:26  InnoDB: Starting shutdown...
141024  9:14:27  InnoDB: Shutdown completed; log sequence number 62739999
141024  9:14:27 [Note] /usr/sbin/mysqld: Shutdown complete

141024 09:14:27 mysqld_safe mysqld from pid file /var/lib/mysql/iix1.sufanet.com.pid ended
141024 09:14:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141024  9:14:28 [Note] Plugin 'FEDERATED' is disabled.
141024  9:14:28 InnoDB: The InnoDB memory heap is disabled
141024  9:14:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141024  9:14:28 InnoDB: Compressed tables use zlib 1.2.3
141024  9:14:28 InnoDB: Using Linux native AIO
141024  9:14:28 InnoDB: Initializing buffer pool, size = 128.0M
141024  9:14:28 InnoDB: Completed initialization of buffer pool
141024  9:14:28 InnoDB: highest supported file format is Barracuda.
141024  9:14:28  InnoDB: Waiting for the background threads to start
141024  9:14:29 InnoDB: 5.5.37 started; log sequence number 62739999
141024  9:14:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141024  9:14:29 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141024  9:14:29 [Note] Server socket created on IP: '0.0.0.0'.
141024  9:14:29 [Note] Event Scheduler: Loaded 0 events
141024  9:14:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
[email protected] [~]#

where is the problem?

dalem · Oct 24, 2014

Error in accept: Too many open files

(errno: 24)

How to Fix an (errno: 24) in MySQL | solomonson.com

Thread starter	Similar threads	Forum	Replies	Date
G	Account Creation Status: failed, failed to determine the mysqld version google cloud	Databases	1	Mar 5, 2022
	systemctl start mariadb error but systemctl status mysql running	Databases	1	Jul 21, 2020
	Changed MySQL root pw, Service Status: down (but it isn't)	Databases	6	Oct 25, 2018
S	MySQL Error in WHM Service Status Daily Process Log	Databases	2	Jun 28, 2018
N	Service Status MySQL	Databases	4	Feb 6, 2018

Search

Search

MySql Status "ON", But All Website "DOWN"

SufaNet

Registered

cPanelMichael

Administrator

SufaNet

Registered

cPanelMichael

Administrator

SufaNet

Registered

dalem

Well-Known Member