Site totally down after product input

[toninovak66]

We are developing this shop for a client who sells clothing. Every item they sell has color and size options. They have a total of 2,368 products currently and on Friday morning after they spent the day Thursday fixing some pricing and combinations, the customer side of the site (the front office as specified by PS) just stopped working. It started out with out of memory errors. So I increased the memory to 512M from 64M. Those errors stopped and now the site is just not loading. In Chrome I get the error - Error 324 (net::ERR_EMPTY_RESPONSE): The server closed the connection without sending any data. Other browsers just say the site may be down and to check back later.

 

Here are the last couple entries from the server error log and the previous ones are all the same:

 

[Fri Apr 05 16:33:49 2013] [error] [client 75.149.23.177] PHP Warning: file_put_contents(/home/bestbuyuniforms/bestbuyuniforms.com/config/xml/default_country_modules_list.xml) [<a href='function.file-put-contents'>function.file-put-contents</a>]: failed to open stream: Permission denied in /home/bestbuyuniforms/bestbuyuniforms.com/controllers/admin/AdminHomeController.php on line 673, referer: http://75.98.175.59/...23610c086c818ee

[Fri Apr 05 16:34:07 2013] [error] [client 75.149.23.177] PHP Warning: file_put_contents(/home/bestbuyuniforms/bestbuyuniforms.com/config/xml/default_country_modules_list.xml) [<a href='function.file-put-contents'>function.file-put-contents</a>]: failed to open stream: Permission denied in /home/bestbuyuniforms/bestbuyuniforms.com/controllers/admin/AdminHomeController.php on line 673, referer: http://75.98.175.59/...23610c086c818ee

 

The day before while they were working on it everything was fine and it was up and they were able to browse the site with no errors.

 

We have our own VPS running CentOS 5.9 with a kloxo control panel. We are running PS 1.5.31, php-5.2.17-24, mysql-5.0.96-1, apache 2.2.23-3. We are running on SSD drives and the server has 1GB of memory which is running at between 28 and 40%. Our php type is mod_php with FastCGI enabled and we have SSL set up and working properly. All the files have the correct ownership/permissions. No matter what I've tried, nothing is working to bring the site back up. The admin loads just fine and I'm able to make changes, add and modify products, combinations, upload images, anything. But you can't browse the site. We also are not anywhere near capacity on the data side of the server so there is plenty of disc space left.

 

You can see it here http://75.98.175.59/

 

Originally I thought it was due to the number of products/combinations that caused the issue and thought that increasing the memory should fix the issue. Now it seems as its something else. Can anyone shed any light on this for me? Do we need to maybe think about using the advanced combinations module from presto chango? Please help and thank you so much in advance for any help you give.

[vekia]

back office works without problems?

 

For the first you should try to regenerate htaccess file, make a backup and then just delete it, and try to access your store.

and what about ps_shop_url table? Everything is ok there? can you check values for rows there?

 

regards

[toninovak66]

Yes the back office works without any problems. Able to access everything and no errors returned.

The values from the table are in the attached screenshot below.

 

I regenerated the .htaccess file, the downloaded it and deleted it and now I get this error:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 1630835 bytes) in /home/bestbuyuniforms/bestbuyuniforms.com/modules/blocktopmenu/blocktopmenu.php on line 644

Edited April 7, 2013 by toninovak66 (see edit history)

[toninovak66]

I also noticed that after deleting the .htaccess file, it would not regenerate a new one even though I turned off the friendly URLs then turned them back on.

[vekia]

you are on shared hosting?

[toninovak66]

No, it's our own VPS and we only have this site and one other small site that we're just developing. Nothing else on the server.

[tomerg3]

if you get out of memory errors, you should increase the RAM PHP is allocated.

[toninovak66]

I have memory limit set to 512M. How much more should I increase it? I'm not getting any out of memory errors anymore. The site is just a blank page, even though I have error reporting set to on in my configuration file. Nothing is working to bring it back up.

Edited April 10, 2013 by toninovak66 (see edit history)

[tomerg3]

Check the main apache error log, it could be a syntax error in a php file

[toninovak66]

Here are the last few lines from my httpd error log

[Wed Apr 10 09:43:01 2013] [notice] child pid 22580 exit signal Segmentation fault (11)
[Wed Apr 10 09:43:25 2013] [notice] child pid 22583 exit signal Segmentation fault (11)
[Wed Apr 10 09:55:20 2013] [notice] child pid 22584 exit signal Segmentation fault (11)
[Wed Apr 10 09:55:44 2013] [notice] child pid 22587 exit signal Segmentation fault (11)
[Wed Apr 10 10:09:15 2013] [notice] child pid 22586 exit signal Segmentation fault (11)
[Wed Apr 10 10:09:38 2013] [notice] child pid 22582 exit signal Segmentation fault (11)

[tomerg3]

try to reload the page the shows empty, and check the log.

 

Also, make sure you turned on dev mode in /config/defines.inc.php

[toninovak66]

I do have dev mode turned on in my defines.inc.php file but it's not returning anything at all.

 

When I reload the page I get one more line in my error log file:

[Wed Apr 10 10:29:08 2013] [notice] child pid 22588 exit signal Segmentation fault (11)

[tomerg3]

Hmm, that's not a php related error.

 

I would try to restore the site from a backup, if it works, compare the files from the backup to the current files.

[toninovak66]

The site files or the DB? I created two backups the day before this happened using the PS DB backup utility but when I tried to restore it, I ran into some garble in the SQL file and it won't run. I don't have a backup of the DB before that now. I do have backups of the site files themselves and can restore those but I'm assuming that won't really help?

[tomerg3]

It would not be a DB issue, it would be a file (syntax errors are in files, not DB).

 

You could double check it by changing the DB password in /config/settings.inc.php

 

If you still get a white screen, it is def related to files (or at least not DB), if you get a DB connection error, then it may not be the files, but worth checking anyway

[toninovak66]

Fatal error: Uncaught Link to database cannot be established: SQLSTATE[28000] [1045] Access denied for user 'bestbuyu_shop'@'localhost' (using password: YES) thrown in /home/bestbuyuniforms/bestbuyuniforms.com/classes/db/DbPDO.php on line 57

 

got that after changing the DB password.

[tomerg3]

hmm, I would say still try the file backup, if that doesn't work, you may need to get a developer to take a closer look...

[toninovak66]

So should I just upload all the files and overwrite everything on the server from my backup? Or is there another way to do it?

[tomerg3]

make a backup of the current files, and then overwrite them

[toninovak66]

Will try that. Thank you so much for your help. I will let you know how it goes. Once I get past this we can start using your AWP module.

[toninovak66]

After overwriting the files from a backup made before this issue occurred, I am in the same predicament. The site still will not load.

[45Direct]

I ran into the same problem, it seems the site will increase the disk spaced used until it has filled the entire disk, or at least the disk space allocated to the site, and then it will go to white pages as it's not able to generate anymore pages with all the disc spaced used.

 

So, I allocated over 40 gigs, so that I would not have to worry about it anymore.

 

However at this point, it's used it all, and I'm not quite sure what to do.

 

Anyone out there know how to stop the massive disc consumption?