Segmentation fault

[MACHOBY]

I keep getting Segmentation fault errors and my server shuts down my site because it continously uses too many resources. Server info posted below. The server teach support said the errors... They both appear to have occured during usage of the /macforum/showthread.php file and /macforum/forumdisplay.php. So either something has been done to PHP on this account, or there is a problem with the PHP code in these files."
A fresh restart of apache will of course get thing back to normal but they slowly creep back up until out of control (over 50% cpu usage)

Any suggestions on fixing this?

[Steve Machol]

Please provide the info requested in the sticky thread at the top of this forum:

http://www.vbulletin.com/forum/showthread.php?t=70117

[MACHOBY]

1. virtual dedicated server

2. your server specs.
cpu speed/type single or dual cpus): 1.13ghz/single
how much memory installed: 1gb
hard drive type/configuration: 2gb swap 1 143gb scsi 10,000 rpm
linux distributor or windows version: Linux/RedHat 7.2
version of php - 4.2.3
version of php accelerator - Zend Engine v1.2.0, Zend Technologies with
Zend Optimizer v2.0.2
version of mysql - 3.23.53
version of apache - 1.3.26
version of mod_gzip - Not sure on this one?

3. version of mysql - 3.23.53

4. if possible how mysql was compiled/installed ???not sure?

5. top stats
Newest member to the forums[crockett64] (http://www.cd-communications.com/macforum/admincp/user.php?do=edit&userid=1786) Record online users295 (12-10-2003 10:42 PM)Top poster[overtyme - 3254] (http://www.cd-communications.com/macforum/admincp/user.php?do=edit&userid=65) Most replied to thread[reds] (http://www.cd-communications.com/macforum/showthread.php?threadid=3280) Most viewed thread[Coldwater/Versailles Game....] (http://www.cd-communications.com/macforum/showthread.php?threadid=3894) Most popular forum[ARCHIVES] (http://www.cd-communications.com/macforum/forumdisplay.php?forumid=13)

6. your mysql configuration variables
[client]
port = 3306
user = root
socket = /tmp/mysql.sock
[mysqld]
port = 3306
user = root
bind-address = 66.84.46.18
socket = /tmp/mysql.sock
skip-locking
#Added by HostDirector Plugin Installer -- Don't remove -- begin
skip-networking
#Added by HostDirector Plugin Installer -- Don't remove -- end
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
#log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=16M

7. http://www.cd-communications.com/mysqlinfo.php

8. since this is a VDS server, there are many other sites/scripts

9. 60 average users

10. http://www.cd-communications.com/phpinfo.php

11.
KeepAlive On/Off - On
MaxKeepAliveRequests - 100
KeepAliveTimeout - 15
MinSpareServers - 1
MaxSpareServers - 1
StartServers - 1
MaxClients - 15

12. VB3 Gold

[MACHOBY]

OK, I think I have all the needed info above

[MACHOBY]

Here are more errors from a crash last night:

[Wed Mar 10 00:40:20 2004] [warn] child process 25900 still did not
exit, sending a SIGTERM
[Wed Mar 10 00:40:20 2004] [warn] child process 25868 still did not
exit, sending a SIGTERM
[Wed Mar 10 00:40:25 2004] [error] child process 25900 still did not
exit, sending a SIGKILL
[Wed Mar 10 00:40:27 2004] [error] child process 25868 still did not
exit, sending a SIGKILL
[Wed Mar 10 00:40:27 2004] [notice] caught SIGTERM, shutting down
[Wed Mar 10 00:40:36 2004] [notice] Apache/1.3.26 (Unix) PHP/4.2.3
configured -- resuming normal operations
[Wed Mar 10 00:40:36 2004] [notice] Accept mutex: fcntl (Default: fcntl)
[Wed Mar 10 00:49:03 2004] [notice] SIGHUP received. Attempting to
restart
[Wed Mar 10 00:49:04 2004] [notice] Apache/1.3.26 (Unix) PHP/4.2.3
configured -- resuming normal operations
[Wed Mar 10 00:49:04 2004] [notice] Accept mutex: fcntl (Default: fcntl)

[Daijoubu]

Are you sure about MySQL being the problem? Could it be PHP?

Try getting rid of the Zend Optimizer (or at least desable the optimization feature if you run Zend encoded files)
It's not good anyway, the time it spends to "optimize" outweight the benefits...
And perhaps update to the lastest PHP4.3.4? The amount of bugs fixed is countless ;)

[MACHOBY]

That did not take care of it. I am still running high server loads.

[MACHOBY]

I upgraded to Gold last night. Here is an error this morning...

[error] server reached MaxClients setting, consider raising the MaxClients setting
[Wed Mar 24 05:15:11 2004] [notice] child pid 3158 exit signal Segmentation fault (11)
[Wed Mar 24 05:38:11 2004]

I was told by the server tech support that raising max clients would only cause more CPU usage and the site will go down more frequently.

[MACHOBY]

Anyone?

[Daijoubu]

To lower CPU usage, install Turck MMCache, you may want to update PHP too..