Author Topic: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):  (Read 9932 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« on: September 12, 2017, 09:35:53 PM »

Hi

I have a fresh install of CWP7 in a Centos 7 VPS. I have only a wordpress install there.

Every day my blog is down, the mysql doesn't work. So I go to my centos panel, and I find this message:

"Warning: [obfuscated](): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/user/index.php on line 0"

After a few seconds the CWP works again and the wordpress run again.

Whats happen !!??


* In my Chkconfig manager I have only two services: netconsole, network.


Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #1 on: September 13, 2017, 08:47:50 AM »
in centos 7 you need to use systemd manager and NOT chkconfig.
For mysql issue you should check mysql logs in folder /var/lib/mysql/  filename is usually named as hostname.err

VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #2 on: September 13, 2017, 02:52:11 PM »
in centos 7 you need to use systemd manager and NOT chkconfig.
For mysql issue you should check mysql logs in folder /var/lib/mysql/  filename is usually named as hostname.err

Thanks for your time studio4host, but there I have not any file .err

 :-\

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #3 on: September 14, 2017, 07:26:55 AM »
then you need to check where your mysql logs are located and check there...you can also try to check /var/log/ or try to check if the logs are configured in configuration.
AntiDDoS Protection (web + mail)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #4 on: September 19, 2017, 02:10:50 PM »
How can I  check if the logs are configured in configuration ?

I don't find any log about mysql in /var/log/

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #5 on: September 21, 2017, 01:02:58 PM »
depending on your mysql version you need to google this for mysql or mariadb

check mysql version
Code: [Select]
mysql --version
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #6 on: September 21, 2017, 06:40:13 PM »
I am using centos 6 and ı have this problem today?

Code: [Select]
# mysql --version

mysql  Ver 14.14 Distrib 5.5.53, for Linux (x86_64) using readline 5.1

Code: [Select]
cat /var/log/mysqld.log

170921 21:44:32 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
170921 21:44:32 [ERROR] Can't start server: can't create PID file: No space left on device
170921 21:44:33 mysqld_safe Number of processes running now: 0
170921 21:44:33 mysqld_safe mysqld restarted
170921 21:44:33 [Note] /usr/libexec/mysqld (mysqld 5.5.53) starting as process 11361 ...
170921 21:44:33 [Note] Plugin 'FEDERATED' is disabled.
170921 21:44:33 InnoDB: The InnoDB memory heap is disabled
170921 21:44:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170921 21:44:33 InnoDB: Compressed tables use zlib 1.2.3
170921 21:44:33 InnoDB: Using Linux native AIO
170921 21:44:33 InnoDB: Initializing buffer pool, size = 128.0M
170921 21:44:33 InnoDB: Completed initialization of buffer pool
170921 21:44:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
170921 21:44:33  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the 170921 21:44:34 mysqld_safe Number of processes running now: 0
170921 21:44:34 mysqld_safe mysqld restarted
170921 21:44:34 [Note] /usr/libexec/mysqld (mysqld 5.5.53) starting as process 11394 ...
170921 21:44:34 [Note] Plugin 'FEDERATED' is disabled.
170921 21:44:34 InnoDB: The InnoDB memory heap is disabled
170921 21:44:34 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170921 21:44:34 InnoDB: Compressed tables use zlib 1.2.3
170921 21:44:34 InnoDB: Using Linux native AIO
170921 21:44:34 InnoDB: Initializing buffer pool, size = 128.0M
170921 21:44:34 InnoDB: Completed initialization of buffer pool
170921 21:44:34 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
170921 21:44:34  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
170921 21:44:34  InnoDB: Waiting for the background threads to start
170921 21:44:35 InnoDB: 5.5.53 started; log sequence number 551980342
170921 21:44:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
170921 21:44:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
170921 21:44:35 [Note] Server socket created on IP: '0.0.0.0'.
170921 21:44:35 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
170921 21:44:35 [ERROR] Can't start server: can't create PID file: No space left on device
170921 21:44:35 mysqld_safe Number of processes running now: 0
170921 21:44:35 mysqld_safe mysqld restarted
170921 21:44:35 [Note] /usr/libexec/mysqld (mysqld 5.5.53) starting as process 11426 ...
170921 21:44:35 [Note] Plugin 'FEDERATED' is disabled.
170921 21:44:35 InnoDB: The InnoDB memory heap is disabled
170921 21:44:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170921 21:44:35 InnoDB: Compressed tables use zlib 1.2.3
170921 21:44:35 InnoDB: Using Linux native AIO
170921 21:44:35 InnoDB: Initializing buffer pool, size = 128.0M
170921 21:44:35 InnoDB: Completed initialization of buffer pool
170921 21:44:35 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
170921 21:44:35  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
170921 21:44:35  InnoDB: Waiting for the background threads to start


« Last Edit: September 21, 2017, 06:46:51 PM by alikemalocalan »

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #7 on: September 22, 2017, 12:30:07 PM »
170921 21:44:35 [ERROR] Can't start server: can't create PID file: No space left on device

is your disk full ?
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
« Reply #8 on: September 22, 2017, 04:33:38 PM »
Ohh  ;D , thats's right .Yes it's thenks  ;) solved