Author Topic: can't start mysqld  (Read 6620 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
can't start mysqld
« 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?

Offline
***
Re: can't start mysqld
« Reply #1 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`.



8==D it's a function that try to compare 8 (int) against D (string) and not ALWAYS does return false.

Offline
*
Re: can't start mysqld
« Reply #2 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

Offline
*
Re: can't start mysqld
« Reply #3 on: October 06, 2014, 07:38:35 AM »
solved after removing some folders and file, thanks for the help  ;)

Offline
***
Re: can't start mysqld
« Reply #4 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
8==D it's a function that try to compare 8 (int) against D (string) and not ALWAYS does return false.

Offline
*
Re: can't start mysqld
« Reply #5 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...

Offline
*
Re: can't start mysqld
« Reply #6 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

Offline
*
Re: can't start mysqld
« Reply #7 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?
/var/www/home.ro

Offline
*
Re: can't start mysqld
« Reply #8 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
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: can't start mysqld
« Reply #9 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
« Last Edit: July 20, 2016, 08:43:39 AM by locvfx »