Control Web Panel

WebPanel => MySQL => Topic started by: ereo on October 06, 2014, 05:59:20 AM

Title: can't start mysqld
Post by: ereo on October 06, 2014, 05:59:20 AM
hello
today i've got trouble with mysql, i can't login because trouble with mysql, the browser give me notification

Quote
mysqld is stopped

Trying to start mysql server, please reload browser!

Could not connect: No such file or directory

how to fix it?
Title: Re: can't start mysqld
Post by: erm3nda on October 06, 2014, 06:11:30 AM
You didn't supply ANY info about your server details nor log info, so it's difficult to help you.

If mysql do not work, this may be a problem from installation. Is this the first time?

You can try restart whole cwp service by command `service cwpsrv restart` or only mysql by command `service mysql restart` or `/etc/init.d/mysqld restart`.

If not, try to reinstall mysql server using command `yum reinstall mysql-server`.



Title: Re: can't start mysqld
Post by: ereo on October 06, 2014, 06:27:25 AM
after checking with tail,
Quote
tail -n 30 /var/log/mysqld.log

it tell's me
Quote
141006 12:54:47 mysqld_safe mysqld restarted
141006 12:54:47 mysqld_safe Number of processes running now: 0
141006 12:54:47 mysqld_safe mysqld restarted
141006 12:54:47  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:47  InnoDB: Completed initialization of buffer pool
141006 12:54:48  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:48  InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
141006 12:54:48  InnoDB: Retrying to lock the first data file
141006 12:54:48  InnoDB: Started; log sequence number 0 103960
141006 12:54:48 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left on device
141006 12:54:48 mysqld_safe Number of processes running now: 1
141006 12:54:48 mysqld_safe mysqld process hanging, pid 23371 - killed
141006 12:54:48 mysqld_safe mysqld restarted
141006 12:54:48 mysqld_safe Number of processes running now: 0
141006 12:54:48 mysqld_safe mysqld restarted
141006 12:54:48  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:48  InnoDB: Completed initialization of buffer pool
141006 12:54:48  InnoDB: Initializing buffer pool, size = 8.0M
141006 12:54:48  InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
141006 12:54:48  InnoDB: Retrying to lock the first data file
141006 12:54:48  InnoDB: Started; log sequence number 0 103960
141006 12:54:48 [ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left
Title: Re: can't start mysqld
Post by: ereo on October 06, 2014, 07:38:35 AM
solved after removing some folders and file, thanks for the help  ;)
Title: Re: can't start mysqld
Post by: erm3nda on October 15, 2014, 02:38:29 AM
Glad to know i forced you to use logs  ::)

Quote
141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left
Title: Re: can't start mysqld
Post by: MarceloMG on October 07, 2015, 08:32:48 PM
solved after removing some folders and file, thanks for the help  ;)

Hi, which folders you remove? I have the same problem...
Title: Re: can't start mysqld
Post by: chatig89 on July 07, 2016, 02:46:20 PM
solved after removing some folders and file, thanks for the help  ;)

Can you tell me which folders you remove? same problem
Title: Re: can't start mysqld
Post by: LiXuS on July 10, 2016, 03:35:30 PM
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_hosting-lv_root
                       50G   47G     0 100% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sda2             477M  198M  255M  44% /boot
/dev/sda1             200M  268K  200M   1% /boot/efi
/dev/mapper/vg_hosting-lv_home
                      864G   37G  784G   5% /home


wich folder or file can i del?
Title: Re: can't start mysqld
Post by: Administrator on July 10, 2016, 07:56:12 PM
probably the best for start would be to check server logs in /var/log and /usr/local/apache/logs
Title: Re: can't start mysqld
Post by: locvfx on July 20, 2016, 08:41:38 AM
solved after removing some folders and file, thanks for the help  ;)

Can you tell me which folders you remove? same problem

I guess you ran out of disk space
You can delete all unused log files or root's email. It happened to me after few months of using

du --max-depth=1 -h /   : List folder size
find / -type f -size +100M   : Find files with the size above 100MB
ls -1 -sh   : list folder and file
du -msh Folder_Name   : Get size of a  folder