Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: edur on September 12, 2017, 09:35:53 PM

Title: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: edur 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.

Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: studio4host 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

Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: edur 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

 :-\
Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: Administrator 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.
Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: edur 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/
Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: studio4host 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
Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: alikemalocalan 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


Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: studio4host 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 ?
Title: Re: Mysqld doesn't work. Message: [obfuscated](): (HY000/2002):
Post by: alikemalocalan on September 22, 2017, 04:33:38 PM
Ohh  ;D , thats's right .Yes it's thenks  ;) solved