Stability issues (especially when editing categories)

[treiman]

Hello,

 

My initial problem with Prestashop was that when modifying categories (editing, deleting or creating new ones) the action took a fair amount of time and resulted in an Internal Server Error (result code 500), and this log message seemed to appear in httpd error_log:

 

[warn] mod_fcgid: process 15853 graceful kill fail, sending SIGKILL

 

It was no always like this. I have a fair amount of categories now, and the problem with the editing has been of late. As a solution, I tried modifying the fcgid configuration file with some post I found on the Internet. The fcgid conf file now includes the following lines:

 

LoadModule fcgid_module modules/mod_fcgid.so

 

<IfModule mod_fcgid.c>

 

<IfModule !mod_fastcgi.c>

    AddHandler fcgid-script fcg fcgi fpl

</IfModule>

 

  FcgidIPCDir /var/run/mod_fcgid/sock

  FcgidProcessTableFile /var/run/mod_fcgid/fcgid_shm

 

  FcgidIdleTimeout 3600

  FcgidProcessLifeTime 30

  FcgidMaxProcesses 20

  FcgidMaxProcessesPerClass 8

  #FcgidMinProcessesPerClass 4

  FcgidConnectTimeout 30

  FcgidIOTimeout 1800

  FcgidInitialEnv RAILS_ENV production

  FcgidIdleScanInterval 480

 

  FcgidSpawnScoreUpLimit 10

  FcgidSpawnScore 1

  FcgidTerminationScore 2

  FcgidMaxRequestLen 1073741824

 

</IfModule>

 

After this change and some larger innodb_buffer_pool_size (85M now), I am having more problems. The modification of categories no longer results in result code 500, though the actions still take a very long time (30 sec to 1 min). However, I am now seeing this in httpd error log:

 

[sat Mar 29 20:44:36 2014] [error] (12)Cannot allocate memory: mod_fcgid: can't run /var/www/cgi-bin/cgi_wrapper/cgi_wrapper

[sat Mar 29 20:44:36 2014] [warn] (12)Cannot allocate memory: mod_fcgid: spawn process /var/www/cgi-bin/cgi_wrapper/cgi_wrapper error

[sat Mar 29 20:44:37 2014] [error] (12)Cannot allocate memory: fork: Unable to fork new process

[sat Mar 29 20:44:47 2014] [error] (12)Cannot allocate memory: fork: Unable to fork new process

[sat Mar 29 20:44:57 2014] [notice] child pid 3040 exit signal Segmentation fault (11)

 

This morning the server had went totally unresponsive, with only the main page being reachable via HTTP and not HTTPS. I could not even get in via SSH. Lucklily I was able to reboot the server from the service provider's management GUI.

 

What I would like to know is how to really configure everything (apache, mysql, fcgid, php, etc.) for me to make my Prestashop installation work without hiccups. At the moment the shop has been up and running all day, but I fear that I might find it down again when I wake up tomorrow.

 

I've attached here as a file some information I thought that would be of use to anyone trying to help -- httpd configuration items, my.cnf contents, error log messages, cpuinfo, etc.

 

What's not there is that I have only 512 MB of RAM at my disposal, nor do I actually know how reliable that cpuinfo is. Would seem rather silly to have all that processing power and only 512 MB of memory...

 

info.txt