Control Web Panel
WebPanel => MySQL => Topic started 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
mysqld is stopped
Trying to start mysql server, please reload browser!
Could not connect: No such file or directory
how to fix it?
-
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`.
-
after checking with tail,
tail -n 30 /var/log/mysqld.log
it tell's me
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
-
solved after removing some folders and file, thanks for the help ;)
-
Glad to know i forced you to use logs ::)
141006 12:54:48 [ERROR] Can't start server: can't create PID file: No space left
-
solved after removing some folders and file, thanks for the help ;)
Hi, which folders you remove? I have the same problem...
-
solved after removing some folders and file, thanks for the help ;)
Can you tell me which folders you remove? same problem
-
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?
-
probably the best for start would be to check server logs in /var/log and /usr/local/apache/logs
-
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