A case of MySQL startup error

Issue: Apache does not start, check log records below, check disk space and Inode is OK

[Tue 20 18:10:48 2014] [Notice] suexec mechanism enabled (wrapper:/usr/sbin/suexec)

[Tue 20 18:10:48 2014] [Warn] module wsgi_module is already loaded, skipping

[Tue 20 18:10:48 2014] [Warn] module wsgi_module is already loaded, skipping

[Tue 20 18:10:48 2014] [Notice] Digest:generating Secret for Digest authentication ...

[Tue 20 18:10:48 2014] [Notice] Digest:done

[Tue 20 18:10:48 2014] [Notice] mod_python:creating 8 session mutexes based on the max processes and 0 max threads.

[Tue 20 18:10:48 2014] [Notice] mod_python:using mutex_directory/tmp

[Tue 20 18:10:49 2014] [Emerg] (28) No space left on DEVICE:COULDN ' t create accept Lock (/etc/httpd/logs/accept.lock.4485) (5)

Reason:

Semaphore arrays is full, here are the relevant explanations found

What's the heck is a semaphore? Well, it's actually an apparatus for conveying information by means of visual signals.

But if it comes to programming, semaphores is used for communicating between the active processes of a certain applica tion.

In the case of Apache, they ' re used to communicate between the parent and child processes. If Apache can ' t write these things down, then it can ' t communicate properly with all of the processes it starts.

Workaround:

For i in ' ipcs-s | grep apache| awk ' {print $} '; Do ipcrm-s $i; Done

This value can be increased by adjusting the kernel

Kernel.msgmni = 1024

Kernel.sem = 250 256000 32 1024

This article is from "Try to be brave" blog, declined reprint!

A case of MySQL startup error